TeamDesk Knowledge Base & Support

   Home      FAQ      Forum      Idea Exchange      Ask a Question      My Stuff      Help   
OR for Match conditions in relationships
At the moment, where you enter more than one match condition for a relationship these are always connected by AND. Would it be possible to allow the choice of using an AND or an OR between relationships

Philipp Matuschka (MMB)
Date Created
10/5/2010 2:00:13 PM
Date Updated
1/18/2016 5:09:45 AM
New Idea
Promoted By
martin oliverArnold HakobyanLiquid Rapid
beogerardo garciaPhilipp Matuschka (MMB)
Anatoliy ZachynskiyJohn ElcikRyan Van Der Vorste
Matan Barnea
Matan Barnea 5/16/2007 8:34:08 AM
if I have few Match Conditions, they act as AND conditionsand not as OR conditions.
i think it should by customized

gerardo garcia 10/5/2010 2:07:53 PM
Even if we can do OR using formulas, it is time consuming. Would be great to have an easy OR option.
Philipp Matuschka (MMB) 10/6/2010 4:11:03 AM
I would be happy with the formula version for now
gerardo garcia 10/6/2010 2:41:11 PM
Formula versión is available philipp
When configuring your filter you have the following options

 All records
 Only records that meet certain criteria
 Custom formula

Choose custom formula. There you can use OR.

Philipp Matuschka (MMB) 10/7/2010 3:47:59 AM

I suspect we are talking about different things. I am talking about the Match Conditions in a Table to Table relationship. Here the only choice is to selct Column from Table 1, Condition, Column form Table 2. There is no option to write your own formula.
gerardo garcia 10/7/2010 3:52:49 AM
My bad!!
Guess my brain was wishing to avoid having to do formulas in views when I need some ORs there. Thanks for the clarification.
gerardo garcia 10/20/2010 9:57:54 AM
Now I would promote this 10 times if I could.
I went into a situation in which I have a many to many relationship between a table of equipments, and a table of field service bulletins. Field service bulletins may afect equipment family or model. So, in order to be able to show the field service bulletins that afect a certain equipment, i need to compare if field service bulletins exist by model OR by family, and show both.

As of now, I have to build 2 diferent many to many relations from the same tables to be able to show them, which I could have done if I had an OR option on the MATCH type.

Thanks Philipp, hope this can be available soon.
Kirill Bondar  Staff  1/27/2011 3:34:20 PM
Merged with:
114 - Match conditions
Philipp Matuschka (MMB) 1/18/2016 5:09:45 AM
Just want to bring this one back to life. I now have a number of situations where I am having to build awkward workarounds for this. I don't mind the development effort for myself, the problem is that I am having to show the user two tabs, one for the first condition being true and one for the second condition being true. User cannot understand why I am being so difficult.

I notice that for 1:m relationships there is the possibility of using contains as a match condition, but for some reason this is blocked for m:m. If that were enabled then I could built the logic I need with a combination of formula columns and using contains in match conditions
Back to Search Results