Home Analyst Portal

API Cireson SCSM Portal - Complex Criteria Examples

Jan_SchulzJan_Schulz Customer Adept IT Monkey ✭✭

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

  • Shane_WhiteShane_White Cireson Support Super IT Monkey ✭✭✭✭✭

    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

Sign In or Register to comment.