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.EmailAddress
FROM OPENEDGE.ABL.CUSTOMER_PD CUSTOMER_PD
WHERE (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
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.
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.
Flag this post as spam/abuse.
The OpenAccess for OpenEdge team should jump in, but both the filter and the orderby should be supported natively in the connector.
Flag this post as spam/abuse.
Flag this post as spam/abuse.
Flag this post as spam/abuse.
Flag this post as spam/abuse.
Flag this post as spam/abuse.
Flag this post as spam/abuse.
Flag this post as spam/abuse.
Flag this post as spam/abuse.
Flag this post as spam/abuse.
Flag this post as spam/abuse.