We have added some custom case status using Field Value rules, the pyFieldValue is different than the pyLocalizedValue. We need to show this property in a column of a table and allow the user to make some operations (Filter, sort, search, etc..).
As for the data, we can print either the values of the property or the localized values of the property, we chose to print the localized values but the problem is that the values shown to the users, when they try to filter on this column, are the ones stored in pyFieldValue only, i was wondering if there's a solution so we can use the values of pyLocalizedValue property instead ?
The other solution, which is simple but long, is to create new field value rules and give the same values to pyFieldValue and pyLocalizedValue, the problem here is how to update the already created cases so they can reference the new status instead of the old ones !
Thanks a lot !
***Edited by Moderator: Pooja Gadige to change content format from Discussion to Question***
The thing is that i don't have a problem in showing the values in the column of the table, the problem is that when i try to filter the values in the column, the suggested values to filter on are not exactly what i need, those values are retrieved from a bunch of Field Value rules and in this type of rule we have two essential properties (pyFieldValue and pyLocalizedValue).
We have control over which values we want to show in the column (we can choose to show pyFieldValue or pyLocalizedValue) but in the column filter, we can't choose, it's pyFieldValue per default.
To sum up, i want to know if i can force the filter to take the values of pyLocalizedValue instead of pyFieldValue.