Pull - Revision history

WikiSysopdi at 17:35, 2 January 2025

2025-01-02T17:35:59Z

2023-03-30T13:25:46Z

← Older revision		Revision as of 13:25, 30 March 2023
Line 29:		Line 29:

	"{\"Query\": \"select * from customers where \\\"CompanyName\\\" ILIKE '%Ana%'\"}"		"{\"Query\": \"select * from customers where \\\"CompanyName\\\" ILIKE '%Ana%'\"}"

			----


			Example query using a date filter

			pull prospects prospects "acdatadatetime>now()::date - 2"

2023-01-31T14:29:15Z

← Older revision		Revision as of 14:29, 31 January 2023
Line 1:		Line 1:
	'''Syntax''' :		'''Syntax''' :

	For All: pull <ISLANDNAME> <SERVER TABLENAME> "[WHERE CLAUSE]" <ENTER>		For All: pull <ISLANDNAME> <SERVER TABLENAME> [WHERE CLAUSE] <ENTER>

	For Files: pull <ISLANDNAME> "<FOLDER PATH>" <ENTER>		For Files: pull <ISLANDNAME> "<FOLDER PATH>" <ENTER>
Line 7:		Line 7:
	Eg:		Eg:

	For All: eg. pull sqldata sqldata.csv "[Country] = 'Germany'"		For All: eg. pull sqldata sqldata.csv "Country" = 'Germany'

	Description : User can pull the available island's data and then store the data to connected database server.		Description : User can pull the available island's data and then store the data to connected database server.

2023-01-18T10:15:22Z

← Older revision		Revision as of 10:15, 18 January 2023
Line 10:		Line 10:

	Description : User can pull the available island's data and then store the data to connected database server.		Description : User can pull the available island's data and then store the data to connected database server.

			Column names are in SQUARE BRACKETS

2023-01-18T10:14:53Z

← Older revision		Revision as of 10:14, 18 January 2023
Line 7:		Line 7:
	Eg:		Eg:

	For All: eg. pull sqldata sqldata.csv "~~where "~~Country" = 'Germany'"		For All: eg. pull sqldata sqldata.csv "[Country] = 'Germany'"

	Description : User can pull the available island's data and then store the data to connected database server.		Description : User can pull the available island's data and then store the data to connected database server.

2023-01-13T10:46:38Z

← Older revision		Revision as of 10:46, 13 January 2023
Line 1:		Line 1:
	'''Syntax''' :		'''Syntax''' :

	For All: pull <ISLANDNAME> <SERVER ~~ISLANDNAME~~> "[WHERE CLAUSE]" <ENTER>		For All: pull <ISLANDNAME> <SERVER TABLENAME> "[WHERE CLAUSE]" <ENTER>

	For Files: pull <ISLANDNAME> "<FOLDER PATH>" <ENTER>		For Files: pull <ISLANDNAME> "<FOLDER PATH>" <ENTER>

2022-10-21T11:32:21Z

← Older revision		Revision as of 11:32, 21 October 2022
Line 9:		Line 9:
	For All: eg. pull sqldata sqldata.csv "where "Country" = 'Germany'"		For All: eg. pull sqldata sqldata.csv "where "Country" = 'Germany'"

	Description : User can pull the available island's data and then store the data to connected database server. For Files provider, we need to give folder path in the place of Server islandname, where all the files will get downloaded from server. We also have one optional parameter as where clause if we wants to narrow down our result.		Description : User can pull the available island's data and then store the data to connected database server.


			For Files provider, we need to give folder path in the place of Server islandname, where all the files will get downloaded from server.


			We also have one optional parameter as where clause if we wants to narrow down our result.

	----		----

2022-10-21T11:32:07Z

← Older revision		Revision as of 11:32, 21 October 2022
Line 1:		Line 1:
	Syntax		'''Syntax''' :

	pull ~~island destinationname~~ "<~~whereclause~~>"		For All: pull <ISLANDNAME> <SERVER ISLANDNAME> "[WHERE CLAUSE]" <ENTER>

			For Files: pull <ISLANDNAME> "<FOLDER PATH>" <ENTER>

			Eg:

			For All: eg. pull sqldata sqldata.csv "where "Country" = 'Germany'"

			Description : User can pull the available island's data and then store the data to connected database server. For Files provider, we need to give folder path in the place of Server islandname, where all the files will get downloaded from server. We also have one optional parameter as where clause if we wants to narrow down our result.

			----

2022-09-21T06:21:55Z

LIKE operator description.

← Older revision		Revision as of 06:21, 21 September 2022
Line 6:		Line 6:
	Please note:		Please note:

	If we use LIKE operator ~~in where clause~~ then we ~~are replacing~~ to ILIKE as PostgreSQL understand ILIKE to make where condition as case in-sensitive, so for example, if we give the payload as:		If we wants to use query select statement with LIKE operator as case insenstive then we need to use ILIKE instead of LIKE operator as PostgreSQL understand ILIKE to make where condition as case in-sensitive, so for example, we need to give the payload as:


	"{\"Query\": \"select * from customers where \\\"CompanyName\\\" ~~like~~ '%Ana%'\"}"		"{\"Query\": \"select * from customers where \\\"CompanyName\\\" ILIKE '%Ana%'\"}"

	~~then internally (in backend side) it will replaced as below and then process:~~

	~~"{\"Query\": \"select * from customers where \\\"CompanyName\\\" ilike '%Ana%'\"}"~~


	~~In case if we already given ilike then it will not replaced.~~

2022-09-20T12:16:03Z

LIKE operator Replaced with ILIKE

← Older revision		Revision as of 12:16, 20 September 2022
Line 2:		Line 2:

	pull island destinationname "<whereclause>"		pull island destinationname "<whereclause>"


			Please note:

			If we use LIKE operator in where clause then we are replacing to ILIKE as PostgreSQL understand ILIKE to make where condition as case in-sensitive, so for example, if we give the payload as:


			"{\"Query\": \"select * from customers where \\\"CompanyName\\\" like '%Ana%'\"}"

			then internally (in backend side) it will replaced as below and then process:

			"{\"Query\": \"select * from customers where \\\"CompanyName\\\" ilike '%Ana%'\"}"


			In case if we already given ilike then it will not replaced.