Web App: Difference between revisions
From Data Islands
WikiSysopdi (talk | contribs) No edit summary |
WikiSysopdi (talk | contribs) No edit summary |
||
| Line 1: | Line 1: | ||
The web application is available at | The web application is available at | ||
https://appdi.crmtogether.com | https://appdi.crmtogether.com | ||
---- | ---- | ||
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"
