Re: Searching notes field in Locations - TRIM 7.2.1.3519 (154 Views)
Reply
Frequent Advisor
Joanna Thompson
Posts: 61
Registered: ‎07-22-2010
Message 1 of 7 (232 Views)

Searching notes field in Locations - TRIM 7.2.1.3519

Is there a way I can run a string-based search on the notes field for locations?  I'm sure it's something really simple, but for the life of me, I can't figure out how to do this.

Thanks in advance!

Joanna Thompson
Senior Records Management Application Analyst
Government Records Service, Information Access Operations
Logistics and Business Services, Shared Services BC
Ministry of Citizens' Services and Open Government
Please use plain text.
Honored Contributor
EWillsey
Posts: 1,708
Registered: ‎04-20-2010
Message 2 of 7 (221 Views)

Re: Searching notes field in Locations - TRIM 7.2.1.3519

Unfortunately no
Please use plain text.
Valued Contributor
RodgerDodger
Posts: 261
Registered: ‎10-28-2009
Message 3 of 7 (187 Views)

Re: Searching notes field in Locations - TRIM 7.2.1.3519

If you must search by notes field, you can always use print merge, import your data into an Access database table, and then search for the contents in the notes field.

 

RD

Please use plain text.
Frequent Advisor
Joanna Thompson
Posts: 61
Registered: ‎07-22-2010
Message 4 of 7 (177 Views)

Re: Searching notes field in Locations - TRIM 7.2.1.3519

I could, but it shouldn't have to be that way, especially when my client needs an answer RIGHT NOW.  

 

If I can search on something relatively complex like find all persons that are using the same address as their default organizational association, then I should be able to run a Note Word search of the notes field of that same location. 

 

I'm thankful for the ability to run string searches, but I always seem to run across situations like this one where the data is tantalizingly out of reach from within TRIM. 

 

Oh well, thanks for responding!

Joanna Thompson
Senior Records Management Application Analyst
Government Records Service, Information Access Operations
Logistics and Business Services, Shared Services BC
Ministry of Citizens' Services and Open Government
Please use plain text.
Honored Contributor
EWillsey
Posts: 1,708
Registered: ‎04-20-2010
Message 5 of 7 (170 Views)

Re: Searching notes field in Locations - TRIM 7.2.1.3519

I have an excel script that can do this for you, if you're interested.

Please use plain text.
Valued Contributor
emTRIM
Posts: 59
Registered: ‎04-17-2011
Message 6 of 7 (161 Views)

Re: Searching notes field in Locations - TRIM 7.2.1.3519

Maybe this should be put through as an enhancement request?
Please use plain text.
Valued Contributor
RodgerDodger
Posts: 261
Registered: ‎10-28-2009
Message 7 of 7 (154 Views)

Re: Searching notes field in Locations - TRIM 7.2.1.3519

[ Edited ]

On a similar topic, we have submitted in the past an enhancement request to HP to make locations act similarly to records : prevent some users from seeing some locations and make record-like searching available.    This request was not accepted.

 

We were told that if some locations needed to be unseen and more advanced searching was necessary then we should consider making these locations actual records.

 

Food for thought.

 

RD

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