Say my database table has a USERNAME column. When displayin

Discontinued products Uncategorized discussions
#1


Say my database table
has a USERNAME column. When displaying in xgrid, I would like to display the
NAME of the user, which is located in a different table. Can I do a JOIN
operation (say, in MYSQL) and pass the results to your software and
successfully display the NAME? (so the question is� will your software handle
column aliases) If so, how will AJAX database
writes to the original table occur?


Do
you think it would be easy or difficult to modify thee code to support JOIN
operations for data display, while still only editing the contents of one main
table.<o:p></o:p>

#2


It is can already be done (without changes in core)
for dhtmlxGrid 1.0 component. The “get” and “update” server
side handlers can be initialized by different XML, so it is not a problem to
create a XML config with JOIN for “get”, and one table XML for
“update” handler.


 


The join can be achieved in next way (only for get
handler!):


<?xml version="1.0"?>





   




        gr_id


        c0


        c1


        c2


        c3


        c4


        c5


        c6


        c7


     



  




  
!nativeeditor_status