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