Jump to content

Dynamic Filters


Steve Giller
 Share

Recommended Posts

Is there a way to filter a report on the contents of a column?
E.g. to restrict the list of assets to those in a particular Building can I have a user-defined filter that allows one (or more) of the existing values in the building column? (i.e. built from SELECT DISTINCT h_building FROM h_cmdb_assets) rather than using a separate list that may get out of sync with the database.

Link to comment
Share on other sites

  • 2 weeks later...

Hi @DeadMeatGF

If I have understood your post correctly, unfortunately right now, for User Prompted values in a report, the a separate simple list of data is the closest that I think you can get to what you require (which I think you have already alluded to)

Screenshot_1.png

 

I'll ask the question internally to see if driving the prompted value from a user defined query is a possibility, and keep you updated.

Kind Regards

Bob

 

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...