labkey.deleteRows laurapas  2016-02-09 11:16
Status: Closed
 
Hi,
No, peptide is not a primary key. Is that a requirement? It doesn't say so in the documentation. Also, it doesn't seem that I can make peptide a primary key; there is no option to have a non-integer primary key in the list design interface. If I try to use the default primary key (from the list design) called 'Key', that doesn't work either.

labkey.deleteRows(baseUrl="https://labkey-dev.roche.com:8443/labkey",
                  folderPath="/gRED/QuaSAR Dev 2/QuaSAR Dev 2 results",
                  schemaName="lists",
                  queryName="QuaSAR_AuDIT",
                  toDelete=data.frame(Key=c(1:3000),
                                      stringsAsFactors = FALSE)
                  )

$rowsAffected
[1] 3000

$queryName
[1] "QuaSAR_AuDIT"

$schemaName
[1] "lists"

$containerPath
[1] "/gRED/QuaSAR Dev 2/QuaSAR Dev 2 results"

$rows
list()

$command
[1] "delete"


Can you tell me the specific list design requirements that would allow labkey.deleteRows to work?