Tag Value for Security Rules not available through QRS?

simonaubert — Sat, 19 Mar 2022 15:09:12 GMT

Hello all,

Pretty weird but I don't manage to retrieve Tag value from security rules

Script :

LIB CONNECT TO 'REST_Custom_Monitor_SystemRule'; RestConnectorMasterTable: SQL SELECT "id", "createdDate", "modifiedDate", "modifiedByUserName", "category", "subcategory", "type", "name", "rule", "resourceFilter", "actions", "comment", "disabled", "ruleContext", "seedId", "version", "privileges", "schemaPath", "__KEY_root", (SELECT "@Value", "__FK_tags" FROM "tags" FK "__FK_tags" ArrayValueAlias "@Value") FROM JSON (wrap on) "root" PK "__KEY_root"; [tags]: LOAD [@Value], [__FK_tags] AS [__KEY_root] RESIDENT RestConnectorMasterTable WHERE NOT IsNull([__FK_tags]); [Qlik System Rule]: LOAD [id] as [Qlik System Rule Id], [createdDate] as [Qlik System Creation Date], [modifiedDate] as [Qlik System Rule Modification Date], [modifiedByUserName] as [Qlik System Rule Modified by UserName], [category] as [Qlik System Rule Category], [subcategory] as [Qlik System Subcategory], [type] as [Qlik System Rule Type], [name] as [Qlik System Rule Name], [rule] as [Qlik System Rule Rule], [resourceFilter] as [Qlik System Rule Resource Filter], [actions] as [Qlik System Rule Actions], [comment] as [Qlik System Rule Comment], [disabled] as [Qlik System Rule Disabled], [ruleContext] as [Qlik System Rule RuleContext], [seedId] as [Qlik System Rule Seed Id], [version] as [Qlik System Rule Version], [privileges] as [Qlik System Rule Privileges], [schemaPath] as [Qlik System Rule Schema Path] RESIDENT RestConnectorMasterTable WHERE NOT IsNull([__KEY_root]); DROP TABLE RestConnectorMasterTable; exit script;

Log

15:55:08 Message effacé. 15:55:40 --- Chargement de données démarré --- Connecté RestConnectorMasterTable << RestConnectorMasterTable Lignes extraites : 158 tags << RestConnectorMasterTable Lignes extraites : 3 Qlik System Rule << RestConnectorMasterTable Lignes extraites : 155 --- Application enregistrée Opération terminée correctement 0 erreur(s) forcée(s) 0 clé(s) synthétique(s)

As you can see, Qlik finds 3 rows for tags (which is true )but when I visualize it, the value are null ???

I use Qlik Sense Server May 2021 Patch 4.

Best regards,

Simon

Re: Tag Value for Security Rules not available through QRS?

simonaubert — Mon, 28 Mar 2022 12:46:59 GMT

Hello all, I found the issue :

The code given by Qlik is not correct because we can't parse the Array. it should be :

RestConnectorMasterTable: SQL SELECT "id", "createdDate", "modifiedDate", "modifiedByUserName", "category", "subcategory", "type", "name", "rule", "resourceFilter", "actions", "comment", "disabled", "ruleContext", "seedId", "version", "privileges", "schemaPath", "__KEY_root", //Code given by Qlik : KO // (SELECT // "@Value" AS "tag_tag_@Value", // "__FK_tags" // FROM "tags" FK "__FK_tags" ArrayValueAlias "tag_tag_@Value") //Code I corrected : OK (SELECT "id" AS "tag_tag_id", "name" AS "tag_tag_name", "privileges" AS "tag_tag_privileges", "__FK_tags" FROM "tags" FK "__FK_tags") FROM JSON (wrap on) "root" PK "__KEY_root";

Same for tags on user, Application, etc...

Best regards,

Simon

topic Re: Tag Value for Security Rules not available through QRS? in Integration, Extension & APIs

Tag Value for Security Rules not available through QRS?

Re: Tag Value for Security Rules not available through QRS?