Forum Discussion
cryptopeck
4 years agoNew Member
Help: Odd Filter Behavior - Data appearing in table is missing in basic filtering (filter pane)
Okay Team - After years of getting immense value out of this forum, this is my first post. Context: I work in hospitality, we aggregate lots of data from 3rd parties. The report in question is a ...
- 4 years ago
Well I went to bed and woke up this morning with an idea... an idea which solved the issue.
The problem was caused by a bi-directional filter in a relationship between contextually unrelated tables. Ultimately this was driven by a larger modeling error involving an associative entity that was doing its job in one place, but causing problems in another.
cryptopeck
4 years agoNew Member
Well I went to bed and woke up this morning with an idea... an idea which solved the issue.
The problem was caused by a bi-directional filter in a relationship between contextually unrelated tables. Ultimately this was driven by a larger modeling error involving an associative entity that was doing its job in one place, but causing problems in another.