Skip to Content
0
Former Member
Aug 10, 2015 at 12:48 PM

ODATA Service With Two Date Input Parameters

179 Views

Hi Experts,

I am trying to create a service with two date input parameters

service {

"ABC_PE.MODELS.CALC_VIEWS_DEMO2::CLV_POWER_OUTAGE_FILTER" as "power_outage" // always use package path not the _sys_bic

key generate local "id"

parameters via entity "InputParams";

}

While accessing the below URL i am getting an error "Illegal query syntax"

URL

https://172.18.246.150:8000/ABC_PE/SERVICES/SRV_POWER_OUTAGE.xsodata/InputParams(inp_date_from='2015-06-28',inp_date_to='2015-07-15')/Results

Calculation View:

SELECT AVG_VOLT,

DT_METER,

MOMENT_TIME,

MOMENT_DATE

FROM "_SYS_BIC"."ABC_PE.MODELS.CALC_VIEWS_DEMO2/CLV_POWER_OUTAGE"

WHERE MOMENT_DATE BETWEEN :INP_DATE_FROM

AND :INP_DATE_TO ;

Requesting your help to resolve this.

Thanks & Regards

Sanjeev