CODEWITHSUNDEEP
node.jsslonik
Md. Sajedul Karim
Md. Sajedul Karim

Reputation: 7085

How to generate dynamic and multiple Order By query in slonik

I am fetching an issue where I have to generate dynamic ORDER BY clause for multiple columns.

Here is my sample query:

SELECT *
FROM user
WHERE gender = 'male'
  ORDER BY created_at ASC, updated_at DESC
LIMIT 10 OFFSET 0;

Here, ORDER BY values will be dynamic and it is coming from user end.

My Progress:

const orderBy: string = 'ORDER BY created_at ASC, updated_at DESC';

SELECT *
FROM user
WHERE gender = 'male'
  ${orderBy}
LIMIT 10 OFFSET 0;

Here, if I pass the ORDER BY clause as ${orderBy}, then it takes it as a value. It shows an error.

The SLONIK-generated SQL is like the below:

{
  sql: "\n  SELECT *\nFROM user\nWHERE gender = 'male'\n  $1\nLIMIT 10 OFFSET 0;\n",
  type: 'SLONIK_TOKEN_SQL',
  values: [ 'ORDER BY created_at ASC, updated_at DESC' ]
}

Thanks in advance.

Upvotes: 0

Views: 342

Answers (1)

Beto
Beto

Reputation: 1

I was having the same problem. According to their docs, you need to create another query:

const query0 = sql.unsafe`SELECT ${'foo'} FROM bar`;
const query1 = sql.unsafe`SELECT ${'baz'} FROM (${query0})`;

Check their documentation: Nesting sql

Upvotes: 0

Related Questions