12-21-2009 01:45 AM
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?
12-21-2009 07:45 AM
You need to format it like this:
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..
12-22-2009 08:00 AM
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.