When my app was based on a spreadsheet (Google sheets) I could compare text easily in a security filter.
[ColumnName] = <LOOKUP Text>
Now that I am using a mysql database the same security filter returns no rows because in the database you have to compare text like this:
ColumnName LIKE '%LOOKUP Text%'
How do I modify the AppSheet security filter so it can speak MySQL 5.6?
AFAIK, security filters should not change based on data source. Have you tried using CONTAINS() ?
โshouldโ being the operative word. CONTAINS() appears to work. Thank you very much!
User | Count |
---|---|
40 | |
34 | |
29 | |
23 | |
17 |