What's the syntax to filter an IDO collection by a field with a null value using MGRestService? Field1 = null
Thanks,
Tim
Mongoose uses SQL Server as the backend database so something like thisWHERE column_name IS NULL
One of the first I tried that didn't work
An example would be this
MGRestService.svc/json/SLEDICoitems/adv/?rowcap=0&filter=CoNum='EC00000024' and CoLine=2 and Item IS NULL&orderby=CoNum&props=EdiCoCustNum,Item, CustItem,CustPo,CoRelease,CoNum,CoLine
did you encode the URI?