the filter is not applied at all (no error, simply the results as if no filter is applied at all)
If I use
query?$filter=(resourceNo eq 'USERA' or resourceNo eq 'USERB')
it works as expected.
This is against latest version of cloud sandbox (23.2.14098.14274) and the field is a normal code[20] field, no flowfield or something (although that shouldn't matter).
An I doing something wrong here or is this an issue in BC?
Hi, I remember BC does not support in-filter expression. I just tested it again and it does not work. I checked the information on the Internet, and except for Microsoft's documents, no other experts mentioned that in-filter expression can be used.
https://api.businesscentral.dynamics.com/v2.0/c8558e71-6ad8-4fcd-9f29-3ca165b41bbe/Sandbox223/ODataV4/Company('My%20Company')/VendorLedgerEntries$filter=Entry_No in (1760,1762,1768)
Hopefully other experts can give you better advice.
Thanks
ZHU
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.