On SQL as data source, Usersettings for date ...

security
(tsuji koichi) #1

On SQL as data source, Usersettings for date is not working

I copied app from Googlesheet to SQL server.

Original App has security filter to slice the row by date column.

It has been working on original app, but clone app working on SQL server is ruling out all the row by the same security filter.

I made sure that the column data type on table (SQL) is “Date” type. Could not find any reason for this failure.

Removing the security filter, showing all the row data from this table, so the security filter is obviously not correctly working on SQL.

Security filter is super simple#

USERSETTINGS(Date From)<=[Date of Visitation (From)]

Could someone in Appsheet have a look?

(Praveen Seshadri (AppSheet)) #2

Hi @tsuji_koichi , could you please send us a support request with the name of the app, the name of the table that shows this issue, and what date to set in UserSettings to see the problem. Since this is with a SQL data source, you may also need to set up the IP address permissions for our dev/debug machines.

(tsuji koichi) #3

@praveen Hi Praveen, I will send email to support now, and want to take it from there.