jarbaby
Posts: 3
|
| Posted: 04/25/2008, 8:32 AM |
|
I am trying to build a grid based on a custom SQL query.
I built a SQL statement outside of CC, then pasted it into the visual query builder after selecting SQL.
Now I want to build a search form to drive this grid based on a date.
So .... I figure there are 2 things I need to do:
1. Use the SQL parameter feature to identify the input parameter CREATED
2. Modify the SQL I just pasted to use this parameter.
If I just do number 1. above, the grid will serve up all the records, regardless of date, and I can see from the debug messages that CREATED was not used anywhere in the WHERE clause, even though the debug messages clearly show that the parameter was passed in with a value I expected.
So ... I'm guessing that number 2. above is where I'm stuck.
My question is .... can anyone give me a screenshot of their visual query builder using a custom SQL and a query parameter?
Thanks!!
|
 |
 |
|
