I need to get list of all the current dashboards in the system,
I went to: Settings>>Customization>>Customize the system>>Components>>Dashboards.
I can see a list of dashboards , but it does not show all the dashboards
How can get list of all dashboards in all different modules
Many Thanks.
*This post is locked for comments
Where do you enter this query language?
thank you it was great help
thank you , this worked fine for me
Hi Shaka,
Use the following query expression to retrieve system dashboards. You should add the condition type is 0.
Share
Report
All responses (
Answers (
QueryExpression query = new QueryExpression("systemform");
query.ColumnSet.AddColumns(new ColumnSet{"formid","name","isdefault","description"});
query.Criteria.AddCondition("type", ConditionOperator.Equal, 0);
query.Orders.Add(new OrderExpression("name", OrderType.Ascending));
return orgService.RetrieveMultiple(query);
Hope this helps.
Please try this:
select * from systemform where type = 0
0 is the type for dashboard.
https://msdn.microsoft.com/en-us/library/mt607589.aspx
As you may see above total is 23 records
while it gave a number of 1039 record as a result of the query:
select * from systemform
thanks
Hi Shaka,
Can you check how many dashboards you see under Settings>>Customization>>Customize the system>>Components>>Dashboards. If it is over 1000, then you will be definitely having these much system dashboards.
Hope this helps.
i query both user forms and system forms using the below simple queries as i'm not that expert how and where to use that code
1- select * from UserForm
2- select * from systemform
the 1st one gave me few records, but the 2nd one for system forms resulted more 1000 of records, im not sure if i have that much number of dashboards in the system
any advise?
Hi Shaka,
To see both system and user dashboards, you can write the code as shown in the link below.
msdynamics2011.blogspot.com/.../get-list-of-system-and-user-dashboards.html
Hope this helps.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156