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

Created by Amine Benarbia on Feb 11, 2022
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
Release
Yes/No
8.3.x(coche)
8.2.x(coche)
8.1.x(tick)
8.0.x(tick)
7.3.x(tick)
Applicable RDBMS
RDBMS
Yes/No
Oracle Server(tick)
Microsoft SQL Server(tick)
CSS2(tick)
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