jira_sql_queries
Differences
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:32] shabnam |
jira_sql_queries [2019/06/11 13:43] (current) shabnam |
||
|---|---|---|---|
| Line 64: | Line 64: | ||
| SELECT * | SELECT * | ||
| FROM AO_60DB71_RAPIDVIEW | FROM AO_60DB71_RAPIDVIEW | ||
| - | WHERE SAVED_FILTER_ID=99999; //<- this is the filter id mentioned in the error// | + | WHERE SAVED_FILTER_ID=55555; //<- this is the filter id mentioned in the error// |
| //Take a note of the ID field value (eg.: 999), and delete the reference records from the below tables as below:// | //Take a note of the ID field value (eg.: 999), and delete the reference records from the below tables as below:// | ||
| Line 109: | Line 109: | ||
| //Take a note of the IDs from the table AO_60DB71_COLUMN// | //Take a note of the IDs from the table AO_60DB71_COLUMN// | ||
| - | |||
| SELECT * FROM AO_60DB71_COLUMN | SELECT * FROM AO_60DB71_COLUMN | ||
| WHERE RAPID_VIEW_ID=999; | WHERE RAPID_VIEW_ID=999; | ||
| Line 118: | Line 117: | ||
| DELETE FROM AO_60DB71_COLUMNSTATUS | DELETE FROM AO_60DB71_COLUMNSTATUS | ||
| WHERE COLUMN_ID IN (1,11,111); | WHERE COLUMN_ID IN (1,11,111); | ||
| + | |||
| + | //Then delete the primary record of AO_60DB71_COLUMN table// | ||
| + | DELETE FROM AO_60DB71_COLUMN | ||
| + | WHERE RAPID_VIEW_ID=999; | ||
| //Now finally delete the record in primary table:// | //Now finally delete the record in primary table:// | ||
| DELETE | DELETE | ||
| FROM AO_60DB71_RAPIDVIEW | FROM AO_60DB71_RAPIDVIEW | ||
| - | WHERE SAVED_FILTER_ID=999; | + | 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 | ||
| </ | </ | ||
jira_sql_queries.1538382762.txt.gz · Last modified: 2018/10/01 04:32 by shabnam
Page Tools
Except where otherwise noted, content on this wiki is licensed under the following license: Public Domain
