Skip to Content
0
Jul 19, 2016 at 08:05 AM

TRUE and/or FALSE in a query - need advice

355 Views

Hi everyone.

I feel that there is potentially a straightforward answer to this question but I'm having trouble retrieving the results I'm looking for out of a query. Basically, I want to bring back a list which has a True value for a field.. but it also needs to be False for another string in the same field.

For example, lets just use the fields 'Customer' & 'Field 1' for the sake of this example.

For 'Customer', I want to bring back a certain string in 'Field 1' but they can't have a certain other string in 'Field 1' otherwise I don't want that customer to be brought back in the results. The issue I'm currently having is that the query will bring back & only display what I set in 'Field 1' but if I try and set a 'Not in list' for a different string in 'Field 1' it might still exist for the customer in the database regardless, it just won't be displayed in the report.

I've tried messing around with combined queries and nested filters but haven't quite figured it out. Could someone put me on the right lines? Apologies if I've made it sound confusing! I'm on WEBI 4.1.

Many thanks,

Nick