Hi,
I am using AEM 6.1 and I have created more then 200 tags with upper case letter in my application ( example:Tag Title: Buy a car, Tag name: Buy-a-car).
I need to follow the correct naming convention and convert the tag name with lower case like :Tag name should be " buy-a-car". Is there any way to convert all the tag name with lower case without deleting or recreating new one or can i run any query to update the name.
Please suggest.
Regards,
Sunil
Solved! Go to Solution.
Here is the fiddle script to convert all tag names jcr:title to lowercase. Modify according to your requirement
package apps.acs_002dtools.components.aemfiddle.fiddle;
import com.day.cq.search.*;
import com.day.cq.wcm.api.*;
import com.day.cq.dam.api.*;
import org.apache.sling.api.*;
import org.apache.sling.api.resource.*;
import org.apache.sling.api.servlets.*;
import java.io.IOException;
import javax.jcr.*;
import java.util.*;
public class fiddle extends SlingAllMethodsServlet {
@Override
protected void doGet(SlingHttpServletRequest request, SlingHttpServletResponse response) throws IOException {
// Code here
//response.getWriter().println("Hello from " + request.getResource().getPath());
Resource resource = request.getResourceResolver().getResource("/content/cq:tags/we-retail");
Session session = request.getResourceResolver().adaptTo(Session.class);
if (resource != null) {
// Writing HTML in servlets is usually inadvisable, and is better suited to be provided via a JSP/Sightly template
// This is just an example.
if (resource != null) {
Iterator<Resource> linkResources = resource.listChildren();
while (linkResources.hasNext()) {
Resource childResource = linkResources.next();
try{
Node childNode = childResource.adaptTo(Node.class);
String tagName = childNode.getProperty("jcr:title").getString();
childNode.setProperty("jcr:title",tagName.toLowerCase());
session.save();
response.getWriter().write(""+childNode.getProperty("jcr:title").getString());
}catch(RepositoryException re){}
}
}
// By Default the 200 HTTP Response status code is used; below explicitly sets it.
response.setStatus(SlingHttpServletResponse.SC_OK);
} else {
// Set HTTP Response Status code appropriately
response.setStatus(SlingHttpServletResponse.SC_INTERNAL_SERVER_ERROR);
response.getWriter().write("ERROR");
}
}
}
Views
Replies
Total Likes
You can do the following :
- create a servlet and using QueryManager or any search API to find all tags like (1)
- Iterate over the result set and use java string api to make the items in the resultset to lowercase
- Persist the items back to same location
(1) - select * from [cq:Tag] where isdescendantnode([/etc/tags])
Views
Replies
Total Likes
You can quickly write a small fiddle script using ACS tools without adding this code your source repo
https://adobe-consulting-services.github.io/acs-aem-tools/features/aem-fiddle/index.html
Here is the fiddle script to convert all tag names jcr:title to lowercase. Modify according to your requirement
package apps.acs_002dtools.components.aemfiddle.fiddle;
import com.day.cq.search.*;
import com.day.cq.wcm.api.*;
import com.day.cq.dam.api.*;
import org.apache.sling.api.*;
import org.apache.sling.api.resource.*;
import org.apache.sling.api.servlets.*;
import java.io.IOException;
import javax.jcr.*;
import java.util.*;
public class fiddle extends SlingAllMethodsServlet {
@Override
protected void doGet(SlingHttpServletRequest request, SlingHttpServletResponse response) throws IOException {
// Code here
//response.getWriter().println("Hello from " + request.getResource().getPath());
Resource resource = request.getResourceResolver().getResource("/content/cq:tags/we-retail");
Session session = request.getResourceResolver().adaptTo(Session.class);
if (resource != null) {
// Writing HTML in servlets is usually inadvisable, and is better suited to be provided via a JSP/Sightly template
// This is just an example.
if (resource != null) {
Iterator<Resource> linkResources = resource.listChildren();
while (linkResources.hasNext()) {
Resource childResource = linkResources.next();
try{
Node childNode = childResource.adaptTo(Node.class);
String tagName = childNode.getProperty("jcr:title").getString();
childNode.setProperty("jcr:title",tagName.toLowerCase());
session.save();
response.getWriter().write(""+childNode.getProperty("jcr:title").getString());
}catch(RepositoryException re){}
}
}
// By Default the 200 HTTP Response status code is used; below explicitly sets it.
response.setStatus(SlingHttpServletResponse.SC_OK);
} else {
// Set HTTP Response Status code appropriately
response.setStatus(SlingHttpServletResponse.SC_INTERNAL_SERVER_ERROR);
response.getWriter().write("ERROR");
}
}
}
Views
Replies
Total Likes
Even though I have contents, I getting 0 results
Views
Replies
Total Likes