Question
How to populate TableView with records from DataGrid?
Hi,
I would like to populate records to TableView to be able get the DISTINCT value of a column. Data will came from a DataGrid.DataSource.
Can't find the right method here:
http://help.openspan.com/52/Components/Data_Table_Viewer.htm
Is this done calling AddNew method in a loop? Is there an alternative? Like is it possible to translate this C# code to Pega?
DataView view =new DataView(table);
Thanks!
So far had done this with the use of LookupTable. I looped the datagrid (rows and column combination) and call the AddNew method to populate LookupTable.
Guess this is it for now. unless there's a better option.
The TableView also works with a DataSource. Once connected to a DataSource you can write a query against the DataSource, in the Filter property you would write a Where clause type query. I don't think you can do an actual DISTINCT as you can't specify the Select portion.
To your second question, DataView view = new DataView(table);, yes you can do this in a script component.
If your DGV is backed by a DataTable, you should be able to define the same column names in the LookupTable and then simply replace the table in the LookupTable with the DataTable from the DGV.
lookupTable.ReplaceTable(dgv.DataSource)
There is a ReplaceTable method on the LookupTable component.
Oh course this depends on your overall use case
Can you clarify? You could pull the column value from the properties of the table.