Problem with where clause
Hi
we have created a new srf and now no entries are visible under Catalog-Categories. Looking into the logfile I can see that the search spec is different from the old srf, but I cannot find out what I need to check in Siebel Tools.
Actually the question here is around following log entry:
Problem comes from following sql statement
SELECT
T5.CONFLICT_ID,
...
:1
FROM
SIEBEL.S_CTLG T1,
SIEBEL.S_LST_OF_VAL T2,
SIEBEL.S_LIT T3,
SIEBEL.S_LIT T4,
SIEBEL.S_CTLG_CAT T5
WHERE
T5.THMBNL_IMAGE_ID = T3.ROW_ID AND
T5.DSPLY_TMPL_CD = T2.VAL