This shows you the differences between two versions of the page.
Both sides previous revision Previous revision | |||
jira_sql_queries [2019/04/29 12:11] shabnam |
jira_sql_queries [2019/06/11 13:43] (current) shabnam |
||
---|---|---|---|
Line 139: | Line 139: | ||
</ | </ | ||
+ | ==== 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 | ||
+ | </ |