[SOLVED] Can I have the same Prefilter WHERE on 2 different Lists?

[reidwalley]

I have the following Prefilter on 2 different Lists:

WHERE payplans_plan.plan id IN 1,2,3,4,5,6 (TYPE: text)

In the first List, the IN condition perfectly displays just the 1,2,3,4,5,6 Membership Levels
View here: http://stagestate.califaep.org/report-members-active

In the second List, the IN condition wrongly displays ALL Membership Levels, which I don't want.
View here: http://stagestate.califaep.org/report-actual-new

Can I not have the same WHERE on 2 Lists?

 

[cheesegrits]

The second link you gave is a 404, "Category not found".

Shouldn't be a problem. Have you checked the access level on the second one, make sure it's actually being applied?

-- hugh

 

[reidwalley]

So sorry, had menu item turned off so client would see it. Page back up: http://stagestate.califaep.org/report-actual-new

 

[cheesegrits]

OK, you had "Overridden by menu/modules" set to Yes in the pre-filter settings on the list, and in your menu item you had a junk pre-filter defined (no element selected, no value, so Fabrik wasn't applying it ... but it was still overriding the ones on the list).

I've removed that junk pre-filter on the menu item, so the list now filters as expected.

Typically, you'd set "Overridden by menu/modules" to No, in which case we apply any menu item pre-filters in addition to the ones on the list.

-- hugh

 

[reidwalley]

OK, you had "Overridden by menu/modules" set to Yes in the pre-filter settings on the list, and in your menu item you had a junk pre-filter defined (no element selected, no value, so Fabrik wasn't applying it ... but it was still overriding the ones on the list).

I've removed that junk pre-filter on the menu item, so the list now filters as expected.

Typically, you'd set "Overridden by menu/modules" to No, in which case we apply any menu item pre-filters in addition to the ones on the list.

-- hugh

Awesome! Thanks so much for the help!