Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Posting on Qlik Community is temporarily paused for some users. Thank you for patience and we'll update you soon!
cancel
Showing results for 
Search instead for 
Did you mean: 
Rehan
Creator III
Creator III

Section Access Where Clause

I have a section access script . what is the purpose of Directory and "Where 1=1" in this ?

SECTION ACCESSS;

Directory;

Load 

NTNAME,

KEY,

ACCESS

FROM  AB.QVD

WHERE 1=1;

SECTION APPLICATION

 

Labels (1)
1 Solution

Accepted Solutions
Anil_Babu_Samineni
MVP
MVP

Directory can read the table structure default while fetch some columns from source. But, Not necessary to use. Where as  1=1, commonly used when variables are used to generate the SQL statement. 1=1 avoids a syntax error when you want no clause

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful

View solution in original post

1 Reply
Anil_Babu_Samineni
MVP
MVP

Directory can read the table structure default while fetch some columns from source. But, Not necessary to use. Where as  1=1, commonly used when variables are used to generate the SQL statement. 1=1 avoids a syntax error when you want no clause

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful