Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anil_Babu_Samineni

Direct Discover Where Clause Issue

Hello Friends,

I am very fresher to Direct Discovery, All Inputs are Valid.

I am not sure what i made mistake here. While i am trying Normal it's working Good. Same thing i tried from Direct Discovery it's not working. Would you let me know if anyone have idea about this, Please assist me if anyone allows earlier by same pros.

And DB Connection is there.

Normal:

LOAD *, OSUser() as User;

SQL SELECT *

FROM "mydb"."public"."DDQ" where User = 'DOMAIN\anil';

Using Direct Discovery

[DirectDiscovery]:

DIRECT QUERY

DIMENSION

last_name,

first_name,

Images

MEASURE

OSUSER() as User,

contact_id

DETAIL

country

FROM

"mydb"."public"."DDQ" where User = 'DOMAIN\anil';

The Reason I intend to add User after DIMENSION,  Because I've read this portal Image

Capture.PNG

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)
5 Replies
sunny_talwar

AFAIK, OSUser() is a QlikView function and cannot be used on DIRECT QUERY. There might be another way to do this using Section Access, but my knowledge of Direct Discovery is rather limited and I wouldn't be able to offer help related to the section access route. One thing I know is that the section access is done through QMC, rather than adding a section access script in the script for direct discovery.

varshavig12
Specialist
Specialist

Dimitri's comment:

DD & section access problem

Anil_Babu_Samineni
Author

Yes, Sunny. As i know OSUSER() is QlikView Function. I am eagerly looking for Other way like this.

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)
Anil_Babu_Samineni
Author

Yes, I agree his response. I know Very Limitation offers by using Direct Query. I am looking for Sunny Suggestion again. In Fact, All inputs are valid too.

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)
Anil_Babu_Samineni
Author

Any other inputs. I am happy, If some one can try help so that i can follow the inside link-link.

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)