Filter values based on Prefix

[Aara]

I have a Input Box and a Straight table.  If I search with a prefix of a value in Input Box , straight table should return all the values with the prefix. For example, If I search with a Prefix as CRO in description column and click on Apply Filter button, it should return all the description starting with CRO.

[vchuprina]

Hi,

You can add a search object instead of an input box and apply the filter button

Add a list of fields for search 

Also, you can change the style on the presentation tab 

Regards,

Vitalii

[Akeem]

---

@Aara wrote:

I have a Input Box and a Straight table.  If I search with a prefix of a value in Input Box , straight table should return all the values with the prefix. For example, If I search with a Prefix as CRO in description column and click on Apply Filter button, it should return all the description starting with CRO.

HP Instant Ink Plans

---

I was trying this out and got some issues and still finding it can you give some more suggestions if any thanks in advance.

[Marijn]

Hi Aari,

You can also use a List Box. By setting Default Search Mode to Use Wildcard search, two * will be added to your search string. This means that if you search for CRO, it will look like *CRO*. The results will include all strings that contain CRO.

Additionally, you can also search for CRO*, which will return every string that starts with CRO.

Hope this helps!

Marijn

[Aara]

Adding to my requirement, reason for Input box is, user should have options to filter multiple values for the particular column. Example, when user wanted to search with State that starts with, "CA" , "NO"  in a comma separated value search, it should display all the State that begins with "CA" and "NO".