[Expression evaluation error at function 'reject' [line 39]: Incorrect number of parameters for function; expected 1 parameters, but found 0 parameters.]

Certified Associate Developer

Hi All

I am getting the error with reject function so please let me know what causing this error .

 [Expression evaluation error at function 'reject' [line 39]: Incorrect number of parameters for function; expected 1 parameters, but found 0 parameters.]

a!localVariables(
  local!group: index(
    rule!CDM2_findUserGroup(loggedInUser()),
    1,
    {}
  ),
  local!escalatedTo: if(
    a!isNullOrEmpty(local!group),
    {},
    index(
      a!queryEntity(
        entity: cons!CDM2_DSE_INQUIRIES,
        query: a!query(
          aggregation: a!queryAggregation(
            aggregationColumns: {
              a!queryAggregationColumn(field: "escalatedTo", isGrouping: true)
            }
          ),
          logicalExpression: a!queryLogicalExpression(
            operator: "AND",
            filters: {
              a!queryFilter(
                field: "groupId",
                operator: "=",
                value: local!group
              )
            },
            ignoreFiltersWithEmptyValues: false
          ),
          pagingInfo: a!pagingInfo(startIndex: 1, batchSize: - 1)
        ),
        fetchTotalCount: false
      ),
      "data",
      "escalatedTo",
      null()
    )
  ),
  local!tmodData: 
  reject(fn!isnull,
  a!forEach(
    items: local!escalatedTo,
    expression: if(
      a!isNullOrEmpty(fv!item),
      {},
      if(
        not(isusernametaken(fv!item)),
        fv!item,
        null()
      )
    )
  )),
  local!tmodGivenNames: if(
    a!isNotNullOrEmpty(local!tmodData),
    index(
      a!queryEntity(
        entity: cons!TMODS_DSE,
        query: a!query(
          selection: a!querySelection(
            columns: {
              a!queryColumn(field: "given_name"),
              a!queryColumn(field: "preferred_given_name"),
              a!queryColumn(field: "enterprise_login_id"),

            }
          ),
          logicalExpression: a!queryLogicalExpression(
            operator: "AND",
            filters: {
              a!queryFilter(
                field: "enterprise_login_id",
                operator: "IN",
                value: upper(local!tmodData)
              )
            },
            ignoreFiltersWithEmptyValues: true
          ),
          pagingInfo: a!pagingInfo(startIndex: 1, batchSize: - 1)
        ),
        fetchTotalCount: false
      ),
      "data",
      null()
    ),
    {}
  ),  
  local!groupMembers:a!forEach(
    items:  local!escalatedTo,
    expression: if(
      a!isNullOrEmpty(fv!item),
      {},
      if(
        not(isusernametaken(fv!item)),
        {
          xid: fv!item,
          name: a!localVariables(
            local!blankTmodGivenName: displayvalue(
              upper(fv!item),
              touniformstring(
                local!tmodGivenNames.enterprise_login_id
              ),
              if(                
                /*a!isNullOrEmpty(local!tmodGivenNames.preferred_given_name),*/
                a!isNullOrEmpty(index(local!tmodGivenNames.preferred_given_name,wherecontains(upper(fv!item),touniformstring(local!tmodGivenNames.enterprise_login_id)),{})),
                local!tmodGivenNames.given_name,
                local!tmodGivenNames.preferred_given_name
              ),
              {}
            ),
            if(
              a!isNullOrEmpty(local!blankTmodGivenName),
              fv!item,
              local!blankTmodGivenName
            )
          )
        },
        {
          xid: fv!item,
          name: user(fv!item, "firstName") & " " & user(fv!item, "lastName")
        }
      )
    )
  ),  
  a!recordFilterList(
  name: "Escalated To",
  isVisible: a!isNotNullOrEmpty(local!groupMembers),
  options: a!forEach(
  items: local!groupMembers,
  expression:a!recordFilterListOption(
  id: fv!index,
  name: fv!item.name,
  filter: a!queryFilter(
  field:'recordType!{92bc5c32-2509-4558-b252-56df608deb1a}CDM2 Inquiries.fields.{escalatedTo}escalatedTo',
  operator: "=",
  value: fv!item.xid
  )
  )
  )
  )
)

