SQL Queries - CAST Knowledge Base - Queries on Transactions - How to check if there is custom function point on Transactions

Purpose of Query

This query returns the custom function point calibration on Transactions.

Applicable CAST Version

Applicable RDBMS

Query for CSS

SELECT count (1)
from dss_transaction
where  user_fp_value is  not null
or  user_isinput is not null

Query result example

2

Query result interpretation

The query returns the number of customized transactions.

Query for Oracle

SELECT count (1)
from dss_transaction
where  user_fp_value is  not null
or  user_isinput is not null

Query result example

2

Query result interpretation

The query returns the number of customized transactions.

Query for SQL server

SELECT count (1)
from dss_transaction
where  user_fp_value is  not null
or  user_isinput is not null

Query result example

2

Query result interpretation

The query returns the number of customized transactions.

Notes/comments

Related Pages