OData and dynamic filters

[s.wieczorek]

Hi,
Can i add dynamic filters to OData requests just like for sql commands (using @<VariableName>)? If not, how to make component send requests with /$filter=fieldName eq '<var from stimulsoft>'

[Alex K.]

Hello,

You can add necessary filtering for the DataBand component.

Thank you.

[s.wieczorek]

But will this send filters to OData server or will it filter data on the clients side?

[Edward]

Hi S.Wieczorek,

It will filter the data on the client side only. The report engine translates the data into an internal format and then filters that data.

Thank you,
Edward

[s.wieczorek]

So there is no possibility to dynamically add variables to filters for OData requests.... Will it be added in the future? It would be good to make Datasource requests the server with addition of filters. Now it will pull all data from DB(which can cause performance problems) or hardcoded set only.

[Alex K.]

Hello,

Unfortunately, at the current moment, we do not have plans to add this feature for the OData. Sorry.

Thank you.

[iandreev]

Hi,

I know this is an old question but right now I'm looking for the same thing. I want to use filters (variables that produce comboboxes) to filter OData on the server side. like /products?$filter=categoryid eq [variable value]

Is it possible now and if so how do I do it?

[Lech Kulikowski]

Hello,

Please try to use the variable in the connection string.

Thank you.