cancel
Showing results for 
Search instead for 
Did you mean: 

Service layer Query view filtering not retrieving results

tomersha717
Explorer
0 Kudos

Hi Experts,

I'm trying to use Query View with filtering and getting empty results
My SAP Version is SAP Business One 10.0 (10.00.140) FP 2011 (64-bit)

The request
https://localhost:50000/b1s/v1/view.svc/v_GetBPBankAccounts_B1SLQuery?$filter=CardCode eq 'C20000'

The results

This is the expected results in management studio

What am I doing wrong here?

Thanks,

Tomer Shalom

Accepted Solutions (0)

Answers (1)

Answers (1)

tomersha717
Explorer
0 Kudos

I managed to find the issue

I Changed the view name from "v_GetBPBankAccounts_B1SLQuery" to "GetAccnt_B1SLQuery"

Not sure why and I didn't find any rule about name length, but it did the job.