Hey,
I have created a JDBC adapter service which is customSQL adapter type. Looks like custom service does not take inputs at runtime. Fore more details I am adding the request details below;

I’ve 2 input fields. If I hard code the inputs it works but it does not take inputs at run time.

SELECT code_id,code_value,ps.SERVICE_ID,ps.CSG_SERVICE_CODE,ps.SERVICE_DESCRIPTION,ps.service_price,ps.billing_type_code_id
from prm_subcomponent sub, prm_subcomponent_service sp, prd_service ps,prd_codes c
where sub.subcomponent_id in (
select distinct(s.subcomponent_id)
from prm_promotion p, prm_promotion_component pc,prm_comp_subcomponent cs,prm_subcomponent s ,
prm_acquisition_channel ac
where p.PROMOTION_ID = ?
and p.PROMOTION_ID = pc.PROMOTION_ID
and cs.COMPONENT_ID = pc.COMPONENT_ID
and cs.SUBCOMPONENT_ID = s.SUBCOMPONENT_ID
and ac.subcomponent_id = s.subcomponent_id
and ac.acquisition_channel_type = ‘DIRECT’
and s.END_DATE is null
and cs.END_DATE is null
and pc.END_DATE is null
and p.END_DATE is null
)
and sub.SUBCOMPONENT_ID = sp.SUBCOMPONENT_ID
and ps.SERVICE_ID = sp.SERVICE_ID
and ps.service_type_code_id = c.code_id
order by code_value

Help really appriciated!!

Can you post the input definitions you entered on the SQL tab of the service? Input JDBC Type, Input Field Type and Input Field.

you can declare a input field and the value passed to that field is substitued at runtime.

say you can define field called ‘PROMOTION_ID’ in input field section like below
Input JDBC Type= VARCHAR
input Field Type= java.lang.String
input Field = PROMOTION_ID