Query Column Filters

bwalk

Good day all,
In a query column filter I would like the text box to be a dropdown of entered values.
The Filter setup page has a column 'Display Choices' but I cannot change it in any way.
Anyone have any ideas? I will post a screenshot of the Filter setup page and my query result.
Any insight is much appreciated.
Thanks

Jaymer

Display choices for when you have a field that has a hard coded set of choices in it, like north south east west
Try doing this in Assigned to filter box:
In the empty box, type a
Then backspace the a and it should be filled with a list of choices

I’m not sure what it’s doing to get that list on the backend, and it certainly undocumented, and there’s no way you can tell your users how to do that,
But it’s nice.
Also, I always use contains as my criteria

If you have a timestamp field, it’s almost impossible to use a filter on that column

If you have a numeric column with a filter, it would be nice to easily remove that numeric up down spinner

bwalk

Hello Jaymer,
That is a pretty neat hack but if that data is already there why can we not set it to come up on entry and not '{some letter} backspace' ?
Yes, I wouldn't even want to mention that to a user, he will think I'm nuts even for suggesting it.
But for me it is good to know it is there. Now if someone who has some influence could suggest it to the powers at be, that would be great.
Thanks

Jaymer

I like that... the '{some letter} backspace' hack
LOL