Filtering in TWebDataSource

BIZ TMS XData
1

I have a TWebDataSource connected to a TXDataWebDataSet using an Entity. If I connect another TWebDataSource to the same DataSet and Filter the results.

Is the filtering

  • Happening locally in the DataSource (in which case everything will work fine)
  • Happening locally in the DataSet (in which case the other dataset will get stuffed)
  • Happening at the Server.

I am trying to minimize data fetch. I need the same list in two different TWebDBLookupCombos, but filtered differently.

2

What Filter are you referring to? The Filter property, or the XData $filter in QueryString? The former happens locally, the latter happens in server.

But both happen in dataset, just like in any Delphi programming ever. A Delphi dataset never has two different sets of data. If you want a different set of data, use a different dataset.