[marcusd]

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.

[donnaf]

I'm trying to do something similar – did you ever find a solution?

[marcusd]

I did not, unfortunately.

[david.smith]

I think you would need to search the child records where the parent is the one you're looking for. You can't search for children. What record type is this?

Basically you would just add the criteria of where "parent" is not empty and "parent" is ??? to find the children. Add any other criteria you need. If you're adding this search as a subtab that should make it easier.

[a.rivetti@clustin.com]

parent is current record -> current value

[Author]

Posts