Using mix() With Foreign Keys


#1

I seem to be getting an error upon using the mix function here despite following this example: docs.dhtmlx.com/connector__php_ … ningtables

I simply want the user to select and view the foreign key by value rather than by ID

[code]$conn = new TreeGridMultitableConnector($res,“Oracle”);
$conn->enable_log(“dp_log.txt”,true);
$conn->setMaxLevel(1);

$level = $conn->get_level();
switch($level) {
	case 0:
		$conn->render_table("CAP_TEAM","TEAM_ID","TEAM_NAME","","");
		break;
	case 1:
		$details = new DataConnector($res,"Oracle");
		$details->configure("CAP_TECHNOLOGY","TECHNOLOGY_ID","TECHNOLOGY_NAME");
		$conn->mix("CAP_TECHNOLOGY", $details, array("TECHNOLOGY_ID" => "TASK_TECHNOLOGY"));
		$conn->render_table("CAP_TASK","TASK_ID","TASK_NAME,TASK_TECHNOLOGY,TASK_SWT","","TASK_TEAM");
		break;
}[/code]

#2

Using “mix” will result in a separate SQL query for each item in the master dataset. It is a rather expensive way to link a data.
Instead of it, you can use render_sql for the “case 1” branch, where you can select data from a master table and join the details table by the foreign key in question.