Purpose of Query
This query returns the list of Transactions reaching a given end point.
Applicable CAST Version
Release | Yes/No |
---|---|
8.3.x |
Applicable RDBMS
RDBMS | Yes/No |
---|---|
CSS |
Query for CSS
SELECT t51.object_id, t51.object_name txn_obj_name, t31.object_name end_point_name FROM dss_objects t11, dss_links t21, cdt_objects t31, dss_transaction t41, cdt_objects t51 WHERE t11.object_type_id = 30002 AND t11.object_id = t21.previous_object_id AND t21.next_object_id = t31.object_id AND t31.object_name = 'END_of_Transaction' ---END POINT OBJECT_NAME AND t41.object_id = t11.object_id AND t41.form_id = t51.object_id AND t51.object_id IN (SELECT t51.object_id FROM dss_objects t11, dss_links t21, cdt_objects t31, dss_transaction t41, cdt_objects t51 WHERE t11.object_type_id = 30002 AND t11.object_id = t21.previous_object_id AND t21.next_object_id = t31.object_id AND t21.link_type_id = 11004 AND t41.object_id = t11.object_id AND t41.form_id = t51.object_id GROUP BY t51.object_id HAVING Count(t51.object_id) = 1);
Query result example
30763;"main";"END_of_Transaction"
Query result interpretation
Notes/comments
Related Pages