List Pre-filter

[stevelis]

Experiencing problem with a list pre-filter following update to F3.5.1 and J3.6.4
Previously the following pre-filter worked for all 4 conditions.
Now the pre-filter only works for the first two conditions showing correct results.
However, when you add either or both of the 3rd or 4th condition, no results are displayed in the front end
The "Fields" are using the raw values
Steve
Adelaide

 

[cheesegrits]

Are you sure you've got the grouping right?

What are you trying to achieve? Your current set up is ...

WHERE filter1 AND (filter2 OR filter 3 OR filter4)

Which list is this? I'll need to take a look at the query it is generating.

-- hugh

 

[stevelis]

Hugh
The list is #49 calendarhi which is a copy of the List #4 Calendar.
Expected results when a steward has logged in (front end), the pre-filter will display any event(s) the logged in steward has been appointed to.
A steward may be appointed as either the chief, 2nd or 3ed steward.
The pre-filtered list is assigned to a menu My Details > My Roster on the front end.
Steve

 

[cheesegrits]

It looks like the last two filters are the same? They both compare against Steward(raw).

 

[stevelis]

Hi Hugh
Correct, and I can't recall if there were originally two steward_raw elements being for steward2 and steward3, when the pre-filter was working
As all three (Chair Steward, Steward2 and Steward3) are dbjoin elements.
Changed the label name on the Steward2 to 2nd Steward which has created the 2nd steward raw value in the field list of the pre-filter.
Given all affected pre-filters a test and all fully working required.

Steve

 

[stevelis]

Hi Hugh
Correct, and I can't recall if there were originally two steward_raw elements being for steward2 and steward3, when the pre-filter was working
As all three (Chair Steward, Steward2 and Steward3) are dbjoin elements.
Changed the label name on the Steward2 to 2nd Steward which has created the 2nd steward raw value in the field list of the pre-filter.
Given all affected pre-filters a test and all fully working required.

Steve