Dashboard widget configuration - Revision history

Kpe: /* Dynamic selectors */

2024-05-17T14:25:03Z

Dynamic selectors

← Older revision		Revision as of 16:25, 17 May 2024
Line 180:		Line 180:

	=== Dynamic selectors ===		=== Dynamic selectors ===
	A special case of the SQL query is the selector		A special case of the SQL query is the selectors. A selector will allow you to select a value or an ID for use as a parameter in another SQL query or a List view.

			A selector will have a name defined by setting its column name in the query

			SELECT DataID, CUSTOMER AS SelectedCustomer FROM data_customer WHERE StatusID = 123

			In this case the value of DataID is set in a user specific variable named SelectedCustomer. The proper notation is in brackets [].

			This can now be used in list and SQL definitions

			SELECT BILLINGDATE, AMOUNT FROM data_invoice WHERE CUSTOMER = [SelectedCustomer]

	=== Other widgets ===		=== Other widgets ===

Kpe: /* Lists */

2024-05-17T14:19:47Z

Lists

← Older revision		Revision as of 16:19, 17 May 2024
Line 178:		Line 178:

	(just change "%2C" to ",")		(just change "%2C" to ",")

			=== Dynamic selectors ===
			A special case of the SQL query is the selector

	=== Other widgets ===		=== Other widgets ===

Tvi: /* SQL Query */ Spelling

2024-04-02T07:21:29Z

SQL Query: Spelling

← Older revision		Revision as of 09:21, 2 April 2024
Line 45:		Line 45:

	=== SQL Query ===		=== SQL Query ===
	An SQL Query may extract almost ~~anyting~~ from the database.		An SQL Query may extract almost anything from the database.

	This process ~~ignoreres~~ the security restrictions in the system, so you will have to implement them yourself (see special ~~keyworkds~~ below).		This process ignores the security restrictions in the system, so you will have to implement them yourself (see special keywords below).

	This widget supports different rendering modes, for a deep dive on the diagrams, [[Dashboard diagram widget configuration\|click here]].		This widget supports different rendering modes, for a deep dive on the diagrams, [[Dashboard diagram widget configuration\|click here]].

Tvi: Added info about url button and link to diagram rendering

2024-04-02T06:36:46Z

Added info about url button and link to diagram rendering

← Older revision		Revision as of 08:36, 2 April 2024
Line 48:		Line 48:

	This process ignoreres the security restrictions in the system, so you will have to implement them yourself (see special keyworkds below).		This process ignoreres the security restrictions in the system, so you will have to implement them yourself (see special keyworkds below).

			This widget supports different rendering modes, for a deep dive on the diagrams, [[Dashboard diagram widget configuration\|click here]].

	==== Sample: Limited status distribution ====		==== Sample: Limited status distribution ====
Line 71:		Line 73:
	To setup a list view, simple copy/paste the URL of a view.		To setup a list view, simple copy/paste the URL of a view.

	Optimally you should strip anything but the parameters from the URL		Optimally you should strip anything but the parameters from the URL.

	?SagID=252&command=list&QUERY_FIELD_1=OPFLGNING& ...		?SagID=252&command=list&QUERY_FIELD_1=OPFLGNING& ...
Line 160:		Line 162:
	\|Only rows with values equal to one of the given (comma separated list)		\|Only rows with values equal to one of the given (comma separated list)
	\|}		\|}
			If you are signed in as an admin on a server with a version newer than 7956, you will have access to the "url button".

			This button redirects you to the full url, that generates the current filtering, that you have on your list.

			This might be an easier way to generate the correct url, when creating dashboard-list-widgets.

	==== Special case: List of values i search parameters ====		==== Special case: List of values in search parameters ====
	Currently lists of search parameters are encoded		Currently lists of search parameters are encoded

Line 171:		Line 178:

	(just change "%2C" to ",")		(just change "%2C" to ",")

	=== Other widgets ===		=== Other widgets ===

Tvi at 11:16, 20 December 2023

2023-12-20T11:16:32Z

← Older revision		Revision as of 13:16, 20 December 2023
Line 35:		Line 35:
	The lookup follows this logic:		The lookup follows this logic:

	* 1 = "col-4 col-md-2 col-xl-1"		* 1 = <code>col-4 col-md-2 col-xl-1</code>
	* 2 = "col-6 col-md-4 col-xl-2"		* 2 = <code>col-6 col-md-4 col-xl-2</code>
	* 3 = "col-6 col-lg-4 col-xl-3"		* 3 = <code>col-6 col-lg-4 col-xl-3</code>
	* 4 = "col-12 col-md-6 col-xl-4"		* 4 = <code>col-12 col-md-6 col-xl-4</code>
	* 5 and 6 = "col-12 col-lg-8 col-xl-6"		* 5 and 6 = <code>col-12 col-lg-8 col-xl-6</code>
	* 7, 8, and 9 = "col-12 col-xl-8"		* 7, 8, and 9 = <code>col-12 col-xl-8</code>
	* 10, 11, and 12 = "col-12"		* 10, 11, and 12 = <code>col-12</code>
	* Above 12 = "col"		* Above 12 = <code>col</code>

	=== SQL Query ===		=== SQL Query ===
