jira_sql_queries
Differences
This shows you the differences between two versions of the page.
| Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
| jira_sql_queries [2019/04/29 12:11] – shabnam | jira_sql_queries [2026/02/01 12:29] (current) – external edit 127.0.0.1 | ||
|---|---|---|---|
| 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 | ||
| + | </ | ||
jira_sql_queries.1556554264.txt.gz · Last modified: (external edit)