pruiz
Posts: 29
|
| Posted: 03/30/2005, 3:24 AM |
|
Mysql
PHP
Main Table: Project
Foreign Key Table: Employees
I have built a couple of Master/detail pages, but now I need to build a new grid by the type of employee. For instance, I click on the project - it takes me to those employees in that project. Within the employee types column, there are temporary emps and full-time. Is there a way to build a grid that displays only those that are temporary employees? I know very well how to write the SQL query, but do not know how to implement it in CodeCharge.
|
 |
 |
Nicole
Posts: 586
|
| Posted: 03/30/2005, 4:04 AM |
|
Hi,
On the first step you can create standard Grid form using Builder without WHERE clause at all.
In order to display temporary employees only, add new WHERE parameter, set Condition Type to Expression and type in Where condition, e.g.
Emp_type = ‘part_time’
Or
Emp_type = 2
using real field name and values.
To be able to filter grid on selected project, add another WHERE parameter with Condition Type set to Parameter and configure the settings.
The following links could be useful
http://docs.codecharge.com/studio/html/index.html?http:...Source.html?toc
http://docs.codecharge.com/studio/html/index.html?http:...hParam.html?toc
_________________
Regards,
Nicole |
|
|
|
|
