Having problems with your account or logging in?
A lot of changes are happening in the community right now. Some may affect you. READ MORE HERE
Norita Super Contributor.
Super Contributor.

How to screlation with a scheduled script : SD's with IM's and RQ's

Hi experts,  i'm working with SM 9.34 and a chatBOT with API Rest that creates interactions (SD) identified as "autogestion".  Some of that SD's are also identifided as "RECLAMO" and the RQnumber or IMnumber that must be related with the interaction.  I need to automate the "screlation" between an interaction (SD) with the RQnumber  or  the IMnumber  collected by the chatBOT
There's a few amount of that kind of interactions (50 per month) :
SD "RECLAMO" a RQnumber
SD "RECLAMO" a IMnumber

Nowadays the relation is made later manually but I need to automate it and I don't know how

Perhaps may be a scheduled script that inserts a record in the screlation table (I add an image as an example)

Any suggestion will be appreciated.  Thanks in advance.


Good questions will have Good answers
1 Reply
Contributor.. DeBa Contributor..

Re: How to screlation with a scheduled script : SD's with IM's and RQ's

Did you consider using a trigger (table trigggers) After Add when one of the records is added into the system?


The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.