@Override
	public List<CPAttachmentFileEntry> findByC_C_T_NotST(long classNameId,
		long classPK, int type, int status, int start, int end,
		OrderByComparator<CPAttachmentFileEntry> orderByComparator,
		boolean retrieveFromCache) {
		boolean pagination = true;
		FinderPath finderPath = null;
		Object[] finderArgs = null;

		finderPath = FINDER_PATH_WITH_PAGINATION_FIND_BY_C_C_T_NOTST;
		finderArgs = new Object[] {
				classNameId, classPK, type, status,
				
				start, end, orderByComparator
			};

		List<CPAttachmentFileEntry> list = null;

		if (retrieveFromCache) {
			list = (List<CPAttachmentFileEntry>)finderCache.getResult(finderPath,
					finderArgs, this);

			if ((list != null) && !list.isEmpty()) {
				for (CPAttachmentFileEntry cpAttachmentFileEntry : list) {
					if ((classNameId != cpAttachmentFileEntry.getClassNameId()) ||
							(classPK != cpAttachmentFileEntry.getClassPK()) ||
							(type != cpAttachmentFileEntry.getType()) ||
							(status == cpAttachmentFileEntry.getStatus())) {
						list = null;

						break;
					}
				}
			}
		}

		if (list == null) {
			StringBundler query = null;

			if (orderByComparator != null) {
				query = new StringBundler(6 +
						(orderByComparator.getOrderByFields().length * 2));
			}
			else {
				query = new StringBundler(6);
			}

			query.append(_SQL_SELECT_CPATTACHMENTFILEENTRY_WHERE);

			query.append(_FINDER_COLUMN_C_C_T_NOTST_CLASSNAMEID_2);

			query.append(_FINDER_COLUMN_C_C_T_NOTST_CLASSPK_2);

			query.append(_FINDER_COLUMN_C_C_T_NOTST_TYPE_2);

			query.append(_FINDER_COLUMN_C_C_T_NOTST_STATUS_2);

			if (orderByComparator != null) {
				appendOrderByComparator(query, _ORDER_BY_ENTITY_ALIAS,
					orderByComparator);
			}
			else
			 if (pagination) {
				query.append(CPAttachmentFileEntryModelImpl.ORDER_BY_JPQL);
			}

			String sql = query.toString();

			Session session = null;

			try {
				session = openSession();

				Query q = session.createQuery(sql);

				QueryPos qPos = QueryPos.getInstance(q);

				qPos.add(classNameId);

				qPos.add(classPK);

				qPos.add(type);

				qPos.add(status);

				if (!pagination) {
					list = (List<CPAttachmentFileEntry>)QueryUtil.list(q,
							getDialect(), start, end, false);

					Collections.sort(list);

					list = Collections.unmodifiableList(list);
				}
				else {
					list = (List<CPAttachmentFileEntry>)QueryUtil.list(q,
							getDialect(), start, end);
				}

				cacheResult(list);

				finderCache.putResult(finderPath, finderArgs, list);
			}
			catch (Exception e) {
				finderCache.removeResult(finderPath, finderArgs);

				throw processException(e);
			}
			finally {
				closeSession(session);
			}
		}

		return list;
	}
