Skip to main content
Inspiring
January 13, 2024
Solved

Cannot filter relationships in record data

  • January 13, 2024
  • 4 replies
  • 8 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

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

Known Participant
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
Inspiring
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