Logical OR in searches

Moderator: crythias

Post Reply
retro2707
Znuny advanced
Posts: 131
Joined: 16 Apr 2014, 17:06
Znuny Version: 6.0.12

Logical OR in searches

Post by retro2707 »

Hi and thanks for reading,

As the title says really.

I want to be able to search and return anything that I am either responsible for or I have locked. I notice by default the search does an AND. How can I change this please?

So:

Responsible = Brendan Martin
OR
LockStatus = Lock

Thanks a lot,

Brendan
Last edited by retro2707 on 18 Feb 2015, 19:05, edited 2 times in total.
Setup:
OTRS 6.0.12
Hosted on CentOS 7.4/ MySQL - MariaDB (5.5.60)
crythias
Moderator
Posts: 10169
Joined: 04 May 2010, 18:38
Znuny Version: 5.0.x
Location: SouthWest Florida, USA
Contact:

Re: Logical OR in searches

Post by crythias »

locked is independent of responsible. Your options are: responsible OR Owner. Locked is yes/no, but not *who*.
OTRS 6.0.x (private/testing/public) on Linux with MySQL database.
Please edit your signature to include your OTRS version, Operating System, and database type.
Click Subscribe Topic below to get notifications. Consider amending your topic title to include [SOLVED] if it is so.
Need help? Before you ask
RStraub
Znuny guru
Posts: 2210
Joined: 13 Mar 2014, 09:16
Znuny Version: 6.0.14
Real Name: Rolf Straub

Re: Logical OR in searches

Post by RStraub »

I think from OTRS 4 onwards you can invert your search criteria. So an upgrade might fix that issue for you.
Currently using: OTRS 6.0.14 -- MariaDB -- Ubuntu 16 LTS
retro2707
Znuny advanced
Posts: 131
Joined: 16 Apr 2014, 17:06
Znuny Version: 6.0.12

Re: [SOLVED] - Logical OR in searches

Post by retro2707 »

Cheers guys, will look to upgrade and see what is available there.
Setup:
OTRS 6.0.12
Hosted on CentOS 7.4/ MySQL - MariaDB (5.5.60)
retro2707
Znuny advanced
Posts: 131
Joined: 16 Apr 2014, 17:06
Znuny Version: 6.0.12

Re: Logical OR in searches

Post by retro2707 »

Hi Chaps,

I have upgraded but cant seem to see this option to invert searches to give me more of an "OR" search rather than a "AND" search. Could anyone assist please?

Brendan
Setup:
OTRS 6.0.12
Hosted on CentOS 7.4/ MySQL - MariaDB (5.5.60)
gawkla
Znuny newbie
Posts: 69
Joined: 15 Jan 2015, 16:48
Znuny Version: 6.0.6

Re: Logical OR in searches

Post by gawkla »

Hi, I know that this is very old ticket. But did you resolve this question? I am in front of exactly the same problem now...
root
Administrator
Posts: 3934
Joined: 18 Dec 2007, 12:23
Znuny Version: Znuny and Znuny LTS
Real Name: Roy Kaldung
Company: Znuny
Contact:

Re: Logical OR in searches

Post by root »

Hi,

The search in the UI combines search tearms always with AND.

- Roy
Znuny and Znuny LTS running on CentOS / RHEL / Debian / SLES / MySQL / PostgreSQL / Oracle / OpenLDAP / Active Directory / SSO

Use a test system - always.

Do you need professional services? Check out https://www.znuny.com/

Do you want to contribute or want to know where it goes ?
gawkla
Znuny newbie
Posts: 69
Joined: 15 Jan 2015, 16:48
Znuny Version: 6.0.6

Re: Logical OR in searches

Post by gawkla »

thanks for answer. Maybe there is other possibilty to create more complicated search patterns?
Post Reply