Skip to main content
kavyam0002
July 19, 2022
Question

Readonly- Grid

  • July 19, 2022
  • 9 replies
  • 0 views

Hi,

am showing list of tasks in read only grid. which is showing data in grid for all users in DEV,UAT and STG but in Production users are not able to see it only few users (belongs to some grp) are able to see the grid

how can i find solution for it any suggestions. 

    9 replies

    July 19, 2022

    are you getting any issues there or there is a blank grid?

    kavyam0002
    July 19, 2022

    blank grid

    July 19, 2022

    please check the filters for queryprocessanalytics for those users. Maybe there are no tasks available for those some users.

    harshitb6843
    July 19, 2022

    You cannot find the solution unless you provide more information about it. 
    Please attach all the relevant resources that can help us understand the problem and assist you. 
    It includes the code of the grid, code of the ER and any other screenshots of objects that are directly connected to this problem. 

    kavyam0002
    July 21, 2022

    a!queryProcessAnalytics(
          report: cons!CR_RPT_ACTIVE_TASKS_FOR_USER_REPORT,
          contextUsers: getdistinctusers(
            {
              cons!CR_GROUP_ALL_USERS
              /*cons!CR_GRP_RELATIONSHIP_MANAGER_GROUP,*/
              /*cons!CR_GRP_UNIT_HEAD_GROUP,*/
              /*cons!CR_GRP_SEGMENT_HEAD_GROUP*/
            }
          ),
          query:  a!query(
            logicalExpression: a!queryLogicalExpression(
              operator: "AND",
              logicalExpressions: {
                a!queryLogicalExpression(
                  operator: "OR",
                  filters: {
                    a!forEach(
                      items: touniformstring(
                        {
                          cons!CR_TXT_ALL_PROCESS_MODEL_NAMES,
                          cons!CR_APP_TXT_ALL_PROCESS_MODEL_NAMES,
                          cons!CR_APP_LA_TXT_ALL_PROCESS_MODEL_NAMES,
                          cons!CR_CMU_TXT_ALL_PROCESS_MODEL_NAMES
                        }
                      ),
                      expression: {
                        a!queryFilter(
                          field: "c13",
                          operator: "=",
                          value: fv!item
                        )
                      }
                    )
                  }
                ),
                a!queryLogicalExpression(
                  operator: "AND",
                  filters: {
                    a!queryFilter(
                      field: "c0",
                      operator: "includes",
                      value: local!customerName_txt,
                      applyWhen: not(
                        isnull(
                          local!customerName_txt
                        )
                      )
                    ),
                    a!queryFilter(
                      field: "c1",
                      operator: "in",
                      value: local!status_txt,
                      applyWhen: not(
                        rule!APN_isEmpty(
                          local!status_txt
                        )
                      )
                    ),
                    a!queryFilter(
                      /*field: "c11",*/
                      field: "c17",
                      operator: "=",
                      value: local!moduleId_int,
                      applyWhen: not(
                        rule!APN_isBlank(
                          local!moduleId_int
                        )
                      )
                    ),
                    a!queryFilter(
                      field: "c4",
                      operator: "=",
                      value: local!cif_int,
                      applyWhen: not(
                        isnull(
                          local!cif_int
                        )
                      )
                    ),
                    a!queryFilter(
                      field: "c5",
                      operator: ">=",
                      value: local!fromDate_dt,
                      applyWhen: not(
                        isnull(
                          local!fromDate_dt
                        )
                      )
                    ),
                    a!queryFilter(
                      field: "c5",
                      operator: "<=",
                      value: local!toDate_dt,
                      applyWhen: not(
                        isnull(
                          local!toDate_dt
                        )
                      )
                    ),
                    a!queryFilter(
                      field: "c2",
                      operator: "=",
                      value: local!originator_txt,
                      applyWhen: not(
                        isnull(
                          local!originator_txt
                        )
                      )
                    )
                  }
                )
              }
            ),
            pagingInfo: local!pagingInfo
          )
        )

    this is querry process analytics. this data only sending to to grid to show in read only mode 

    mikes0011
    Brainy
    July 21, 2022

    What happens when you run just that QPA call in the expression rule editor?  Does the data you get back look right?

    The Expression Guru
    Participating Frequently
    July 19, 2022

    For a user to be able to view other user's tasks they need at least viewer permission to the processes. 

    Please review process instance security