I have a client who wants a list of a particular member type (REG) who reside in Canada or in Washington State.
This is really easy to do with SQL: SELECT Full_Name, ID, State_Province, Country, Member_Type FROM Name WHERE STATE_PROVINCE = 'WA' OR COUNTRY = 'Canada'
I tried using IQA in the following ways:
- Create a query where I use the CsContact BO and Filter Member Type = "Regular" AND State Province = "Washington" OR Member Type = "Regular" AND Country = "Canada" Depending on the order, I either get all Washington or All Canada, but never both. If I try Member Type = "Regular" and State Province = "Washington" or Country = "Canada" I get the same results, depending on the order
- I tried creating two queries - one where Member Type = "Regular" and Country = "Canada" and one where Member Type = "Regular" and State Province = "Washington" then used left outer joins to the CsContact BO for each of them, but got multiple lines for each result and only ID numbers, no other fields
- I created a query to just show Member Type = "Regular" and then used it as my source for a query where Country = "Canada" or State Province = "Washington" and was able to get only Canada and Washington but for every member type.
The only solution I could find was to use State Province and select all the Canadian provinces as well as Washington. This works for now, but in the future they will be asking me for this type of thing again and it may not be possible to make the filtering selections from one field. Did I do something wrong with my joins or my filters?
