SQL Queries - CAST Knowledge Base - Queries on Links - How to count the number of links generated during the analysis by the computation of the Inference Engine

Purpose of Query

The query retrieve the number of links generated during the analysis by the computation of the Inference Engine on the Knowledge base.

Applicable CAST Version

ReleaseYes/No
8.3.x(coche)
8.2.x(coche)
8.1.x✅
8.0.x✅
7.3.x✅

Applicable RDBMS

RDBMSYes/No
Oracle Server✅
Microsoft SQL Server✅
CSS2✅

Query for CSS, Oracle and SQL Server

SELECT Count(fa.idfus) 
FROM   fusacc fa 
       JOIN objdsc od 
         ON od.idobj = fa.idfus 
            AND od.inftyp = 110 
            AND od.infsubtyp = 9;

Query result example

–10

Query result interpretation

The query returns the count of the number of links generated during the analysis by the computation of the Inference Engine.

Notes/comments

Ticket #13132

Related Pages