Details

    • Type: Bug
    • Status: Resolved
    • Priority: Minor
    • Resolution: Fixed
    • Fix Version/s: 6.2.x
    • Component/s: Developer Network
    • Labels:
      None
    • Liferay Contributor's Agreement:
      Accept

      Description

      In this Article https://dev.liferay.com/develop/tutorials/-/knowledge_base/6-2/developing-custom-sql-queries we have suggested SQLs should be written inside CDATA but below code snippet doesn't include same

      <?xml version="1.0" encoding="UTF-8"?>
      <custom-sql>
          <sql id="com.liferay.docs.eventlisting.service.persistence.EventFinder.\
      findByEventNameEventDescriptionLocationName">
              SELECT Event_Event.*
              FROM Event_Event
              INNER JOIN 
                  Event_Location ON Event_Event.locationId = Event_Location.locationId
              WHERE
                  (Event_Event.name LIKE ?) AND
                  (Event_Event.description LIKE ?) AND
                  (Event_Location.name LIKE ?)
          </sql>
      </custom-sql>
      

      Therefore we should include CDATA in snippet too.

      Here is the Pull request : https://github.com/liferay/liferay-docs/pull/222

        Attachments

          Activity

            People

            • Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Packages

                Version Package
                6.2.x