microsoft / AL

Home of the Dynamics 365 Business Central AL Language extension for Visual Studio Code. Used to track issues regarding the latest version of the AL compiler and developer tools available in the Visual Studio Code Marketplace or as part of the AL Developer Preview builds for Dynamics 365 Business Central.
MIT License
718 stars 242 forks source link

IN operator not working in OdataV4 BC SaaS #7761

Closed mishof closed 2 weeks ago

mishof commented 4 weeks ago

According to these instructions: https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/webservices/use-filter-expressions-in-odata-uris

We are able to filter our published OdataV4 queries with the IN operator. f.i.: $filter=GDM1_FilterOnly eq 'ADM' and DATE_FilterOnly ge 2021-01-01 and DATE_FilterOnly le 2022-05-31 and GLACC_FilterOnly in ('7200','7250','7251','7300','7400','7401','7600','7711','7712','7730')

but the part "in ('7200','7250','7251','7300','7400','7401','7600','7711','7712','7730')" is not working in all of our BC SaaS versions. There is no error, but BC just ignores the IN operator and it's array of values.

General availability was announced for Apr 2, 2024: https://learn.microsoft.com/en-us/dynamics365/release-plan/2024wave1/smb/dynamics365-business-central/use-odata-v4-operator-web-service-queries

thloke commented 2 weeks ago

Hi, this issue is out of scope of for this repository. You should do one of the following:

As a reminder, this repository only handles issues to do with the compiler or VSCode development experience for AL.