Dynamic clientdataset content filtering

I ask myself a question about how to filter the contents of clientdataset in a three-stage datasnap architecture: Oracle DB <=> My Datasnap Server <=> My Datasnap clients

I have an Oracle table accessed through TDSProviderConnectionand TClientDataset.

Several clients use a dataset that contains a field with a name "clientId". I would like each client to request only its own rows (exactly the same as WHERE clientId = 'Client1'in the SQL statement).

If I am right, using a filter does not reduce overhead.

myclientdataset.Filter:= 'ClientId = Client1';
myclientdataset.Filtered:= true;

Since it is still transmitting the entire client. I want the server to filter the sent message.

But I do not know how to do this using these components.

Any idea would be greatly appreciated.

Regards, In JP