OFFSET and LIMIT are not working when placed in CosmosDB binding of Azure functions

user_1472423 0
Viewed 224

I have followed the process mentioned in the post to supply values for OFFSET and LIMIT in my sqlquery. Below is how it looks like

SELECT * FROM c where c.recordType = 'employees' OFFSET udf.convertToNumber('0') LIMIT udf.convertToNumber('200')

But facing this error, "message\":\"Syntax error, incorrect syntax near 'udf'.\"

Any help, please?

azure-cosmosdb-sqlapi azure-cosmosdb azure-functions azure
1 Answers

Why you don't apply just the OFFSET 0 LIMIT 200, instead of calling a udf to convert the string 0 to number 0 and string 200 to number 200?

user_48753000
Related