I am planning my approach to an issue and am just wondering if this is the correct approach or there is something better?
I will have a gallery that is populated by data from SQL server (using on-prem gateway) however..
I need to filter that data by a field that doesn't exist in the SQL Server data...
So I was thinking that I would create a dataflow table from the SQL data then add the column that I need with the filter parameters on it and then use the table as the datasource for the gallery? I will also need to update that field with action done using a check box in the gallery so will use collections and patch to achieve..Therefore the gallery should show the correct filtered items after updates..
Do you think that is a reasonable approach or is there a better way?
TIA
