Filter Table based on Fields in a Related List

  • 1
  • Question
  • Updated 2 years ago
  • Doesn't Need an Answer
I need to filter the Account records I am displaying in a table based on a field called "Sales Initiative Name" in an account related list.  Is this possible?
Photo of Stephen Chilcoat

Stephen Chilcoat

  • 732 Points 500 badge 2x thumb

Posted 2 years ago

  • 1
Photo of mB Pat Vachon

mB Pat Vachon, Champion

  • 42,714 Points 20k badge 2x thumb
Yes. ;)
Photo of Stephen Chilcoat

Stephen Chilcoat

  • 732 Points 500 badge 2x thumb
I tried using a subquery condition but that didn't seem to work
Photo of mB Pat Vachon

mB Pat Vachon, Champion

  • 42,714 Points 20k badge 2x thumb
That aught to work without issue. Can you paste the XML for the page?
Photo of Stephen Chilcoat

Stephen Chilcoat

  • 732 Points 500 badge 2x thumb
I figured out a different solution altogether.  Thanks for your help though
Photo of Shmuel Kamensky

Shmuel Kamensky, Champion

  • 4,328 Points 4k badge 2x thumb
Stephen,

Can you please post your solution? I'm running into a similar issue. Thanks!
Photo of Stephen Chilcoat

Stephen Chilcoat

  • 732 Points 500 badge 2x thumb
I just added a Sales Initiative name field to the Account object itself and I'm filtering on that instead.
Photo of Shmuel Kamensky

Shmuel Kamensky, Champion

  • 4,328 Points 4k badge 2x thumb
Ah, thanks. In my case that won't work since I'm dealing with option values that differ depending on the subqueried records.