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(),
        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
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
2898
2899
2900
2901
2902
2903
2904
2905
2906
2907
2908
2909
2910
2911
2912
2913
2914
    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
3092
3093
3094
3095
3096
3097
3098
3099
3100
3101
3102
3103
3104
3105
3106
3107
3108
3109
3110
3111
3112
3113
3114
3115
3116
3117
3118
3119
3120
3121
3122
3123
3124
3125
3126
3127
3128
3129
3130
    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 (bindName) {
      qPos.add(name);
    }

    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
3262
3263
3264
3265
3266
3267
3268
3269
3270
3271
3272
3273
3274
3275
3276
3277
3278
3279
3280
3281
3282
3283
3284
3285
    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);

      if (bindName) {
        qPos.add(name);
      }

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

      return count.intValue();
    }
    catch (Exception e) {
      throw processException(e);
View Full Code Here
32
33
34
35
36
37
38
39
40
41
42
43
44
    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
606
607
608
609
610
611
612
613
614
615
616
617
618
619
620
621
622
    Session session = null;

    try {
      session = openSession();

      SQLQuery q = session.createSQLQuery(sql);

      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);
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.