Package com.liferay.portal.kernel.dao.orm

Examples of com.liferay.portal.kernel.dao.orm.SQLQuery

781
782
783
784
785
786
787
788
789
790
791
792
793
794
795
796
797
798
799
800
801
802
803
804
805
806
807
808
809
810
811
812
813
814
815
    String sql = InlineSQLHelperUtil.replacePermissionCheck(query.toString(),
        Location.class.getName(),
        _FILTER_ENTITY_TABLE_FILTER_PK_COLUMN, groupId);

    SQLQuery q = session.createSQLQuery(sql);

    q.setFirstResult(0);
    q.setMaxResults(2);

    if (getDB().isSupportsInlineDistinct()) {
      q.addEntity(_FILTER_ENTITY_ALIAS, LocationImpl.class);
    }
    else {
      q.addEntity(_FILTER_ENTITY_TABLE, LocationImpl.class);
    }

    QueryPos qPos = QueryPos.getInstance(q);

    qPos.add(groupId);

    if (orderByComparator != null) {
      Object[] values = orderByComparator.getOrderByConditionValues(location);

      for (Object value : values) {
        qPos.add(value);
      }
    }

    List<Location> list = q.list();

    if (list.size() == 2) {
      return list.get(1);
    }
    else {
View Full Code Here
910
911
912
913
914
915
916
917
918
919
920
921
922
923
924
925
926
927
928
929
    Session session = null;

    try {
      session = openSession();

      SQLQuery q = session.createSQLQuery(sql);

      q.addScalar(COUNT_COLUMN_NAME,
        com.liferay.portal.kernel.dao.orm.Type.LONG);

      QueryPos qPos = QueryPos.getInstance(q);

      qPos.add(groupId);

      Long count = (Long)q.uniqueResult();

      return count.intValue();
    }
    catch (Exception e) {
      throw processException(e);
View Full Code Here
2004
2005
2006
2007
2008
2009
2010
2011
2012
2013
2014
2015
2016
2017
2018
2019
2020
    Session session = null;

    try {
      session = openSession();

      SQLQuery q = session.createSQLQuery(sql);

      if (getDB().isSupportsInlineDistinct()) {
        q.addEntity(_FILTER_ENTITY_ALIAS, EntryImpl.class);
      }
      else {
        q.addEntity(_FILTER_ENTITY_TABLE, EntryImpl.class);
      }

      QueryPos qPos = QueryPos.getInstance(q);

      qPos.add(groupId);
View Full Code Here
2184
2185
2186
2187
2188
2189
2190
2191
2192
2193
2194
2195
2196
2197
2198
2199
2200
2201
2202
2203
2204
2205
2206
2207
2208
2209
2210
2211
2212
2213
2214
2215
2216
2217
2218
2219
2220
    String sql = InlineSQLHelperUtil.replacePermissionCheck(query.toString(),
        Entry.class.getName(), _FILTER_ENTITY_TABLE_FILTER_PK_COLUMN,
        groupId);

    SQLQuery q = session.createSQLQuery(sql);

    q.setFirstResult(0);
    q.setMaxResults(2);

    if (getDB().isSupportsInlineDistinct()) {
      q.addEntity(_FILTER_ENTITY_ALIAS, EntryImpl.class);
    }
    else {
      q.addEntity(_FILTER_ENTITY_TABLE, EntryImpl.class);
    }

    QueryPos qPos = QueryPos.getInstance(q);

    qPos.add(groupId);

    qPos.add(guestbookId);

    if (orderByComparator != null) {
      Object[] values = orderByComparator.getOrderByConditionValues(entry);

      for (Object value : values) {
        qPos.add(value);
      }
    }

    List<Entry> list = q.list();

    if (list.size() == 2) {
      return list.get(1);
    }
    else {
View Full Code Here
2327
2328
2329
2330
2331
2332
2333
2334
2335
2336
2337
2338
2339
2340
2341
2342
2343
2344
2345
2346
2347
2348
    Session session = null;

    try {
      session = openSession();

      SQLQuery q = session.createSQLQuery(sql);

      q.addScalar(COUNT_COLUMN_NAME,
        com.liferay.portal.kernel.dao.orm.Type.LONG);

      QueryPos qPos = QueryPos.getInstance(q);

      qPos.add(groupId);

      qPos.add(guestbookId);

      Long count = (Long)q.uniqueResult();

      return count.intValue();
    }
    catch (Exception e) {
      throw processException(e);
View Full Code Here
TOP

Related Classes of com.liferay.portal.kernel.dao.orm.SQLQuery

  • com.jengine.orm.db.adapter.liferay.LiferayAdapter
  • com.jenginetest.builder.service.persistence.TestFinderImpl
  • com.liferay.docs.guestbook.service.persistence.EntryPersistenceImpl
  • com.liferay.docs.guestbook.service.persistence.GuestbookPersistenceImpl
  • com.liferay.socialnetworking.service.persistence.WallEntryFinderImpl
  • com.nosester.portlet.eventlisting.service.persistence.EventFinderImpl
  • com.nosester.portlet.eventlisting.service.persistence.EventPersistenceImpl
  • com.nosester.portlet.eventlisting.service.persistence.LocationPersistenceImpl
  • com.samples.portlet.eventlisting.service.persistence.EventFinderImpl
  • com.samples.portlet.eventlisting.service.persistence.EventPersistenceImpl
    • Copyright © 2018 www.massapicom. All rights reserved.
    All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.