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

Auto-complete list suggestion list

Highlighted
cat_gon
Super Collector

Auto-complete list suggestion list

Hi All,

 

Is there a way that we can do the ff:

 

1. In an auto-complete list, provide a suggestion list when you are typing the value.

 

Example: Field is called Project Manager, and in this auto-complete list there are people named John Smith, John Sawyer, John John. So if you type in the word John in the field, there will be a suggestion list for these 3 names

 

2. Auto-complete the word.

 

Example: Field is called Project Manager, and in this auto-complete list there is only one person named Linda Lim. So if I type the word Linda, it will auto-complete the word without having to tab out.

 

3. Keeping the history.

 

Example. I have previously typed in John Smith in the field, when I type J it will show the history of al the inputs I made which starts with J.

 

Is this possible?

 

Thanks.

 

Catherine

7 REPLIES
Erik Cole
Honored Contributor

Re: Auto-complete list suggestion list

Hi Catherine,

 

re: 1 & 2, you have all that functionality already, except you have to hit tab. I don't know another way around that. But in your case, if you type "john" and hit tab you'll get a popup with the three Johns to select from.

 

re: 3, that's a browser function. I'm currently doing this in Firefox 18.

Mohit_Agrawal
Frequent Visitor

Re: Auto-complete list suggestion list

Hi Catherine..

 

For the points 1 & 2.. Configure the auto complete validation as below: It will automatically short out the list without tab out...

 

Component Tye: Auto Complete List

Validated by: SQl - Custom

Expected list length: Long (Radio button) -- Most Imp.

 

SQL:

Select  Distinct usr.user_id, usr.user_full_name
From  knta_user_security_v usr, knta_security_groups grp, knta_users_v usrv
Where  usr.security_group_id  =  grp.security_group_id 
AND usrv.user_id   = usr.user_id
AND usrv.enabled_flag  = 'Y'
AND ( '[REQ.P.REQUEST_APPROVER]' = ' '))
AND  usr.user_id IN  (Select usr2.user_id
    From  knta_user_security_V usr2
    Where  usr2.security_group_name = ' provide grp name'
   )
AND  UPPER(usr.user_full_name) like UPPER('?%')   --- Include this text only in your validation
Order by usr.user_full_name

 

For Points 3: it's browser settings..

 

 

Thanks!!

Mohit Agrawal

:: Click KUDOS if you like it....

Mohit_Agrawal
Frequent Visitor

Re: Auto-complete list suggestion list

Hi Cath,
Is there any update on this? did it work?
cat_gon
Super Collector

Re: Auto-complete list suggestion list

Hi Mohit,

 

It did not work. I still have to click on the tab or Find button.

skbd
Regular Collector

Re: Auto-complete list suggestion list

Hi Mohit,

I dont mean to hijack this thread, but a question -

I am new to customizing PPM for particular use and I have found lines of SQL similar to yours everywhere:

AND UPPER(usr.user_full_name) like UPPER('?%')

 

What does the 'like UPPER('?%')' really mean in plain english?

 

Thanks!

Steve

Mohit_Agrawal
Frequent Visitor

Re: Auto-complete list suggestion list

Hi Steve,

 

 

UPPER(usr.user_full_name) --- would first convert the full name to upper case

UPPER('?%')--- would convert the input (input by user taken as ?) to upper case.

 

So, UPPER(usr.user_full_name) like UPPER('?%') -- means select the data where username like 'the value users type in the field'.

 

 

skbd
Regular Collector

Re: Auto-complete list suggestion list

Thanks Mohit!

//Add this to "OnDomLoad" event