Hello Dilmi,

I am not sure what you are trying to implement so if you can explain more what is your scenario you are trying to implement or share action you are creating.

Let me try to suggest solution based on my assumption. You can add advance SQL query to your action and inside it add input parameters which will be value of session mail flag (SessionVariable) variable and value of  CVIP_Mail_Crpnd mail flag (MailFlagValue) then you need to add output structure for your advanced SQL

for SQL statment you can write:

Select * from {CVIP_Mail_Crpnd}

where @SessionVariable = false or {CVIP_Mail_Crpnd}.[MAIL_FLG ] = @MailFlagValue 

You can read more here about advanced SQL:

https://success.outsystems.com/Documentation/11/Developing_an_Application/Use_Data/Query_Data/SQL_Queries

please anyone can share the query for filter the ACTIVE Inactive Close data

Hi Dilmi,

I have attached an OML file to filter the active and inactive SQL queries.

Regards,

Dhivyaraj Sivam

Hello Dilmi,

Kindly find attached oml but please note that I made many changes to your module first thing I found you are using two different quires to return data. In preparation you are using aggregate and in search button you are using SQL query so I add local variable EmployeesList of data type list of Employ and in both cases assigned returned list from quires to this list then bind this list as data source for table.

I also created input parameter for SQL query as text which contains Ids of states selected comma separated and set it property Expand Inline to Yes