This topic contains 0 replies, has 0 voices, and was last updated by marcusd 7 years, 5 months ago.
-
Posts
-
marcusd- Contributions: 0
- Level 1
- ☆
I am trying to write a saved search formula that runs on a parent record and will check a set of child records and see if one exists with a certain field value. If one does, I want to filter out the parent record from my results. I have tried CASE WHEN and DECODE with no luck. The parent record that I am trying to filter out is still in the results. In this particular case, there were 5 child records, one matched my criteria and the parent record was repeated in the results 4 times.
Any help would be appreciated.
Marcus
This is a cached copy. Click here to see the original post.
You must be logged in to reply to this topic.