issue with linked (lookup) columns.
2 posts by 2 authors in: Forums > CMS Builder
Last Post: April 19 (RSS)
By Davidpanter - April 15
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?
Hi David,
Search on linked fields is a current limitation and something we hope to address in future.
You might be able to add a search pulldown at the top of the page for it, though. Under Database Editor > Search fields: Add something like: Document Lines|document_lines|match
Or you can write (or update) some custom code to populate a text field with the linked value, so you have something to search on.
interactivetools.com