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
1974
1975
1976
1977
1978
1979
1980
1981
1982
1983
1984
1985
1986
1987
1988
1989
1990
    Session session = null;

    try {
      session = openSession();

      SQLQuery q = session.createSQLQuery(sql);

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

      QueryPos qPos = QueryPos.getInstance(q);

      qPos.add(groupId);
View Full Code Here
2149
2150
2151
2152
2153
2154
2155
2156
2157
2158
2159
2160
2161
2162
2163
2164
2165
2166
2167
2168
2169
2170
2171
2172
2173
2174
2175
2176
2177
2178
2179
2180
2181
2182
2183
    String sql = InlineSQLHelperUtil.replacePermissionCheck(query.toString(),
        Guestbook.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, GuestbookImpl.class);
    }
    else {
      q.addEntity(_FILTER_ENTITY_TABLE, GuestbookImpl.class);
    }

    QueryPos qPos = QueryPos.getInstance(q);

    qPos.add(groupId);

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

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

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

    if (list.size() == 2) {
      return list.get(1);
    }
    else {
View Full Code Here
2278
2279
2280
2281
2282
2283
2284
2285
2286
2287
2288
2289
2290
2291
2292
2293
2294
2295
2296
2297
    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
24
25
26
27
28
29
30
31
32
33
34
35
36
    try {
      session = openSession();

      String sql = CustomSQLUtil.get(FIND_BY_EVENTNAME_EVENTDESCRIPTON_LOCATIONNAME);

      SQLQuery q = session.createSQLQuery(sql);
      q.setCacheable(false);
      q.addEntity("Event_Event", EventImpl.class);

      QueryPos qPos = QueryPos.getInstance(q);
      qPos.add(eventName);
      qPos.add(eventDescription);
      qPos.add(locationName);
View Full Code Here
607
608
609
610
611
612
613
614
615
616
617
618
619
620
621
622
623
    Session session = null;

    try {
      session = openSession();

      SQLQuery q = session.createSQLQuery(sql);

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

      QueryPos qPos = QueryPos.getInstance(q);

      qPos.add(groupId);
View Full Code Here
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(),
        Event.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, EventImpl.class);
    }
    else {
      q.addEntity(_FILTER_ENTITY_TABLE, EventImpl.class);
    }

    QueryPos qPos = QueryPos.getInstance(q);

    qPos.add(groupId);

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

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

    List<Event> 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
607
608
609
610
611
612
613
614
615
616
617
618
619
620
621
622
623
    Session session = null;

    try {
      session = openSession();

      SQLQuery q = session.createSQLQuery(sql);

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

      QueryPos qPos = QueryPos.getInstance(q);

      qPos.add(groupId);
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.