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 :)
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 :)
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
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
This is exactly what I was looking for. Thank you Markus.
This is exactly what I was looking for. Thank you Markus.
Linking this thread which has the same topic with a slightly different query:
Form field count report of an application
https://community.webcon.com/forum/thread/1239?page=1#m1240