Filtering oData page

(0) Share

Report

Posted on by aitorNAV

Hi everyone,

I have published a page as a webService. In that page, I show one variable that is calculated in the onAfterGetRecord event of the page. But I see that when I try to filter with the URI that variable, is nto working. Just works filtering with the field that are in the table.

Is it possible to filter from that calculated variable? basically I've created a variable that is the customer number, and want to filter the contact with a known custoemr number, something like this:

http:/XXXX:7058/DynamicsNAV110/ODataV4/Company('XXXX.')/ContactAPI?$filter=gCustNo eq '000010'

All responses (3)

Answers (0)

aitorNAV 35 on at

Like (0)

Report

RE: Filtering oData page

THnaks for your answer Josh, I dind't realise that the WebServices work in the same way on filtering.
Suggested answer

JAngle 33,159 on at

Like (1)

Report

RE: Filtering oData page

You can't filter with a calculated variable on a regular page in the UI. Web service with behave in the same way. If you want to filter with it you'll need a flow field on the table
Suggested answer

Andy Sather on at

Like (0)

Report

RE: Filtering oData page

Hello - We currently do not have dedicated Dev support via the Dynamics 365 Business Central forums, but I wanted to provide you some additional resources to assist. If you need assistance with debugging or coding I would recommend discussing this on one of our communities.

www.yammer.com/dynamicsnavdev

dynamicsuser.net/.../developers

I will open this up to the community in case they have something to add.