Can we fetch one record only in Workflow Siebel Operation query step?
In the workflow, we need to query a business component (pick one record out of 10000+ available records matching the conditions) and pass to next step.
This workflow is creating a performance problem as in the Siebel operation query step it fetch a lot of records (obviously it satisfy the condition). However since our requirement just need one record (first record from the list of record satisfying the condition) to be fetched and pass the value to next step, it is possible (using any parameter) via which Siebel operation query step fetch only first available record and pass to next step?