Hi, I was searching through the documentation and example tutorials

<a class="user-mention notranslate" data-hovercard-type="user" data-hovercard-url="/us

orderBy Query Parameter about nodal HOT 3 CLOSED

edgar971 commented on August 16, 2024

orderBy Query Parameter

from nodal.

Comments (3)

edgar971 commented on August 16, 2024 1

@nogsantos Thanks for the help.

I ended up doing the following:

Created a function to parse the orderBy query.

parseOrderBy(query) {

        let orderBy = [];

        if (!query.__orderBy && query.__orderBy.length) return false;

        orderBy = query.__orderBy.split('|');

        return orderBy;

    }

Used the function inside my index method.

let order = this.parseOrderBy(this.params.query);
        console.log(order);

        Site.query()
            .where(this.params.query)
            .orderBy(...order)
            .end((err, models) => {


                this.respond(err || models);

            });

That worked for me.

from nodal.

nogsantos commented on August 16, 2024

By Query composer you have the .orderBy() method, something like...

...
Customer.query()
   .where(this.params.query)
    .join('phones')
    .limit(this.params.query.offset, process.env.QUERY_LIMIT)
    .orderBy("id", "DESC") // here you put your params
    .end((err, cliente) => {
...

Just send the values what you want in body or, like you said, in you query string.

You have another options, see http://nsipplswezey.github.io/nodal/docs/graphql.html

from nodal.

maxism commented on August 16, 2024

@edgar971 you should use __order instead of __orderBy param in your HTTP request. So in your case it will be looks like http:///localhost:8080/v1/sites?__order=created_at desc.

from nodal.

Recommend Projects