02-26-2009 11:27 PM
How to do this?
Solved! Go to Solution.
02-27-2009 07:57 AM
In the Process "cc.screlate" add the following (after the existing RAD calls and expressions).
$L.void=rtecall("rinit", $L.rc, $L.get.screlation, "screlation");$L.void=rtecall("select", $L.rc, $L.get.screlation, "source=\""+incident.id in $L.file+"\"")
$L.depend=depend.filename in $L.get.screlation;if ($L.depend="problem") then ($L.depend="probsummary")
$L.query="number=\""+depend in $L.get.screlation+"\""
RAD Application: se.search.engine
Condition: true (
Parameter Names | Parameter Values
name | $L.depend
query | $L.query
So what this does is initialize the screlation table and pull back the first record with this Interaction as the source. (Since this is a new Interaction that has just been escalated, there should only be one record anyway). It then gets the value of the "depend.filename" field (which contains what table the related record was opened in) and value in the "depend" field (the record id for the related record).
Then it runs the se.search.engine Application, wich runs a query against the specified table and pulls back the related record.
Again, not sure if there's an easier way, but this way works.
Hope that helps.