Skip to main content

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
Aditya_Chitale
Creator III
Creator III

Function to get app name using app id.

Hello,

Is there any way to get app name using respective app id ? I have used DocumentTitle() and DocumentName() but it returns only the app name/id in which the function is used. 

I want to get external app name as I am trying to use it a mail subject for task failure alert.

Community link referred for alerting: 

https://community.qlik.com/t5/Qlik-Sense-Documents/Email-Alert-for-Qlik-Sense-task-failed-Very-easy/...

 

Regards,

Aditya

Labels (1)
  • SaaS

1 Solution

Accepted Solutions
HugoRomeira_PT
Creator
Creator

Hi Aditya,

I propose you use the Qlik Connector :monitor_apps_REST_app to get the app ID and name, and than create a mapping table and apply the map.

See script bellow. Hope it helps:

 


LIB CONNECT TO 'monitor_apps_REST_app';

RestConnectorMasterTable:
SQL SELECT
"id" AS "id_u4",
"createdDate" AS "createdDate_u0",
"modifiedDate" AS "modifiedDate_u0",
"modifiedByUserName" AS "modifiedByUserName_u0",
"name" AS "name_u3",
"publishTime",
"published",
"description",
"fileSize",
"lastReloadTime",
"availabilityStatus",
"__KEY_root",
(SELECT
"userId",
"userDirectory",
"__FK_owner"
FROM "owner" FK "__FK_owner"),
(SELECT
"name" AS "name_u2",
"__FK_stream"
FROM "stream" FK "__FK_stream")
FROM JSON (wrap on) "root" PK "__KEY_root";



MapApp:
Mapping LOAD
[id_u4] AS ObjectId,
[name_u3] AS [App Name QRS]
RESIDENT RestConnectorMasterTable
WHERE NOT IsNull([__KEY_root]);

DROP TABLE RestConnectorMasterTable;

Best regards

Hugo Romeira

If the issue is solved please mark the answer with Accept as Solution.
If you want to go quickly, go alone. If you want to go far, go together.

View solution in original post

1 Reply
HugoRomeira_PT
Creator
Creator

Hi Aditya,

I propose you use the Qlik Connector :monitor_apps_REST_app to get the app ID and name, and than create a mapping table and apply the map.

See script bellow. Hope it helps:

 


LIB CONNECT TO 'monitor_apps_REST_app';

RestConnectorMasterTable:
SQL SELECT
"id" AS "id_u4",
"createdDate" AS "createdDate_u0",
"modifiedDate" AS "modifiedDate_u0",
"modifiedByUserName" AS "modifiedByUserName_u0",
"name" AS "name_u3",
"publishTime",
"published",
"description",
"fileSize",
"lastReloadTime",
"availabilityStatus",
"__KEY_root",
(SELECT
"userId",
"userDirectory",
"__FK_owner"
FROM "owner" FK "__FK_owner"),
(SELECT
"name" AS "name_u2",
"__FK_stream"
FROM "stream" FK "__FK_stream")
FROM JSON (wrap on) "root" PK "__KEY_root";



MapApp:
Mapping LOAD
[id_u4] AS ObjectId,
[name_u3] AS [App Name QRS]
RESIDENT RestConnectorMasterTable
WHERE NOT IsNull([__KEY_root]);

DROP TABLE RestConnectorMasterTable;

Best regards

Hugo Romeira

If the issue is solved please mark the answer with Accept as Solution.
If you want to go quickly, go alone. If you want to go far, go together.