labkey.deleteRows Jon (LabKey DevOps)  2016-02-10 14:34
Status: Closed
 
Hi Laura,

This is really strange. There is nothing special that needs to be done to delete the record here.

I'd like to confirm a few other things with you.

1. Can you delete records in the QuaSAR_AuDIT list directly?

2. Can you try to delete a record using the Javascript API?

Use the following code below in a wiki page in the same folder as the list and replace KEY_NUMBER with one of the Key values you want to remove.

==================================

<p><button onclick="onSubmit()">Click me to delete a record</button></p>

<script type="text/javascript">

function onSubmit(){
LABKEY.Query.deleteRows({
    requiredVersion: 9.1,
    schemaName: 'lists',
    queryName: 'QuaSAR_AuDIT',
    rows: [{'Key': KEY_NUMBER}],
    success: onSuccess
});

function onSuccess(results) {
                  alert('Success!');
                 }
}
</script>

==================================


Regards,

Jon