SQL Queries - CAST Knowledge Base - Queries on Transactions - How to get Transactions by module

Purpose of Query

This query lists Transactions by module

Applicable CAST Version

Release	Yes/No
8.3.x

Applicable RDBMS

RDBMS	Yes/No
CSS

Query for CSS

For CAST 8.3.36 and below:

SELECT k.keynam AS MODULE,
       k2.keynam AS TR,
       dtr.tf_ex AS FP
FROM Keys k
JOIN SETROOT sr ON sr.IDSET = k.IdKey
JOIN CTT_OBJECT_APPLICATIONS coa ON coa.APPLICATION_ID = sr.IDROOT
JOIN dss_transaction dtr ON dtr.form_id = coa.object_id
JOIN keys k2 ON k2.idkey = coa.object_id
WHERE k.ObjTyp = 20000
  AND coa.properties = 0
  AND k.KeyNam not like '%union content%'
  AND k.KeyNam NOT LIKE '% IFPUG objects'

For CAST 8.3.37 and above:

SELECT k.keynam AS MODULE,
       k2.keynam AS TR,
       dtr.tf_ex AS FP
FROM Keys k
JOIN SETROOT sr ON sr.IDSET = k.IdKey
JOIN CTT_OBJECT_APPLICATIONS coa ON coa.APPLICATION_ID = sr.IDROOT
JOIN dss_transaction dtr ON dtr.form_id = coa.object_id
JOIN keys k2 ON k2.idkey = coa.object_id
WHERE k.ObjTyp = 20000
  AND coa.properties & 255 = 0
  AND k.KeyNam not like '%union content%'
  AND k.KeyNam NOT LIKE '% IFPUG objects'

Query result example

"My java full content";"run";5
"My java full content";"Customer.jsp";4
"My java full content";"AjaxDemo.jsp";0
"My java full content";"SuccessUserImage.jsp";0
"My java full content";"Menu.jsp";3
"My java full content";"SuccessCustomer.jsp";3
"My java full content";"Header.jsp";0
"My java full content";"Footer.jsp";0
"My java full content";"Welcome.jsp";0
"My java full content";"Login.jsp";3
"My java full content";"BaseLayout.jsp";0
"My java full content";"UserImage.jsp";3

Query result interpretation

The query returns module name, Transaction name and Transaction function point value

Notes/comments

Related Pages