Differences

This shows you the differences between two versions of the page.

--- jira_sql_queries [2018/10/01 04:35]
shabnam
+++ jira_sql_queries [2019/06/11 13:43]
shabnam
@@ Line 126: / Line 126: @@
 FROM AO_60DB71_RAPIDVIEW
 WHERE SAVED_FILTER_ID=55555;
+</code>
+=== Get users in a group  ===
+<code java>
+select distinct(U.display_name), U.lower_user_name, U.email_address, G.parent_name
+from cwd_membership G, cwd_user U
+where G.parent_name = <<group_name>>
+and G.lower_child_name = U.lower_user_name
+and U.active='1'
+order by U.display_name;
+</code>
+==== Get filternames in a dashboard ====
+<code java>
+SELECT pp.id, pp.username, pp.pagename, s.filtername, s.id, gup.USERPREFVALUE FROM portalpage pp
+JOIN portletconfiguration pc on pp.id = pc.portalpage
+JOIN gadgetuserpreference gup on pc.ID = gup.portletconfiguration
+JOIN searchrequest s on gup.userprefvalue=s.filtername
 </code>

PawelWiki