JavaScript functions v1.0 - Revision history

Nun: /* Get and set values */

2025-06-25T14:50:07Z

Get and set values

← Older revision		Revision as of 16:50, 25 June 2025
Line 38:		Line 38:
	<syntaxhighlight lang="javascript">		<syntaxhighlight lang="javascript">
	let recordId = getDecimal("SELECTRECORD");		let recordId = getDecimal("SELECTRECORD");
			</syntaxhighlight>

			For explicitly getting a datetime use
			* '''getFieldTime(fieldName)'''

			Example

			<syntaxhighlight lang="javascript">
			const time = new Date(getFieldTime('DEADLINE'));
	</syntaxhighlight>		</syntaxhighlight>

2025-06-11T13:58:55Z

Server code

← Older revision		Revision as of 15:58, 11 June 2025
Line 219:		Line 219:

	==== Server code ====		==== Server code ====
	In the configuration 'NamedQueryLookup.FindPhoneFromEmail' the following SQL is stored		In the configuration '''NamedQueryLookup.FindPhoneFromEmail''' the following SQL is stored

	SELECT COMPANYPHONE FROM data_company WHERE COMPANYEMAIL = ?		SELECT COMPANYPHONE FROM data_company WHERE COMPANYEMAIL = ?

2025-06-11T13:58:36Z

Client code

← Older revision		Revision as of 15:58, 11 June 2025
Line 215:		Line 215:
	var email = getValue("EMAIL");		var email = getValue("EMAIL");
	setValue( "PHONE",		setValue( "PHONE",
	lookupNamedQuery("FindPhoneFromEmail",email)		'''lookupNamedQuery("FindPhoneFromEmail",email)'''
	)		)

	==== Server code ====		==== Server code ====

2025-06-11T13:58:09Z

Named queries

@@ Line 197: / Line 197: @@
 *'''lookupNamedQuery(query,value)'''
-Example code (client)
+The query executed in the backend, must be stored under the configuration named: "NamedQueryLookup." + query
 The value will be inserted into the ? parameter an escaped properly
@@ Line 213: / Line 206: @@
 * Entity configuration (if SagID on caller page is present in URL)
 * System configuration
 ==Inspect command and users==

2025-06-11T13:52:33Z

Named queries

← Older revision		Revision as of 15:52, 11 June 2025
Line 197:		Line 197:
	*'''lookupNamedQuery(query,value)'''		*'''lookupNamedQuery(query,value)'''

	~~JS example~~ code		Example code (client)

	var email = getValue("EMAIL");		var email = getValue("EMAIL");

2025-06-11T13:52:01Z

Named queries

← Older revision		Revision as of 15:52, 11 June 2025
Line 196:		Line 196:

	*'''lookupNamedQuery(query,value)'''		*'''lookupNamedQuery(query,value)'''

			JS example code

			var email = getValue("EMAIL");
			setValue( "PHONE",
			lookupNamedQuery("FindPhoneFromEmail",email)
			)

	The query executed in the backend, must be stored under the configuration named: "NamedQueryLookup" + query		The query executed in the backend, must be stored under the configuration named: "NamedQueryLookup" + query

2025-06-11T13:49:51Z

Named queries

← Older revision		Revision as of 15:49, 11 June 2025
Line 204:		Line 204:

	If call is made from an entity the Query will be stored in either		If call is made from an entity the Query will be stored in either
	* Entity configuration (if SagID on caller page is present)		* Entity configuration (if SagID on caller page is present in URL)
	* System configuration		* System configuration

2025-06-11T13:49:20Z

Named queries

← Older revision		Revision as of 15:49, 11 June 2025
Line 204:		Line 204:

	If call is made from an entity the Query will be stored in either		If call is made from an entity the Query will be stored in either
	* Entity configuration		* Entity configuration (if SagID on caller page is present)
	* System configuration		* System configuration

2025-06-11T13:47:14Z

Named queries

← Older revision		Revision as of 15:47, 11 June 2025
Line 197:		Line 197:
	*'''lookupNamedQuery(query,value)'''		*'''lookupNamedQuery(query,value)'''

	The query must be stored under the ~~name~~: "NamedQueryLookup" + query		The query executed in the backend, must be stored under the configuration named: "NamedQueryLookup" + query

	The value will be inserted into the ? parameter an escaped properly		The value will be inserted into the ? parameter an escaped properly

2025-02-25T11:45:00Z

Value lookups

@@ Line 191: / Line 191: @@
 #E´xtract the DataID form the field ''FieldNameTrigger''
 # Same as above
 ==Inspect command and users==