M
Mike Fechner
Guest
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
Continue reading...
Continue reading...