How to SELECT/filter rows given a particular condition on a DataGrid/Data Table?
Hi,
I would like to SELECT the rows where column contains specified value.
Example: I would like to SELECT records where Country = "US"
ID | Name | Country
--------------------------
1 | John | US
2 | Fred | Canada
3 | Ben | US
Expected Result: Should return Data Table.
ID | Name | Country
--------------------------
1 | John | US
3 | Ben | US
Thanks
Posted: 3 years ago
Posted: 3 years ago
Thanks for your reply. My original source is from DataGrid. Which property/method do I need to use to connect to Lookup Table? Then how to populate the TableView? I saw the C# code:
DataView view =newDataView(table);
but not sure how to do it in Pega.
Thanks
Posted: 3 years ago
Thanks for the response.
I have 2 columns that is used to uniquely identify a record. Guess this is not possible with LookupTable.
Any other suggestion?
It depends on what you desired result is, but the TableView component is the simplest option. It attaches to a LookupTable and allows you to filter using standard System.Data.DataTable filter syntax. Additionally, it has a ToTable method which you can use to output a filtered DataTable with. It can be used as a DataSource for a DataGrid as well.