Cannot set child filter as 'Reference Code' when a parent filter has been set
Defect Logged
Hi
When creating filter group in the View, filters can be sorted by reference code (Value List Setup --> Reference code (pic 1 below)
However, if I have a filter with a parent link, then the Value List Setup does not have Reference Code to select (pic 2 below). Is there another way to show those filers (child filters) sorted in a specific code specified in Reference code? thanks
Hi Emily, thanks for the screens!
Firstly, I'm able to replicate your scenario which I agree is a little strange and suspect it's related to some UI in consistencies which we can address in a future release.
However in the interim, I think there is a way for you to achieve what you're after. Here is what I did;
1. At the view level ensured my field was formatted as 'reference code'
2. Now in the report, that field is formatted s a reference code, whether or not it was used as a filter;
3. If I now set up the dependency, the values are shown as a reference values, and also sorted the same
Can you confirm this works for you? (I'm using 9.6.1, just in case there are some differences with my steps).
Thanks,
David
Hi Emily, thanks for the screens!
Firstly, I'm able to replicate your scenario which I agree is a little strange and suspect it's related to some UI in consistencies which we can address in a future release.
However in the interim, I think there is a way for you to achieve what you're after. Here is what I did;
1. At the view level ensured my field was formatted as 'reference code'
2. Now in the report, that field is formatted s a reference code, whether or not it was used as a filter;
3. If I now set up the dependency, the values are shown as a reference values, and also sorted the same
Can you confirm this works for you? (I'm using 9.6.1, just in case there are some differences with my steps).
Thanks,
David
thanks David
though because I used a filter group, in the report, I can't click into the specific filters. Is there another way around it? thanks
thanks David
though because I used a filter group, in the report, I can't click into the specific filters. Is there another way around it? thanks
Replies have been locked on this page!