Appsheet not considering SQL Full Table in Expression while applying Security Filters

[Hmunjal]

Dear Community,

Just migrated Google Sheets to SQL ,  Wherein SQL Database is having the same security filter as that of G Sheets

As below :

OR(
    AND(
         useremail()=[Email],
         lookup(
                Useremail(),
                "Users",
                "Email_ID",
                "User_Category"
                )=
         "Inputter"
       )
,
    Contains(
       Lookup(
               Useremail(),
               "Users",
               "Email_ID",
               "Auth_Latlong"
               ),
    [Project]
    
     )
 )

But When Applying below expressions it ignores the whole database and captures only current user table as I have to check the unique serial number in a complete database if any user is entering same serial number it should reflect an error but that is not going through when using SQL Database whereas it is working completely fine with G Sheet data.

Or(and([Gift Item].[Serial Number Required]=True,[In/Out]="In",Count(Select(Gift[Serial / Batch No.],And([Status]<>"Reject",[_THISROW].[Serial / Batch No.]=[Serial / Batch No.],[_THISROW].[UniqueID]<>[UniqueID])))=0),[Gift Item].[Serial Number Required]=False,[In/Out]="Out")

Please Suggest

Thanks in Advance...

[Hmunjal]

Please suggest