Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
Rehan
Contributor II

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

 

1 Solution

Accepted Solutions
Highlighted

Re: Section Access Where Clause

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

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)

View solution in original post

1 Reply
Highlighted

Re: Section Access Where Clause

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

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)

View solution in original post