This article has been submitted by my friend Ashish Arora who is working in Siebel Analytics and ETL for past 2 years and has a total of 3.5 years of experience in siebel. He is currently leading a team in an Software concern
When the Query Optimizer is asked to optimize a query and create an [...]
Table Scan Index Scan and Index Seek
SQL – extracting the workflow queue.
This query has been shared by a “Svetj” a member of SiebelUnleashed forum. I find it quite useful in case if I work in admin and need to know the workflow queue.
It shows
The actual queue for a workflow policy group with the insert date of the next record to work so you can know the [...]
Identifying Positions based on divisions – SQL.
This query has been shared by a reader of my blog Kaushik Ghosh. It helps us to identify position and parent position for the specified division.
Can be really helpful in
Support jobs involving creation of various positions.
Avoid duplicate of Position creation
Places where lot of divisions and positions exsist
Here is the query
Useful SQL Queries – Workflow Processes exposed.
This Query has been provided by my Friend Nitin. This query let’s you get all the information about workflow processes. You can get various kind of output by just modifying the where clause.
Useful SQL Queries – Workflow Process and Workflow Policies
This SQL Query has been provided by a friend of mine Nitin Kumar. Who has been in siebel from past 2 years and is currently working as a Senior Siebel Developer in an MNC. When working with siebel Workflow policies and Workflow process are very common. This SQL can you help you to determine name [...]
Useful SQL Queries – Customization exposed
We imparts you with great information. While surfing on web came across blog that had some articles on SQL and I think it is worth sharing with everybody. I orignal post was found on blog called nbrightside. Some useful queries that I found on that blog are:
Custom Indexs and Custom Columns:
Useful SQL Queries in Siebel – Views and Responsibility.
Below mentioned SQL Query will give you the list of users (First Name and Last Name) who have particular view added to their responsibility in Siebel.
