I have a few Ticket Tag Groups …
[Ticket Tag Groups:1,4,4,2,2,2,1,1,1]
>>tagGroupId|tagGroupName|FreeTagging|SaveFreeTags|ButtonColorWhenTagSelected|ButtonColorWhenNoTagSelected|ForceValue|AskBeforeCreatingTicket|DataType
{REPORT SQL DETAILS:
SELECT
g.[Id] as [tagGroupId]
,g.[Name] as [tagGroupName]
,g.[FreeTagging]
,g.[SaveFreeTags]
,g.[ButtonColorWhenTagSelected]
,g.[ButtonColorWhenNoTagSelected]
,g.[ForceValue]
,g.[AskBeforeCreatingTicket]
,g.[DataType]
FROM [TicketTagGroups] g
ORDER BY g.[SortOrder], g.[Name]
:F.tagGroupId,F.tagGroupName,F.FreeTagging,F.SaveFreeTags,F.ButtonColorWhenTagSelected,F.ButtonColorWhenNoTagSelected,F.ForceValue,F.AskBeforeCreatingTicket,F.DataType}
But only 1 Group named TA has predefined Tags, so only these Tag Buttons will appear for selection …
[Ticket Tags:1,4,1,4,2,2,2,1,1,1,1]
>>tagId|tagName|tagGroupId|tagGroupName|FreeTagging|SaveFreeTags|ButtonColorWhenTagSelected|ButtonColorWhenNoTagSelected|ForceValue|AskBeforeCreatingTicket|DataType
{REPORT SQL DETAILS:
SELECT
t.[Id] as [tagId]
,t.[Name] as [tagName]
,g.[Id] as [tagGroupId]
,g.[Name] as [tagGroupName]
,g.[FreeTagging]
,g.[SaveFreeTags]
,g.[ButtonColorWhenTagSelected]
,g.[ButtonColorWhenNoTagSelected]
,g.[ForceValue]
,g.[AskBeforeCreatingTicket]
,g.[DataType]
FROM [TicketTags] t
JOIN [TicketTagGroups] g on g.[Id]=t.[TicketTagGroupId]
ORDER BY g.[SortOrder], g.[Name], t.[SortOrder], t.[Name]
:F.tagId,F.tagName,F.tagGroupId,F.tagGroupName,F.FreeTagging,F.SaveFreeTags,F.ButtonColorWhenTagSelected,F.ButtonColorWhenNoTagSelected,F.ForceValue,F.AskBeforeCreatingTicket,F.DataType}
And there they are (they don’t function yet ;)) …