This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision | ||
jira_sql_queries [2018/10/01 04:35] shabnam |
jira_sql_queries [2019/06/11 13:43] (current) shabnam |
||
---|---|---|---|
Line 126: | Line 126: | ||
FROM AO_60DB71_RAPIDVIEW | FROM AO_60DB71_RAPIDVIEW | ||
WHERE SAVED_FILTER_ID=55555; | WHERE SAVED_FILTER_ID=55555; | ||
+ | </ | ||
+ | |||
+ | === Get users in a group === | ||
+ | |||
+ | <code java> | ||
+ | select distinct(U.display_name), | ||
+ | from cwd_membership G, cwd_user U | ||
+ | where G.parent_name = << | ||
+ | and G.lower_child_name = U.lower_user_name | ||
+ | and U.active=' | ||
+ | order by U.display_name; | ||
+ | </ | ||
+ | |||
+ | ==== Get filternames in a dashboard ==== | ||
+ | |||
+ | <code java> | ||
+ | SELECT pp.id, pp.username, | ||
+ | JOIN portletconfiguration pc on pp.id = pc.portalpage | ||
+ | JOIN gadgetuserpreference gup on pc.ID = gup.portletconfiguration | ||
+ | JOIN searchrequest s on gup.userprefvalue=s.filtername | ||
</ | </ |