Skip to main content
January 13, 2024
Solved

Cannot filter relationships in record data

  • January 13, 2024
  • 4 replies
  • 0 views

Hi

I need someone help!!

I was trying to filter relationships in record data using record type in rule input, but could not filter.

When I tried to filter the relationship of record data using text datatype in the rule input, i was worked.

My question is why I couldn't  Filter when using recordtype. I don't know what is wrong.

Best answer by girlc0001

 [mention:f5e81b8502fa4e77ad12697686a4fc56:e9ed411860ed4f2ba0265705b8793d05] 

Thanks for your answer.Finally i got answer.Here's  my solution

for testing purpose , I wrote in expression my test input

4 replies

January 13, 2024

Hi,

I'm not entirely sure I understand your question, but if you're attempting to filter a record type or table based on a specific field – let's say, for instance, the record field is 'caseName' with the data type 'text' – it's important to ensure that you pass a value of the correct type ('text' in this case).

January 13, 2024

Hi,

From the screenshot shared, the 'Test Input value' is provided as null, 

since the parameter 'ignoreFilterswithEmptyValues: is set as True, The filter condition will ignore incase of your input value is null. 

For testing purpose , in the condition, you can update the query input value(Rule input you have mentioned)  with a constant value and can check whether your query is working or not.

For ex: 

 filters: {
    a!queryFilter(
      field: recordType!TE_Customer.testcase.testname,
      operator: "=",
      value: "Test01"
    )
  },

mathieud0001
Brainy
January 13, 2024

Should work fine - here's an example

girlc0001AuthorAnswer
January 14, 2024

 [mention:f5e81b8502fa4e77ad12697686a4fc56:e9ed411860ed4f2ba0265705b8793d05] 

Thanks for your answer.Finally i got answer.Here's  my solution

for testing purpose , I wrote in expression my test input