我使用的是以下代码: // Define "LineItemsIds" in input data section.
// Get the number of line items.**return** *{ line_items_count: inputData.LineItemsIDs.split(',').length };* 我收到错误拆分:无法读取未定义的属性‘TypeError’ 我也附上了一张图片--我使用的是Zapier。
这是我的问题 WHERE (date >= '2012-06-26'AND date < '2012-06-30') AND (Avail > '0')SELECT COUNT(*) as total, toys, date FROM T2
WHERE (date >= '2012-06-26'ANDdate < '2012-06-3
我尝试了以下查询,但执行时间太长: SELECT employees.company as x, COUNT(DISTINCT (results.employee_id)) "Total Surveys", (SELECT COUNT(employees.id) FROM employees WHERE company = x) "Headcount"JOIN employees