Wildcard searching for title? (624 Views)
Reply
Regular Advisor
ramamoorthyshal
Posts: 115
Registered: ‎02-04-2014
Message 1 of 9 (624 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: 577
Registered: ‎04-22-2008
Message 2 of 9 (613 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: 115
Registered: ‎02-04-2014
Message 3 of 9 (595 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,128
Registered: ‎06-17-2010
Message 4 of 9 (577 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.
Regular Advisor
ramamoorthyshal
Posts: 115
Registered: ‎02-04-2014
Message 5 of 9 (568 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,128
Registered: ‎06-17-2010
Message 6 of 9 (566 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.
Regular Advisor
ramamoorthyshal
Posts: 115
Registered: ‎02-04-2014
Message 7 of 9 (552 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,128
Registered: ‎06-17-2010
Message 8 of 9 (547 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.
Honored Contributor
John Stagaman
Posts: 3,521
Registered: ‎07-13-2007
Message 9 of 9 (543 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.