Form Your Select Query

It follows SQL syntax! Capitalization doesn’t matter for operators (but it does for filter criteria and API names). The “columns” you pull in need to be the API names of the fields you want. Here’s what it should look like:

todayLess365 = zoho.currentdate.subDay(365).toString("yyyy-MM-dd");
info todayLess365;
queryMap.put({"select_query":"select Deal_Name, Amount, Account_Name.Account_Name, Account_Name from Deals where Closing_Date > '" + todayLess365 + "' and Stage like '7 Closed Won' order by Account_Name.Account_Name"});
Back to Lesson