Hi,
So I have the following code for a list view:
SELECT
COL_1, COL_2, COL_3, COL_4, COL_5, COL_USER
FROM TABLE_1
WHERE COL_1='EXPIRED'
AND COL_USER = :APPUSER
GROUP BY COL_2, COL_3, COL_4, COL_5, COL_USER
ORDER BY COL_2;
I want to be able to filter the data from the list depending on the user logged into the APP so where the current user = COL_USER, but my current code is not working. Does anyone know how to do this?