topic Re: Problem using CMLUpdate or CMLDelete in Alfresco Archive

Problem using CMLUpdate or CMLDelete

king — Wed, 22 Nov 2006 10:51:45 GMT

I'm trying to delete or update a node using CML statements.The code is: CML cml = new CML(); CMLDelete delete = new CMLDelete(); Reference reference = new Reference(); reference.setStore(STORE); Predicate wherePredicate = new Predicate();

Re: Problem using CMLUpdate or CMLDelete

rwetherall — Wed, 22 Nov 2006 15:14:06 GMT

Hi,

Only thing I'd suggest is not to set the query on the where predicate. You don't need it since you are explicity providing the references to the nodes you want to delete.

If this still isnt working then I'd suggest raising a bug on Jira.

Cheers,
Roy

Re: Problem using CMLUpdate or CMLDelete

king — Wed, 22 Nov 2006 15:19:48 GMT

I've tried to use the statement whithout the query but the response is the same!

Re: Problem using CMLUpdate or CMLDelete

rwetherall — Wed, 22 Nov 2006 15:23:27 GMT

Ok, then I suggest you raise this as a bug on Jira (http://issues.alfresco.com) , providing the unit test code that is failing.

This is the best way to ensure one of the development team will look at it for you.

Cheers,
Roy

Re: Problem using CMLUpdate or CMLDelete

king — Wed, 22 Nov 2006 15:39:36 GMT

Thanks!

Re: Problem using CMLUpdate or CMLDelete

sergio — Fri, 24 Nov 2006 10:00:42 GMT

Hi all.

Here you can find one possible solution (for every one is looking for) to delete a node (or a set of nodes) using WS APIs.

private void wsDeleteNodes ()
   {
   final String tipo = "TYPE:\"{it.nsi.mageml.model}meta\"";
   final Store store = new Store(Constants.WORKSPACE_STORE, "SpacesStore");

   Query query = new Query();
   query.setLanguage(Constants.QUERY_LANG_LUCENE);
   query.setStatement(tipo);

   try
   {
         QueryResult qrst = repositoryService.query(store, query, false);
         ResultSet rst = qrst.getResultSet();
         long numRec = rst.getTotalRowCount();
         JOptionPane.showMessageDialog(null, "Deleting " + numRec + " nodes of type " + tipo);

         ResultSetRow[] elencoNodi = rst.getRows();

         Predicate predicate = new Predicate();
         predicate.setStore(store);
         //cicle through the nodes
         for (ResultSetRow node : elencoNodi)
         {
            Reference ref = new Reference();
            ref.setStore(store);
            ref.setUuid(node.getNode().getId());
            predicate.setNodes(new Reference[]{ref});
            CML cml = new CML();
            CMLDelete cmlDelete = new CMLDelete();
            cmlDelete.setWhere(predicate);
            cml.setDelete(new CMLDelete[]{cmlDelete});
            UpdateResult[] results = repositoryService.update(cml);
         }

      }
   catch (Exception e)
   {
         e.printStackTrace();
      }
   }

Hoping this code snippet could be useful.

Best regards.

Sergio

Re: Problem using CMLUpdate or CMLDelete

keweishang — Mon, 09 Jul 2012 13:06:53 GMT

Your workaround does work. thanks sergio.