Uploaded image for project: 'PUBLIC - Liferay Portal Community Edition'
  1. PUBLIC - Liferay Portal Community Edition
  2. LPS-33167

Adding a custom query parameter of value 0 with CustomSQLParam will not be included in the execution

    Details

      Description

      When creating a custom query with CustomSQLParam passing in a value of 0, it will not include that parameter within the execution of the query.

      If you try something like:
      userParams.put("usersOrgs", new Long(0));

      and then execute a search passing in the params, it will return an exception: org.hibernate.QueryException: Expected positional parameter count

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              michael.saechang Michael Saechang
              Reporter:
              wesley.gong Wesley Gong
              Participants of an Issue:
              Recent user:
              Esther Sanz
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:
                Days since last comment:
                7 years, 44 weeks, 1 day ago

                  Packages

                  Version Package
                  6.1.30 EE GA3
                  6.2.0 CE M5