I'm having some problems with QlikView, I'm new at it, SQL SELECT it's working good but... i have a query in SQL that works perfectly but i need QlikView to execute it and I'm having no succes at it, the query in SQL is:
SELECT a.userid,
d.id as cursoid,
c.visible,
c.id as disciplinaid,
e.roleid
FROM
tb_log a INNER JOIN tb_user b ON a.userid=b.id
INNER JOIN tb_course c ON a.course=c.id
INNER JOIN tb_course_categories d ON c.category=d.id
INNER JOIN tb_role_assignments e ON a.userid=e.userid
INNER JOIN tb_context f ON e.contextid=f.id AND f.instanceid=c.id AND f.contextlevel=50
WHERE
b.firstname <> 'suporte'
GROUP BY
a.userid,
d.id,
c.id,
d.name,
c.shortname
ORDER BY
a.userid,
d.id,
c.id,
d.name,
c.shortname";
I think I should use the comand ALIAS a as tb_log; ... but still, i couldn't execute the query because of the Joins and I'm using ODBC conection.
today we`re using a PHP script to do that, first connect to db then execute that query and the result is saved in a variable $students, then we use the comand while and another query like that:
please look at the attachment there is the code in PHP that i need Qlik to execute and generate a QVD in the end with the table "tb_temp_temptable"
.png "arvind1494"){kind=avatar}
