2 Replies Latest reply on Jul 13, 2016 12:33 PM by JJGearhart

    Finding Automated Processes

    Apprentice
    JJGearhart Jul 11, 2016 3:34 PM

      How can I find all contacts that have a specific Automated Process attached to them?

       

      TIA

      Jon Gearhart

      • 207 Views
      • Tags:
        • 1. Re: Finding Automated Processes
          John Neighbors SSMMVPGroup
          John Neighbors Jul 11, 2016 3:55 PM (in response to JJGearhart)

          This is a very "quick-n-dirty" query that could obviously be polished up as you see fit:

           

          select * from contact1 where accountno in (select accountno from contsupp where rectype = 'E' and address1 = 'AP Name')

           

          In short, attached automated processes are stored in the CONTSUPP table with a RECTYPE = 'E' and the NAME of the specific automated process is stored in the address1 field.  In the example above, the automated process is named "AP Name".

           

          Hope this feedback helps. Please let me know if I need to clarify anything.

          1 of 1 people found this helpful
          • 2. Re: Finding Automated Processes
            Apprentice
            JJGearhart Jul 13, 2016 12:33 PM (in response to John Neighbors)

            Thanks, John. This is exactly what I needed. I knew that it was in the contsupp with rectype = E but did not know the name of the field that contained the AP name.