SOQL Query For To Get the Tabs of Particular Application

Question

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.

Answer 1

Updates: According to this existing question, there seems to be indeed a known issue with retrieving some application and tab details using DescribeTabsetResult methods.

The answer in that question mentions workaround via SOQL:

First query in AppDefinition and filter by your application developer name and get the application DurableId

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 AppTabMember

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

References:

AppDefinition

AppTabMember