Author Topic: Can't search for documents' names in substring and numerical values  (Read 6088 times)

Den

  • Newbie
  • *
  • Posts: 8
    • View Profile
I can't search for my documents in substring or in case when its names contain numerical values. For example, I have a document named "Letters to Father Frost". I can find it typing "letters" in a search string, but if I would type a part of word, for example, "letter" the inquiry will return nothing.
And there's another problem with documents containing numerical values in their names. For example, the document named "1-1/2009" exists. I can't find it neither full name, nor a part of name. Maybe it's not a bug, but seems a serious lack.
« Last Edit: May 07, 2009, 02:05:48 am by Den »

Pet

  • Global Moderator
  • Hero Member
  • *****
  • Posts: 638
  • Always mining for solutions!
    • View Profile
    • The Bet!
For text, it assumes exact match for the word. If you want to use an incomplete word, add an asterisk, as in  "lett*" instead.

For documents containing numerical values in their name, I did some testing using that exact filename "1-1/2009", and search works fine for me if I search for "2009".  I also tested searching for "1/2" which returned nothing as expected, but when I searched for "1/2*" the file appeared in my search results.
Support OpenGoo - Sponsor a Feature! | Follow me on Twitter | OG Support Chat | Did you turn debugging on?

Den

  • Newbie
  • *
  • Posts: 8
    • View Profile
Ok, for text it works. But I think that developers could include this in their sql queries.
As to numerical values it's interesting for me to search for full filename e.g. "1-1/2009" or for first part of filename, e.g. "1-1".  If I search for "1-1/2009" OG shows me all documents which names contain "2009" (1-2/2009, 1-3/2009, etc.). When I searched for "1-1", OG has returned nothing.

Pet

  • Global Moderator
  • Hero Member
  • *****
  • Posts: 638
  • Always mining for solutions!
    • View Profile
    • The Bet!
Yes, there are some issues with how substring searches work in the sql queries.  Even "1-1*" returns nothing.  Perhaps in a future version the search will be made more flexible.

cheers
Support OpenGoo - Sponsor a Feature! | Follow me on Twitter | OG Support Chat | Did you turn debugging on?

alvarotm01

  • Administrator
  • Sr. Member
  • *****
  • Posts: 335
    • View Profile
    • Email
Hi,

This issue will be fixed in a future version, today i can't say in what version is going to be fixed, because at this moment we have other things with more priority.


Den

  • Newbie
  • *
  • Posts: 8
    • View Profile
alvarotm01, whether search in contacts in a future version will be realised?