![]() ![]() (Note: The events are run on a recurring basis so if you can’t make a specific date just let us know you’re interested and we’ll notify you of a future date. Would you like an overview of the capabilities of Microsoft SQL Queries and Reporting Services for GoldMine? Check our our Sharpen Your Knowledge Training Event. For purposes of writing any of these queries you need to know that “Automated processes are stored in the “contsup” table with “rectype=E” and the “Event” name is listed in the “contsupref.” The query statement can be written using the actual “event” description (name). A query can list out all the records on this event. Therefore you need a way to find only those records that have that Process attached AND are on the event you’re editing. So you want to know which records those are. Any prior triggered events will not be effected by your changes, but any records that are up to and on the event that you’re changing may be effected by your change. ![]() Let’s also say you know that that this process is already attached to records in GoldMine. Suppose you’re working on editing an existing Automated Process and you’re changing an event. Here’s an example and my explanation of a situation that presents the need for #3. Simply repeat the process outlined above using the Contact and Company fields. ![]() You may also want to perform a merge/purge operation for contacts that have matching Contact and Company fields. Finding which records in GoldMine have an Automated Process waiting on a specific “Event.” The GoldMine Process Monitor window will appear and show the status of the merge/purge process.Finding which records in GoldMine have a particular Automated Process attached.Finding all records in GoldMine that have any Automated Process attached.If you’re a GoldMine Administrator or someone who builds Automated Processes in GoldMine then you are bound to run into the need for the following:
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |