Parameters do not work in string functions about surrealdb HOT 5 CLOSED

Sure, thats just the current execution context for that query, like $parent inside a sub-query.

https://surrealdb.com/docs/surrealdb/surrealql/parameters#parent-this

Don't forget to close the issue ^^

from surrealdb.

Heya! If I understand your example correctly, you want to ensure that the column with the name of the column being contained in the $column variables, which is a string, contains a value that you pass from the client in the $value parameter? You would do this like so:

LET $column = "name";
LET $value = "biryani";

SELECT * FROM menu_item WHERE  string::startsWith($this[column], $value) LIMIT 10 FETCH categories

from surrealdb.

$column and $value are dynamic, so i don't really know whats coming in them.
Since i am using JavaScript I would do the above like this.

LET $column = "${column}";
LET $value = "${value}";

this is same as i am sending values directly in query.

My question is why can't i use parameters inside the query. The query works when i don't use string functions. But with string functions it gives error.

I have a similar issue for RELATE query, where i am sending extra data with parameters and they are also not working. While sending them directly in query working

from surrealdb.

import { Surreal } from 'surrealdb.node';

const db = new Surreal();

async function main() {
  await db.connect('ws://127.0.0.1:8000');
  await db.signin({
    username: 'root',
    password: 'root',
  });
  await db.use({ ns: 'test', db: 'test' });

  await db.create('menu_item', { name: 'Pizza' });
  let res = await db.query(
    'SELECT * FROM menu_item WHERE string::startsWith($this[$column], $value)',
    { column: 'name', value: 'P' }
  );
  console.log(res);
}

main();

i've tried around a bit, this seems to work, you where just missing the $this like @kearfy mentioned

from surrealdb.

This resolved the issue but can you tell me why $this is used with $column variable and why not with $value?
@fokklz

from surrealdb.