Apply Reference Code Custom Sort to Filter Cache List

Jason Kaczmarek shared this idea 9 months ago
Completed

Please allow the ability to sort a cached list of values (on a report filter) by the custom sort set on the reference code. Right now they only sort by data value, not by the custom sort value. (v7.4.6)

Thank you,

Jason

Comments (3)

photo
1

Hi Jason,

Thanks for reaching out. Unless I'm missing something I believe this is already a possibility.

If you click on Format > Edit for the corresponding field with your reference codes, set the Format to Reference Code and choose your Reference Type then go to Edit:

/H1w7b7t239ynAAAAAElFTkSuQmCC

You can turn on Custom Sort:

/QbtiE0VCnSAAAAABJRU5ErkJggg==

Then head into Values tab and Sort how you'd wish. Here I made Australia and Austria a value of 1, while the rest are 0, so it now appears at the bottom of list (after saving and re-opening):

/H+GOSOm5fqb4QAAAABJRU5ErkJggg==

Now these two values are now at the bottom of my filter value list:

/H+HlUEyXSHARwAAAABJRU5ErkJggg==

Might this have been what you're looking for? If not, please let me know how my set-up differs.

Thanks,

Mike

photo
1

Mike,

Sorry for the delay, our firewall keeps blocking foreign emails.

I see that my issue was not selecting the "Reference Codes" option in the Entry Style section of the filter formatting screen. I think the default might be Cached Values; which, at first glance, appears to be what I want.

So my issue was simply not paying attention to what I was doing. I'm good now.

Thank you,

Jason

photo
1

Hi Jason,

Thanks for letting us know! I'll go ahead and close this out then.

Please don't hesitate to reach out with any other questions or concerns (or Ideas!).

Regards,

Mike