Query on BC in a workflow may have following three scenario.
1.Query on Primary BC of BO :
We can not use Siebel Operation for this, We can use 'SIA BC Utility' Vanilla BS for same.
Input Parameters:
Business Component Name=Contact,
Forward Only=Y,
From First=Y,
Search Specification='[Id] is not NULL'
2.Query on Child BC of same BO:
For this scenario,We can simply use Siebel Operation.
3.Query on some other BC , not part of BO:
For this scenario, we need to use 'Inbound E-mail Database Operations' BC method: FindRecord.
Input Parameters:
BusComp
BusObj
QueryFields = Type,Status
ValueFields = Priority
Type = 'Abc'
Status = 'Open'
Output Parameters:
ProcessProperty1 = Priority
*Input Argument query fields need to pass , and value field can be collected as output.
great stuff.
ReplyDeleteGood article. Just wanted to add my exp on the usage "SIA BC Utility" BS, every iteration you set to repeat the BS step, the number of query criteria increases which may not be convenient if you are expecting to iterate several times for performing updates. The context gets carried along for the step and there is no argument to have ClearCriteria property to reset/clear.
ReplyDeleteQuery on Child BC of same BO:
ReplyDeleteFor this scenario,We can simply use Siebel Operation.
IS IT TRUE ?? I have seen somewhere written that if we want to query in Child BC than we'll use 2 Business Services , First BS will query in Primary BC and 2nd BS will query in Child BC . ..
Kindly guide me with correct one, em facing problems.
Thanks
@Muhammad Awais Chahte kya ho tum????
ReplyDeleteApky Ishq ki Inteha chahta hun but Filhal Workflow problem ka solution Chahta hun!!! !
Deletewhat if 'Inbound E-mail Database Operations' find record matches multiple record(more than one)?....what would be the Id value in output Argument
ReplyDeleteInbound E-mail Database Operations return "Formatted field value" (1,234.00), but I need "Not formatted" (1234). Any idea?
ReplyDelete