Missing global WHERE's in cascade panes

[side-martin]

I think, that if we put global WHERE at this point, it's start being more obvious

Starts from line 355 at SearchPaneOption.php

$query = $db ->query('select') ->distinct(true) ->table($table) ->left_join($leftJoin) ->where($this->_where);

[AllanJard]

Hi! Could you elaborate on the problem you are having please?

[side-martin]

Hi! Could you elaborate on the problem you are having please?

Hello, Allan!

Example:

a) Imagine we have some Editor instance with multiple fields,
b) then we filter it by ->where(...) method (ex. dates, permissions, etc...)
c) Then for several fields we apply ->searchPaneOptions(...)

As result we get in searchPanes total amount of records for every fields in table/database, which matched to step C and ignore filters from step B

[AllanJard]

I'm with you - thank you. At the moment you need to add a call to SearchPaneOptions->where() matching your global condition. Part of the reason for this is that the global condition might not be applicable to the condition for the options for the pane (e.g. joined columns). Unfortunately it isn't as trivial as simply having the SearchPaneOptions apply the same global condition.