Pick Applet SQL Query issue

View previous topic View next topic Go down

Pick Applet SQL Query issue

Post  Guest on Thu Oct 28, 2010 5:09 am

Hi Guys,

I am trying to rectify one of the issue with the configuration done on BC and Applets. To get started I have increased the Siebel log Events to level - 5 and drilled down to the issue part of SQL query generated for Pick Applet.

SQL query is as below:

SELECT
T1.CONFLICT_ID,
T1.LAST_UPD,
T1.CREATED,
T1.LAST_UPD_BY,
T1.CREATED_BY,
T1.MODIFICATION_NUM,
T1.ROW_ID,
T1.PAR_ROW_ID,
T3.LOC,
T1.X_CASE_ID,
T1.ATTRIB_07,
T1.ATTRIB_20,
T1.ATTRIB_22,
T1.ATTRIB_21,
T1.ATTRIB_14,
T1.NAME,
T1.ATTRIB_12,
T1.ATTRIB_08,
T1.ATTRIB_06,
T2.VAL,
T1.ATTRIB_03,
T1.ATTRIB_10,
T1.ATTRIB_48,
T2.ROW_ID,
T3.ROW_ID
FROM
SIEBEL.S_ORG_EXT_XM T1
INNER JOIN SIEBEL.S_LST_OF_VAL T2 ON T1.ATTRIB_03 = T2.NAME AND T2.ACTIVE_FLG = 'Y' AND T2.TYPE = 'IR_TAX_TYPE'
INNER JOIN SIEBEL.S_ORG_EXT T3 ON T1.PAR_ROW_ID = T3.PAR_ROW_ID
WHERE
((T1.ATTRIB_06 != ?) AND
(T1.TYPE = 'Case_Period') AND
(T1.PAR_ROW_ID = ? AND T3.LOC = ? AND T1.X_CASE_ID = ? AND T1.ATTRIB_14 = ? AND T2.VAL = ?))
ORDER BY
T1.TYPE, T1.NAME

In the WHERE condition it is using T1.X_CASE_ID = ? which is the culprit. I want to know how to get rid of that field from WHERE condition. If I take out that field, then I will get desired result in the Pick Applet.

I have checked the Search specifications & User properties for that applet and BC, I did not get any restrictions made on them. Is there anything I have to check in Table Index and User Key level?

Could any body help me rectify the issue.

Cheers,
Narayan

Guest
Guest


Back to top Go down

Re: Pick Applet SQL Query issue

Post  Admin on Thu Jan 06, 2011 8:22 pm

Looking at the Column and Table name, it is clear that it is a custom colulmn.

The condition "T1.X_CASE_ID = ?" should be coming from a search specification.

Check these:
Search Specification on the Pick Applet.
Search Specification on the Business Component of Picklist.
Search Specification on the PickList (Picklist defined on the field having Pick Option)
Check if there is any constrain defined (expand Pickmap) for the field having Picklist.

Hope you find the problem in any of the above.

Share the findings.

Munavvar
avatar
Admin
Admin

Posts : 21
Join date : 2010-02-25

View user profile http://siebelwithmunav.dodiscussion.com

Back to top Go down

View previous topic View next topic Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum