OpenAccess for OpenEdge Sort order - Forum - DataDirect Connect - Progress Community

OpenAccess for OpenEdge Sort order

 Forum

OpenAccess for OpenEdge Sort order

  • 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

    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.

  • I am receiving Json already for the filter. So I was under the impression that was provided like that in the sample.
     
    Where is that setting – so that I can double check?

    Architect of the SmartComponent Library and WinKit

    Consultingwerk Ltd.

  • Object Edit page.

  • Hi, I know where to find that setting in Rollbase and used it before.
     
    But where do I find that setting in OpenAccess SDK for OpenEdge?
     
    And as I wrote before – I do already get JSON data – but only the ablFilter property is set, not the orderby.
     
     
    Von: pvorobie [mailto:bounce-pvorobie@community.progress.com]
    Gesendet: Dienstag, 28.
    Oktober 2014 18:02
    An: TU.DD.Connect@community.progress.com
    Betreff: RE: [Technical Users - DataDirect Connect] OpenAccess for OpenEdge Sort order
     
    Reply by pvorobie

    Object Edit page.

    Stop receiving emails on this subject.

    Flag this post as spam/abuse.

    Architect of the SmartComponent Library and WinKit

    Consultingwerk Ltd.

  • 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.

  • Hi Edsel,
     
    that property and that annotation is not mentioned in the docs or at least well hidden J
     
    I’ll give it a go, though!
     
    Cheers,
    Mike
    Von: egarcia [mailto:bounce-egarcia@community.progress.com]
    Gesendet: Dienstag, 28. Oktober 2014 18:24
    An: TU.DD.Connect@community.progress.com
    Betreff: RE: [Technical Users - DataDirect Connect] OpenAccess for OpenEdge Sort order
     
    Reply by egarcia

    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.

    Stop receiving emails on this subject.

    Flag this post as spam/abuse.

    Architect of the SmartComponent Library and WinKit

    Consultingwerk Ltd.

  • Hi Edsel,
     
    tried that. Added the annotation to the read method and this was added the capabilities attribute was added to the method definition in the json catalog:
     
                "operations": [{
                    "path": "?filter={filter}",
                    "type": "read",
                    "verb": "get",
                    "capabilities": "top,skip,id,orderBy",
                    "params": []
     
    But still no luck! Excel does have sort in the SELECT, but this is not send to the AppServer in the JSON.
     
    Mike

     

    Architect of the SmartComponent Library and WinKit

    Consultingwerk Ltd.

  • The OpenAccess for OpenEdge team should jump in, but both the filter and the orderby should be supported natively in the connector.
  •  
    In the current release we support only where clause in filter.  OpenAccess will sort results if there is order by in the query.
     
    Thanks and Regards,
    Chandu
     
    From: Bill Wood [mailto:bounce-wood@community.progress.com]
    Sent: 29 October 2014 AM 01:35
    To: TU.DD.Connect@community.progress.com
    Subject: Re: [Technical Users - DataDirect Connect] AW: OpenAccess for OpenEdge Sort order
     
    Reply by Bill Wood
    The OpenAccess for OpenEdge team should jump in, but both the filter and the orderby should be supported natively in the connector.
    Stop receiving emails on this subject.

    Flag this post as spam/abuse.

  • Hi Chandra,
     
    Is the support for the orderby, top and skip on the roadmap and planned for a future release?
     
    If so, when?
     
    Regards,
    Mike
    Von: Chandra Sekhar [mailto:bounce-csekhar@community.progress.com]
    Gesendet: Mittwoch, 29. Oktober 2014 06:25
    An: TU.DD.Connect@community.progress.com
    Betreff: RE: [Technical Users - DataDirect Connect] AW: OpenAccess for OpenEdge Sort order
     
    Reply by Chandra Sekhar
     
    In the current release we support only where clause in filter.  OpenAccess will sort results if there is order by in the query.
     
    Thanks and Regards,
    Chandu
     
    From: Bill Wood [mailto:bounce-wood@community.progress.com]
    Sent: 29 October 2014 AM 01:35
    To: TU.DD.Connect@community.progress.com
    Subject: Re: [Technical Users - DataDirect Connect] AW: OpenAccess for OpenEdge Sort order
     
    Reply by Bill Wood
    The OpenAccess for OpenEdge team should jump in, but both the filter and the orderby should be supported natively in the connector.
    Stop receiving emails on this subject.

    Flag this post as spam/abuse.

    Stop receiving emails on this subject.

    Flag this post as spam/abuse.

    Architect of the SmartComponent Library and WinKit

    Consultingwerk Ltd.

  • Hi Mike,
     
    We will support these features in next release. Dates are not finalized, I will keep you posted.
     
    Thanks and Regards,
    Chandu
     
    From: Mike Fechner [mailto:bounce-mikefechner@community.progress.com]
    Sent: 29 October 2014 AM 11:46
    To: TU.DD.Connect@community.progress.com
    Subject: [Technical Users - DataDirect Connect] AW: AW: OpenAccess for OpenEdge Sort order
     
    Reply by Mike Fechner
    Hi Chandra,
     
    Is the support for the orderby, top and skip on the roadmap and planned for a future release?
     
    If so, when?
     
    Regards,
    Mike
    Von: Chandra Sekhar [mailto:bounce-csekhar@community.progress.com]
    Gesendet: Mittwoch, 29. Oktober 2014 06:25
    An: TU.DD.Connect@community.progress.com
    Betreff: RE: [Technical Users - DataDirect Connect] AW: OpenAccess for OpenEdge Sort order
     
    Reply by Chandra Sekhar
     
    In the current release we support only where clause in filter.  OpenAccess will sort results if there is order by in the query.
     
    Thanks and Regards,
    Chandu
     
    From: Bill Wood [mailto:bounce-wood@community.progress.com]
    Sent: 29 October 2014 AM 01:35
    To: TU.DD.Connect@community.progress.com
    Subject: Re: [Technical Users - DataDirect Connect] AW: OpenAccess for OpenEdge Sort order
     
    Reply by Bill Wood
    The OpenAccess for OpenEdge team should jump in, but both the filter and the orderby should be supported natively in the connector.
    Stop receiving emails on this subject.

    Flag this post as spam/abuse.

    Stop receiving emails on this subject.

    Flag this post as spam/abuse.

    Stop receiving emails on this subject.

    Flag this post as spam/abuse.

  • Thanks!
    Von: Chandra Sekhar [mailto:bounce-csekhar@community.progress.com]
    Gesendet: Mittwoch, 29. Oktober 2014 07:46
    An: TU.DD.Connect@community.progress.com
    Betreff: RE: [Technical Users - DataDirect Connect] AW: AW: OpenAccess for OpenEdge Sort order
     
    Reply by Chandra Sekhar
    Hi Mike,
     
    We will support these features in next release. Dates are not finalized, I will keep you posted.
     
    Thanks and Regards,
    Chandu
     
    From: Mike Fechner [mailto:bounce-mikefechner@community.progress.com]
    Sent: 29 October 2014 AM 11:46
    To: TU.DD.Connect@community.progress.com
    Subject: [Technical Users - DataDirect Connect] AW: AW: OpenAccess for OpenEdge Sort order
     
    Reply by Mike Fechner
    Hi Chandra,
     
    Is the support for the orderby, top and skip on the roadmap and planned for a future release?
     
    If so, when?
     
    Regards,
    Mike
     
    Von: Chandra Sekhar [mailto:bounce-csekhar@community.progress.com]
    Gesendet: Mittwoch, 29. Oktober 2014 06:25
    An: TU.DD.Connect@community.progress.com
    Betreff: RE: [Technical Users - DataDirect Connect] AW: OpenAccess for OpenEdge Sort order
     
    Reply by Chandra Sekhar
     
    In the current release we support only where clause in filter.  OpenAccess will sort results if there is order by in the query.
     
    Thanks and Regards,
    Chandu
     
    From: Bill Wood [mailto:bounce-wood@community.progress.com]
    Sent: 29 October 2014 AM 01:35
    To: TU.DD.Connect@community.progress.com
    Subject: Re: [Technical Users - DataDirect Connect] AW: OpenAccess for OpenEdge Sort order
     
    Reply by Bill Wood
    The OpenAccess for OpenEdge team should jump in, but both the filter and the orderby should be supported natively in the connector.
    Stop receiving emails on this subject.

    Flag this post as spam/abuse.

    Stop receiving emails on this subject.

    Flag this post as spam/abuse.

    Stop receiving emails on this subject.

    Flag this post as spam/abuse.

    Stop receiving emails on this subject.

    Flag this post as spam/abuse.

    Architect of the SmartComponent Library and WinKit

    Consultingwerk Ltd.