Wildcard searching for title? (600 Views)
Reply
Regular Advisor
ramamoorthyshal
Posts: 107
Registered: ‎02-04-2014
Message 1 of 9 (600 Views)

Wildcard searching for title?

I need to search a change based on the Title using Wildcard.

Title is a Text field.

in Title field i tried giving an "tes" instead of "test". I'm able to search. But i need to search using Wildcard

How to achieve that?

Trusted Contributor
lwvirden
Posts: 572
Registered: ‎04-22-2008
Message 2 of 9 (589 Views)

Re: Wildcard searching for title?

go into the change management search changes form.
Go to the advanced search tab.
Select Brief Description
Select Contains as the comparison
Enter as the value your string surrounded by one or two astersisk.
Click Next
Click the Search button
For example *est* to look for "test", "Test", "testing", "attests" and so forth.
Regular Advisor
ramamoorthyshal
Posts: 107
Registered: ‎02-04-2014
Message 3 of 9 (571 Views)

Re: Wildcard searching for title?

Thank u for ur response. The requirement is like, the user will enter the *tes* in Title field of Search change form.

it should display all the RFc which contains "tes".

 

They should not go to advance search tab for this. Directly in Title field it should happen.

Honored Contributor
Piku
Posts: 4,072
Registered: ‎06-17-2010
Message 4 of 9 (553 Views)

Re: Wildcard searching for title?

Hi Rama,

Here your SM 'IR search' comes in play.
When you say that it should display all rfc where some word comes then you have to tell SM in which fields of CR it should look out. And this is controlled by table 'irfields' , you have to add all those field here.
But this is not supposed(to add all fields) to do as it will impact the performance badly and irexpert search are very heavy.

So it s better to allow use of advance search.

hth,
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Assign Kudo, if found post useful and mark it accepted if solves the issue.
http://h30499.www3.hp.com/t5/Tips-and-Tricks/Kudos-what-where-how-and-why/m-p/5677925#U5677925
Regular Advisor
ramamoorthyshal
Posts: 107
Registered: ‎02-04-2014
Message 5 of 9 (544 Views)

Re: Wildcard searching for title?

Hi piku,

 

I'm trying to search *tes* in Title field.

So, RFC's which is having "tes" in title field(Text field alone it should search.

I mean not to search entire CR for "tes".

Any Possible way to achieve it?

if yes please let me know in detail.

 

Thanks.

Honored Contributor
Piku
Posts: 4,072
Registered: ‎06-17-2010
Message 6 of 9 (542 Views)

Re: Wildcard searching for title?

Hi,

Yes it would, use *tes*. You are doing it correct.
If it is simple varchar type field not array(text area type)

hth,


~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Assign Kudo, if found post useful and mark it accepted if solves the issue.
http://h30499.www3.hp.com/t5/Tips-and-Tricks/Kudos-what-where-how-and-why/m-p/5677925#U5677925
Regular Advisor
ramamoorthyshal
Posts: 107
Registered: ‎02-04-2014
Message 7 of 9 (528 Views)

Re: Wildcard searching for title?

Hi Piku,

 

 

But Its not working.

I have entered *tes*, its not searching properly.

I Tried with some other text also.. its not working.

 

Thanks.

Honored Contributor
Piku
Posts: 4,072
Registered: ‎06-17-2010
Message 8 of 9 (523 Views)

Re: Wildcard searching for title?

Hi,

What do you mean by not working?
Not returning result at all ? --- check for field name in search screen.
Is it working if not using '*' ?

hth,
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Assign Kudo, if found post useful and mark it accepted if solves the issue.
http://h30499.www3.hp.com/t5/Tips-and-Tricks/Kudos-what-where-how-and-why/m-p/5677925#U5677925
Honored Contributor
John Stagaman
Posts: 3,478
Registered: ‎07-13-2007
Message 9 of 9 (519 Views)

Re: Wildcard searching for title?

[ Edited ]

If the title is IR Indexed (check the IR Key for the table), then searches againt title will be performed using that functionality. It already does stemming, relevancy, etc. and a  wildcard search may not return the expected values. 

 

Note that is is not possible to execute a search against only one of the fields in an IR Key. If title and description are IR indexed, they will be searched together. Removing title from the IR Key doesn't really address the issue, because then your question becomes "How do I perform a full table scan by having users do a wildcard search against the title field?" which is less than ideal. 

 

For your example, if you were to try to search an IR indexed field for tes* you would likely get no results if that string is common to too many records. For example, I often have users demo IR by adding the word test repeatedly and searching for it. Then, one day, it stops working because too high a percentage of tickets include the word test and the word is automatically excluded from IR relevancy ranking. 

 

Why do users need to do a wildcard search against the title field? 

--If they are coding things in the title (e.g status, next action, follow up time), it is probably better to add a custom field to manage the functionality.

----------------------------------------------------
Kudos - what, where, how, and why
Want Good Answers? Ask Good Questions...
The opinions expressed above are the personal opinions of the authors, not of HP. By using this site, you accept the Terms of Use and Rules of Participation.