Filter not refreshing in Record

Karthigha Kailasam over 6 years ago

Hi All,

I have a scenario like I will be displaying the record list in a grid view to the user, where the facets will be populated from one of the column, For EX: Priority.

Now the scenario is like "Priority" is having "low", "Medium" and "High", I have added a new case with "Critical" as "Priority" then the facets are not refreshing, the facets are refreshing only when I refresh the page or reload the record.

Please let me know is there a dynamic way to achieve the facets are also getting refreshed.

Thanks!!

Discussion posts and replies are publicly visible

Parents

0 aloks0189
Certified Lead Developer
over 6 years ago

Hi @karthighak69, Try enclosing the rule(Which contains facet) under with() , for example:

with(
local!myData: rule!myRule(),
a!facet(
name: "Something",
options: Loop the Expression of a!facetOption()
)
)
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Reject Answer

Cancel
0 lokeshk over 6 years ago in reply to aloks0189

Hi @karthighak69,
try using the below example:

with(
local!pagingInfo: if(
isnull(
ri!query
),
a!pagingInfo(
startIndex: 1,
batchSize: 100
),
ri!query.pagingInfo
),
local!queryCondition: index(
ri!query,
"logicalExpression|filter|search",
null
),
local!queryCondition1: index(
local!queryCondition,
"logicalExpression|filter|search",
null
),
local!sub1: index(
local!queryCondition1[1],
"field",
null
),
local!sub2: index(
local!queryCondition1[1],
"operator",
null
),
local!sub3: index(
local!queryCondition1[1],
"value",
null
),
local!deffilter: if(
and(
index(
local!queryCondition,
"field",
null
) = "firstName",
index(
local!queryCondition,
"operator",
null
) = "not null"
),
index(
local!queryCondition,
"value",
null
),
null
),
local!requestedId: if(
and(
index(
local!queryCondition,
"field",
null
) = "rp!id",
index(
local!queryCondition,
"operator",
null
) = "="
),
index(
local!queryCondition,
"value",
null
),
null
),
local!searchTerm: index(
local!queryCondition,
"searchQuery",
null
),
local!requestStatus: if(
and(
index(
local!queryCondition,
"field",
null
) = "requestStatus",
index(
local!queryCondition,
"operator",
null
) = "="
),
index(
local!queryCondition,
"value",
null
),
null
),
local!employees: if(
not(
isnull(
local!requestedId
)
),
rule!getEmployeeByyId(
local!requestedId,
local!deffilter,
local!pagingInfo
),
if(
not(
isnull(
local!searchTerm
)
),
rule!searchEmployeesByLastName(
local!searchTerm,
local!deffilter,
local!pagingInfo
),
if(
local!sub1 = "requestStatus",
rule!getemployeeByrequestStatus(
local!sub3,
local!deffilter,
local!pagingInfo
),
if(
local!sub1 = "rp!id",
rule!getEmployeeByyId(
local!sub3,
local!deffilter,
local!pagingInfo
),
rule!Entity(
local!deffilter,
local!pagingInfo
)
)
)
)
),

topagingInfo(
1,
1
)

)
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

0 kondetiv over 6 years ago in reply to lokeshk

Try to use "rich formatting editor" while posting code, images, videos or attaching files etc. Such that it would be very easy to read. The fun part in "use rich formatting" editor is, it can format all programming languages code except SAIL. So we have to format our code in the expression editor and select language text then paste your code.

