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
  • 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. 

  • 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 

Reply Children