Skip to Main Content

ORDS, SODA & JSON in the Database

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

QBEs orderby field created

martvJun 5 2019 — edited Jul 3 2019

Hi,

Have a question. How can i order itmes by attribute <created> via (QBEs)?

?

{

    "items": [

        {

            "id": "2E048A5541D44A508ABCEF88099E4C3C",

            "etag": "FEEBA77FAC7A97ACCE18A813D0025B5D2E97F309E9B5E76245C99A79B884C968",

            "lastModified": "2019-06-04T17:01:04.928322Z",

            "created": "2019-06-04T17:01:04.928322Z",

            "value": {

                "user": "x",

........................

{

    "$query": {

        "geodata.properties.WKTCLASS": {

            "$eq": "rf:OWLClass_000010"

        },

        "status": {

            "$eq": "I"

        }, "user": {"$eq": "x"}

    },

    "$orderby": {

        "$items.created": -1

    }

}

Comments
Post Details
Added on Jun 5 2019
8 comments
284 views