Readonly- Grid

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. 

  Discussion posts and replies are publicly visible

Parents Reply Children
  • 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 

  • 0
    Certified Lead Developer
    in reply to KM

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

  • i guessed why it was not showing data in production, as per analysis this queryprocessanalysis is taking too much time. maybe just because of timeout it is not showing data 

  • 0
    Certified Lead Developer
    in reply to KM

    What is the page size set to?  What happens if you try a smaller value for that?