This content has been marked as final.
Show 2 replies
-
1. Re: Finding Automated Processes
John Neighbors Jul 11, 2016 3:55 PM (in response to JJGearhart)1 of 1 people found this helpfulThis 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.
-
2. Re: Finding Automated Processes
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.