labkey.deleteRows Jon (LabKey DevOps)  2016-02-09 21:19
Status: Closed
 
Hi Laura,

No, that should be it. If it's Key, then your query to delete is right.

Just curious, are you able to run a selectRows query and get results to view?

testSelectRows <- labkey.selectRows(
                  baseUrl="https://labkey-dev.roche.com:8443/labkey",
                  folderPath="/gRED/QuaSAR Dev 2/QuaSAR Dev 2 results",
                  schemaName="lists",
                  queryName="QuaSAR_AuDIT"
                  )

Also, have you tried to do a delete on a single row like this?

testDeleteRows <- 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=1, stringsAsFactors = FALSE)
                  )

Regards,

Jon