SAS VA last name text input search

[anamika009]

i have created a text input on SAS VA report where user can search last name. i have assigned category last name to the input box so as the user types last name it shows the last name starts with that word. 

client don't want this they want to be able to search last name that contains this specific word and filters the results. (like wildcard search)

e.g 

when searching in “Last_Name”  if I search “Hutterian” I only get the records where “hutterian” is the first word in the cell – not records like “Clear Lake Hutterian” or “Three Hills Hutterian”

please help!

[Madelyn_SAS]

You can achieve this by: 

1.Create a parameter based on the Category you are using in the Text Input control. 
2.Assign the parameter to the Text Input control in Parameter role.
3.On the target object, create a filter similar to this, where "Name" is the category you are filtering on:  ( UpCase('Name'n) Contains UpCase('Name Parameter'p) )

[anamika009]

Hi Madelyn!

Thank you so much for your quick response!

I have followed the instructions and created the parameter and assigned it as a role to last name input box. I have also created the filter but its not working for me. Do i also assign the category under roles?

Please see attached file.

[Madelyn_SAS]

Yes, the data item should be in the Category role and its parameter should be in the Parameter role. 

[anamika009]

Hi Madelyn,

Thank you again!

data item (last_name) is in the category role and parameter in parameter role but its still not working. Please help!

[Madelyn_SAS]

I was actually incorrect. The Text Input control should have only the parameter assigned to the Parameter role. Here is an example: 

Report has a Text Input control with Origin Parameter assigned to the Parameter role.
List table has these data items: Origin, Make, Invoice. Some valid values for Origin are Asia, Europe, USA.
List table has an Advanced Filter (Filters pane) with this expression: 

( UpCase('Origin'n) Contains UpCase('Origin Parameter'p) )

I enter a lowercase letter a in the Text Input control and press ENTER. This is important because the value is not registered until you press ENTER. 

The list table is filtered to show USA and Asia.

[ASHISH2525]

Hi Anamika,

This is may be you were looking for.

Regards,

Ashish

( UpCase('Task name'n) Contains UpCase('Task name Parameter'p) )

[anamika009]

Thank you so much Ashish!!

I have the similar code but its just not working for me. I have SAS VA 8.2. 

Also if i don't have the category assigned for Last_Name i see an error sign on the input box. 

Please see screenshots.

Please help!!!

[ASHISH2525]

Anamika !

Please share the screenshot how you created this parameter ?
Did you apply the filter on list table it self ?


Regards,
Ashish

[anamika009]

Hi Ashish!

Thank you once again for your quick response!

I have created the parameter by going into LAST_NAME category and adding a parameter from there.

I have applied the filter on the LAST_NAME T'ext_Input' box not the list table.

Please see the screenshots.

[Madelyn_SAS]

The filter needs to be on the list table. 

[ASHISH2525]

You have to apply the filter on list table only.

[anamika009 · Accepted solution]

Hi Ashish!!!!

You are great thank you sooooo much for this and yes it solved the issue and i am getting the results i want!!

God Bless!!!! 🙂

[ASHISH2525]

Cheers !!

Good to hear that.