Hello everyone. This is my first blog!! I am going to discuss about the experiments I did in technologies like Siebel, Salesforce, MS Dynamics CRM, Right Now CRM and so forth.
Let me start with a Siebel experiment I conducted recently.
Requirement: To show the list of MVG fields in a comma separated list for a parent record. Example: For an Account, I want to see the associated Contact Ids in a comma separated list in a field.
Solution: To get field list as a comma separated list, I searched a lot for any available vanilla functionality. I found that GetProfileAttrAsList function will work only for Personalisation requirements. Then right before I went for the worst(and easiest) option of custom scripting, I looked for all the vanilla Business Services and methods.
I was lucky to find this business service: FS Workflow Utility. GenerateList method in this service did the job for me. This method is not well documented.
I just simulated the service and found the result working.
Below are the input arguments.
The Field List argument takes the names or the fields in comma separated List like 'Contact Id', 'Last Name'. Remember to provide the fields in single quotes. If the field name has two words (Contact and Id as above), it did not recognize the field name.
Here is the Output:
Output is a property set with one property for each field in Field List input argument.
Observations: This service can be used to get data from any BC based on the search spec instead of using scripting to query and get field values. Added advantage I observe is performance. If you are working on a workflow and want to get field values from another instance of the business component that is not in current BO, we can use this service. We can create array list of field data for any requirement. I have used a calculated field and a workflow to query data and get the values in UI. So, no scripting involved :) I will post my experience about the Calculated field and challenges faced in my next post
Let me start with a Siebel experiment I conducted recently.
Requirement: To show the list of MVG fields in a comma separated list for a parent record. Example: For an Account, I want to see the associated Contact Ids in a comma separated list in a field.
Solution: To get field list as a comma separated list, I searched a lot for any available vanilla functionality. I found that GetProfileAttrAsList function will work only for Personalisation requirements. Then right before I went for the worst(and easiest) option of custom scripting, I looked for all the vanilla Business Services and methods.
I was lucky to find this business service: FS Workflow Utility. GenerateList method in this service did the job for me. This method is not well documented.
I just simulated the service and found the result working.
Below are the input arguments.
The Field List argument takes the names or the fields in comma separated List like 'Contact Id', 'Last Name'. Remember to provide the fields in single quotes. If the field name has two words (Contact and Id as above), it did not recognize the field name.
Here is the Output:
Output is a property set with one property for each field in Field List input argument.
Observations: This service can be used to get data from any BC based on the search spec instead of using scripting to query and get field values. Added advantage I observe is performance. If you are working on a workflow and want to get field values from another instance of the business component that is not in current BO, we can use this service. We can create array list of field data for any requirement. I have used a calculated field and a workflow to query data and get the values in UI. So, no scripting involved :) I will post my experience about the Calculated field and challenges faced in my next post
How to avoid duplicate records with the FS Workflow Utility business service?
ReplyDeleteThis comment has been removed by the author.
ReplyDeleteThanks, this is generally helpful.
ReplyDeleteStill, I followed step-by-step your method in this
salesforce training
salesforce online training India
salesforce online training
salesforce certification
salesforce course online
Thank you for providing good information from Kexlin
ReplyDeleteYou are in the right place for a perfect solution for any app development company in hyderabad. We are well known for delivering the best quality Mobile Application Development Solutions to our clients.