Forum Discussion

o59393's avatar
o59393
Post Prodigy
6 years ago
Solved

Text filter that does not filter the table

Hello everyone I added a text filter in order to easily recreate a table. The problem is that when you enter a value, the table will not be updated. But when you use a drop-down cutter, you w...
Need Help
Show and Tell
  • HotChilli's avatar
    HotChilli
    6 years ago

    There's more than one issue here.  Text filter filters text not numbers (it will filter them if both fields are set as text).

    The tables material1 and material2 have duplicate entries (filtering from many-to-one might work but does it make sense) -> I edited that and went off and tested many to one filtering , it can work but it doesn't really make sense)

HotChilli's avatar
HotChilli
Community Champion
6 years ago

Relationships and directions.

 

The text filter on Material2 can't filter anything because of the relationship direction.

o59393's avatar
o59393
Post Prodigy
6 years ago

Hi HotChilli 

 

I changed the text filter to use rp (2) and same result.

 

Should I set up the relationship in both ways from rp(2) to material1 and material2?

 

 

Thanks!

  • HotChilli's avatar
    HotChilli
    Community Champion
    6 years ago

    There's more than one issue here.  Text filter filters text not numbers (it will filter them if both fields are set as text).

    The tables material1 and material2 have duplicate entries (filtering from many-to-one might work but does it make sense) -> I edited that and went off and tested many to one filtering , it can work but it doesn't really make sense)

    • o59393's avatar
      o59393
      Post Prodigy
      6 years ago

      Hi HotChilli 

       

      Changed it to text and it worked.

       

      Thanks!