The community will be in read-only from Tuesday 11:59pm (PST) to Wednesday 7:30am (PST)
The community will be in read-only from Tuesday 11:59pm (PST) to Wednesday 7:30am (PST)
Project and Portfolio Management Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

User Login Font Page details

SOLVED
Go to solution
Highlighted
PPMRam
Collector

User Login Font Page details

Hello,

 

Please help in getting the Frontpage details whenever user login into PPM.

 

I am trying to find out to get the portlet / Module details viewed whenever user login into PPM. Able to get the details for all the portlets using the query but not able to get the portlet / Module details of only exist on front page view.

 

SELECT dpd.name PORTLET_NAME, ku.full_name USERNAME, dp.title PAGE_NAME, dpt.title PORTLET_TITLE
FROM dsh_pages dp, knta_users ku, dsh_user_pages dup,dsh_portlets dpt,dsh_portlet_defs dpd
WHERE dup.page_id= dp.page_id
and     ku.user_id= dup.user_id
and     dp.page_id=dpt.page_id
and dpt.portlet_def_id =dpd.portlet_def_id
and dpd.enabled = 'Y'

 

Thanks in advance......

 

 

 

8 REPLIES
kwood55
Frequent Visitor

Re: User Login Font Page details

It is not really a portlet/Module. It is a JSP page.

You do not yet have acces to PPM yet, not until  user is authenticated

PPMRam
Collector

Re: User Login Font Page details

Hi kwood55,

 

Am discussing about after user authentication dashboard front page view only.

 

 

Regards,

Oscar_Pereira
Frequent Visitor

Re: User Login Font Page details

Hi,

 

Try with the following query:

 

 

SELECT p.TITLE Dashboard_Page_Title,
a.title Portlet_Title , a.page_id Page_id,
u.username Username , pd.portlet_def_id Portlet_Def_id, pd.name Portlet_Definition_name,
m.name Module_name
FROM dsh_portlets a,
dsh_user_pages UP,
dsh_pages p LEFT OUTER JOIN dsh_modules m on (m.module_id = p.module_id),
knta_users u,
dsh_portlet_defs pd
WHERE a.page_id = UP.page_id
AND UP.user_id = u.user_id
AND UP.page_id = p.page_id
AND a.portlet_def_id = pd.portlet_def_id
AND  p.TITLE = 'Test_Front_page'
AND u.username = 'admin';

 

 

Substitude the p.TITLE value for the name of the Front page for a particular user

 

 

Regards

Oscar Pereira

 

 

PPMRam
Collector

Re: User Login Font Page details

Hi Oscar,

 

Thanks for your query but I need the details of front page displayed whenever user login into ppm, like for example if the user admin set dashboard pages as "Test_Front_Page","Test_Front_Page1" and "Test_Front_Page2", Selected "Test_Front_page" as first page to display in personalized view of the dashboard settings. When he login into PPM, the page will be displayed "Test_Front_Page". So, here I need this type of page details for every user which will display after authentication of user.

 

Please let me know for further clarification.

 

Regards,

d4y4n4
Frequent Visitor

Re: User Login Font Page details

Hi,

Check with this one

SELECT u.user_id,
u.username,
p.title page_title,
a.portlet_id,
a.title,
a.portlet_def_id,
pd.NAME portlet_def_name,
pd.TYPE portlet_type
FROM dsh_portlets a,
dsh_user_pages UP,
dsh_pages p,
knta_users u,
dsh_portlet_defs pd
WHERE a.page_id = UP.page_id
AND UP.user_id = u.user_id
AND UP.page_id = p.page_id
AND a.portlet_def_id = pd.portlet_def_id

and here is another one



Usage Details: Replace <user_name> corresponding to u.username with the required Project and Portfolio Management (PPM) username.

Results Returned: Returns the Title of Dashboard Page, Title of the Portlet, User's Name, Portlet Preference Value Name:

SELECT p.TITLE Dashboard_Page_Title,
a.title Portlet_Title ,
u.username Username ,
pf.name Portlet_Pref_Name

FROM dsh_portlets a,
dsh_user_pages UP,
dsh_pages p,
knta_users u,
dsh_portlet_defs pd ,
dsh_portlet_preferences pf


WHERE a.page_id = UP.page_id
AND UP.user_id = u.user_id
AND UP.page_id = p.page_id
AND a.portlet_def_id = pd.portlet_def_id
AND pf.portlet_id = a.portlet_id
AND u.username = '<user_name>'

Regards,
Dayana
jsalass
Frequent Visitor
Solution

Re: User Login Font Page details

Hey PPMRam

 

This should be easy by using this query:

 

select * from (
-- Users using a group page as a default first page
Select p.page_id, p.page_sequence, p.title page_title, u.user_page_id, u.user_id,
p.page_group_id, g.title  group_title, g.sequence Group_SEQ
from dsh_pages p join dsh_user_pages u on p.page_id=u.page_id
JOIN dsh_page_groups g on p.page_group_id= g.page_group_id
where p.module_id is null
and  g.sequence=0 and p.page_sequence=0
--and u.user_id=1
union all
-- Users using a page as a default first page
Select p.page_id, p.page_sequence, p.title page_title, u.user_page_id, u.user_id,
null page_group_id, null group_title,null Group_SEQ
from dsh_pages p join dsh_user_pages u on p.page_id=u.page_id
where p.module_id is null and p.page_group_id is null
and p.page_sequence=0
--and u.user_id=1
) order by  user_id,page_sequence

 


Here you will be able to identify what page or group page is the first page for every user. The key here is to use the union statement since there are two possible tables that can provide the default page. Also, when the user is using a group page the query will return the page with seq 0.

 

PPM always modifies the seq for the dsh_pages or the dsh_page_groups when a user personalizes his/her dashboard.

 

Hope this helps!

 

Regards,

Jonathan

 

 

PPMRam
Collector

Re: User Login Font Page details

Hi Jonathan,

 

Great!!!!!!! thanks for your query. This achieves my requirement.

 

Regards,

jsalass
Frequent Visitor

Re: User Login Font Page details

Nice to see the query worked fine for you.

 

Regards.

Jonathan

//Add this to "OnDomLoad" event