Hi,
I always prefer to use id when possible for stored queries are they are more efficient in ter of resources.
for creating stored queires you need to refer the attributes of the current object.
for the group as an example in your case
you need to use group and not group_id that don't exist on the cr object.
also to refer field with UUID you need to note it as U'xxxxxxxxxxxxxxxx' with \ as escape characters and not refer to the sql reprenstation (0x)
group = U \’ 2A97BF63E650C542A38F5D53027B47AD\’ AND active = 1
Not in front of an env (currently in a train) and don't remember by hard the predicted sla flag naming but using bops_sinfo -d cr on the server wil lprovide you will all the attributes you can refer on the cr object and you can grab the exact attribute name from it and construct your query as you was trying to do:
group.[group]group_list.member IN (@cnt.id) AND active = 1 AND <to find with the command above> = 1
You can also fine usefull example like above in the SDM admin guide
hope this help
/J