Customer 47: Use @rid in SQL Function

[j5bot]

I am a commercial support customer (#47) and I am experiencing problems using @Rid in an SQL function.

When I attempt to write a function where @Rid=$param is part of the WHERE clause, the function returns an empty result set.

example function:

{"@type":"d","@rid":"#7:9","@version":4,"@class":"OFunction",
"code":"select from V where @rid=$param",
"parameters":["param"],
"language":"SQL","idempotent":true,"name":"fromrid"}

I have tried with @rid.asString() with the same result.

example function:

{"@type":"d","@rid":"#7:10","@version":4,"@class":"OFunction",
"code":"select from V where @rid.asString()=$param","parameters":["param"],
"language":"SQL",
"idempotent":true,"name":"fromridAsString"}

[lvca]

You should pass the RID without #. This works:

select from V where @rid = :param