This site is currently read-only as we are migrating to Oracle Forums for an improved community experience. You will not be able to initiate activity until January 30th, when you will be able to use this site as normal.

    Forum Stats

  • 3,889,967 Users
  • 2,269,775 Discussions
  • 7,916,823 Comments

Discussions

How to filter list data based on user

User_CV1YV
User_CV1YV Member Posts: 1 Green Ribbon

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?

Answers