Pull: Difference between revisions
From Data Islands
WikiSysopdi (talk | contribs) (Created page with "Syntax pull island destinationname "<whereclause>"") |
WikiSysopdi (talk | contribs) (LIKE operator Replaced with ILIKE) |
||
| 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. | |||
Revision as of 12:16, 20 September 2022
Syntax
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.
