Codeunit/Formevents - Revision history

Nun: /* FILTER event hooks */

2025-06-25T14:55:13Z

FILTER event hooks

← Older revision		Revision as of 16:55, 25 June 2025
Line 65:		Line 65:
	Filters will help you build customized permission schemes. They are called for '''both''' LIST and ITEM commands.		Filters will help you build customized permission schemes. They are called for '''both''' LIST and ITEM commands.

	dataFilterActive() {}		@Override
	dataFilterHandler(StringBuilder sql) {}		protected boolean dataFilterActive() {
			return true;
			}
			@Override
			protected void dataFilterHandler(StringBuilder sql) {
			sql.append(" AND something");
			}

	In some cases you only want the filter to trigger for '''either''' LIST or ITEM commands		In some cases you only want the filter to trigger for '''either''' LIST or ITEM commands

2025-06-18T12:52:29Z

Examples

← Older revision		Revision as of 14:52, 18 June 2025
Line 80:		Line 80:

	boolean dataFilterActive() { return ! s.isAdministor(); }		boolean dataFilterActive() { return ! s.isAdministor(); }

	The xxxFilterHandler modifies the SQL used to fetch data		The xxxFilterHandler modifies the SQL used to fetch data

2025-06-18T12:52:20Z

FILTER event hooks

← Older revision		Revision as of 14:52, 18 June 2025
Line 66:		Line 66:

	dataFilterActive() {}		dataFilterActive() {}
	dataFilterHandler(StringBuilder sql) { ~~return sql;~~ }		dataFilterHandler(StringBuilder sql) {}

	In some cases you only want the filter to trigger for '''either''' LIST or ITEM commands		In some cases you only want the filter to trigger for '''either''' LIST or ITEM commands

	itemFilterActive() {}		itemFilterActive() {}
	itemFilterHandler(StringBuilder sql) { ~~return sql;~~ }		itemFilterHandler(StringBuilder sql) {}

	listFilterActive() {}		listFilterActive() {}
	listFilterHandler(StringBuilder sql) { return sql; }		listFilterHandler(StringBuilder sql) {}

			=== Examples ===
			The xxxFilterActive tells if the filter is active

			boolean dataFilterActive() { return ! s.isAdministor(); }

			The xxxFilterHandler modifies the SQL used to fetch data

			void dataFilterHandler(StringBuilder sql) { sql.append(" AND CATEGORY NOT IN (123,456,789)"); }

	== Event firing details ==		== Event firing details ==

2025-06-18T12:44:18Z

FILTER event hooks

← Older revision		Revision as of 14:44, 18 June 2025
Line 72:		Line 72:
	itemFilterActive() {}		itemFilterActive() {}
	itemFilterHandler(StringBuilder sql) { return sql; }		itemFilterHandler(StringBuilder sql) { return sql; }

	listFilterActive() {}		listFilterActive() {}
	listFilterHandler(StringBuilder sql) { return sql; }		listFilterHandler(StringBuilder sql) { return sql; }

2025-06-18T12:44:05Z

FILTER event hooks

← Older revision		Revision as of 14:44, 18 June 2025
Line 63:		Line 63:

	== FILTER event hooks ==		== FILTER event hooks ==
	Filters will help you build customized permission schemes		Filters will help you build customized permission schemes. They are called for '''both''' LIST and ITEM commands.

	dataFilterActive() {}		dataFilterActive() {}
	dataFilterHandler(StringBuilder sql) { return sql; }		dataFilterHandler(StringBuilder sql) { return sql; }

	In some cases you only want the filter to trigger for either LIST or ITEM commands		In some cases you only want the filter to trigger for '''either''' LIST or ITEM commands

	itemFilterActive() {}		itemFilterActive() {}

2025-06-18T12:43:17Z

LIST execution order

← Older revision		Revision as of 14:43, 18 June 2025
Line 20:		Line 20:
	# Gather form data from database		# Gather form data from database
	#* '''dataFilterActive > dataFilterHandler'''		#* '''dataFilterActive > dataFilterHandler'''
	#* '''~~itemFilterActive~~ > ~~itemFilterHandler~~'''		#* '''listFilterActive > listFilterHandler'''
	# '''beforeRenderList'''		# '''beforeRenderList'''
	# Return list to user		# Return list to user

2025-06-18T12:42:43Z

LIST execution order

← Older revision		Revision as of 14:42, 18 June 2025
Line 19:		Line 19:
	# '''beforeSelectList'''		# '''beforeSelectList'''
	# Gather form data from database		# Gather form data from database
			#* '''dataFilterActive > dataFilterHandler'''
			#* '''itemFilterActive > itemFilterHandler'''
	# '''beforeRenderList'''		# '''beforeRenderList'''
	# Return list to user		# Return list to user

2025-06-18T12:42:10Z

ITEM execution order: viewing data

← Older revision		Revision as of 14:42, 18 June 2025
Line 40:		Line 40:
	# '''beforeSelectItem'''		# '''beforeSelectItem'''
	# Gather form data from database		# Gather form data from database
	#* dataFilterActive -> ~~dataFilter~~		#* '''dataFilterActive > dataFilterHandler'''
	#* itemFilterActive -> ~~dataFilter~~		#* '''itemFilterActive > itemFilterHandler'''
	# '''beforeRenderItem'''		# '''beforeRenderItem'''
	# Return form to user		# Return form to user

2025-06-18T12:41:18Z

ITEM execution order: viewing data

← Older revision		Revision as of 14:41, 18 June 2025
Line 40:		Line 40:
	# '''beforeSelectItem'''		# '''beforeSelectItem'''
	# Gather form data from database		# Gather form data from database
			#* dataFilterActive -> dataFilter
			#* itemFilterActive -> dataFilter
	# '''beforeRenderItem'''		# '''beforeRenderItem'''
	# Return form to user		# Return form to user


	==== ITEM execution order: posting data ====		==== ITEM execution order: posting data ====

2024-11-26T06:18:48Z

FILTER event hooks

← Older revision		Revision as of 08:18, 26 November 2024
Line 60:		Line 60:

	== FILTER event hooks ==		== FILTER event hooks ==
			Filters will help you build customized permission schemes

	* dataFilterActive		dataFilterActive() {}
	* dataFilterHandler(StringBuilder sql)		dataFilterHandler(StringBuilder sql) { return sql; }

	In some cases you only want the filter to trigger for either LIST or ITEM commands		In some cases you only want the filter to trigger for either LIST or ITEM commands

	* itemFilterActive		itemFilterActive() {}
	* itemFilterHandler(StringBuilder sql)		itemFilterHandler(StringBuilder sql) { return sql; }
	* listFilterActive		listFilterActive() {}
	* listFilterHandler(StringBuilder sql)		listFilterHandler(StringBuilder sql) { return sql; }

	== Event firing details ==		== Event firing details ==