Avoid Scripting with Configuration || BCHasRows Function
15 February 2012
1,927 views
2 Comments
Generally we maintain our fields unique using User keys or creating of Index at Table level or else we move with the scripting, but we have simple solution with simple configuration. This post has been shared by Manjula Vani.
Solution follows… here
We have very good function in Siebel called “BCHasRows”.
Syntax: BCHasRows (BO, BC, search_expr, visibility)
Scenario: Maintain “PAN Card Number” as unique.
BCHasRows ("Account", "Account", "[PAN Card Number*] = '"+ [PAN Card Number*] +"'", "All")
The following 2 steps we need to do……
STEP1: Create Calculated Field
STEP2: Give the Calculated Filed in Validation property of the Filed for which we want to maintain uniqueness.
OUTPUT:
Related posts:
- Aspect BC ReadOnly – BC user property
- Parametrized report and calculated field
- Immediate Post Changes
- Configure a VBC to invoke an EAI Workflow without scripting
- Siebel Scripting Interview Question – Continued
- Suppressing Scripting Error Code SBL-EXL-00151 In Custom Validation Error Messages
(No Ratings Yet)
Loading ...
Thank you for your post.
But I have one question regarding to your solution.
Is "BCHasRows" predefined function in script? If yes, where it is defined and what's the detail?
If no, how it works? I cannot find such method/property in any books.
Thank you very much.
Kevin (CN-Dalian)
Thanks for your post… Will it work if we want to dispaly the same message in different languages??
Leave your response!
Our Stats
hit counter
Author Spotlight
SADMIN
Website: http://www.siebeloracle.com/Join us in Facebook !!!!
Donate
If you find this blog useful to you, please consider making a small donation to help contribute to further development. Thanks for your kind support!
Hosted By
SIEBEL BOOKSHELF
Advertise With Us
Place your advertisement anywhere in the website.
[Nominal Rates/Genuine readers]
For details reach us at contact@siebeloracle.com
Training Partner
Advertisement
Advertisement