Is there any way to view the layouts that my users are currently using? For example, I suspect one user has not customized their layout. They just keep using favorite shortcuts, ignoring the entire layout screen. Without going to each user and asking them to show their homepage layout, how can I review what each user is using? I’m currently using the Ice.FavItems to make sure I create their layouts with all the relevant favorites from their classic menu history. Is there something similar to review for the layouts?
Thank you!
Nate
EDIT: I see ShellLayoutPersonal has some of the details, just not sure how to use it.
/*
* Disclaimer!!!
* This is not a real query being executed, but a simplified version for general vision.
* Executing it with any other tool may produce a different result.
*/
select
[Base].[UserFile_DcdUserID] as [UserFile_DcdUserID],
[Base].[UserFile_Name] as [UserFile_Name],
[Base].[Calculated_CustomizedLayout] as [Calculated_CustomizedLayout],
[Base].[Calculated_Layout] as [Calculated_Layout],
(case
when Base.Calculated_CustomizedLayout = 1
then Base.ShellLayoutPersonal_ShellHomePage
else ShellLayout.ShellHomePage
end) as [Calculated_ShellHomePage]
from (select
[UserFile].[DcdUserID] as [UserFile_DcdUserID],
[UserFile].[Name] as [UserFile_Name],
(case when ShellLayoutPersonal.ShellHomePage is null OR ShellLayoutPersonal.ShellHomePage = '' then 0 else 1 end) as [Calculated_CustomizedLayout],
(case
when CustomizedLayout = 1
then 'Custom Layout'
else
(case
when ShellLayoutPersonal.BaseLayoutID is null OR ShellLayoutPersonal.BaseLayoutID = ''
then 'System Default'
else ShellLayoutPersonal.BaseLayoutID
end)
end) as [Calculated_Layout],
[ShellLayoutPersonal].[ShellHomePage] as [ShellLayoutPersonal_ShellHomePage]
from Erp.UserFile as UserFile
left outer join Ice.ShellLayoutPersonal as ShellLayoutPersonal on
UserFile.DcdUserID = ShellLayoutPersonal.UserID
and ( ShellLayoutPersonal.SubType = 'kinetic' )
where (UserFile.UserDisabled = false)) as Base
left outer join Ice.ShellLayout as ShellLayout on
Base.Calculated_Layout = ShellLayout.LayoutID
This is wicked cool! Thank you! Is the “ShellHomePage” field like the HTML for the view of the layout? I was hoping to extract the Layout Name but it doesn’t appear to be in there. The “Layout” field only has three values “Custom Layout”, “System Default”, and “Manufacturing”. None of my layout names appear here. Are they stored somewhere else?
For example, I have my layout saved as “IT Maintenance”. In the BAQ I can see this data:
User ID Name CustomizedLayout Layout ShellHomePage
NATHAN NATHAN HASSLER-SCHOONOVER TRUE Custom Layout “<HomePageDataSet xmlns=” yadda yadda…
I poked around in Dev tools to search for my layout name, but didn’t find it exposed anywhere. Checking the other layout fields in the BAQ,
ShellLayoutPersonal_LayoutID is all “Default”. I assumed that they would have to store the layout name somewhere, right?
When I click the … in the top right of the home page layout, I can change layouts, manage layouts, or edit layout. If I manage, I can create a new layout with a name. After its create, I can’t find a place to view/change the name besides this slideout.
