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

Check this tool. 

https://adobe-consulting-services.github.io/acs-aem-tools/csv-resource-type-updater.html

I think this is what you are looking for.