Web App: Difference between revisions

Latest revision as of 11:35, 8 July 2024

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"

@@ Line 1: / Line 1: @@
 The web application is available at
+https://app.dataislands.com/
-https://data.crmtogether.com/
+----
+Advanced SQL help
-Register here or log on with your credentials
+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"