FieldSubselect - Revision history

Tvi: 8 revisions imported

2021-12-10T10:52:37Z

8 revisions imported

← Older revision

Revision as of 12:52, 10 December 2021

old>Tvi: /* Configuration example 1 */

2021-10-28T14:20:33Z

Configuration example 1

← Older revision		Revision as of 16:20, 28 October 2021
Line 64:		Line 64:

	...		...
	WHERE :PARENT = data_testparent.DataID		WHERE data_testchild.PARENT = data_testparent.DataID

	=== Configuration example 2 ===		=== Configuration example 2 ===

old>Admin: /* Configuration */

2014-02-20T13:57:59Z

Configuration

← Older revision		Revision as of 15:57, 20 February 2014
Line 30:		Line 30:

	Options:		Options:
	* ~~When~~ to display the value:		* Restrictions (when to display the value):
	** Always: Single, list and subitem mode		** Always: Single, list and subitem mode
	** Items: Single mode only (hidden in list mode)		** Items: Single mode only (hidden in list mode)
Line 39:		Line 39:
	* Values are not cached or stored		* Values are not cached or stored
	* Consider activating INDEX for fields used in WHERE or JOIN clauses		* Consider activating INDEX for fields used in WHERE or JOIN clauses



	=== Configuration example 1 ===		=== Configuration example 1 ===

old>Admin: /* Configuration */

2014-02-20T13:57:24Z

Configuration

← Older revision		Revision as of 15:57, 20 February 2014
Line 30:		Line 30:

	Options:		Options:
	* ~~''As shown above''~~		* When to display the value:
			** Always: Single, list and subitem mode
			** Items: Single mode only (hidden in list mode)
			** Lists: List mode only (hidden in single mode)
			** Subitem: Lists displayed in single items (child records)

			Notes for usage:
			* Values are not cached or stored
			* Consider activating INDEX for fields used in WHERE or JOIN clauses

	=== Configuration example 1 ===		=== Configuration example 1 ===

old>Admin: /* Configuration example 2 */

2014-02-20T13:47:52Z

Configuration example 2

← Older revision		Revision as of 15:47, 20 February 2014
Line 58:		Line 58:

	=== Configuration example 2 ===		=== Configuration example 2 ===

			==== Solution setup ====

	Solution "Example" (system name: "example")		Solution "Example" (system name: "example")

old>Admin: /* Configuration example 1 */

2014-02-20T13:47:17Z

Configuration example 1

← Older revision		Revision as of 15:47, 20 February 2014
Line 34:		Line 34:

	=== Configuration example 1 ===		=== Configuration example 1 ===

			==== Solution setup ====

	Solution "Child items" (system name: "testchild")		Solution "Child items" (system name: "testchild")
Line 54:		Line 56:
	...		...
	WHERE :PARENT = data_testparent.DataID		WHERE :PARENT = data_testparent.DataID


	=== Configuration example 2 ===		=== Configuration example 2 ===

old>Admin: /* Configuration */

2014-02-20T13:46:41Z

Configuration

← Older revision		Revision as of 15:46, 20 February 2014
Line 27:		Line 27:

	Required:		Required:
	* ~~''As shown above''~~		* SELECT query that returns a single record with a single value in the recordset

	Options:		Options:

old>Admin: /* Configuration */

2014-02-20T13:45:35Z

Configuration

← Older revision		Revision as of 15:45, 20 February 2014
Line 32:		Line 32:
	* ''As shown above''		* ''As shown above''


			=== Configuration example 1 ===

			Solution "Child items" (system name: "testchild")
			* Relation field "owner" (system name: "PARENT").

			Solution: "Parent items" (system name: "testparent")
			* Date field "starting date" (system name: "DATO")

			==== Business requirement ====
			Display the starting date (system name: "DATO") from the related parent table, linked by the local field owner (system name: "PARENT").

			==== Subselect SQL statement ====

			SELECT DATO
			FROM data_testparent
			WHERE :PARENT = data_testparent.DataID

			this is the shorthand version for

			...
			WHERE :PARENT = data_testparent.DataID


			=== Configuration example 2 ===

			Solution "Example" (system name: "example")
			* Status log activated

			==== Business requirement ====
			Display the number of state changes for a data item

			==== Subselect SQL statement ====

			SELECT CONCAT( COUNT(*), ' transitions')
			FROM data_example_statuslog
			WHERE data_example_statuslog.DataID = :DataID

			this is the shorthand version for

			...
			WHERE data_example_statuslog.DataID = data_example.DataID

	== Developer info ==		== Developer info ==

old>Ln.jeel: Created page with '= SQL: Subselect = Enquiry in own or foreign database Properties * Type: Lookup * Groupable: No * Show in lists: Yes * Searchable: Yes == User …'

2013-03-13T13:35:44Z

Created page with '= SQL: Subselect = Enquiry in own or foreign database Properties * Type: Lookup * Groupable: No * Show in lists: Yes * Searchable: Yes == User …'

New page

= SQL: Subselect =
Enquiry in own or foreign database

Properties
* Type: [[Field type reference#Lookup|Lookup]]
* Groupable: No
* Show in lists: Yes
* Searchable: Yes

== User interface ==
Field in show mode

[[File:FieldSubselect_show.png]]

Field in edit mode

[[File:FieldSubselect_edit.png]]

User interface as displayed in picture

== Configuration ==
This field requires configuration before deployment.

[[File:FieldSubselect_BE.png]]

Required:
* ''As shown above''

Options:
* ''As shown above''

== Developer info ==
* FeltTypeID: 510
* SQL datatype: Special
* Class name: FieldSubselect
* Field is allowed in inline tables