Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Filter portal list on each keystroke

Status
Not open for further replies.

caman74

IS-IT--Management
Jan 1, 2005
67
NO
Hello.

I would like how to filter a portal list on each keystroke.

Let's say I'm searching for a name in a portal list.
I Type A; then Anna, Adam, Adolf comes up.
When I type the next letter D (ad), then only Adam and Adolf comes up.

How can I make this work??

Thank you for the effort!

Chris
 
Apart that I don't see why you want to do this in a portal, yes it is possible.

With the Auto-complete function.

However, if you want this for each given value or letter, a more advanced technique is needed.

The auto complete function is based upon the first characters of a word.
For every given value, you need a custom function that will index every part of a word in a field.

Out of this calculation you create a valuelist and format the imput field with this valuelist.
Together with an auto-enter on that datafield, you can capture the first matching record based upon a relationship.
The key fields for this relationship are the result of the custom functions (which is basically a multiline key) and the values in the datafield.

The custom function for the words can be something along these lines:
Case (

WordCount ( Text ) > 1 ;

CF_WordBeginsWith ( LeftWords ( Text ; WordCount ( Text ) - 1 ) ) & "¶" & FieldBeginsWith ( RightWords ( Text ; 1 ) ) & "¶" ; FieldBeginsWith ( RightWords ( Text ; 1 ) ) & "¶"

)

And you need another one for the field content.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top