What is the correct way to perform the query in JSON to obtain the records that start with the letter "Y"?
The next JSON get the columns GivenName, MiddleName and Surname from "Contact":
{ "RootSchemaName":"Contact", "OperationType":0, "Columns":{ "Items":{ "GivenName":{ "Expression":{ "ExpressionType":0, "ColumnPath":"GivenName" } }, "MiddleName":{ "Expression":{ "ExpressionType":0, "ColumnPath":"MiddleName" } }, "Surname":{ "Expression":{ "ExpressionType":0, "ColumnPath":"Surname" } } } }, "AllColumns":1 }
And return all que records from "Contact".
When I apply the filter GivenName = Yxyxyx
{ "RootSchemaName":"Contact", "OperationType":0, "Columns":{ "Items":{ "GivenName":{ "Expression":{ "ExpressionType":0, "ColumnPath":"GivenName" } }, "MiddleName":{ "Expression":{ "ExpressionType":0, "ColumnPath":"MiddleName" } }, "Surname":{ "Expression":{ "ExpressionType":0, "ColumnPath":"Surname" } } } }, "AllColumns":1, "Filters":{ "RootSchemaName":"Contact", "FilterType":1, "ComparisonType":3, "LeftExpression":{ "ExpressionType":0, "ColumnPath":"GivenName" }, "RightExpression":{ "ExpressionType":2, "Parameter":{ "DataValueType":1, "Value":"Yxyxyx" } } } }
Returns all records with the name GivenName equal to "Yxyxyx"
But an error returned when I sent the query GivenName starts with "Y", like this:
{ "RootSchemaName":"Contact", "OperationType":0, "Columns":{ "Items":{ "GivenName":{ "Expression":{ "ExpressionType":0, "ColumnPath":"GivenName" } }, "MiddleName":{ "Expression":{ "ExpressionType":0, "ColumnPath":"MiddleName" } }, "Surname":{ "Expression":{ "ExpressionType":0, "ColumnPath":"Surname" } } } }, "AllColumns":1, "Filters":{ "RootSchemaName":"Contact", "FilterType":1, "ComparisonType":16, "LeftExpression":{ "ExpressionType":0, "ColumnPath":"GivenName" }, "RightExpression":{ "ExpressionType":2, "Parameter":{ "DataValueType":1, "Value":"Y" } } } }
The error return is:
{ "responseStatus": { "ErrorCode": "SqlException", "Message": "Incorrect syntax near '@P1'.", "Errors": [] }, "rowsAffected": -1, "nextPrcElReady": false, "success": false }
And, How do you filter two or more columns?
Like
2 comments
21:27 Nov 26, 2018
Try changing the ComparisonType from:
"ComparisonType":16
To
ComparisonType":9
9 = STARTS_WITH (16 = "NOT_EXISTS)
https://academy.bpmonline.com/api/jscoreapi/7.12.0/index.html#!/api/Ter…
Show all comments