com.endeca.portal.catalog.query

Class CatalogResultsDatasetQuery

java.lang.Object

com.endeca.portal.catalog.query.AbstractCatalogResultsQuery

com.endeca.portal.catalog.query.CatalogResultsDatasetQuery

All Implemented Interfaces:

CatalogResultsQuery

public class CatalogResultsDatasetQuery
extends AbstractCatalogResultsQuery

Field Summary

Fields

Modifier and Type	Field and Description
protected static java.lang.String	COUNT_DATASET_ADDED_TO_PROJECT_STMT
static java.lang.String	PARAM_DATASET_DISPLAYNAME

Fields inherited from class com.endeca.portal.catalog.query.AbstractCatalogResultsQuery

DATASET_RECORDS_STATEMENT, DATASETS_COUNT_STATEMENT_KEY, jacksonMapper, logger, PROJECT_RECORDS_STATEMENT, PROJECTS_COUNT_STATEMENT_KEY, RESULTS_STATEMENT_KEY, STATE_MODEL_PARAMETER, UNIQUE_DATASET_DEFINE_STATEMENT

Fields inherited from interface com.endeca.portal.catalog.query.CatalogResultsQuery

MOST_POPULAR_PAGE_SIZE, MOST_RECENTLY_CREATED_DATASETS_PAGE_SIZE, MOST_RECENTLY_VIEWED_DATASETS_PAGE_SIZE, MOST_RECENTLY_VIEWED_PROJECTS_PAGE_SIZE, SORT_TYPE_MOST_POPULAR, SORT_TYPE_MOST_RECENTLY_ACCESSED, SORT_TYPE_MOST_RECENTLY_ADDED

Constructor Summary

Constructors

Constructor and Description
CatalogResultsDatasetQuery()

Method Summary

Methods

