Results 1 to 10 of 10

Thread: Searching Cases by Subject (AND,OR)

  1. #1
    chrislynch8's Avatar
    chrislynch8 is offline Sugar Community Member
    Join Date
    Oct 2007
    Location
    Cork, Ireland
    Posts
    747

    Default Searching Cases by Subject (AND,OR)

    Hi,

    Is it possible to for example search for all case where the subject contains Paul and Internet...

    Rgds
    Chris

  2. #2
    roblaus's Avatar
    roblaus is offline Sugar Community Member
    Join Date
    Dec 2006
    Location
    Vienna / Austria
    Posts
    2,850

    Default Re: Searching Cases by Subject (AND,OR)

    Test it: I just tried it with %paul% %internet% and it worked. Very interesting, didn't expect it.
    Actually I used the global search...
    __________________________
    Robert Laussegger
    http://www.iscongroup.net

    Bei Fragen: support@iscon.at
    Die deutschen Sprachdateien für SugarCRM und das deutsche Handbuch gibt es hier: http://goo.gl/kPsAz
    Ab sofort auch mit 6.4.2

  3. #3
    mikesolomon is offline Sugar Community Member
    Join Date
    Feb 2008
    Location
    UK
    Posts
    1,467

    Default Re: Searching Cases by Subject (AND,OR)

    Quote Originally Posted by roblaus View Post
    Test it: I just tried it with %paul% %internet% and it worked. Very interesting, didn't expect it.
    Actually I used the global search...
    does that work if the words are the other way round?

    I would expect it to match 'paul is on the internet' but not 'the person with the internet is paul'
    Mike Solomon
    Development Manager
    Ivy Ltd
    www.ivy.ltd.uk]www.ivy.ltd.uk

    php version 5.2.6
    MySql 5.1.59

  4. #4
    roblaus's Avatar
    roblaus is offline Sugar Community Member
    Join Date
    Dec 2006
    Location
    Vienna / Austria
    Posts
    2,850

    Default Re: Searching Cases by Subject (AND,OR)

    you are right. Can enhanced search do it? Never tried it.
    __________________________
    Robert Laussegger
    http://www.iscongroup.net

    Bei Fragen: support@iscon.at
    Die deutschen Sprachdateien für SugarCRM und das deutsche Handbuch gibt es hier: http://goo.gl/kPsAz
    Ab sofort auch mit 6.4.2

  5. #5
    mikesolomon is offline Sugar Community Member
    Join Date
    Feb 2008
    Location
    UK
    Posts
    1,467

    Default Re: Searching Cases by Subject (AND,OR)

    Quote Originally Posted by roblaus View Post
    you are right. Can enhanced search do it? Never tried it.
    I don't think the free version can

    The full version may be able to
    Mike Solomon
    Development Manager
    Ivy Ltd
    www.ivy.ltd.uk]www.ivy.ltd.uk

    php version 5.2.6
    MySql 5.1.59

  6. #6
    kenshiro is offline Sugar Community Member
    Join Date
    Mar 2007
    Location
    Macerata - ITALY
    Posts
    421

    Default Re: Searching Cases by Subject (AND,OR)

    Quote Originally Posted by mikesolomon View Post
    I don't think the free version can

    The full version may be able to
    Hi,
    Yes, it is supported on the DEMO, too.

    If you are running the Mysql DB you can select the RLIKE operator and enter the following search string

    Paul|Internet

    (Put the pipe | between "Paul" and "Internet")

  7. #7
    mikesolomon is offline Sugar Community Member
    Join Date
    Feb 2008
    Location
    UK
    Posts
    1,467

    Default Re: Searching Cases by Subject (AND,OR)

    Quote Originally Posted by kenshiro View Post
    Hi,
    Yes, it is supported on the DEMO, too.

    If you are running the Mysql DB you can select the RLIKE operator and enter the following search string

    Paul|Internet

    (Put the pipe | between "Paul" and "Internet")
    Ah - I forgot about rlike - great module
    Mike Solomon
    Development Manager
    Ivy Ltd
    www.ivy.ltd.uk]www.ivy.ltd.uk

    php version 5.2.6
    MySql 5.1.59

  8. #8
    chrislynch8's Avatar
    chrislynch8 is offline Sugar Community Member
    Join Date
    Oct 2007
    Location
    Cork, Ireland
    Posts
    747

    Default Re: Searching Cases by Subject (AND,OR)

    Hi,

    This RLIKE is interesting - I am on 5.0.0i

    This is not supported in this version, am I correct. I try to do SSAP|Carry forward and I get no results from my search?

    Rgds
    Linkedin Profile:Chris Lynch

    FDC IT Solutions
    FDC House
    Wellington Road
    Cork
    Ireland

  9. #9
    kenshiro is offline Sugar Community Member
    Join Date
    Mar 2007
    Location
    Macerata - ITALY
    Posts
    421

    Default Re: Searching Cases by Subject (AND,OR)

    Quote Originally Posted by chrislynch8 View Post
    Hi,

    This RLIKE is interesting - I am on 5.0.0i

    This is not supported in this version, am I correct. I try to do SSAP|Carry forward and I get no results from my search?

    Rgds
    Yes it is, RLIKE has been supporting since the very first release of ES.

  10. #10
    chrislynch8's Avatar
    chrislynch8 is offline Sugar Community Member
    Join Date
    Oct 2007
    Location
    Cork, Ireland
    Posts
    747

    Default Re: Searching Cases by Subject (AND,OR)

    How and where do I use it. If I use it in the advanced search of cases, Accounts, Client, it finds nothing.
    Linkedin Profile:Chris Lynch

    FDC IT Solutions
    FDC House
    Wellington Road
    Cork
    Ireland

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Cases view created cases
    By Wilkerson in forum General Discussion
    Replies: 0
    Last Post: 2008-11-12, 06:16 PM
  2. change case subject
    By shawncooper in forum Help
    Replies: 0
    Last Post: 2008-09-29, 12:14 PM
  3. Emails, not saving subject.
    By Tavares in forum Developer Help
    Replies: 1
    Last Post: 2007-07-16, 03:00 PM
  4. Searching cases
    By wjohnson in forum Help
    Replies: 0
    Last Post: 2006-07-11, 05:37 PM
  5. Problem with subject EVERYWHERE!
    By athan00 in forum Help
    Replies: 3
    Last Post: 2006-03-13, 08:42 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •