I would like to create a dataservice in wso2 with a query with? How to make? the query would be this:
with servicos as ( select cast(tec_servico as text) || '-' || ser_nome as servico, ser_metodo as metodo, coalesce(tec_vl_maximo, 0) as maximo, teh_tipo as origem, case when teh_dia_semana = 4410 then 0 when teh_dia_semana = 4404 then 1 when teh_dia_semana = 4405 then 2 when teh_dia_semana = 4406 then 3 when teh_dia_semana = 4407 then 4 when teh_dia_semana = 4408 then 5 when teh_dia_semana = 4409 then 6 end as dia, teh_hora_inicial_am as hora_inicial_am, teh_hora_final_am as hora_final_am, teh_hora_inicial_pm as hora_inicial_pm, teh_hora_final_pm as hora_final_pm from tb_gcc_ted_configuracao join tb_gfc_servico on (tec_servico = ser_cod_serial) join tb_gcc_ted_horario on (teh_servico = tec_servico) join tb_gen_registro on (reg_id_registro = teh_tipo) where reg_cod_registro = :origem and (tec_vl_maximo is null or tec_vl_maximo > :valorLancamento) ) select metodo from servicos where dia = extract(dow from current_date) and (current_time between hora_inicial_am and hora_final_am or current_time between hora_inicial_pm and hora_final_pm) order by metodo limit 1 and gives the error below: SQL query is not applicable to automate the response how can i do for wso2 to recognize?
_______________________________________________ Dev mailing list Dev@wso2.org http://wso2.org/cgi-bin/mailman/listinfo/dev