At first I want to say that I am a absolute JavaScript Beginner.
My goal is to find a way setting a filter in my Qlik sense APP with an external Action.
I thought about using einigma.js for pushing the "Select values" method to automatically getting applied in Realtime (without refreshing Browser!).
If there is any other way or solution I would be more than thankful for every hint.
Here is what I tried till now using node.js:
const serverUri = 'localhost';
const clientCertFile = '.\\client.pem';
const clientCertKey = '.\\client_key.pem';
const enigma = require('./node_modules/enigma.js/enigma.min.js');
const WebSocket = require('ws');
const fs = require('fs');
const schema = require('./node_modules/enigma.js/schemas/12.170.2.json');
// match this schema to your Qlik Sense version.
const defaultCertPath = 'C:\\ProgramData\\Qlik\\Sense\\Repository\\Exported Certificates\\.Local Certificates';
const session = enigma.create({
schema,
url: `wss://${serverUri}:4747/app/engineData`,
createSocket: url => new WebSocket(url, {
rejectUnauthorized: false,
//ca: [fs.readFileSync('.\\root.pem')], // you can skip ca if you set rejectUnautzoried to false
key: fs.existsSync(clientCertKey)?fs.readFileSync(clientCertKey)
:fs.readFileSync(`${defaultCertPath}\\client_key.pem`),
cert: fs.existsSync(clientCertFile)?fs.readFileSync(clientCertFile)
:fs.readFileSync(`${defaultCertPath}\\client.pem`),
headers: { "X-Qlik-User": 'UserDirectory=INTERNAL;UserId=sa_engine' }
})
});
var addToApp = '4c85c23b-19f2-4bd1-952d-5627618ba044';
session.open().then(function (global) {
console.log('>> Session was opened successfully');
var app;
var origScript;
//console.log(global);
return global.engineVersion().then(ret => {
console.log('Engine Version: ', ret);
//return global.getDocList();
return global.openDoc(addToApp);
}).then(ret => {
app = ret;
return app.getScript();
}).then(script => {
origScript = script;
script = [];
//Here ist the main part:
script.push(`//header of generated script`);
script.push("var qlikapp = qlik.currApp()")
script.push("qlikapp.field('Kalender.Year').selectValues([2019],false,true);")
script.push(`//footer of generated script`);
script = script.join('\n'); // implode script array into new-line separated string
console.log('---begin of new script---\n');
console.log(script);
console.log('\n---end of new script---');
return app.setScript(script);
}).then(ret => {
console.log('>> App script changed, now reloading (pushing new data):');
return app.doReload(0, true); // true = Partial Reload
}).then(ret => {
console.log('>> Reload finished: ', ret);
return app.setScript(origScript);
}).then(ret => {
console.log('>> Load script reverted to original script. Now saving.');
return app.doSave();
}).catch(error => {
console.error('Error', error);
});
}).then(ret => {
session.close();
console.log('>> Done.');
}).catch(error => {
console.error('Error', error);
});
Node generates the following output, but nothing happens:
>> Session was opened successfully
Engine Version: { qComponentVersion: '12.421.3' }
---begin of new script---
//header of generated script
var qlikapp= qlik.currApp()
qlikapp.field('Kalender.Year').selectValues([2019],false,true);
//footer of generated script
---end of new script---
>> App script changed, now reloading (pushing new data):
>> Reload finished: false
>> Load script reverted to original script. Now saving.
>> Done.
Would be more than happy to get any hint. Thanks!
