Hi Team,
We are unable to fetch publications using the below query in Intelligent Viewer 25.3 with MSSQL 2022 Server:
/publication/api/v1/publications?contains(tags,and(key=keyName,value=keyValue))
We receive a 500 error:
{
"code": 500,
"userMessage": "Server error",
"developerMessage": "Unable to find publications: (RECIPIENT_FAILURE,500) Unable to find publications using provided query"
}
In the publication logs, we see:
'JSON_EXISTS' is not a recognized built-in function name.
We have verified that the publications exist in MS SQL 2022 Server with the correct keyName tag and the access token is valid. The same query structure works in Intelligent Viewer version 22.1 with PostgreSQL.
Is any additional configuration required for SQL Server in IV 25.3 for contains(tags,...) queries?
Thank you
