I have a JQGrid table that can be displayed in different languages. The data for this table is stored as English text and translated when output. The JQGrid table can be filtered by text.
The issue I have, is that when the JQGrid table is filtered, the query will run against the English text. E.g.
Original table: Yes No
Translated table: Oui Non
User is French and tries to filter for 'Oui': Database query will return zero results because 'Oui' does not exist in the database table. If the French user queries for 'Yes' then Oui will show because it matches the database and is translated on output.
This is using custom integration with JQGrid.
Since all string translation is cached and as far as I know there are no database tables available to join on, how can I get translated filtering to work?
Any ideas on the best way to handle this?