I need only show: WHERE estmarh.SchID = users.SchID

saleh · Post by **saleh** » Wed Mar 15, 2017 9:23 pm

But unfortunately it shows all

// Recordset Selecting event
function Recordset_Selecting(&$filter) {
// Enter your code here
if (CurrentUserLevel() ==3 && CurrentUserLevel() <> -1) {
ew_AddFilter($filter, "SELECT DISTINCT estmarh.SchID AS SchID,
users.SchID AS SchID1,
estmarh.*
FROM estmarh
JOIN users ON estmarh.SchID = users.SchID
WHERE estmarh.SchID = users.SchID
");

}}

Please help write the right code

mobhar · Post by **mobhar** » Wed Mar 15, 2017 10:16 pm

Please post your Database View schema that you used for the current table.