since ever, it is well known that field names in Section Access must be written in Upper Case. This is well documented for all Qlik Sense editions (and Qlikview too)
Nevertheless, sometimes Section Access is working even with Lowercase field names.
This simple script is working in a test app. Field1 is limited to 'A' value.
Section Access;
LOAD
'USER' AS ACCESS,
'username@domain.com' as USER.EMAIL,
'A' as Field1
AUTOGENERATE 1;
Section Application;
Table:
LOAD * INLINE [
Field1
A
B
C
];
So why bother with translating to upper case if it working anyway? Is there any deterministic rule to this behaviour?
By the way, the same table with an INLINE instead of AUTOGENERATE will result in an upper case field name (FIELD1), therefore in the above situation, the field won't be filtered.
I haven't tested if it works as you say, but I'll assume you're correct. "So why bother with translating to upper case if it working anyway?" Well, I'd say you should bother because the section access syntax defines it. If it works now, it doesn't necessarily mean that it will still work in the next version.
