How can a parameter be used in an SQL query's WHERE clause?
For example, to list just employees in the current department in the list view, or on a drop-down selection box in an insert/edit page.
Set a session variable before entering the code? Pass a parm on the URL? Set a Javascript variable?
If yes to any/all of these, then how reference it in the SQL statement? Would session or URL parm be available in SQL source? How would SQL source access a Javascript variable?
Use one of the events? Which one? Before Process?
This has to be a pretty common requirement, right?
Please excuse me if I've overlooked something in the documentation. I've only started using PHPRunner last week.
