Search by Keyword
Sense Excel the Add-In for Microsoft
If you miss something please send us an email. Thanks!
Overview about reporting json setting
This is a complete overview of the reporting config settings of the JSON Script notation.
At the moment you will see a hsjon (human json) script.
SET task = ´{ tasks: [ { meta: { name: <- click for info description: <- click for info } reports: [ {
general:
{
timeout: <- click for info
autoFitTables: <- click for info
disableAutoLink: <- click for info
disableAdvancedTableMode: <- click for info
usePerfomanceAnalyzer: <- click for info
errorRepeatCount: <- click for info
cpuLimitInCore: <- click for info
memoryLimitInGB: <- click for info
} template: { input: <- click for info output: <- click for info outputFormat: <- click for info
outputPassword: <- click for info
outputFormatOptions: <- click for info
useBase64Password: <- click for info selections:<- click for info [ { name: Year <- click for info type: static <- click for info
objectType: <- click for info values: <- click for info [ value] } { name: <- click for info type: <- click for info values: [ value ] } { name: <- click for info type: <- click for info values:
sorted: <- click for info [ value value
]} ] } connections: <- click for info { app: <- click for info } distribute: { mail: <- click for info {
sendAttachment: <- click for info subject: <- click for info message: <- click for info ''' string or html ''' mailType: <- click for info text to: <- click for info
cc: <- click for info
bcc: <- click for info mailServer: <- click for info { host: <- click for info from: <- click for info port: <- click for info username: <- click for info password: <- click for info useSsl: <- click for info } active: <- click for info } file: <- click for info { active: <- click for info target: <- click for info mode: <- click for info } hub: <- click for info { active: <- click for info mode: <- click for info
owner: <- click for info } } } ] }
{
meta:
{
name: ... ] }´;
** This part is autogenerated from the AnalyticsGate - Management Console ! Do not change this ! **
** You can change this if your are an Qlik expert - good look or visit: https://help.qlik.com/ **
//Start reporting
Let ResultWithTaskId = SER.START(task);
Let TaskIdValue = TextBetween(ResultWithTaskId,'taskId":"','"');
TRACE TaskId: $(TaskIdValue);
//Show Versions
Let versions = SER.STATUS('versions: all');
Let MainVersion = TextBetween(versions,'version":"','"');
TRACE Version: $(MainVersion);
//Wait for finish
Let Status = 0;
Do while Status < 3 and Status > -1
Let Result = SER.STATUS(ResultWithTaskId);
Let LogMsg = TextBetween(Result,'log":"','"');
Let Status = num(mid(Result,11,1));
TRACE Status: $(Status) - $(LogMsg);
Sleep 2000;
Loop
TRACE Status: $(Status) - Finished;
//Read distibute results
Let ResultText = SER.RESULT(ResultWithTaskId);
Let FormatedResult = TextBetween(ResultText,'formatedResult":"','"');
Let OutputText = Replace(FormatedResult, '\r\n', chr(13)&chr(10));
TRACE $(OutputText);
//End reporting
No Comments