Push - Revision history

WikiSysopdi at 17:36, 2 January 2025

2025-01-02T17:36:53Z

← Older revision		Revision as of 17:36, 2 January 2025
Line 51:		Line 51:

	so we only get the latest data		so we only get the latest data

			----

			Note you can also use

			>export

			instead of

			>push

	----		----

WikiSysopdi: removed incorrect documentation

2024-02-14T10:54:35Z

removed incorrect documentation

← Older revision		Revision as of 10:54, 14 February 2024
Line 56:		Line 56:
	JINT - Javascript integration		JINT - Javascript integration

	~~di.push("islandname")~~
	~~di.push("islandname", "u/a/d")~~
	~~di.push("islandname", "u/a/d", "column list")~~
	~~di.push("islandname", "u/a/d", "column list", "description")~~
	di.push("islandname", dataTable)		di.push("islandname", dataTable)
	di.push("islandname", dataTable, "u/a/d")		di.push("islandname", dataTable, "u/a/d")
	di.push("islandname", dataTable, "u/a/d", "column list")		di.push("islandname", dataTable, "u/a/d", "column list")
	di.push("islandname", dataTable, "u/a/d", "column list", "description")		di.push("islandname", dataTable, "u/a/d", "column list", "description")

WikiSysopdi at 09:49, 31 January 2024

2024-01-31T09:49:45Z

← Older revision		Revision as of 09:49, 31 January 2024
Line 51:		Line 51:

	so we only get the latest data		so we only get the latest data

			----

			JINT - Javascript integration

			di.push("islandname")
			di.push("islandname", "u/a/d")
			di.push("islandname", "u/a/d", "column list")
			di.push("islandname", "u/a/d", "column list", "description")
			di.push("islandname", dataTable)
			di.push("islandname", dataTable, "u/a/d")
			di.push("islandname", dataTable, "u/a/d", "column list")
			di.push("islandname", dataTable, "u/a/d", "column list", "description")

WikiSysopdi at 20:00, 17 May 2023

2023-05-17T20:00:45Z

← Older revision		Revision as of 20:00, 17 May 2023
Line 9:		Line 9:

	With update option, we need to provide column list with comma separate with double quotes in the place of description.		With update option, we need to provide column list with comma separate with double quotes in the place of description.


			Example querydb with push that updates based on the idfield


			querydb "SELECT trim(IDCUST)+'_'+DB_NAME() as [idfield],

			trim(IDCUST) as IDCUST,

			trim(NAMECUST) as NAMECUST,AMTBALDUEH, AMTBALDUET,

			DATELASTIV,

			trim(AUDTORG) as AUDTORG,trim(TEXTSNAM) as TEXTSNAM,trim(TEXTSTRE1) as TEXTSTRE1,trim(TEXTSTRE2) as TEXTSTRE2,

			trim(TEXTSTRE3) as TEXTSTRE3,trim(TEXTSTRE4) as TEXTSTRE4,

			trim(NAMECITY) as NAMECITY,trim(CODESTTE) as CODESTTE,trim(CODEPSTL)as CODEPSTL,

			trim(CODECTRY) as CODECTRY,trim(NAMECTAC) as NAMECTAC,

			trim(TEXTPHON1) as TEXTPHON1,trim(TEXTPHON2) as TEXTPHON2,trim(CODETERR)as CODETERR,

			trim(IDACCTSET) as IDACCTSET,AMTCRLIMT as AMTCRLIMT,trim(EMAIL1) as EMAIL1, trim(EMAIL2) as EMAIL2,

			trim(PRICLIST) as PRICLIST,

			<nowiki>''</nowiki> as acstatus, getdate() as acdatadatetime, DB_NAME() AS acdbname,

			<nowiki>'' as islandid, '' as acpassword, ''</nowiki> as acportalaccess

			FROM ARCUS where DATELASTMN> convert(varchar, getdate()-1, 112)"


			push arcustomers u "idfield"


			You can see we filter

			FROM ARCUS where DATELASTMN> convert(varchar, getdate()-1, 112)"

			so we only get the latest data

WikiSysopdi at 11:31, 21 October 2022

2022-10-21T11:31:30Z

← Older revision		Revision as of 11:31, 21 October 2022
Line 1:		Line 1:
	'''Syntax''' : push <ISLANDNAME> [A/D/U] "<COLUMN LIST>" "<DESCRIPTION>" <ENTER>		'''Syntax''' : push <ISLANDNAME> [A/D/U] "<COLUMN LIST>" "<DESCRIPTION>" <ENTER>

	Description : Creates a data island in the current region and adds the data based on the previous run query. For the FILES provider ONLY, please note that the files (which we get from querydb) will be uploaded to the server. We also have one optional parameter 'a' append or 'd' delete or 'u' update, so if user try to store data into existing island then application will ask whether we are going to appened or we need to delete the existing island first. With update option, we need to provide column list with comma separate with double quotes in the place of description.		Description : Creates a data island in the current region and adds the data based on the previous run query.


			For the FILES provider ONLY, please note that the files (which we get from querydb) will be uploaded to the server.

			We also have one optional parameter 'a' append or 'd' delete or 'u' update, so if user try to store data into existing island then application will ask whether we are going to appened or we need to delete the existing island first.

			With update option, we need to provide column list with comma separate with double quotes in the place of description.

WikiSysopdi: Created page with "'''Syntax''' : push [A/D/U] "" "" Description : Creates a data island in the current region and adds the data based on the previous run query. For the FILES provider ONLY, please note that the files (which we get from querydb) will be uploaded to the server. We also have one optional parameter 'a' append or 'd' delete or 'u' update, so if user try to store data into existing island then application will ask whether we are..."

2022-10-21T11:31:01Z

Created page with "'''Syntax''' : push <ISLANDNAME> [A/D/U] "<COLUMN LIST>" "<DESCRIPTION>" <ENTER> Description : Creates a data island in the current region and adds the data based on the previous run query. For the FILES provider ONLY, please note that the files (which we get from querydb) will be uploaded to the server. We also have one optional parameter 'a' append or 'd' delete or 'u' update, so if user try to store data into existing island then application will ask whether we are..."

New page

'''Syntax''' : push <ISLANDNAME> [A/D/U] "<COLUMN LIST>" "<DESCRIPTION>" <ENTER>

Description : Creates a data island in the current region and adds the data based on the previous run query. For the FILES provider ONLY, please note that the files (which we get from querydb) will be uploaded to the server. We also have one optional parameter 'a' append or 'd' delete or 'u' update, so if user try to store data into existing island then application will ask whether we are going to appened or we need to delete the existing island first. With update option, we need to provide column list with comma separate with double quotes in the place of description.