Query Table stopped working
I have a query table that has worked fine for several weeks now. All of the sudden I went back in to add one more column and it is telling me this is not supported by Zoho yet. When I hit execute query it works fine. Please help me!
Thank You!
Jeremiah
My query is below
SELECT '' as 'Report_Id', 'POL' as 'Record_ID',curdate() as 'Transmission_Date',NAIC_Code, Transaction_Type_Code,policy_number, date("effective_date"),date(expiration_date),'' as 'Policy_Cancellation_Date', '' as 'Filler', Individual_Company_Indicator, risk_location_state as 'State_Abbreviation', Policy_Type_Code, '' as 'Filler','' as 'Filler','' as 'Producer_Id', '' as 'Transaction_Reason_Code', '' as 'Previous_Policy_Number', '' as 'Filler', '' as 'Filler', '' as 'Unpaid_Premium', User_Id, '' as 'Operator_Name', '' as 'Process Center', '' as 'Reserved', '' as 'Reserved','' as 'Reserved','' as 'Reserved','' as 'Reserved', '' as 'Reinstatement_Effective_Date', effective_date as 'Policy_Inception_Date', '' as 'Filler'
FROM "ALL_AUTO"
GROUP BY
"policy_number"