Erik Nicholson |
n00b |
|
|
Joined: 13 Feb 2012 |
Posts: 3 |
Location: Pittsburgh |
|
|
|
|
|
|
|
I am trying to create a drop-down list in a dashboard that displays all of the Goldmine users names, except the disabled accounts. Once the name is selected, the table below would only show records related to that user.
I currently have the following Query in the data source:
select 'All' as [text], '<<__INACTIVE_STATE__>>' as [value], 0 as [sort_index]
UNION ALL
select RTRIM( NAME ) + ' (' + RTRIM( NAME ) + ')' as [text], RTRIM( NAME ) as [value], 1 as [sort_index] from {{owner}}USERS order by [sort_index], [text]
This is what is returning:
Text: Value:
(Disabled Account) (Disabled Account)
(Disabled Account) (Disabled Account)
(Disabled Account) (Disabled Account)
How can I add to the query to remove these disabled accounts from displaying?
Thanks |
|