Common Problems & Things to Consider
Mapper Connector use single quote ' instead double quotes " Calculation, Math and Expressions Calculate in mapper then put them in variable to be used later on Consider fragmentation using () general function expression Compare always use variables SQL Syntax Sql syntax prepare it in variables (not in mapper). Bug everything after dynamic field will be taken out !!! Select from xxx where id = '' and 'bbb', everything after dynamic will be eaten Into postgresSome readersWhitelist Easyflow IP addresses for database access
To allow Easyflow.io to connect to your databases, you'll need to either make your database publicly accessible or you can white list ALL of the following static IP addresses for access: 52.88.196.176 35.164.12.120Some readersDate & Time Code format List
Format Code List The table below shows all the format codes that you can use. Sun, Mon, ... %a Abbreviated weekday name. Sunday, Monday, ... %A Full weekday name. 0, 1, ..., 6 %w Weekday as a decimal number. 01, 02, ..., 31 %d Day of the month as a zero-padded decimal. 1, 2, ..., 30 %-d Day of the month as a decimal number. Jan, Feb, ..., Dec %b Abbreviated month name. January, February, ... %B Full month name. 01, 02, ..., 12Few readersList of Date Timezones
List of time zones by country – sorted by number of current time zones in the world. Lists of time zones Africa/Abidjan Africa/Accra Africa/AddisAbaba Africa/Algiers Africa/Asmara Africa/Asmera Africa/Bamako Africa/Bangui Africa/Banjul Africa/Bissau Africa/Blantyre Africa/Brazzaville Africa/Bujumbura Africa/Cairo Africa/Casablanca Africa/Ceuta Africa/Conakry Africa/Dakar Africa/DaresSalaam Africa/Djibouti Africa/Douala Africa/ElAaiun Africa/FFew readers