Line 171:		Line 171:

	(just change "%2C" to ",")		(just change "%2C" to ",")



	=== Other widgets ===		=== Other widgets ===

Tvi: #THISWIDGET# added

2023-12-20T11:14:25Z

#THISWIDGET# added

← Older revision		Revision as of 13:14, 20 December 2023
Line 1:		Line 1:

	== Configuration help ==		== Configuration help ==

			=== Styling ===
			All widgets have a field called "Custom CSS". This allows addition of styling, when that stylesheet is shown.

			As of version 8359 it is possible to use <code>#THISWIDGET#</code> to target that specific widget.

			<code>#THISWIDGET#</code> will automatically be replaced by the unique html-id of that widget, eg. <code>#Widget69</code>, thus allowing css that can be copied to another widget without the need to know the ID.

	=== Buttons ===		=== Buttons ===

Nun: /* Distribution */

2023-08-02T13:41:14Z

Distribution

← Older revision		Revision as of 15:41, 2 August 2023
Line 173:		Line 173:

	==== Distribution ====		==== Distribution ====
	This creates one of many diagrams to show records of an entity.		This creates one of many diagrams to show records of an entity. Bar, circle, and table diagrams work, but the others don't.

	It should at the very least have the SagID of the entity and a QUERY_GROUPBY parameter to know what should be shown. If it does not have this, it will always show the status of the records.		It should at the very least have the SagID of the entity and a QUERY_GROUPBY parameter to know what should be shown. If it does not have this, it will always show the status of the records.

Nun: Added Distribution widget

2023-08-02T13:30:35Z

Added Distribution widget

← Older revision		Revision as of 15:30, 2 August 2023
Line 172:		Line 172:
	This widget displays raw HTML ouput from any PageContentCodeunit.		This widget displays raw HTML ouput from any PageContentCodeunit.

			==== Distribution ====
			This creates one of many diagrams to show records of an entity.

			It should at the very least have the SagID of the entity and a QUERY_GROUPBY parameter to know what should be shown. If it does not have this, it will always show the status of the records.

			Content should look something like this:<syntaxhighlight lang="text">
			?SagID=3&QUERY_GROUPBY=TOPIC
			</syntaxhighlight>

	== Pro tips ==		== Pro tips ==

Tvi: new bootstrap 4 sizing

2022-11-03T11:48:00Z

new bootstrap 4 sizing

← Older revision		Revision as of 13:48, 3 November 2022
Line 28:		Line 28:
	The lookup follows this logic:		The lookup follows this logic:

	* 1 = "col-4 col-md-1"		* 1 = "col-4 col-md-2 col-xl-1"
	* 2 = "col-4 col-md-2"		* 2 = "col-6 col-md-4 col-xl-2"
	* 3 = "col-6 col-md-4 col-lg-3"		* 3 = "col-6 col-lg-4 col-xl-3"
	* 4 = "col-6 col-md-6 col-lg-4"		* 4 = "col-12 col-md-6 col-xl-4"
	* 5 and 6 = "col-12 col-md-6"		* 5 and 6 = "col-12 col-lg-8 col-xl-6"
	* 7, 8, and 9 = "col-12 col-md-8"		* 7, 8, and 9 = "col-12 col-xl-8"
	* 10, 11, and 12 = "col-12"		* 10, 11, and 12 = "col-12"
	* Above 12 = ""		* Above 12 = "col"

	=== SQL Query ===		=== SQL Query ===

Tvi: Added section about sizing

2022-11-03T11:45:00Z

Added section about sizing

← Older revision		Revision as of 13:45, 3 November 2022
Line 15:		Line 15:

	Optimally buttons are places in the '''Toolbar''' zone on the page, where they are rendered as normal buttons. If placed in other zones they are rendered as large squares.		Optimally buttons are places in the '''Toolbar''' zone on the page, where they are rendered as normal buttons. If placed in other zones they are rendered as large squares.

			=== Sizing ===

			==== Length ====
			Setting the length of a widget limits how many rows are shown. This setting only applies to lists.

			==== Size ====
			Setting the height of a widget forces it to be that number, times 100, pixels tall. This setting does not affect lists.

			Setting the width of a widget applies a set of [https://getbootstrap.com/docs/4.1/layout/grid/ bootstrap column-classes], setting the width in a responsive manner.

			The lookup follows this logic:

			* 1 = "col-4 col-md-1"
			* 2 = "col-4 col-md-2"
			* 3 = "col-6 col-md-4 col-lg-3"
			* 4 = "col-6 col-md-6 col-lg-4"
			* 5 and 6 = "col-12 col-md-6"
			* 7, 8, and 9 = "col-12 col-md-8"
			* 10, 11, and 12 = "col-12"
			* Above 12 = ""

	=== SQL Query ===		=== SQL Query ===