with(
  local!pagingInfo: if(
    isnull(
      ri!query
    ),
    a!pagingInfo(
      startIndex: 1,
      batchSize: 100
    ),
    ri!query.pagingInfo
  ),
  local!queryCondition: index(
    ri!query,
    "logicalExpression|filter|search",
    null
  ),
  local!queryCondition1: index(
    local!queryCondition,
    "logicalExpression|filter|search",
    null
  ),
  local!sub1: index(
    local!queryCondition1[1],
    "field",
    null
  ),
  local!sub2: index(
    local!queryCondition1[1],
    "operator",
    null
  ),
  local!sub3: index(
    local!queryCondition1[1],
    "value",
    null
  ),
  local!deffilter: if(
    and(
      index(
        local!queryCondition,
        "field",
        null
      ) = "firstName",
      index(
        local!queryCondition,
        "operator",
        null
      ) = "not null"
    ),
    index(
      local!queryCondition,
      "value",
      null
    ),
    null
  ),
  local!requestedId: if(
    and(
      index(
        local!queryCondition,
        "field",
        null
      ) = "rp!id",
      index(
        local!queryCondition,
        "operator",
        null
      ) = "="
    ),
    index(
      local!queryCondition,
      "value",
      null
    ),
    null
  ),
  local!searchTerm: index(
    local!queryCondition,
    "searchQuery",
    null
  ),
  local!requestStatus: if(
    and(
      index(
        local!queryCondition,
        "field",
        null
      ) = "requestStatus",
      index(
        local!queryCondition,
        "operator",
        null
      ) = "="
    ),
    index(
      local!queryCondition,
      "value",
      null
    ),
    null
  ),
  local!employees: if(
    not(
      isnull(
        local!requestedId
      )
    ),
    rule!getEmployeeByyId(
      local!requestedId,
      local!deffilter,
      local!pagingInfo
    ),
    if(
      not(
        isnull(
          local!searchTerm
        )
      ),
      rule!searchEmployeesByLastName(
        local!searchTerm,
        local!deffilter,
        local!pagingInfo
      ),
      if(
        local!sub1 = "requestStatus",
        rule!getemployeeByrequestStatus(
          local!sub3,
          local!deffilter,
          local!pagingInfo
        ),
        if(
          local!sub1 = "rp!id",
          rule!getEmployeeByyId(
            local!sub3,
            local!deffilter,
            local!pagingInfo
          ),
          rule!Entity(
            local!deffilter,
            local!pagingInfo
          )
        )
      )
    )
  ),
  topagingInfo(
    1,
    1
  )
)

Reply

0 kondetiv over 6 years ago in reply to lokeshk

with(
  local!pagingInfo: if(
    isnull(
      ri!query
    ),
    a!pagingInfo(
      startIndex: 1,
      batchSize: 100
    ),
    ri!query.pagingInfo
  ),
  local!queryCondition: index(
    ri!query,
    "logicalExpression|filter|search",
    null
  ),
  local!queryCondition1: index(
    local!queryCondition,
    "logicalExpression|filter|search",
    null
  ),
  local!sub1: index(
    local!queryCondition1[1],
    "field",
    null
  ),
  local!sub2: index(
    local!queryCondition1[1],
    "operator",
    null
  ),
  local!sub3: index(
    local!queryCondition1[1],
    "value",
    null
  ),
  local!deffilter: if(
    and(
      index(
        local!queryCondition,
        "field",
        null
      ) = "firstName",
      index(
        local!queryCondition,
        "operator",
        null
      ) = "not null"
    ),
    index(
      local!queryCondition,
      "value",
      null
    ),
    null
  ),
  local!requestedId: if(
    and(
      index(
        local!queryCondition,
        "field",
        null
      ) = "rp!id",
      index(
        local!queryCondition,
        "operator",
        null
      ) = "="
    ),
    index(
      local!queryCondition,
      "value",
      null
    ),
    null
  ),
  local!searchTerm: index(
    local!queryCondition,
    "searchQuery",
    null
  ),
  local!requestStatus: if(
    and(
      index(
        local!queryCondition,
        "field",
        null
      ) = "requestStatus",
      index(
        local!queryCondition,
        "operator",
        null
      ) = "="
    ),
    index(
      local!queryCondition,
      "value",
      null
    ),
    null
  ),
  local!employees: if(
    not(
      isnull(
        local!requestedId
      )
    ),
    rule!getEmployeeByyId(
      local!requestedId,
      local!deffilter,
      local!pagingInfo
    ),
    if(
      not(
        isnull(
          local!searchTerm
        )
      ),
      rule!searchEmployeesByLastName(
        local!searchTerm,
        local!deffilter,
        local!pagingInfo
      ),
      if(
        local!sub1 = "requestStatus",
        rule!getemployeeByrequestStatus(
          local!sub3,
          local!deffilter,
          local!pagingInfo
        ),
        if(
          local!sub1 = "rp!id",
          rule!getEmployeeByyId(
            local!sub3,
            local!deffilter,
            local!pagingInfo
          ),
          rule!Entity(
            local!deffilter,
            local!pagingInfo
          )
        )
      )
    )
  ),
  topagingInfo(
    1,
    1
  )
)

Children

No Data