XERO files - Revision history

WikiSysopdi at 12:25, 14 September 2023

2023-09-14T12:25:25Z

← Older revision		Revision as of 12:25, 14 September 2023
Line 7:		Line 7:
	Example 2 - using jscript to build the where clause		Example 2 - using jscript to build the where clause

	jscript "var today = new Date(); var myDate = new Date(); myDate.setDate(myDate.getDate() - 10); var somestring = '(UpdatedDateUTC >= DateTime(' + myDate.getFullYear() + ', ' + (myDate.getMonth() + 1) + ',' + myDate.getDate() + ') AND UpdatedDateUTC <= DateTime(' + today.getFullYear() + ',' + (today.getMonth() + 1) + ', ' + today.getDate() + ')) or UpdatedDateUTC = null'; return somestring;"		jscript "var today = new Date(); var myDate = new Date(); myDate.setDate(myDate.getDate() - 3); var somestring = 'Type==\'ACCREC\' and (UpdatedDateUTC >= DateTime(' + myDate.getFullYear() + ', ' + (myDate.getMonth() + 1) + ',' + myDate.getDate() + ') AND UpdatedDateUTC <= DateTime(' + today.getFullYear() + ',' + (today.getMonth() + 1) + ', ' + today.getDate() + ')) or UpdatedDateUTC = null'; return somestring;"

	~~querydb invoices jscriptoutput FILES~~		Note: we filter on Type=ACCREC also here

			>querydb invoices jscriptoutput FILES

	So next we need to push/export these files up into a data island.		So next we need to push/export these files up into a data island.

WikiSysopdi at 12:19, 14 September 2023

2023-09-14T12:19:26Z

← Older revision		Revision as of 12:19, 14 September 2023
Line 18:		Line 18:

	Now we switch to a "FILES" server (or add a files server)		Now we switch to a "FILES" server (or add a files server)

			>addserver files "c:\files\"



	Then we pull/import the data island		Then we pull/import the data island

	>pull tmpxerofiles "tmpxerofiles"		>pull tmpxerofiles "tmpxerofiles"

			With this structure the folder "c:\files\tmpxerofiles" will be created (you may need to run the data islands console as an administrator for this to work)

			If you just call

			>pull tmpxerofiles

			the server default location will be used

WikiSysopdi at 11:34, 13 September 2023

2023-09-13T11:34:27Z

← Older revision		Revision as of 11:34, 13 September 2023
Line 15:		Line 15:

	>push tmpxerofiles		>push tmpxerofiles


			Now we switch to a "FILES" server (or add a files server)


			Then we pull/import the data island

			>pull tmpxerofiles "tmpxerofiles"

WikiSysopdi at 11:28, 13 September 2023

2023-09-13T11:28:23Z

← Older revision		Revision as of 11:28, 13 September 2023
Line 10:		Line 10:

	querydb invoices jscriptoutput FILES		querydb invoices jscriptoutput FILES


			So next we need to push/export these files up into a data island.

			>push tmpxerofiles

WikiSysopdi at 11:23, 13 September 2023

2023-09-13T11:23:21Z

← Older revision		Revision as of 11:23, 13 September 2023
Line 9:		Line 9:
	jscript "var today = new Date(); var myDate = new Date(); myDate.setDate(myDate.getDate() - 10); var somestring = '(UpdatedDateUTC >= DateTime(' + myDate.getFullYear() + ', ' + (myDate.getMonth() + 1) + ',' + myDate.getDate() + ') AND UpdatedDateUTC <= DateTime(' + today.getFullYear() + ',' + (today.getMonth() + 1) + ', ' + today.getDate() + ')) or UpdatedDateUTC = null'; return somestring;"		jscript "var today = new Date(); var myDate = new Date(); myDate.setDate(myDate.getDate() - 10); var somestring = '(UpdatedDateUTC >= DateTime(' + myDate.getFullYear() + ', ' + (myDate.getMonth() + 1) + ',' + myDate.getDate() + ') AND UpdatedDateUTC <= DateTime(' + today.getFullYear() + ',' + (today.getMonth() + 1) + ', ' + today.getDate() + ')) or UpdatedDateUTC = null'; return somestring;"

	querydb invoices jscriptoutput		querydb invoices jscriptoutput FILES

WikiSysopdi at 11:22, 13 September 2023

2023-09-13T11:22:00Z

← Older revision		Revision as of 11:22, 13 September 2023
Line 4:		Line 4:

	>querydb invoices UpdatedDateUTC>= DateTime(2022, 01, 01) AND UpdatedDateUTC<= DateTime(2022, 01, 31) FILES		>querydb invoices UpdatedDateUTC>= DateTime(2022, 01, 01) AND UpdatedDateUTC<= DateTime(2022, 01, 31) FILES

			Example 2 - using jscript to build the where clause

			jscript "var today = new Date(); var myDate = new Date(); myDate.setDate(myDate.getDate() - 10); var somestring = '(UpdatedDateUTC >= DateTime(' + myDate.getFullYear() + ', ' + (myDate.getMonth() + 1) + ',' + myDate.getDate() + ') AND UpdatedDateUTC <= DateTime(' + today.getFullYear() + ',' + (today.getMonth() + 1) + ', ' + today.getDate() + ')) or UpdatedDateUTC = null'; return somestring;"

			querydb invoices jscriptoutput

WikiSysopdi at 11:12, 1 February 2023

2023-02-01T11:12:28Z

← Older revision		Revision as of 11:12, 1 February 2023
Line 3:		Line 3:
	Example		Example

	>querydb invoices ~~"UpdateDateUTC~~>= DateTime(2022, 01, 01) AND ~~UpdateDateUTC~~<= DateTime(2022, 01, 31)" FILES		>querydb invoices UpdatedDateUTC>= DateTime(2022, 01, 01) AND UpdatedDateUTC<= DateTime(2022, 01, 31) FILES

WikiSysopdi at 13:31, 19 January 2023

2023-01-19T13:31:26Z

← Older revision		Revision as of 13:31, 19 January 2023
Line 3:		Line 3:
	Example		Example

	>querydb invoices "~~Date~~ >= DateTime(2022, 01, 01) AND ~~Date~~ <= DateTime(2022, 01, 31)" FILES		>querydb invoices "UpdateDateUTC>= DateTime(2022, 01, 01) AND UpdateDateUTC<= DateTime(2022, 01, 31)" FILES

WikiSysopdi: Created page with "Experimental feature that will get the invoice PDF files Example >querydb invoices "Date >= DateTime(2022, 01, 01) AND Date <= DateTime(2022, 01, 31)" FILES"

2023-01-19T11:36:52Z

Created page with "Experimental feature that will get the invoice PDF files Example >querydb invoices "Date >= DateTime(2022, 01, 01) AND Date <= DateTime(2022, 01, 31)" FILES"

New page

Experimental feature that will get the invoice PDF files

Example

>querydb invoices "Date >= DateTime(2022, 01, 01) AND Date <= DateTime(2022, 01, 31)" FILES