Hello Rob,
I have experiencing strange behavior in my Fabrik application.
Let's say I have en element named 'Entity' using databasejoin plugin that rendering from site database. To limit the dropdown list I apply [Data - where]->[Joins where and/or order by statement (SQL)] with a command line: {thistable}.active = 1, so when I select the dropdown it will only show active 'Entity'. It was working just fine, until I do the Advance Search from the front-end List.
When I select Entity EQUALS .... in Advance Search, nothing happen.
But when I remove the statement: {thistable}.active = 1, then when I select Entity EQUALS ... I got the dropdown showing All Entities (both active & non active) and the Advance Search works fine.
Is it normal or something wrong with my setup ?
Regards,
I have experiencing strange behavior in my Fabrik application.
Let's say I have en element named 'Entity' using databasejoin plugin that rendering from site database. To limit the dropdown list I apply [Data - where]->[Joins where and/or order by statement (SQL)] with a command line: {thistable}.active = 1, so when I select the dropdown it will only show active 'Entity'. It was working just fine, until I do the Advance Search from the front-end List.
When I select Entity EQUALS .... in Advance Search, nothing happen.
But when I remove the statement: {thistable}.active = 1, then when I select Entity EQUALS ... I got the dropdown showing All Entities (both active & non active) and the Advance Search works fine.
Is it normal or something wrong with my setup ?
Regards,