Project and Portfolio Management Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

Finding Default dashboard

Highlighted
Mohan Raju C
Occasional Contributor

Finding Default dashboard

Hi All,

Is there a way to find a default dashboard of a user from the backend(DB)?

Thanks!

Regards,
Mohan
5 REPLIES
Mahen M
Honored Contributor

Re: Finding Default dashboard

Please check up DSH_USER_PAGES table, I am not sure whether you are looking for this table or not.

Regards,
Mahendran M
Mohan Raju C
Occasional Contributor

Re: Finding Default dashboard

Hi Mahendran,

Thanks for your instant reply.

Yes, I did look at that table. But, it does not contain the information about the default dashbord of a user. It just shows the list of pages the user has. There is no sequence associated with it.

Thanks!

Regards,
Mohan
Semenov Alexand
Esteemed Contributor

Re: Finding Default dashboard

Good Day.
Use this query:
SELECT "DSH_USER_PAGES"."USER_ID", "DSH_PAGES"."TITLE", "DSH_PORTLETS"."TITLE", "DSH_PAGES"."PAGE_SEQUENCE"
FROM "ITGUSER"."DSH_PORTLETS" "DSH_PORTLETS" INNER JOIN ("ITGUSER"."DSH_USER_PAGES" "DSH_USER_PAGES" INNER JOIN "ITGUSER"."DSH_PAGES" "DSH_PAGES" ON "DSH_USER_PAGES"."PAGE_ID"="DSH_PAGES"."PAGE_ID") ON "DSH_PORTLETS"."PAGE_ID"="DSH_PAGES"."PAGE_ID"
WHERE "DSH_USER_PAGES"."USER_ID"='108035' AND "DSH_PAGES"."PAGE_SEQUENCE"=0
ORDER BY "DSH_PAGES"."TITLE"

Notes:
In result query show default dashboard of a user with portlets on thhis page.
"DSH_PAGES"."PAGE_SEQUENCE"= 0 - default dashboard of a user

Erik Cole
Honored Contributor

Re: Finding Default dashboard

Hi,

Looks like Alexander may have beat me to it, but we use

Select p.PAGE_ID,
p.TITLE,
p.PAGE_SEQUENCE,
p.PAGE_GROUP_ID,
g.TITLE,
g.SEQUENCE,
decode(g.SEQUENCE,null,p.PAGE_SEQUENCE,g.SEQUENCE) "MASTER_SEQ"
From DSH_PAGES p
left join DSH_PAGE_GROUPS g on g.PAGE_GROUP_ID = p.PAGE_GROUP_ID
where p.PAGE_ID in (select PAGE_ID from DSH_USER_PAGES
where USER_ID = 1)
order by 7,3

Obviously, you need to replace the USER_ID with your value, but "MASTER_SEQ" is the zero-based order that the pages appear on the menu.
Mohan Raju C
Occasional Contributor

Re: Finding Default dashboard

Hi All,

Thanks a lot for your data. It really helped us.

Thanks again!

Regards,
Mohan
//Add this to "OnDomLoad" event