I am geeting the error in reject function when the "AssignTo" is null

  Discussion posts and replies are publicly visible

  • 0
    Certified Associate Developer
    in reply to Shubham Aware

     

    My exact requirement are if there is no any data/value in "escalatedto" field then the filter can't show any null value in dropdown.

    I want if there is a data in field then filter shows that value 

  • 0
    Certified Associate Developer
    in reply to jojog0003

    Hi experts

    Anybody help me on above code . I am still facing issues .

    Thanks 

  • 0
    Certified Lead Developer
    in reply to jojog0003

    In your code for local!groupMembers you intentionally create an entry with blank ID and blank Name when the current entry of local!escalatedTo is blank.  This is what's causing your dropdown to have a blank entry.  This is the expected behavior.

  • 0
    Certified Senior Developer
    in reply to jojog0003

    Hey  ,
    Try this code 

    a!localVariables(
      local!group: index(
        rule!CDM2_findUserGroup(loggedInUser()),
        1,
        {}
      ),
      local!escalatedTo: if(
        a!isNullOrEmpty(local!group),
        {},
        index(
          a!queryEntity(
            entity: cons!CDM2_DSE_INQUIRIES,
            query: a!query(
              aggregation: a!queryAggregation(
                aggregationColumns: {
                  a!queryAggregationColumn(field: "escalatedTo", isGrouping: true)
                }
              ),
              logicalExpression: a!queryLogicalExpression(
                operator: "AND",
                filters: {
                  a!queryFilter(
                    field: "groupId",
                    operator: "=",
                    value: local!group
                  )
                },
                ignoreFiltersWithEmptyValues: false
              ),
              pagingInfo: a!pagingInfo(startIndex: 1, batchSize: - 1)
            ),
            fetchTotalCount: false
          ),
          "data",
          "escalatedTo",
          null()
        )
      ),
      local!tmodData: a!flatten(
        a!forEach(
          items: local!escalatedTo,
          expression: if(
            a!isNullOrEmpty(fv!item),
            {},
            if(
              not(isusernametaken(fv!item)),
              fv!item,
              {}
            )
          )
        )
      ),
      local!tmodGivenNames: if(
        a!isNotNullOrEmpty(local!tmodData),
        index(
          a!queryEntity(
            entity: cons!TMODS_DSE,
            query: a!query(
              selection: a!querySelection(
                columns: {
                  a!queryColumn(field: "given_name"),
                  a!queryColumn(field: "preferred_given_name"),
                  a!queryColumn(field: "enterprise_login_id"),
                  
                }
              ),
              logicalExpression: a!queryLogicalExpression(
                operator: "AND",
                filters: {
                  a!queryFilter(
                    field: "enterprise_login_id",
                    operator: "IN",
                    value: upper(local!tmodData)
                  )
                },
                ignoreFiltersWithEmptyValues: true
              ),
              pagingInfo: a!pagingInfo(startIndex: 1, batchSize: - 1)
            ),
            fetchTotalCount: false
          ),
          "data",
          null()
        ),
        {}
      ),
      local!groupMembers: a!forEach(
        items: local!escalatedTo,
        expression: if(
          a!isNullOrEmpty(fv!item),
          {},
          if(
            not(isusernametaken(fv!item)),
            {
              xid: fv!item,
              name: a!localVariables(
                local!blankTmodGivenName: displayvalue(
                  upper(fv!item),
                  touniformstring(
                    local!tmodGivenNames.enterprise_login_id
                  ),
                  if(
                    /*a!isNullOrEmpty(local!tmodGivenNames.preferred_given_name),*/
                    a!isNullOrEmpty(
                      index(
                        local!tmodGivenNames.preferred_given_name,
                        wherecontains(
                          upper(fv!item),
                          touniformstring(
                            local!tmodGivenNames.enterprise_login_id
                          )
                        ),
                        {}
                      )
                    ),
                    local!tmodGivenNames.given_name,
                    local!tmodGivenNames.preferred_given_name
                  ),
                  {}
                ),
                if(
                  a!isNullOrEmpty(local!blankTmodGivenName),
                  fv!item,
                  local!blankTmodGivenName
                )
              )
            },
            {
              xid: fv!item,
              name: user(fv!item, "firstName") & " " & user(fv!item, "lastName")
            }
          )
        )
      ),
      a!recordFilterList(
        name: "Escalated To",
        isVisible: and(
          a!isNotNullOrEmpty(local!groupMembers),
          a!isNotNullOrEmpty(local!escalatedTo)
        ),
        options: a!forEach(
          items: local!groupMembers,
          expression: a!recordFilterListOption(
            id: fv!index,
            name: fv!item.name,
            filter: a!queryFilter(
              field: 'recordType!{92bc5c32-2509-4558-b252-56df608deb1a}.fields.{escalatedTo}',
              operator: "=",
              value: fv!item.xid
            )
          )
        )
      )
    )

  • 0
    Certified Associate Developer
    in reply to Shubham Aware

     

    The above code not working . I am still getting the error 

    Expression evaluation error at function a!forEach [line 140]: Error in a!forEach() expression during iteration 1: Expression evaluation error at function a!queryFilter [line 145]: Invalid index: Cannot index property 'xid' of type String into type List of Variant.

    Thanks 

  • 0
    Certified Senior Developer
    in reply to jojog0003

    I modified my above posted code. Check that once.
    Also Can you share the value coming for local!groupMembers.