Log in Register FAQ Memberlist Search ContactReview Forum Index
A GoldMine Discussion and Support Community

ContactReview Forum Index » GoldMine 8 - 2019 (Premium Edition) » Goldmine Dashboards
Post new topic  Reply to topic View previous topic :: View next topic 
Goldmine Dashboards
PostPosted: Fri Aug 31, 2012 8:49 am Points: 0 Reply with quote
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
View user's profile Send private message

Goldmine Dashboards
  ContactReview Forum Index » GoldMine 8 - 2019 (Premium Edition)
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
All times are GMT - 7 Hours  
Page 1 of 1  

  
  
 Post new topic  Reply to topic  


Brought to you by Castell Computers, Doug Castell, Admin
RSS Feed
Powered by phpBB © 2001-2004 phpBB Group
Theme created by Vjacheslav Trushkin