Here is a piece of code that I had written for a friend.
Requirement:
He needed following information for some list applets in Siebel Application
- Display Names of Fields in those list Applets
- Data Type of the fields associated with it
- Fields have Picklist associated with them or not
- Fields have their Runtime Flag checked or not
One way to do was to open application get display names from application and then go to Siebel Tools and query one by one to get the Data Type and also query in Applet Section to get Runtime flag and other information
This code queries for the given applet name. Get’s all the records that are mapped in UI and then queries one by one in Business Component BC to extract their datatype and also if they have any picklist associated with them or not.
This is not a very common requirement. You can use this code to understand repository BC’s and their relationship and also to can act as an eScript assignment for fresher’s in Siebel.
Let me know your feedback on code.

2 Comments at "Accessing Siebel Repository Information"
I would do that with SQL on Development database.
Can you please send me the SQL Query for this requirment
Comment Now!