Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
devarasu07
Honored Contributor II

direct discovery in qlikview?

HI,

I've write back functionality which is working fine and how auto feed user Commentary table view?  tried like below direct query method but still not refreshing latest inserted value in the table view (note: if i reload the app and able to see the latest comments but i dont want to reload every time )

SET DirectCacheSeconds= 15;

LET DirectStringQuoteChar=chr(39);

SET DirectIdentifierQuoteChar=' ';

SET DirectConnectionMax= 4;

SET DirectTableBoxListThreshold=100000;

SET DirectDistinctSupport=true;

SET DirectIdentifierQuoteStyle=’ANSI’;

[DirectDiscovery]:

DIRECT QUERY DIMENSION transactionid,

    product,

   MEASURE price,

   DETAIL

    status,

    ntname,

    comment;

SQL SELECT *

FROM qlikview.dbo.sqlwb;

FYI, what ever the entry i made via write back comments, i just wanted to auto-refresh the comments summary table (direct database)

Direct Discovery.JPG