Let’s say I have a document:
“xp” : 1,
How can I parameterize a query like:
select myBucket.* from myBucket where xp = 1
Let’s say I need to swap out xp, hp, or mp with a parameter? Doing something like this just seems to compare the text “xp” against the number 1:
select myBucket.* from myBucket where $1 = 1
(then of course, use the SDK to set a positional parameter)
I am using the .NET SDK, but I think this is just a general N1QL question.