Parsing in Liferay(Using SAX Parser reader)

-

  Liferay provided default classes to parse the xml content.

  Have look at this SAXReaderUtil  which will be useful to parse the xml.

  For Example:

    Consider the WebContent(Journal article) where we have added metadata ,consider to fetch it.

   First of all this metadata content will be store in Journal article table of Content column as

<?xml version="1.0"?>

<root available-locales="en_US" default-locale="en_US">

   <dynamic-element instance-id="trtrtrt454" name="Title" type="text" index-type="">
        <dynamic-content><![CDATA[Test Title]]></dynamic-content>
    </dynamic-element>
   
    <dynamic-element instance-id="Adgbcd456" name="Desc" type="text" index-type="">
        <dynamic-content><![CDATA[Test Desc]]></dynamic-content>
    </dynamic-element>
   
</root>

We have fetch the meatdata field Title of value "Test Title"

Here we go,

String xmlContent = journalArticle.getContent();

String title = "Title";

Document document = SAXReaderUtil.read(xmlContent);

Node node = document .selectSingleNode("/root/dynamic-element[@name='"  + title + "']/dynamic-content");

String value = node.getText();

System.out.println("value is"+value);

Output is:  value is : Test Title

Thats it here we got value of the metadata value.

Comments

  1. de sorry pietFebruary 11, 2014 at 9:12 PM

    Thanks, exactly what i was looking for!

    ReplyDelete
  2. AnonymousSeptember 8, 2014 at 4:25 PM

    how to get repeatable fields using this....suppose i have one field name="title" and inside this repeatable field one field name="description" than for repeatable field i can get using List node = document.selectnodes(""); but for inner field how to get can u please rply......

    ReplyDelete
  3. UnknownDecember 1, 2016 at 3:05 PM

    Sometimes for other XML's, it does not show the output.
    I found this solution to be working for me in that scenarios:

    For the same above XML file content and to get the output value as "Test Title", i used below snippet for Node syntax:

    Node node = document.selectSingleNode("/root/dynamic-element[@name='Title']/dynamic-content");

    Other code is same as above.

    ReplyDelete
  4. UnknownJune 17, 2017 at 3:05 PM

    hi can u please suggest how to change "TEST TITLE" value to "HELLO WELCOME" & get changed Full XML Content AS .













    ReplyDelete
  5. AnonymousSeptember 3, 2019 at 5:58 PM

    How to parse Nested Elements ??



    ReplyDelete

Post a Comment

Popular posts from this blog

Theme display in javascript

-
We know that we can access the themedisplay in java as ThemeDisplay themeDisplay = (ThemeDisplay) request.getAttribute(WebKeys.THEME_DISPLAY) But how can we access in javascript? Here we go Liferay.ThemeDisplay.getScopeGroupId() Liferay.ThemeDisplay.getCompanyId() Liferay.ThemeDisplay.getPlid() Liferay.ThemeDisplay.getLayoutId() By this we can access the groupId, companyid ... etc
Read more

How to know which liferay version we are using

-
Image
Sometimes we have to know which liferay version we are using, so how can we know? We can know the liferay version in different ways. 1. Liferay has provided some utility methods to know the which liferay version we are using , Here is the utility method ReleaseInfo.getReleaseInfo() It prints this statement " Liferay Portal Community Edition 6.2 CE GA2 (Newton / Build 6201 / March 20, 2014) " as i am using community version it shoes as CE. 2. Also we can also identify by response headers as below screenshot. If your using the chrome, right click on the browser and click inscept element , and navigate to the network  . you will see the URLS , click on the any url. 3. Also we can see during server startup as below statement Liferay Portal Community Edition 6.2 CE GA2 (Newton / Build 6201 / March 20, 2014)
Read more

Viewing the SQL Query in liferay : debugging the SQL Query in Hibernate

-
Sometimes we have to know SQL query hiting in DB to retrieve the list. Suppose When we are writing the DynamicQuery , Some times we have to know SQL query it is generating to hit DB. So generally it is useful when we are debugging the Query it is generated. In hibernate we used the write the property in XML file as hibernate.show.sql to view the query. In Liferay also we can also set the below property to true in the portal-ext.properties to view the SQL query at the console. hibernate.show_sql=true. By adding the above property it will just reterive the parameters. What if we want to display the parameters. Add the below properties in log4j.properties it will display the paramters also. # logs the SQL statements #log4j.logger.org.hibernate.SQL=debug # Logs the JDBC parameters passed to a query #log4j.logger.org.hibernate.type=trace In Liferay log4j is located in the below location tomcat-7.0.42\webapps\ROOT\WEB-INF\classes Also we want to see hibernate ses
Read more