No row with the given identifier exists

[KaiSchaffrath]

I'm trying to check over sdata for existing leads. I'm using for example this address to check:

http://serverort/sdata/slx/dynamic/-/leads?where Company like 'company name'

But it always tells me "No row with the given identifier exists".

I've checked back in the application Architect but there I can find exact the same name "Company" as I'm using  it in my link.

What am I making false that this is not working?

Regards

Kai

[RJLedger]

You need to format it like this:

   For "Contains:

     http://servername/sdata/slx/dynamic/-/Leads?where=Company like '*company name*'

    For "Starts With:

     http://servername/sdata/slx/dynamic/-/Leads?where=Company like '*company name'

   For "Ends With:

     http://servername/sdata/slx/dynamic/-/Leads?where=Company like 'company name*' 

FYI.. you can toss &orderby=Company on teh end if you want to.. 

[KaiSchaffrath]

Thanks RJ,

I think I've found the solution.

I've checked directly in the sql database and noticed that the record I was looking for was existing twice in the sql database, but only shown once in slx. After removing the duplicate, everything worked fine.

Regards

Kai