01.08.2025
09:21
Is there an up-to-date list somewhere showing the limit of attributes that can be used in a single process?
I'm asking because I used the Yes/No choice field 40 times, and the only page I found is from 2020, which says that such fields are limited to 20, not 40.
https://community.webcon.com/posts/post/limiting-the-number-of-form-fields/70/3
01.08.2025
14:39
You can view the data directly in the wfelements table or at https://developer.webcon.com/2025/resources/db/#wfelements.
05.08.2025
09:58
I cant find any fresher data from Webcon about # of fields, although to improve on Krystian Answer, if you don't want to count them or search through the list you could query db like this:
WITH column_names AS (
SELECT
CONCAT(
LEFT(c.name, PATINDEX('%[0-9]%', c.name) - 1),
IIF(c.name LIKE '%Glob', 'Glob', '')
) AS name
FROM sys.columns AS c
LEFT OUTER JOIN sys.tables AS t ON t.object_id = c.object_id
WHERE t.name = 'WFElements'
AND c.name LIKE 'WFD_Att%'
AND c.name NOT LIKE '%_ID'
)
SELECT name, COUNT(*)
FROM column_names
GROUP BY name
For 2025.2.1.138 those are the numbers:
WFD_AttBool 40
WFD_AttChoose 90
WFD_AttChooseGlob 10
WFD_AttDateTime 50
WFD_AttDateTimeGlob 5
WFD_AttDecimal 50
WFD_AttInt 30
WFD_AttLong 25
WFD_AttMap 3
WFD_AttPeople 15
WFD_AttText 80
WFD_AttTextGlob 10
