...
Code Block |
---|
//select the city from the specified region return sql("TestSQL", "select city from cities c, district d, region r where c.iddistrict=d.id and d.idregion=r.id and r.region='Bucharest'"); |
Status Age
Code Block |
---|
string field_name = "status"; string[] field_history = fieldHistory(key, field_name); number n = arraySize(field_history); date startDate; if (n > 0) { startDate = arrayGetElement(field_history, n - 2); return "Current issue has been " + status + " for " + (currentDate() - startDate); } return "Current issue has been " + status + " for " + (currentDate() - created); |
...