Siebel Backend Query to Find number of Force Active Fields in BC

Started looking into some best practices violation in the repository. So build a query which helps to identify the Number of Force Active Fields in a Buscomp. My personal recommendation is to have <30 Force Active fields in a Buscomp. But depends on BC to BC and Business case.

SELECT
B.NAME,
COUNT(A.FORCEACTIVE) AS NUM_OF_FORCEACTIVE
FROM
SIEBEL.S_FIELD A,
SIEBEL.S_BUSCOMP B
WHERE
A.BUSCOMP_ID = B.ROW_ID AND
A.BUSCOMP_ID IN (SELECT B.ROW_ID FROM SIEBEL.S_BUSCOMP B)
GROUP BY
A.BUSCOMP_ID,
B.NAME;
OUTPUT TO E:\TEMP\FORCEACTIVE2.TXT

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Create a free website or blog at WordPress.com.

Up ↑

%d bloggers like this: