Sudheer
|
| Posted: 10/12/2004, 6:21 AM |
|
Hi,
I have a table storing parent-child relationship and has the following structure.
Table: (id, name, parent_id)
I need to display this information in GRID in the format of
Name , Parent name
Also there is a search form (on name field) to filter the list .
I could able to get the GRID showing the parent child relationship, but I could not able to link this with the search form.
Can anyone guide me how to do this in CCS.
Thanks and Regards,
-Sudheer
sudheer.yakkala@gmail.com
|
|
|
 |
sudheer
Posts: 11
|
| Posted: 10/12/2004, 7:10 AM |
|
I figured the way to do it.
Earlier I took the Data Source for the GRID as 'SQL' instead of default 'TABLE'.
This has to be done as:
#1) take the data source as 'TABLE'
#2) While selecting the table name, you need to frame the query for LEFT JOIN on the same table ( I did it using visual Query Builder)
-Sudheer
sudheer.yakkala@gmail.com
|
 |
|
|