Modifier and Type	Method and Description
com.endeca.mdex.eql_parser.types.Query	buildQuery(CatalogDataSetModel viewModel, java.lang.String collectionKey, javax.portlet.PortletRequest request)
com.endeca.mdex.eql_parser.types.Query	buildQuery(ViewModel viewModel, java.lang.String collectionKey, javax.portlet.PortletRequest request, boolean includeZonesData)
java.lang.String	getCollectionKey()
static CatalogResultsDatasetQuery	getInstance()
com.endeca.mdex.eql_parser.types.Query	getQuickLookInfoQuery(javax.portlet.PortletRequest request, java.lang.String selectedCollectionKey) 'RELATED DATASETS' QUERY: DEFINE SELECTED_DATASET AS SELECT "system-bddDatasetInventory.collectionKey" AS collectionKey FROM system-bddDatasetInventory WHERE (collectionKey = '' OR ("system-bddDatasetInventory.published = 'false' AND parentCollectionName = '')); GROUP BY collectionKey; DEFINE PROJECT_RESULTS1 AS SELECT COUNT(1) as REC_COUNT FROM WHERE SOME dataset IN ".datasets" SATISFIES (dataset IN "SELECTED_DATASET") GROUP BY MEMBERS(".datasets") AS "relDataSetKey.datasets"; DEFINE DSINVENTORY_RESULTS AS SELECT "system-bddDatasetInventory.collectionKey" AS collectionKey, "system-bddDatasetInventory.displayName" AS displayName, "system-bddDatasetInventory.tag" AS tag, "system-bddDatasetInventory.description" AS description, "system-bddDatasetInventory.sourceType" AS sourceType, "system-bddDatasetInventory.sourceName" AS sourceName, "system-bddDatasetInventory.attributeCount" AS attributeCount, "system-bddDatasetInventory.recordCount" AS recordCount FROM system-bddDatasetInventory WHERE NOT ("system-bddDatasetInventory.collectionKey" IN SELECTED_DATASET); RETURN RELATED_DATASETS AS SELECT DSINVENTORY_RESULTS.collectionKey, DSINVENTORY_RESULTS.displayName, DSINVENTORY_RESULTS.description, DSINVENTORY_RESULTS.tag, DSINVENTORY_RESULTS.sourceType, DSINVENTORY_RESULTS.sourceName, DSINVENTORY_RESULTS.recordCount, DSINVENTORY_RESULTS.attributeCount, PROJECT_RESULTS.REC_COUNT AS relationCount FROM PROJECT_RESULTS JOIN DSINVENTORY_RESULTS ON (PROJECT_RESULTS."
void	processResults(CatalogDataSetModel viewModel, java.util.List<com.endeca.mdex.conversation.types.ResultRecords> resultList, long loggedInUserId, javax.portlet.PortletRequest request) Process the results set and update the viewmodel
void	processResults(ViewModel viewModel, java.util.List<com.endeca.mdex.conversation.types.ResultRecords> resultList, long loggedInUserId, javax.portlet.PortletRequest request, boolean includeZonesData) Process the results object and update the viewmodel that is passed in
DatasetsResultsObject	queryQuickLookInfo(javax.portlet.PortletRequest request, java.lang.String selectedCollectionKey)
java.lang.String	translateAttributeKey(CatalogDataSetModel viewModel)

Methods inherited from class com.endeca.portal.catalog.query.AbstractCatalogResultsQuery

applySorting, getPaging, getQueryState, isStudioSideSorting, isStudioSideSorting, query, query

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Field Detail

PARAM_DATASET_DISPLAYNAME

public static final java.lang.String PARAM_DATASET_DISPLAYNAME

See Also:

Constant Field Values

COUNT_DATASET_ADDED_TO_PROJECT_STMT

protected static final java.lang.String COUNT_DATASET_ADDED_TO_PROJECT_STMT

See Also:

Constant Field Values

Constructor Detail

CatalogResultsDatasetQuery

public CatalogResultsDatasetQuery()

Method Detail

getInstance

public static CatalogResultsDatasetQuery getInstance()

buildQuery

public com.endeca.mdex.eql_parser.types.Query buildQuery(CatalogDataSetModel viewModel,
                                                java.lang.String collectionKey,
                                                javax.portlet.PortletRequest request)
                                                  throws java.lang.Exception

Throws:

java.lang.Exception

buildQuery

public com.endeca.mdex.eql_parser.types.Query buildQuery(ViewModel viewModel,
                                                java.lang.String collectionKey,
                                                javax.portlet.PortletRequest request,
                                                boolean includeZonesData)
                                                  throws java.lang.Exception

Throws:

java.lang.Exception

processResults

public void processResults(CatalogDataSetModel viewModel,
                  java.util.List<com.endeca.mdex.conversation.types.ResultRecords> resultList,
                  long loggedInUserId,
                  javax.portlet.PortletRequest request)
                    throws ModelException,
                           java.text.ParseException,
                           com.liferay.portal.SystemException

Process the results set and update the viewmodel

Throws:

com.liferay.portal.SystemException

ModelException

java.text.ParseException

processResults

public void processResults(ViewModel viewModel,
                  java.util.List<com.endeca.mdex.conversation.types.ResultRecords> resultList,
                  long loggedInUserId,
                  javax.portlet.PortletRequest request,
                  boolean includeZonesData)
                    throws ModelException,
                           java.text.ParseException,
                           Formatter.FormatParseException,
                           com.liferay.portal.SystemException

Process the results object and update the viewmodel that is passed in

Throws:

java.text.ParseException

ModelException

Formatter.FormatParseException

com.liferay.portal.SystemException

getCollectionKey

public java.lang.String getCollectionKey()

translateAttributeKey

public java.lang.String translateAttributeKey(CatalogDataSetModel viewModel)

Specified by:

translateAttributeKey in interface CatalogResultsQuery

Overrides:

translateAttributeKey in class AbstractCatalogResultsQuery

queryQuickLookInfo

public DatasetsResultsObject queryQuickLookInfo(javax.portlet.PortletRequest request,
                                       java.lang.String selectedCollectionKey)
                                         throws DataSourceException,
                                                KeyNotFoundException,
                                                ModelException,
                                                java.text.ParseException,
                                                Formatter.FormatParseException,
                                                com.liferay.portal.SystemException,
                                                com.liferay.portal.PortalException

Throws:

DataSourceException

KeyNotFoundException

ModelException

java.text.ParseException

Formatter.FormatParseException

com.liferay.portal.SystemException

com.liferay.portal.PortalException

getQuickLookInfoQuery

public com.endeca.mdex.eql_parser.types.Query getQuickLookInfoQuery(javax.portlet.PortletRequest request,
                                                           java.lang.String selectedCollectionKey)
                                                             throws DataSourceException,
                                                                    KeyNotFoundException,
                                                                    com.liferay.portal.PortalException

'RELATED DATASETS' QUERY: DEFINE SELECTED_DATASET AS SELECT "system-bddDatasetInventory.collectionKey" AS collectionKey FROM system-bddDatasetInventory WHERE (collectionKey = '' OR ("system-bddDatasetInventory.published = 'false' AND parentCollectionName = '')); GROUP BY collectionKey; DEFINE PROJECT_RESULTS1 AS SELECT COUNT(1) as REC_COUNT FROM WHERE SOME dataset IN ".datasets" SATISFIES (dataset IN "SELECTED_DATASET") GROUP BY MEMBERS(".datasets") AS "relDataSetKey.datasets"; DEFINE DSINVENTORY_RESULTS AS SELECT "system-bddDatasetInventory.collectionKey" AS collectionKey, "system-bddDatasetInventory.displayName" AS displayName, "system-bddDatasetInventory.tag" AS tag, "system-bddDatasetInventory.description" AS description, "system-bddDatasetInventory.sourceType" AS sourceType, "system-bddDatasetInventory.sourceName" AS sourceName, "system-bddDatasetInventory.attributeCount" AS attributeCount, "system-bddDatasetInventory.recordCount" AS recordCount FROM system-bddDatasetInventory WHERE NOT ("system-bddDatasetInventory.collectionKey" IN SELECTED_DATASET); RETURN RELATED_DATASETS AS SELECT DSINVENTORY_RESULTS.collectionKey, DSINVENTORY_RESULTS.displayName, DSINVENTORY_RESULTS.description, DSINVENTORY_RESULTS.tag, DSINVENTORY_RESULTS.sourceType, DSINVENTORY_RESULTS.sourceName, DSINVENTORY_RESULTS.recordCount, DSINVENTORY_RESULTS.attributeCount, PROJECT_RESULTS.REC_COUNT AS relationCount FROM PROJECT_RESULTS JOIN DSINVENTORY_RESULTS ON (PROJECT_RESULTS."relDataSetKey".datasets" = DSINVENTORY_RESULTS.collectionKey) ORDER BY relationCount DESC; 'USED IN PROJECTS' QUERY: DEFINE PROJECT_RESULTS2 AS SELECT ARB(".name") AS projectName, ARB(".description") AS description, ARB(".tags") AS tags, ARB(".lastModified") AS lastModified, ARB(".creatorUserName") AS creatorUserName, ARB(".friendlyUrl") AS friendlyUrl, ".recordSpec" AS groupId FROM WHERE SOME dataset IN ".datasets" SATISFIES (dataset IN "SELECTED_DATASET") GROUP BY ".recordSpec", MEMBERS(".datasets") AS dataSetKey; DEFINE DSINVENTORY_RESULTS1 AS SELECT "system-bddDatasetInventory.collectionKey" AS collectionKey, "system-bddDatasetInventory.displayName" AS displayName FROM system-bddDatasetInventory; RETURN USED_IN_PROJECTS AS SELECT DSINVENTORY_RESULTS1.collectionKey, DSINVENTORY_RESULTS1.displayName, PROJECT_RESULTS1.groupId, PROJECT_RESULTS1.projectName, PROJECT_RESULTS1.description, PROJECT_RESULTS1.creatorUserName, PROJECT_RESULTS1.tags, PROJECT_RESULTS1.lastModified, PROJECT_RESULTS1.friendlyURL FROM PROJECT_RESULTS1 JOIN DSINVENTORY_RESULTS1 ON (PROJECT_RESULTS1.dataSetKey = DSINVENTORY_RESULTS1.collectionKey) GROUP BY PROJECT_RESULTS1.groupId;

Throws:

com.liferay.portal.PortalException

DataSourceException

KeyNotFoundException