How create charts that are based on TaggedValues-CheckList

[steen.jensen]

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')

[qwerty]

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

q.