SBX - Search With Button

SBX - Forum Post Title

Reporting data set "add filters" while creating new data set

Dynamics 365 Business Central Forum

AJ_5 asked a question on 14 Sep 2018 3:31 AM

Question Status

Suggested Answer

Hi,

I am trying to create a new data set to publish as a web service. There is an option to add filters to limit the rows returned from the dimension value table. However, the filter I am applying isn't working. I am working with the demo company "CRONUS USA, Inc." and trying to create a web service for the dimension "DEPARTMENT"

Reply
Suggested Answer

Do you mean that you're creating a query object and you're trying to publish it as WS?

Can you show us the definition?

Reply
AJ_5 responded on 14 Sep 2018 11:41 PM

Hi Stefano,

Yes you are correct. I am trying to create a page object and will be accessing it via the OData link. I am using the web services page to create a new data set . I am using the Dimension Value List object (object id 560) to separate Department dimension values and customergroup values. I have added a filter on dimension code = 'DEPARTMENT' but the odata url still gives me all dimension values. Is there something I am missing here?

Reply
Suggested Answer

Do you mean that you're creating a query object and you're trying to publish it as WS?

Can you show us the definition?

Reply

SBX - Two Col Forum

SBX - Migrated JS