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

    Finding Automated Processes

    JJGearhart Apprentice

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

       

      TIA

      Jon Gearhart

        • 1. Re: Finding Automated Processes
          John Neighbors Expert

          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
            JJGearhart Apprentice

            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.