HPE Records Manager and HPE TRIM Forum
Showing results for 
Search instead for 
Do you mean 

HPRM 8.0 Boolean search issue

HPE Expert

HPRM 8.0 Boolean search issue

Hi all,

 

I thought it worth mentioning that an issue has been discovered with the default Boolean search operators when using multiple words in a title/notes word search in HP Records Manager 8.0.

 

As you know, multiple words in such a search should be treated by default as an AND search. E.g. Entering "financial estimates 2014" (without the quotes) in a title word search should equate to financial AND estimates AND 2014.

 

However...in HPRM 8.0 the above search could actually be executed as 2014 AND (financial OR estimates)

 

A change request has been raised to have this issue addressed in an upcoming release:

 

QCCR2D50217: Title & Notes word searches - multiple word searches using wrong Boolean operators


Neil


Note: Any posts I make on this forum are my own personal opinion and do not constitute a formal commitment on behalf of HPE.

(Please state the version of TRIM/HPRM/HPERM you're using in all posts)

HPE Software Support Online (SSO): https://softwaresupport.hp.com/
4 REPLIES
Honored Contributor Honored Contributor

Re: HPRM 8.0 Boolean search issue

Thanks Neil, I just heard about this one yesterday. :)



::::::::::::::::::::::
NOT A HP EMPLOYEE
::::::::::::::::::::::

Kapish.com.au
Frequent Advisor

Re: HPRM 8.0 Boolean search issue

Hi Neil,

 

That is great to hear.  We had a feeling for quite some time that the searching for multiple words didn't quite do what you would expect but never got to the bottom of it.  We are getting inconsistent results for the same searches and when you then change the default search operator in the IDOL config files it behaves different again.

 

We also have found, and again not being able to get to the bottom of it yet, that you can get "strange" and unexpected results.  That however may be due to IDOL "intelligent" operating layer having a mind of its own.

 

On the positive side (a huge positive side), IDOL seems to work so much better than ISYS ever did and I'm sure we all get used to the new way of retrieving the information.

InfocentriK Helpdesk

P (+64) 04 – 566 1115
E support@infocentrik.co.nz
W www.infocentrik.co.nz

InfocentriK Limited
PO Box 31139
Lower Hutt 5040
HPE Expert

Re: HPRM 8.0 Boolean search issue

To avoid confusion for others reading this thread, the title/notes searches where this issue is evident aren't using IDOL; rather a standard SQL query.

 

A workaround is to add separate lines in your search criteria and specify the AND operator for each. E.g.:

Title Word = financial

AND Title Word = estimates

AND Title Word = 2014

 


Neil


Note: Any posts I make on this forum are my own personal opinion and do not constitute a formal commitment on behalf of HPE.

(Please state the version of TRIM/HPRM/HPERM you're using in all posts)

HPE Software Support Online (SSO): https://softwaresupport.hp.com/
Highlighted
HPE Expert

Re: HPRM 8.0 Boolean search issue

Another workaround would be to change the system option 'Usage of IDOL search engine for Record search clauses'

 

(under: HP Records Manager Administration - System Options - Record tab)

 

to "Document Content, Record Titles and Record Notes" or "Use IDOL indexes where possible".

 

Assuming you're using IDOL with HPRM, and IDOL's configured to use the default Boolean operator 'AND', this should also give you the results you're after.


Neil


Note: Any posts I make on this forum are my own personal opinion and do not constitute a formal commitment on behalf of HPE.

(Please state the version of TRIM/HPRM/HPERM you're using in all posts)

HPE Software Support Online (SSO): https://softwaresupport.hp.com/