Hi,
We managed to solve the problem:
-on client side DynamicWhere needs data type for constant expression (if server is with zeos driver you don’t need it)
-on server side in the connection string you must include GUIDEndian=Big parameter if you are using PostgreSQL and FIreDAC driver
Best regards.