Sparx Systems Forum

Enterprise Architect => Automation Interface, Add-Ins and Tools => Topic started by: steen.jensen on September 11, 2020, 01:06:21 am

Title: How create charts that are based on TaggedValues-CheckList
Post by: steen.jensen on September 11, 2020, 01:06:21 am

I have used a SQL-script for my Charts based from TaggedValues.
But I have a few TaggedValues based on CheckList type.
With same script I only got 0/o if each checkbox is marked ie 0,0,1,0

How to get each checkbox value with its  Name and Value in SQL-script that is working with Charts

Sql-script för Charts:

SELECT tv.Value AS Series, tv.Property as GroupName
FROM t_objectproperties tv
INNER JOIN t_object o ON o.Object_ID = tv.Object_ID
WHERE tv.Property in ('TaggedValueName')

Title: Re: How create charts that are based on TaggedValues-CheckList
Post by: qwerty on September 11, 2020, 02:10:23 am

If I'm not wrong this info is in the memo field (t_objectproperties.notes) and you need to parse that.

q.