API Cireson SCSM Portal - Complex Criteria Examples
Hi,
have anyone for the GetProjectionByCriteria a complex example. Like a typeprojection for workitems with assignedToUser Relationship. And there filter on status = "Active or In Progress" and assignedUser = "john doe"?
I used the Cireson View Builder in the console and replaces the alias with MP ID, the Classname with the ID and the Property with PropertyID. But it didn´t work.
The Examples in the API documentation and Knowledgebase are to simple so that i can´t find out what i did wrong.
And can the result have multiple relationship levels, like A Workitem -> Has Parent -> Assigned To Parent?
regards,
Jan
Answers
Hi Jan,
As mentioned on your other post, the syntax is slightly different, try using this and let me know if it helps:
{
"Id": "62bc2bc9-14be-3ff9-1ff4-ba3e0930f03c",
"Criteria": {
"Base": {
"Expression": {
"SimpleExpression": {
"ValueExpressionLeft": {
"GenericProperty": {
"@Path": "$Context/Path[Relationship='15e577a3-6bf9-6713-4eac-ba5a5b7c4722']$",
"#text": "DisplayName"
}
},
"Operator": "Like",
"ValueExpressionRight": {
"Value": "Shane%"
}
}
}
}
}
}
Thanks,
Shane