jira_sql_queries
Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision | Last revision Both sides next revision | ||
|
jira_sql_queries [2018/10/01 04:35] shabnam |
jira_sql_queries [2019/04/29 12:11] shabnam |
||
|---|---|---|---|
| Line 127: | Line 127: | ||
| 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; | ||
| + | </ | ||
| + | |||
jira_sql_queries.txt ยท Last modified: 2019/06/11 13:43 by shabnam
Page Tools
Except where otherwise noted, content on this wiki is licensed under the following license: Public Domain
