Adding a legend with values to a diagram via script.

[Ruff]

I was inspired by Java inserting into a legend
I have no issues adding the legend to the diagram but they entries to the legend aren't added.  Any ideas why this my not work are welcome.  (version 15.2.1554)

Here's the SQL statement in generates:(I can't post code but a paste link like this works?!?)


Link to Stack Overflow since I can't post code here.

[Geert Bellekens]

What I've answered on SO:

You can't execute update or insert statements using Repository.SQLQuery()

You can use the undocumented and unsupported method Repository.Execute(), but you better be damn sure of what you are doing. This has the potential to seriously corrupt your model.

Geert

[philchudley]

Hi All

I have achieved this via a Model Based add-in, but as Geert says it is NOT trivial.

In addition to creating a Text element with a subtype = 76, all the legend stuff is located in t_xref with a specific ; delimited string and the RGB values must be stored in EA's own integer values this entry is then cross referenced to the Text element. This requires a new entry per legend to be created in t_xref with each having its own GUID.

Phil