Skip to main content

Notifications

Announcements

No record found.

Small and medium business | Business Central, N...
Answered

Flowfield filters in api page

Posted on by 65

How to apply filters in the flowfields in businesscentral api page? Ex. $filter= flowfieldname lt 0

  • imkarthikeyan Profile Picture
    imkarthikeyan 65 on at
    RE: Flowfield filters in api page

    Thanks for your reply. When I try to filter the flowfield i got the error msg like 'field is not filterable'.

    Then I noticed  flowfield is multiplied with (-1) in the page that's the reason why I'm not able to apply filter.

    pastedimage1681193670064v1.png

  • Verified answer
    YUN ZHU Profile Picture
    YUN ZHU 73,647 Super User 2024 Season 2 on at
    RE: Flowfield filters in api page

    Hi, I did a simple test, and it is the same as adding a filter to a normal field.

    More details: https://yzhums.com/6117/#toc8

    https://api.businesscentral.dynamics.com/v2.0/d8f36038-1f93-4543-affc-5dc92b6ee871/Sandbox220/ODataV4/Company('My Company')/Items?$filter=InventoryField eq 100

    pastedimage1681170731869v1.png

    pastedimage1681170768266v2.png

    pastedimage1681170836898v3.png

    Hope this helps.

    Thanks.

    ZHU

  • Suggested answer
    Nitin Verma Profile Picture
    Nitin Verma 21,091 Super User 2024 Season 1 on at
    RE: Flowfield filters in api page

    Hi,

    You can try below syntax for using flowfilter

    pastedimage1681175079153v1.png

    https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/webservices/use-flowfilters-in-odata-uris

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans