labkey.deleteRows Jon (LabKey DevOps)  2016-02-08 18:45
Status: Closed
 
Hi Laura,

That's odd. I pretty much ran the same query on a list without issue. The output shows what records got deleted when I run it:

=========
> deldata2 <- labkey.deleteRows(
+ baseUrl="https://www.labkey.org",
+ folderPath="/Support Tickets/Dashboards/JonY",
+ schemaName="lists",
+ queryName="ListTest",
+ toDelete=data.frame(Key=c(2,3,4), stringsAsFactors=FALSE)
+ )
> deldata2
$rowsAffected
[1] 3

$queryName
[1] "ListTest"

$schemaName
[1] "lists"

$containerPath
[1] "/Support Tickets/Dashboards/JonY"

$rows
$rows[[1]]
$rows[[1]]$EntityId
[1] "0ac6dd24-bca7-1032-80ef-e5ac46246e24"

$rows[[1]]$Check
[1] FALSE

$rows[[1]]$Key
[1] 2

$rows[[1]]$Name
[1] "Frank"


$rows[[2]]
$rows[[2]]$EntityId
[1] "f5af4afa-bf8a-1032-80ef-e5ac46246e24"

$rows[[2]]$Check
[1] TRUE

$rows[[2]]$Key
[1] 3


$rows[[3]]
$rows[[3]]$EntityId
[1] "26e52ba1-d663-1032-b44e-e5ac46241b3e"

$rows[[3]]$Check
[1] FALSE

$rows[[3]]$Key
[1] 4


$command
[1] "delete"
>
=======

So that $rows section of yours should show the actual records being deleted rather than list().

Is that Peptide field the Primary Key for your list?

Regards,

Jon