Wildcard searching for title? (382 Views)
Reply
Frequent Advisor
ramamoorthyshal
Posts: 50
Registered: ‎02-04-2014
Message 1 of 9 (382 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?

Please use plain text.
Trusted Contributor
lwvirden
Posts: 533
Registered: ‎04-22-2008
Message 2 of 9 (371 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.
Please use plain text.
Frequent Advisor
ramamoorthyshal
Posts: 50
Registered: ‎02-04-2014
Message 3 of 9 (353 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.

Please use plain text.
Honored Contributor
Piku
Posts: 3,837
Registered: ‎06-17-2010
Message 4 of 9 (335 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,
Please use plain text.
Frequent Advisor
ramamoorthyshal
Posts: 50
Registered: ‎02-04-2014
Message 5 of 9 (326 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.

Please use plain text.
Honored Contributor
Piku
Posts: 3,837
Registered: ‎06-17-2010
Message 6 of 9 (324 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,


Please use plain text.
Frequent Advisor
ramamoorthyshal
Posts: 50
Registered: ‎02-04-2014
Message 7 of 9 (310 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.

Please use plain text.
Honored Contributor
Piku
Posts: 3,837
Registered: ‎06-17-2010
Message 8 of 9 (305 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,
Please use plain text.
Honored Contributor
John Stagaman
Posts: 3,304
Registered: ‎07-13-2007
Message 9 of 9 (301 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...
Please use plain text.
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