Searching the fields

[suryadev]

Hello,

I have a requirement where I need to search for fields from a given query and then based on the search if I find the searched fields then I need to run the DS job to update those fields.

So basically there are 10 jobs and based on the search I need to find specified fields and then select which jobs to run to update which fields

[SURA]

I have a requirement where I need to search for fields from a given query

you mean, need to trigger a job based on the query result ?

[suryadev]

Yes, exactly

Need to trigger the correct job based on the query result search for fields


Thank you

[SURA]

Is the search numbers keep on grow / fixed and there won't be any changes?

[suryadev]

There are some 10 queries which come as an alert, based on the alert/query which we see we need to do a search and pull the trigger for the correct job.

They are fixed queries 10 different kinds but fixed fields for each of them


Thank you

[ray.wurlod]

So, one server job to execute the query and store the result in its user status area, a Nested Condition activity to filter based on the value in the user status area with ten triggers to fire the ten Job activities. Maybe an Otherwise trigger as well.

[suryadev]

Thank you!

Actually I need not run the query, only thing I need to check for the field names in the query and depending on the field names the jobs should be triggered.

Also I assume all these job activities and triggers will be in sequence job.

[ray.wurlod]

OK, use Nested Condition activity to search the query (use Index() function) and select the appropriate job to be run.

Yes, these are in a sequence.

[suryadev]

Thanks very much!

I think that will help to do a sequence job and using the job activities to trigger other parallel jobs.