Solved: Select Statement in Security Filter - Page 2

GusL · 02-21-2022 06:41 PM

Hello Community,

In order to speed up sync time, I transitioned the table over to a relational database and filtered through the security filter. I read by using the expression, [Service Days] = Monday, it will still fetch all the records and then retain the filtered records. VS if the I sent the database a query: SELECT * from MyTable where [Service Days] = Tuesday. This expression would return the x number of records.

Per the documentation:

'Obviously, the second approach is much more efficient. Database systems have techniques like indexing that can run such queries quickly.'

I tried creating a Select statement that would return only those records that match the service day filtered but am having no success. Any help with the syntax is greatly appreciated.

The expression I need help tr

SELECT(*)

FROM SC Parcel

WHERE [Service Days] = Tuesday

Marc_Dillon

You are mis-interpreting the documentation. To quote the following linked doc "When security filters are used with database sources, there is the potential for the system to convert the security filter into a database query."

https://help.appsheet.com/en/articles/975990-scaling-using-security-filters

To re-state that, Appsheet itself will take your Appsheet expression, and convert it into a database query, which it will then use to retrieve the data. You, as the app builder, are not writing any database queries yourself anywhere.

[Service Days] = "Tuesday" is a fine Security Filter expression by itself. If you're using a SQL database, Appsheet will convert that into

SELECT ...... WHERE `Service Days`="Tuesday"

View solution in original post