Hi all,
using the ABL samples provided with the OpenAccess IP for OpenEdge, I am executing the following query on the customer_pd object from Excel 2013:
SELECT CUSTOMER_PD.CustNum, CUSTOMER_PD.Country, CUSTOMER_PD.Name, CUSTOMER_PD.Address, CUSTOMER_PD.Address2, CUSTOMER_PD.City, CUSTOMER_PD.State, CUSTOMER_PD.PostalCode, CUSTOMER_PD.Contact, CUSTOMER_PD.Phone, CUSTOMER_PD.SalesRep, CUSTOMER_PD.CreditLimit, CUSTOMER_PD.Balance, CUSTOMER_PD.Terms, CUSTOMER_PD.Discount, CUSTOMER_PD.Comments, CUSTOMER_PD.Fax, CUSTOMER_PD.EmailAddressFROM OPENEDGE.ABL.CUSTOMER_PD CUSTOMER_PDWHERE (CUSTOMER_PD.CustNum<10000)ORDER BY CUSTOMER_PD.Name
The JsonObject received as the "filter" parameter on the AppServer looks like this here:
{"ablFilter":"(CustNum < 10000)"}
So there is no order by information passed in. However the sample suggest that there should be an orderby attribute.
Is that a configuration setting I may have missed somewhere?
Thanks,
Mike
Architect of the SmartComponent Library and WinKit
Consultingwerk Ltd.
Please make sure you have option "Service Object supports complex filter and sorting" checked on Object Edit page.
Object Edit page.
Flag this post as spam/abuse.
Hello Mike,
The "Service Object supports complex filter and sorting" option is for the OpenEdge Service Objects in Rollbase.
Does the documentation for the OpenAccess IP for OpenEdge mention about a capabilities property for the read method?
@openapi.openedge.method.property (name="capabilities", value="top,skip,id,orderBy").
Thanks.