@ Override public List < CPAttachmentFileEntry > findByC_C_T_NotST ( long classNameId , long classPK , int type , int status , int start , int end , OrderByComparator < CPAttachmentFileEntry > orderByComparator , boolean retrieveFromCache ) { boolean pagination = true ; FinderPath finderPath = null ; Object [ ] finderArgs = null ; finderPath = FINDER_PATH_WITH_PAGINATION_FIND_BY_C_C_T_NOTST ; finderArgs = new Object [ ] { classNameId , classPK , type , status , start , end , orderByComparator } ; List < CPAttachmentFileEntry > list = null ; if ( retrieveFromCache ) { list = ( List < CPAttachmentFileEntry > ) finderCache . getResult ( finderPath , finderArgs , this ) ; if ( ( list != null ) && ! list . isEmpty ( ) ) { for ( CPAttachmentFileEntry cpAttachmentFileEntry : list ) { if ( ( classNameId != cpAttachmentFileEntry . getClassNameId ( ) ) || ( classPK != cpAttachmentFileEntry . getClassPK ( ) ) || ( type != cpAttachmentFileEntry . getType ( ) ) || ( status == cpAttachmentFileEntry . getStatus ( ) ) ) { list = null ; break ; } } } } if ( list == null ) { StringBundler query = null ; if ( orderByComparator != null ) { query = new StringBundler ( 6 + ( orderByComparator . getOrderByFields ( ) . length * 2 ) ) ; } else { query = new StringBundler ( 6 ) ; } query . append ( _SQL_SELECT_CPATTACHMENTFILEENTRY_WHERE ) ; query . append ( _FINDER_COLUMN_C_C_T_NOTST_CLASSNAMEID_2 ) ; query . append ( _FINDER_COLUMN_C_C_T_NOTST_CLASSPK_2 ) ; query . append ( _FINDER_COLUMN_C_C_T_NOTST_TYPE_2 ) ; query . append ( _FINDER_COLUMN_C_C_T_NOTST_STATUS_2 ) ; if ( orderByComparator != null ) { appendOrderByComparator ( query , _ORDER_BY_ENTITY_ALIAS , orderByComparator ) ; } else if ( pagination ) { query . append ( CPAttachmentFileEntryModelImpl . ORDER_BY_JPQL ) ; } String sql = query . toString ( ) ; Session session = null ; try { session = openSession ( ) ; Query q = session . createQuery ( sql ) ; QueryPos qPos = QueryPos . getInstance ( q ) ; qPos . add ( classNameId ) ; qPos . add ( classPK ) ; qPos . add ( type ) ; qPos . add ( status ) ; if ( ! pagination ) { list = ( List < CPAttachmentFileEntry > ) QueryUtil . list ( q , getDialect ( ) , start , end , false ) ; Collections . sort ( list ) ; list = Collections . unmodifiableList ( list ) ; } else { list = ( List < CPAttachmentFileEntry > ) QueryUtil . list ( q , getDialect ( ) , start , end ) ; } cacheResult ( list ) ; finderCache . putResult ( finderPath , finderArgs , list ) ; } catch ( Exception e ) { finderCache . removeResult ( finderPath , finderArgs ) ; throw processException ( e ) ; } finally { closeSession ( session ) ; } } return list ; }
Returns an ordered range of all the cp attachment file entries where classNameId = &#63; and classPK = &#63; and type = &#63; and status &ne; &#63;.

<p>
Useful when paginating results. Returns a maximum of <code>end - start</code> instances. <code>start</code> and <code>end</code> are not primary keys, they are indexes in the result set. Thus, <code>0</code> refers to the first result in the set. Setting both <code>start</code> and <code>end</code> to {@link QueryUtil#ALL_POS} will return the full result set. If <code>orderByComparator</code> is specified, then the query will include the given ORDER BY logic. If <code>orderByComparator</code> is absent and pagination is required (<code>start</code> and <code>end</code> are not {@link QueryUtil#ALL_POS}), then the query will include the default ORDER BY logic from {@link CPAttachmentFileEntryModelImpl}. If both <code>orderByComparator</code> and pagination are absent, for performance reasons, the query will not have an ORDER BY clause and the returned result set will be sorted on by the primary key in an ascending order.
</p>

@param classNameId the class name ID
@param classPK the class pk
@param type the type
@param status the status
@param start the lower bound of the range of cp attachment file entries
@param end the upper bound of the range of cp attachment file entries (not inclusive)
@param orderByComparator the comparator to order the results by (optionally <code>null</code>)
@param retrieveFromCache whether to retrieve from the finder cache
@return the ordered range of matching cp attachment file entries