How can I identify the groupID for a given named group?

#1 · 2023-07-29, 5:42 pm

I want write a query for user data for people that are in a specific group, but I can't figure out how to correlate a group name to its database ID.

#2 · 2023-07-29, 7:06 pm

Post-RM7, here's the list of group names:

SELECT * FROM TagTable WHERE TagType=0

Pre-RM8,...

SELECT * FROM LabelTable WHERE LabelType=0

The group name is stored respectively in TagName and LabelName.

The GroupTable relates to the TagTable or LabelTable ON GroupID=TagValue (post-RM7), GroupID=LabelValue (pre-RM8).

For examples that may give you some ideas, look at the blog posts under #namedgroup . To search within the Forum, use its own search field.