• State Suggested Answer
  • Replies 2 replies
  • Answers 1 answer
  • Subscribers 96 subscribers
  • Views 510 views
  • Users 0 members are here
Options
Related

problem with creating processes steps and get values to next process step

philip benjaminsson
over 1 year ago

Hey,

I have a problem when I'm creating a process-step. I'm using the process task "handleObjectComponent - Update" where I want to make a Whereclause and compare different values in the two tables I'm in (lets say table 1 and Table 2). When I have all my object from table 1 that "is true" compared to my whereclause. I want to send the object down into the next process-step and compare these objects that was true in the last process-step in a new whereclause in table 3.... How can I do this in the best way? Is "handleobjectcomponent" maybe not the best use for this? If so, what should I use instead ?

  • 0 over 1 year ago

    Hello Philip,

    My approach for figuring out possible solutions is to look at what is already there.
    Run this query and have a look at how these OOTB processes handle EXISTS operations.

    SELECT c.Name AS 'Process name'
	,j.Name 'Process step'
	,t.TaskName
	,p.Name AS 'Parameter'
	,p.ValueTemplate AS 'WhereClause'
FROM JobRunParameter p
JOIN Job j ON j.UID_Job = p.UID_Job
JOIN JobChain c ON c.UID_JobChain = j.UID_JobChain
JOIN JobTask t ON t.UID_JobTask = j.UID_JobTask
	AND t.TaskName IN (
		'Exists'
		,'Not Exists'
		,'Check SQL Column'
		,'Update'
		)
WHERE p.Name = 'WhereClause'

  • 0 over 1 year ago

    In your case, I would use a script component inste4ad and do all your object layer operations in the script.