fady005
Posts: 115
|
Posted: 02/15/2007, 6:40 AM |
|
Hello,
I would like to know if it is possible with CCS to make a search grid with 2 fields of two binded tables of a database.
If Yes please tell me how because I'm having some trouble doing it.
Thanks
_________________
Be inventive ! |
|
|
LH_13
Posts: 30
|
Posted: 02/15/2007, 7:41 AM |
|
Possible.
Try to use Query Builder.
Joins and perhaps custom SQL.
_________________
Sorry my english! |
|
|
fady005
Posts: 115
|
Posted: 02/15/2007, 8:52 AM |
|
I already tried it. It allow the selection of fields in only one table.
I also tried to modify the code but it's not working...
_________________
Be inventive ! |
|
|
LH_13
Posts: 30
|
Posted: 02/15/2007, 8:58 AM |
|
Try press add button in Query Builder.
You can add new table. Than create link by fied.
Or change type from Table to SQL and write your custom sql.
_________________
Sorry my english! |
|
|
fady005
Posts: 115
|
Posted: 02/16/2007, 12:51 AM |
|
In Query Builder I can select only one table and then add fields. Where can I add fields ?
For the SQL can you give me the code if my two tables are named table1 and table2 and my two fields field1 and field2.
Thanks
_________________
Be inventive ! |
|
|
LH_13
Posts: 30
|
Posted: 02/16/2007, 1:31 AM |
|
Be intently!
You have add button at the buttons panel.
Here you CAN ADD NEW table.
_________________
Sorry my english! |
|
|
fady005
Posts: 115
|
Posted: 02/16/2007, 1:43 AM |
|
I can't find it...
Can you please put a screen capture ?
Thanks
_________________
Be inventive ! |
|
|
LH_13
Posts: 30
|
Posted: 02/16/2007, 2:24 AM |
|
_________________
Sorry my english! |
|
|
fady005
Posts: 115
|
Posted: 02/16/2007, 4:06 AM |
|
Ah ok...
So if I want my two grid to show the result of the search box I should add to each one a where condition that take the parameter from the URL....
Thanks It's working
_________________
Be inventive ! |
|
|