issue with linked (lookup) columns.
1 posts by 1 authors in: Forums > CMS Builder
Last Post: Wednesday at 4:36am (RSS)
When I search within a table, Iām having an issue with linked (lookup) columns.
If I search using the displayed text from the linked column, no results are returned. However, it appears the search is instead using the underlying ID value from the related table.
Example:
- I have a
document_linestable with a column called Doc Header - This column is linked to a
headingstable - In the UI, it displays:
"section1: Brakes & Lines" - But in the database, this entry has an ID of 7
Issue:
- Searching for "section1:" ā returns no results
- Searching for "7" ā correctly returns all related entries
Question:
Is there a way to make the search work against the displayed text (e.g. "section1: Brakes & Lines") instead of the underlying ID?