Duplicate rows query

LabKey Support Forum
Duplicate rows query fcf  2019-06-24 16:12
Status: Closed
 

I am working off a list and trying to duplicate rows to allow editing of the duplicates. It is for an order book where people can re-order supplies, making changes to the previous orders as necessary. I am modeling the code after a bulk edit, but I am having trouble selecting data to be edited and inserted. Here is the bulk edit code:

                 var url = LABKEY.ActionURL.buildURL('query', 'updateQueryRows.view', null, {
                       schemaName: dataRegion.schemaName,
                       'query.queryName': dataRegion.queryName,
                       dataRegionSelectionKey: dataRegion.selectionKey
                   });
                   var form = dataRegion.form;
                   console.log(typeof form);
                   if (form && verifySelected.call(this, form, url, 'POST', 'rows')) {
                       submitForm(form);
                   }
                   return false;

I thought it would be appropriate to change updateQueryRows to some form of a select statement, but cannot get it to work. Is there a duplicate rows query function? Any ideas?

 
 
Jon (LabKey DevOps) responded:  2019-06-24 19:40

Hi Frank,

We'll move your question to your Premium Support Ticket portal and work with you there.

Regards,

Jon