You can add one more column to your static entity like IsShow or Active and run a getquery to get only active record and bind it to with dropdown.

Hello,

I aggre with Pramod Jain, if you want to get all records from any entity you just need change the attributes on the dropdown, like:

Source Entity /Structure: Entity to get data from;
Source Attribute: Attribute to appear on the dropdown.

If you need a subset of any entity, you can do a query at Preparation action and the assign that query to the attribute Source Record List and then the attribute to appear on Source Attribute.

Hope it helped.

Hi All,

I am little confused. If I understand correctly, Valerji's use case is not to show "Deleted" records from Static Entity?

As per my knowledge we cannot delete record from Static entity from the application. We will need delete action or IsDeleted flag to delete the record. If we are making drop down out of Static Entity, we will get all records from Static entity unless we set flags in Static Entity.

Correct?

Actually,

Jose answer helped me. Instead of Source Entity I use Source Record List with requst to DB to get all recods except "Deleted" one.

Thank you All.

So you are pulling records from normal entity having IsDeleted flag as 'False' and not from the Static entity.

My concern was that how you are deleting records from Static Entity :)

Suraj ,
You are getting confused here , he is not deleting any value , it is an record in static entity named "DELETED" like we have different status in our static entity.
For example he has following records in his entity
1 PENDING
2 APPROVED
3 REJECTED
4 DELETED
so he simply wants to show only 1,2,3 and not the 4 and that can be achieved as Jose suggested.

Regards
-PJ-

Thanks Pramod for your detailed explanation. Sometimes I overthink that every problem is complex one.

Regards,
Suraj Borade