Hi
Can we get the data from View instead from physical table using dhtmlxGridConnector?
I have done this successfully in MySQL with the Coldfusion connector to populate a co/coro as follows:
<cfset filter1 = createObject(“component”,request.dhtmlxConnectors[“options”]).init(request.dhtmlxConnectors[“datasource”],request.dhtmlxConnectors[“db_type”])>
<cfset filter1.render_table(“qryfullcodes”,“tourcodedate_id”,“tourcodedate_id(value),fullcode(label)”)>
<cfset grid.set_options(“tourcodedate_id”,filter1)>
Where qryfullcode refers to my view.
Although I haven’t yet tried it. presumably one can use a view to populate an entire grid as opposed to just one column:
i) … and then update the view itself assuming that the view doesn’t feature (in MySQL 5 anyway): GROUP BY, HAVING, JOINS, SUBQUERIES, UNIONS, Aggregate Functions, DISTINCT, Calculated columns.
OR
ii) To display data only and not update it.