direct discovery in qlikview?

devarasu07 — Wed, 25 Nov 2020 16:16:04 GMT

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)

topic direct discovery in qlikview? in QlikView

direct discovery in qlikview?