Friday, January 17, 2020

How to find the latest Record in Siebel?



SQL Query to Get Latest Record


There are times when we require to find latest record in siebel through SQL.

Following are the SQL which fetches the latest records of S_SRV_REQ table.

SELECT * FROM SIEBEL.S_SRV_REQ 

WHERE CREATED  = (SELECT MAX(CREATED) FROM SIEBEL.S_SRV_REQ);
OR
SELECT * FROM SIEBEL.S_SRV_REQ
WHERE (CREATED>sysdate); 

Note : CREATED Column is the created date of the record.


No comments:

Post a Comment

Updating parent BC depending on the status of child BC using configuration

Parent BC: Service Request Child BC: Action Requirement: When all the Actions corresponding to an SR are closed the SR status should be “Clo...