Appian Community and Appian Academy are being upgraded. From July 24–August 3, the Appian Community will be in read-only mode. During this time, the site will be read-only and user registration will be disabled. We apologize for any inconvenience this may cause, but a more secure, stable, and performant Community experience is coming soon!

The new Appian Community launches August 3, followed by Appian Academy on August 7. During the migration, Appian Community Edition, Appian Academy, Documentation, Certifications, Instructor-led Customer Training, Partner Sales Training & Accreditation, and Forum (for Appian Partners and Customers only) will remain available.
  • State Not Answered
  • Replies 23 replies
  • Subscribers 9 subscribers
  • Views 13886 views
  • Users 0 members are here
Related Discussions
Home » Discussions » AI and Rules

How does contextProcessModels property of a!queryProcessAnalytics() function wor

greggl
How does contextProcessModels property of a!queryProcessAnalytics() function work?

My a!queryProcessAnalytics() function works great below when using contextProcessModels, but when I try and switch to contextProcessIds to display just the current process, it returns nothing. So then I backed up and just tried to hard-code the process ID that I want which is 6400, and that doesn't work. I tried using the processId variable and toInteger(6400) but no luck. What gives?

How is the contextProcessIds used correctly to return just those process IDs (pp!id) and can you show an example?

Thanks much!

local!report: a!queryProcessAnalytics(
report:cons!eOff_TASKS_GRID,
/* contextProcessModels: cons!EOB_MAIN_PROCESS_MODEL, */
           contextProcessIds:{tointeger(6400)}
          
           /*
contextProcessIds:
           contextProcessModels:cons!eOFF_MAIN_PROCESS_MODEL
           contextProcessIds:6400,
           ri!processId,*/
          
/*


OriginalPostID-201423

OriginalPostID-201423

  Discussion posts and replies are publicly visible

Parents
  • 0
    @greggl Here are two ways of doing it:

    Ex 1:
    a!queryProcessAnalytics(
    report: cons!eOff_TASKS_GRID,
    contextProcessModels: cons!EOB_MAIN_PROCESS_MODEL,
    query: a!query(
    pagingInfo: a!pagingInfo(startIndex: 1, batchSize: -1),
    logicalExpression: a!queryLogicalExpression(
    operator: "AND",
    filters: {
    a!queryFilter(field: "cx", operator: "in", value: tointeger(ri!processId))
    \ t/* Replace 'cx' with a value that holds process id in the Report, for instance: c2 */
    }
    )
    )
    )

    Ex 2:
    a!queryProcessAnalytics(
    report: cons!eOff_TASKS_GRID,
    contextProcessModels: cons!EOB_MAIN_PROCESS_MODEL,
    query: a!query(
    pagingInfo: a!pagingInfo(startIndex: 1, batchSize: -1),
    filter: a!queryFilter(field: "cx", operator: "in", value: tointeger(ri!processId))
    \t/* Replace 'cx' with a value that holds process id in the Report, for instance: c2 */
    )
    )

    Please do let me know in case if you have any follow up questions.
Reply
  • 0
    @greggl Here are two ways of doing it:

    Ex 1:
    a!queryProcessAnalytics(
    report: cons!eOff_TASKS_GRID,
    contextProcessModels: cons!EOB_MAIN_PROCESS_MODEL,
    query: a!query(
    pagingInfo: a!pagingInfo(startIndex: 1, batchSize: -1),
    logicalExpression: a!queryLogicalExpression(
    operator: "AND",
    filters: {
    a!queryFilter(field: "cx", operator: "in", value: tointeger(ri!processId))
    \ t/* Replace 'cx' with a value that holds process id in the Report, for instance: c2 */
    }
    )
    )
    )

    Ex 2:
    a!queryProcessAnalytics(
    report: cons!eOff_TASKS_GRID,
    contextProcessModels: cons!EOB_MAIN_PROCESS_MODEL,
    query: a!query(
    pagingInfo: a!pagingInfo(startIndex: 1, batchSize: -1),
    filter: a!queryFilter(field: "cx", operator: "in", value: tointeger(ri!processId))
    \t/* Replace 'cx' with a value that holds process id in the Report, for instance: c2 */
    )
    )

    Please do let me know in case if you have any follow up questions.
Children
No Data
© 2026 Appian. All rights reserved.
We want to hear from you! Submit a review on Gartner or G2.