Showing results for 
Search instead for 
Do you mean 
Community Home Request Access Read Blogs Share Your Ideas Search Community View My Settings
Reply
New Member
Posts: 17
Registered: ‎09-10-2009

No row with the given identifier exists

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

 

http://serverSmiley Tongueort/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

Gold Super Contributor
Posts: 3,087
Registered: ‎03-19-2009

Re: No row with the given identifier exists

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.. 

--
RJ Ledger - rjledger@rjlSystems.net +1 603.369.3047 x101

".. Innovators in Mobility - Experts in Workflow Automation..."
http://www.rjlSystems.net - blog: www.rjlSystems.net/blog.html
New Member
Posts: 17
Registered: ‎09-10-2009

Re: No row with the given identifier exists

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