Which SQL query syntax should I use for Kalix views or does kalix have separate syntax for SQL? please let me know.
The ERROR says UNKNOWN COLUMN active_connection.connection_id and to fis this issue, correct the query
rpc GetActiveCustomer(ConnectionMessage) returns (stream ActiveCustomerFlag) {
option (kalix.method).view.query = {
query: "SELECT CASE WHEN COUNT(*) = 4 THEN ‘true’ ELSE ‘false’ END AS result FROM active_connection "
" JOIN active_party ON active_connection.connection_id = active_party.connection_id "
" JOIN active_borrowing_entity ON active_party.connection_id = active_borrowing_entity.connection_id "
" JOIN active_guarantee ON active_borrowing_entity.connection_id = active_guarantee.connection_id "
" WHERE active_connection.connection_id = :connection_id "
};
option (google.api.http) = {
get: “/company_search/GetAllActiveCustomer”
};
}