Web App: Difference between revisions
From Data Islands
WikiSysopdi (talk | contribs) No edit summary |
WikiSysopdi (talk | contribs) No edit summary |
||
| (2 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
The web application is available at | The web application is available at | ||
https:// | https://appdi.crmtogether.com | ||
---- | ---- | ||
| Line 24: | Line 24: | ||
B. Islands = Tables | B. Islands = Tables | ||
An Island is a Table in Postgres | |||
If we run the SQL | |||
select * from apVendorsX where "VendorName" ilike '%ma%' | |||
where apVendorsX is not a valid Island you will see | |||
"Query Failed: island "apvendorsx" does not exist 15" | |||
Latest revision as of 09:20, 31 July 2025
The web application is available at
Advanced SQL help
The backend of Data Islands is Postgres SQL servers.
A. Column Names
Column Names are case-sensitive and should be enclosed in double Quotes.
If not you may see the error text
"Query Failed: column "vendorname" does not exist 31"
Example of working SQL
select * from apvendors where "VendorName" ilike '%ma%'
B. Islands = Tables
An Island is a Table in Postgres
If we run the SQL
select * from apVendorsX where "VendorName" ilike '%ma%'
where apVendorsX is not a valid Island you will see
"Query Failed: island "apvendorsx" does not exist 15"
