Why queryProcessAnalytics function is not working in rule event?

Firstly, when you are indexing a particular field from queryProcessAnalytics().data, that field will contain an array of elements. So, your if condition will return a list of true and false. Means it will return a list of boolean elements.

Store your queryProcessAnalytics().data in a local variable, say local!data. Then use the local variable inside your if condition as,
if(
index(local!data,"c31","") =1,
true,
false
)

put the entire code inside a load().

I tried this way also but getting same error and process paused by exception.
Thanks!!

Don't put your load and a!queryProcessAnalytics().data inside if condition. What I meant was:
load(
local!data:a!queryProcessAnalytics().data,

then start your if conditions and everything else.......

if(/*your condition*/,

false,

if(/*Your Condition*/,

true,

false

)

)
)

Your entire code should be inside load. That means your code should start with load()

I think your batchsize should be -1. If it is not -1and if you are calling your a!queryProcessAnalytics() inside load, you will have only one data.

 

I have tried this way still facing same issue

Hi Shubham Aware (shubhama),

Could you try using this code:

if(
  rule!RCOS_PFM_nullCheck( ri!ppid_int ),
  {},
  index(
    index(
      a!queryProcessAnalytics(
      report: cons!RCOS_PFM_CUSTODIAN_TASK_REPORT,
        contextProcessModels: cons!RCOS_PFM_CUSTODIAN_PROCESS_MODEL,
        query: a!query(
          pagingInfo: a!pagingInfo(
            startIndex: 1,
            batchSize: 1,
            sort: a!sortInfo(
              field: "c32",
              ascending: false
            )
          ),
          filter: a!queryFilter(
            field: "c28",
            operator: "=",
            value: ri!ppid_int
          )
        )
      ).data,
      "c31",
      ""
    ), 1, {}
  ) = "1"
)

If you still get the same issue, first test the result executing the queryprocessanalytics rule, to see if it's ok, then with the first and then the last one, like debugging your results.

Hi Shubham Aware (shubhama),

Could you try using this code:

if(
  rule!RCOS_PFM_nullCheck( ri!ppid_int ),
  {},
  index(
    index(
      a!queryProcessAnalytics(
      report: cons!RCOS_PFM_CUSTODIAN_TASK_REPORT,
        contextProcessModels: cons!RCOS_PFM_CUSTODIAN_PROCESS_MODEL,
        query: a!query(
          pagingInfo: a!pagingInfo(
            startIndex: 1,
            batchSize: 1,
            sort: a!sortInfo(
              field: "c32",
              ascending: false
            )
          ),
          filter: a!queryFilter(
            field: "c28",
            operator: "=",
            value: ri!ppid_int
          )
        )
      ).data,
      "c31",
      ""
    ), 1, {}
  ) = "1"
)

If you still get the same issue, first test the result executing the queryprocessanalytics rule, to see if it's ok, then with the first and then the last one, like debugging your results.

Hi Brazil Vibanco Vibanco

I have tried this way also process status is changed to paused by exception.

Actually problem with my condition is value of my pv! is not changing that's why rule event is not getting called after interval of time.
In rule event we need to pass any parameter as it's value may get changed and based on that value rule condition is executed.