SQL2 Update Query

Avatar

Avatar

deana66659071

Avatar

deana66659071

deana66659071

19-10-2016

I'm using AEM 6.2.

Is it possible to update content using a SQL2 query with the Tools, Query, SQL2 tool?

Example Select

select * from [nt:unstructured] as p where isdescendantnode (p, [/content/]) AND [sling:resourceType] like '/apps/project/component%'

and Update the content to '/apps/project/component2'

Thank you in advance for your help.

-Dean

View Entire Topic

Avatar

Avatar

Anton_Smulskiy

Avatar

Anton_Smulskiy

Anton_Smulskiy

19-10-2016

From description - no.

One more option is a bulk editor

https://docs.adobe.com/docs/en/aem/6-1/administer/operations/bulk-editor.html

  1. Make a query
  2. Export results to excel file
  3. Filter/update properties in excel file
  4. Import excel file

But, be aware. From documentation: 

When you re-import content, you erase any previous content for those nodes. Be careful not to overwrite important information.