Emma,
As of my last reply we did use custom attributes and the repository rest connectors as I listed above to pull custom attributes from the QMC Repository. We did implement the solution and then Qlik Deprecated the connectors and replaced them with different ones.
Here is what I have running at one of my clients I use is as an include file for all my apps at the end you willhave a variable named vEnvironmentName that is either Development or Production.
//Configuration section
//set vEnvironmentPropertyName to match the name of the QMC custom property used to define the environment
Let vEnvironmentPropertyName = 'ApplicationEnvironment';
//initialize making sure I don't reuse the value from the last run.
Let vEnvironmentName = null();
Let vEnvironmentCount = 0;
//Find the guid for this application.
Let vMe = documentname();
//Query the application data from the qmc
LIB CONNECT TO 'qrs_app';
RestConnectorMasterTable:
SQL SELECT
"id" AS "id_u4",
"createdDate" AS "createdDate_u0",
"modifiedDate" AS "modifiedDate_u0",
"modifiedByUserName" AS "modifiedByUserName_u0",
"name" AS "name_u3",
"appId",
"publishTime",
"published",
"description",
"fileSize",
"lastReloadTime",
"thumbnail",
"savedInProductVersion",
"migrationHash",
"dynamicColor",
"availabilityStatus",
"privileges" AS "privileges_u3",
"schemaPath" AS "schemaPath_u0",
"stream",
"__KEY_root",
(SELECT
"id" AS "id_u0",
"createdDate",
"modifiedDate",
"modifiedByUserName",
"value",
"schemaPath",
"__KEY_customProperties",
"__FK_customProperties",
(SELECT
"id",
"name",
"valueType",
"privileges",
"__KEY_definition",
"__FK_definition",
(SELECT
"@Value",
"__FK_choiceValues"
FROM "choiceValues" FK "__FK_choiceValues" ArrayValueAlias "@Value")
FROM "definition" PK "__KEY_definition" FK "__FK_definition")
FROM "customProperties" PK "__KEY_customProperties" FK "__FK_customProperties"),
(SELECT
"id" AS "id_u1",
"userId",
"userDirectory",
"name" AS "name_u0",
"privileges" AS "privileges_u0",
"__FK_owner"
FROM "owner" FK "__FK_owner"),
(SELECT
"id" AS "id_u2",
"name" AS "name_u1",
"privileges" AS "privileges_u1",
"__FK_tags"
FROM "tags" FK "__FK_tags"),
(SELECT
"id" AS "id_u3",
"name" AS "name_u2",
"privileges" AS "privileges_u2",
"__FK_stream"
FROM "stream" FK "__FK_stream")
FROM JSON (wrap on) "root" PK "__KEY_root";
//Application name and guid
[ApplicationRoot]:
LOAD
[id_u4] AS [AppGUID],
[name_u3] As AppName,
[__KEY_root] AS [AppKey]
RESIDENT RestConnectorMasterTable
WHERE NOT IsNull([__KEY_root]) and [id_u4] = '$(vMe)';
//Custom Property Values
//at this point you will have all custom property values assiged to the app.
Left Join(ApplicationRoot)
LOAD
[__FK_customProperties] AS [AppKey],
[__KEY_customProperties] AS [CustomPropertyKey],
[value] AS [CustomPropertyValue]
RESIDENT RestConnectorMasterTable
WHERE NOT IsNull([__FK_customProperties]);
//Removing all custom property values except the environment property.
Inner Join(ApplicationRoot)
LOAD
[__FK_definition] AS [CustomPropertyKey],
[name] AS [CustomPropertyName]
RESIDENT RestConnectorMasterTable
WHERE NOT IsNull([__FK_definition]) and name = '$(vEnvironmentPropertyName)';
DROP TABLE RestConnectorMasterTable;
Let vEnvironmentCount = Fieldvaluecount('CustomPropertyValue');
If vEnvironmentCount = 1 then
Let vEnvironmentName = Fieldvalue('CustomPropertyValue',1);
else
//decision: we can do a number of things here
// defaulting to production but we could fail the script or whatever
// xet vEnvironmentName = 'FAIL FAIL FAIL';
Let vEnvironmentName = 'Production';
End if
drop table ApplicationRoot;
trace running with $(vEnvironmentName) data !!!;
