0.00.0100005050NY50000YN1000100-2019/01/29 16:02:42.790-2019/01/29 16:02:42.790H4sIAAAAAAAAAAMAAAAAAAAAAAA=NPRD_ORION_AZURE192.168.100.4MSSQLNATIVENativePRD_ORION1433MERELEC_PDIEncrypted 2bec8eb8127c28081a71cad348cc2fe82EXTRA_OPTION_MSSQLNATIVE.instanceazureme.wmercadosme.localFORCE_IDENTIFIERS_TO_LOWERCASENFORCE_IDENTIFIERS_TO_UPPERCASENIS_CLUSTEREDNMSSQLUseIntegratedSecurityfalseMSSQL_DOUBLE_DECIMAL_SEPARATORNPORT_NUMBER1433PRESERVE_RESERVED_WORD_CASEYQUOTE_ALL_FIELDSNSUPPORTS_BOOLEAN_DATA_TYPEYSUPPORTS_TIMESTAMP_DATA_TYPEYUSE_POOLINGNJSON InputModified Java Script ValueYModified Java Script ValueSelect valuesYJSON Input 2JSON InputYSelect valuesFilter rowsYREST ClientJSON Input 2YGet rows from resultREST ClientYFilter rowsTable outputYFilter rowsFilterRowsY1noneTable outputNNtime_hmi>=fecha_mañanaNANDtime_hmi<fecha_pasado992128YGet rows from resultRowsFromResultY1nonepaisString-1-1ciudadString-1-1urlString-1-1208128YJSON InputJsonInputY1noneNNNNYNYYYNNtime$.data[*].timeNumber-1-1noneNprecipIntensity$.data[*].precipIntensityNumber-1-1noneNprecipProbability$.data[*].precipProbabilityNumber-1-1noneNprecipType$.data[*].precipTypeString-1-1noneNtemperature$.data[*].temperatureNumber-1-1noneNapparentTemperature$.data[*].apparentTemperatureNumber-1-1noneNhumidity$.data[*].humidityNumber-1-1noneNpressure$.data[*].pressureNumber-1-1noneNwindSpeed$.data[*].windSpeedNumber-1-1noneNwindGust$.data[*].windGustNumber-1-1noneNwindBearing$.data[*].windBearingNumber-1-1noneNcloudCover$.data[*].cloudCoverNumber-1-1noneNsummary$.data[*].summaryString-1-1noneNicon$.data[*].iconString-1-1noneN0YNhourly608128YJSON Input 2JsonInputY1noneNNNNNNYYYC:\Users\BI4\Documents\Development\PDI - Kettle\weather-darksky\san-salvador-forecast.jsonNNlatitude$.latitudeNumber-1-1noneNlongitude$.longitudeNumber-1-1noneNhourly$.hourlyString-1-1noneN0YNresult_json496128YModified Java Script ValueScriptValueModY1noneY90Script 1//Script here
var time_hmi = new Date(time*1000);
var fecha = new Date();
var fecha_mañana = truncDate(dateAdd(fecha, "d", 1),3);
var fecha_pasado = truncDate(dateAdd(fecha, "d", 2),3);
//var ciudad = "San Salvador";
//var pais = "El Salvador";-1dateAdd_Sample// Add's the given number to the given date Value.
//
// Usage:
// dateAdd(var,var,var);
// 1: Date - The Variable with the Date.
// 2: String - The Type which represents the value
// to add.
// y - Years
// m - Months
// d - Days
// w - Weeks
// wd - Workingdays
// hh - Hours
// mi - Minutes
// ss - Seconds
// 3: Numeric - The Value to add.
//
// 2006-11-15
//
var d1 = new Date();
Alert(dateAdd(d1, "y", 1));
Alert(dateAdd(d1, "m", 4));
Alert(dateAdd(d1, "d", 5));
Alert(dateAdd(d1, "wd", 5));-1truncDate_Sample
//
// Usage:
// truncDate(var1, var2);
//
// 1: a date - the date-time to be truncated
// 2: the requested precision:
// - 5 : truncate MONTHS (set to 1)
// - 4 : truncate DAYS (set to 1)
// - 3 : truncate HOURS (set to 0)
// - 2 : truncate MINUTES (set to 0)
// - 1 : truncate SECONDS (set to 0)
// - 0 : truncate MILLISECONDS (set to 0)
//
// 2008-02-29
//
var dateTime = new Date();
var date0 = truncDate(dateTime, 0); // gives back today at yyyy/MM/dd HH:mm:ss.000
var date1 = truncDate(dateTime, 1); // gives back today at yyyy/MM/dd HH:mm:00.000
var date2 = truncDate(dateTime, 2); // gives back today at yyyy/MM/dd HH:00:00.000
var date3 = truncDate(dateTime, 3); // gives back today at yyyy/MM/dd 00:00:00.000
var date4 = truncDate(dateTime, 4); // gives back today at yyyy/MM/01 00:00:00.000
var date5 = truncDate(dateTime, 5); // gives back today at yyyy/01/01 00:00:00.000
time_hmitime_hmiDate-1-1Nfecha_mañanafecha_mañanaDate-1-1Nfecha_pasadofecha_pasadoDate-1-1N736128YREST ClientRestY1noneJSONGETYNurlEncrypted NEncrypted result_json368128YSelect valuesSelectValuesY1noneNtime880128YTable outputTableOutputY1nonePRD_ORION_AZURECLIMA