AtkExpressionAttribute - Revision history

Yotmv at 19:39, 11 September 2008

2008-09-11T19:39:55Z

← Older revision		Revision as of 19:39, 11 September 2008
Line 12:		Line 12:

	Any SQL expression can be used and you can reference the node's table using the [table] block.		Any SQL expression can be used and you can reference the node's table using the [table] block.


			Similarly you can use join's (example below is for MySQL LEFT JOIN) to get information through relations.
			Example:

			<syntaxhighlight lang="php">
			$this->add(new atkExpressionAttribute("widget_count", "SELECT COUNT(*)
			FROM widget wi
			LEFT JOIN widgetBatch wb ON wi.batch_ID=wb.batch_ID
			WHERE wb.name_ID = [table].name_ID"));
			</syntaxhighlight>

	Note: http://www.achievo.org/forum/viewtopic.php?t=2409&highlight=atkexpressionattribute		Note: http://www.achievo.org/forum/viewtopic.php?t=2409&highlight=atkexpressionattribute

bahtiar at 17:25, 19 December 2007

2007-12-19T17:25:21Z

← Older revision		Revision as of 17:25, 19 December 2007
Line 1:		Line 1:
			{{attribute}}

	example:		example:

bahtiar at 21:35, 17 December 2007

2007-12-17T21:35:42Z

← Older revision		Revision as of 21:35, 17 December 2007
Line 2:		Line 2:

	<syntaxhighlight lang="php">		<syntaxhighlight lang="php">
	$this->add(new atkExpressionAttribute("employee_count", "SELECT COUNT(*) FROM employee_department ed WHERE ed.department_id = [table].id"));		$this->add(new atkExpressionAttribute("employee_count", "SELECT COUNT(*)
			FROM employee_department ed
			WHERE ed.department_id = [table].id"));
	</syntaxhighlight>		</syntaxhighlight>

bahtiar at 21:34, 17 December 2007

2007-12-17T21:34:36Z

← Older revision		Revision as of 21:34, 17 December 2007
Line 1:		Line 1:
	example:		example:

			<syntaxhighlight lang="php">
	$this->add(new atkExpressionAttribute("employee_count", "SELECT COUNT(*) FROM employee_department ed WHERE ed.department_id = [table].id"));		$this->add(new atkExpressionAttribute("employee_count", "SELECT COUNT(*) FROM employee_department ed WHERE ed.department_id = [table].id"));
			</syntaxhighlight>

	This gives you a nice overview of the number of employees in each department in the admin overview of the department node.		This gives you a nice overview of the number of employees in each department in the admin overview of the department node.

Sams90 at 23:13, 12 December 2007

2007-12-12T23:13:48Z

New page

example:

$this->add(new atkExpressionAttribute("employee_count", "SELECT COUNT(*) FROM employee_department ed WHERE ed.department_id = [table].id"));

This gives you a nice overview of the number of employees in each department in the admin overview of the department node.

Any SQL expression can be used and you can reference the node's table using the [table] block.

Note: http://www.achievo.org/forum/viewtopic.php?t=2409&highlight=atkexpressionattribute