I want Soql Query for to get the tabs(Navigation Items) under one application (App) in salesforce. Suppose Application Name is Data Management under these We have Database,Table,Column tabs as Custom Objects.I want to get the Database,Table,Column Names Using the SOQL Query.I used the SELECT AppDefinitionId,SortOrder,TabDefinitionId FROM AppTabMember WHERE AppDefinition.DurableId = '06m2w000000v8VCAAY' to get the Tab Members Name but get only Id's.Please help on this. Thank You.
According to this existing question, there seems to be indeed a known issue with retrieving some application and tab details using
The answer in that question mentions workaround via SOQL:
First query in
AppDefinition and filter by your application developer name and get the application
SELECT Description,DeveloperName,DurableId,Label FROM AppDefinition WHERE DeveloperName = 'YourAppDeveloperNameHere'
Then use the app
DurableId to query for the app's tabs in a second SOQL on
SELECT AppDefinitionId,SortOrder,TabDefinitionId, TabDefinition.Name,TabDefinition.Label FROM AppTabMember WHERE AppDefinition.DurableId = '06mxxxxxxxxxxxxxxx'
TabDefinition.Name returns developer name of the tab
TabDefinition.Label returns the label of the tab
TabDefinitionId may also return tab name, if it matches with a standard object or standard tab like report or dashboard