Skip to Content
0

How to pass filter in odata call from front end?

Jan 19, 2017 at 11:35 AM

23

avatar image

This is the query i have to generate after passing the filter.

?$filter=((IN_FKDAT ge '20161001' and IN_FKDAT le '20161231') and (IN_COMPANY eq 'INFSYS') and (IN_VBELN eq '2100027030' or IN_VBELN eq '2100027031' or IN_VBELN eq '2100027032' or IN_VBELN eq '2100027033' or IN_VBELN eq '2100027034' or IN_VBELN eq '2100027035'))

I am passing like this:

oModelForFA.read("ActionSet('" + selectedAction1 + "')/SearchActiontoInvoice?" + "$filter=((IN_FKDAT ge '" + paramBillingDateFrom + "' " + "and IN_FKDAT le '" + paramBillingDateTo + "') " + "and (IN_COMPANY eq '" + COMPANY_NAME + "') " + "and (IN_VBELN eq '" + invoices_temp_String + "')) ", null, null, true,

I am getting the IN_VBELN values as a list of invoices in array like:2000000133, 35000000,20000000.

How will I pass the query in read function for the IN_VBELN field?

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers