I created a grid using the source "ItemInCalendar". I want to have a single grid column that shows which calendar each item is assigned to. So for instance, the field values that would populate in the column would be *name* of the field, not the value in it, i.e. "personal calendar", "holiday calendar", "work calendar" etc.
I know, at least last I checked, that IQ does not support the old ecco feature of a column showing the value of child fields. But here I just want to show the name of the child fields (so to speak). Best way to accomplish?
If formulas are required, please include them :D.
Comments
<source>SELECT Event.ItemID, ¯Fields.Name AS CalendarName
FROM Event INNER JOIN ¯Fields ON Event.FieldID = ¯Fields.ID;
</source>