Filter not refreshing in Record

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()
)
)

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()
)
)

Hi Alok,

Thanks for the reply. Currently we are doing that but still filters are not getting refreshed until i refresh the page.

If Possible, can you please attach the Facet and FacetOption Expression rule code here, so that it will be easy to debug and understand what you are able to achieve as of now and whats your expectations.

You are saying, you wrote your code inside with() but still not getting refreshed.


I suspect, generally with() variables will be refreshed after saveInto performed. But here there is no saveInto. That is the reason facet values are refreshed on reload only. @Mike already said that it is expected behavior.

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
)

)

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
  )
)