Hi Vasilis,

you need to write a query in SQL Tool to get the records  by filtering the mentioned column, by using the where clause.

If you wish to get all columns in the list use this-

Select *  From {EntityName} where {EntityName}.[EntityAttributeName] = @Query Parameter Name

you can create the query parameter to pass a attribute value by which you wish to filter the records.

you may need to create one output Structure/Entity. in this case where you want all columns in to the record, just have the output structure as you Entity.

you can test your output, if the query is running properly , by passing test input values.

If you whish to have some of the columns in the output ,you need to mention the columns name and seperate them with comma,in select ,like-

Select {EntityName}.[EntityAttribute1Name], {EntityName}.[EntityAttribute2Name] 

  From {EntityName} where {EntityName}.[EntityAttributeName] = @Query Parameter Name

rest process is same.

Hope this helps,

Thanks Mita

Hi @Vasilis Roumeliotis

Add one input parameter (Description) in the sql and pass value from dropdown. 

SELECT {location}.[id] , {location}.[desc]

FROM {location}

WHERE ({location}.[desc] LIKE CONCAT('%', @Description, '%'))

Thanks,

Vipin Yadav

Hello Vasilis,

Not sure if this is what you want to achieve but check attached oml.

Regards,

Pramod.

Hello Vasilis,

I got your issue. And it was quite interesting for me to get solution for this issue so I created a Screen(bookings) in one of my existing POC app and tested it. It worked properly(screenshot). Kindly go through the logic in Bookings screen in attached OML. 

Kindly give attention in these highlighted point:

Hope it helps!!

Sanjay