Home > Forum > Data sources > [Solved] Dictionary data source does not return all data

[Solved] Dictionary data source does not return all data

2

28.03.2023

13:18

Hi everyone,

does anyone has an idea, why a data source dictionary would not return all data, also "access data in the context of system account" is checked?

I was banking my head on the wall, why the form validation stopped working until I noticed that the lastest workflow instances are not returned by the data source.

The screenshot shows the data from the "data sources" navigation pane, it's not a field which is filtered.

Best regards,
Daniel

28.03.2023

13:37

Just after writing the thread, it came to me that I should just use the SQL Profiler to see, why it doesn't work anymore.

There's a default where condition which would only return those dictionary entries which are active.
/*SUBSTITUTIONSFILTER*/

AND WFD_AttBool1 = ''True''
/*ADVANCEDSEARCH*/

I've hidden the field because it's not used in this case which in turn had the effect, that the field has no default value => The latest instance are not 'active'.

Best regards,
Daniel