Hi VinayMurthy,I am getting a list of File names in an collection, And I want to delete the files, if its name contains location in it.. I have attached an moc data of the collection :
Did you check the above filter condition which returns an output collection with only those rows that have location in them?Actually, I am deleting those files from an web app, I have already designed 2 actions which will select and delete those files based on value I pass on the value field, which I made dynamic when I spy that element in Application modular. Soo now I have to pass the value only if it contains Locations..
A general condition to use in the filter criteria is "Name = 'Pass'". This will filter all records where the value is Pass in the column called Name. If you look at the code of the Filter collection action it is filtering a collection based on the filter criteria that was passed as a parameter. Collections are datatables in .net. If you do a websearch on how to filter a datatable you will come across different selection criteria and operators that can be used.Yeap, its working... Could you please explain bit more on how did you framed this : "Name LIKE '*location*'" and any reference material to learn more on this kind.. Thanks ~VJ