How do I search through History

[JwithaL]

I am trying to figure out the most efficient way of searching through our Goldmine 5.7 history/pending calls. All of our notes are in those two areas and in looking for part numbers it can be a real pain if you don't know the contact name.

Does anyone have any knowledge on how to search the history/pending area of Goldmine.

Thanks in advance,
Justin

FYI: This is dBase version of Goldmine 5.7

 

[richardy]

Justin,

You might want to use an SQL query, its not elegant but a quick way:

select * from conthist where notes like '%PARTNUMBER%'

or

select * from CAL where notes like '%PARTNUMBER%'





Regards,

Richard.
PRIOR Analytics UK

http://www.prior-analytics.com

Winners of the LBA Customer Service Award.

 

[JwithaL]

Richard,

Thank you very much for your help.

We have the tried the "select * from conthist where notes like '%PARTNUMBER%'" before. The only problem is for some reason there will be days where you search for a string and it won't find anything, even if you are looking at it on your screen.

Because of that, is the search from CAL any different? Or are there any other ways to search.

Thanks in advance,

Justin

 

[richardy]

Hi Justin,

Its the same on both. I guess thats the difference between SQL and dBase. Do you reindex regularly? That could be why its skipping some records.

Is the partnumber in upper case or mixed? Could be a case sensitivity issue.


Regards,

Richard.
PRIOR Analytics UK

http://www.prior-analytics.com

Winners of the LBA Customer Service Award.

 

[JwithaL]

Richard,

For the reindexing part of it. Does the search only affect those objects that have been reindexed? Chances are if that is the case, that is the problem right there.

And you are right on the differences for SQL and dBase. You really lose a lot of speed and functionality with dBase version.

Thanks for you help,

Justin

 

[richardy]

Hi Justin

Yes that would be an issue then


Regards,

Richard.
PRIOR Analytics UK

http://www.prior-analytics.com

Winners of the LBA Customer Service Award.