Haven’t found the answer to this on the forums yet.
I modified the SQL query on my grid to include a “where” criteria so I have a limited set of records.
I am using dynamic search, but the autocomplete on the fields uses the full table data, not the “where” clause. How can I modify the autocomplete so it uses the “where”?
Thanks!
SC rocks my socks!
Hello,
In the autocomplete field configuration have a option of “Edition Lookup”.
You check it and put your sql there.
Thank you!
For other learners like me… I expanded the “Search” -> “Fields” menu… clicked on my field and changed its “data type” to “Text Auto-Complete”.
That brought up a “Search Lookup” section where I could create and modify the autocomplete query.
Simple and works great!