Can I define a label for certain filter values
Answered
Hello,
Is it possible to use the custom query option in a filter to define some sort of label to show in the filter. So I want to filter on a number but show a label. This label is in a different table. I can easily create a query with gives the number and the label (description) but the measure table has the number in it and not the label.
I thought I read somewhere that this is possible but I get an error that the query should result in a single field.
Maybe the names should be something specific.
I tried finding the article or forum post where I read that this was possible so now I am unsure if it is.
Please let me know.
Regards,
JeRoen
The same question
Hi There
I have done something similar to what you require by using Reference Codes
in YF 8 you can refresh Reference Codes with a SQL Query that returns the Code, the Description (Label) and if required the Sort Order
You can then use that Reference Code in your Filter Group in the View to Select using the Code but Display the Description (label) and if required have a specific Sort Order
Hi There
I have done something similar to what you require by using Reference Codes
in YF 8 you can refresh Reference Codes with a SQL Query that returns the Code, the Description (Label) and if required the Sort Order
You can then use that Reference Code in your Filter Group in the View to Select using the Code but Display the Description (label) and if required have a specific Sort Order
Hello,
Thanks. We managed to get it working by using reference codes.
Regards,
JeRoen
Hello,
Thanks. We managed to get it working by using reference codes.
Regards,
JeRoen
Replies have been locked on this page!