Home > Forum > General > Counting the attributes used

Counting the attributes used
0

Is there any way to check how many attributes of each type have been used in a process (I mean not manually)?

Thanks in advance :)

MVP

You can query the tables WFConfigurations and DicWFFieldTypes, e.g.

SELECT Count(*) AS Count
,DicWFFieldTypes.EnglishName
FROM [WFConfigurations]
INNER JOIN DicWFFieldTypes ON WFCON_FieldTypeID = DicWFFieldTypes.TypeID
WHERE WFCON_DEFID = 4 -- your Process id
Group by DicWFFieldTypes.EnglishName

See also
https://developer.webcon.com/2022/resources/db/

Or just generate the process documentation. The excel sheet will list all fields, types and more