use surreal variable into query

[josselinchevalay]

Hello,

i need to create a complex request with variable and if also:

LET $name="john";
 SELECT salary FROM employee WHERE name ~ $name

into surreal db LET / IF statements exists LET statement / if statement

but if i use my example query on section explore of grafana with surreal db source i don,t see anything

do you have an idea ?

[ppaulweber]

Hi @josselinchevalay, did you check the logs in the data query view? Or are there any error messages in the web console to provide more context to this issue? Thx 🙏

[josselinchevalay]

sure here you can see explore test

same request into explore with inspect console open :

on grafan server i don,t see any error

but this request on my surreal db respond 2081 lines

i don't understand. Maybe grafana respond directly after the LET STATEMENTS and not return the result of my seconds request

[josselinchevalay]

qucik update i use http cli like postman when i execute my script :

LET $name="ADMIN";
SELECT jobName FROM builds WHERE jobName ~ $name;

i receive it

[
  {
    "result": null,
    "status": "OK",
    "time": "34.68µs"
  },
 {
    "result": [......],
    "status": "OK",
    "time": "34.68µs"
  }
]

so i think by default we use only je first occurence of respond object but here we need to use the second

[ppaulweber]

Ah I see, yes makes sense ... so maybe we could consider in the plugin only to evaluate/return the last result set.

Would be a rather small insertion into the code base. Are you by change familiar with golang and do want maybe to make your first contribution in this effort? 😃

[josselinchevalay]

helas, i'm not too golang developer i suppose the change is in datasource.go or something in this taste but locally i donn't have tools to develop under golang

[josselinchevalay]

or better into

grafana.surrealdb/pkg/plugin/datasource.go

Line 600 in f1681f3

dataMap, ok := array[0].(map[string]interface{})

i guess

[josselinchevalay]

let me know is ok for you

[coutouly]

did you upgrade to surrealdb v2 ?

[josselinchevalay]

@coutouly i tested with v2 of surreal i continue to have an array where each line of my script return an json line of this array with result etc is more link how we consume this array of response