org.springframework.data.mongodb.repository.Query Java Examples

@Query(value = "{accountNumber : ?0}")
Collection<CloudInstance> findByAccountNumber(String accountNumber);
 

@Query(value= "{ tags: ?0 }")
Collection<CloudVirtualNetwork> findByTags(List<NameValue> tags);
 

@Query("{_hidden: {$ne: true}, _dummy: {$ne: true}, id: {$gt: ?0}}")
List<Event> consumeEvent(Long id, Pageable pageable);
 

@Query(value = "{ 'updatedTimeStamp' : {$ne : ?0} }")
List<Vast> getOldVastDetails(Long timeStamp);
 

@Query("{ $and: [ {'scheduledNotifications.REMIND.active': true }, { $where: 'this.scheduledNotifications.REMIND.lastNotified < " +
		"new Date(new Date().setDate(new Date().getDate() - this.scheduledNotifications.REMIND.frequency ))' }] }")
@CatAnnotation
List<Recipient> findReadyForRemind();
 

@Query(value="{'options.applicationName' : ?1, 'collectorId' : ?0}")
List<CollectorItem> findByOptionsAndDeployedApplicationName(ObjectId collectorId, String applicationName);
 

@Query(value="{ 'collectorId' : ?0, options.instanceUrl : ?1, options.jobName : ?2}")
T findJob(ObjectId collectorId, String instanceUrl, String jobName);
 

@Query("{ 'collectorItemId': ?0, 'artifactGroupId' : ?1, 'artifactModule' : ?2, 'artifactVersion' : ?3, 'artifactName' : ?4, 'artifactClassifier' : ?5, 'artifactExtension' : ?6 }")
Iterable<BinaryArtifact> findByAttributes(Object collectorItemId, String artifactGroupId, String artifactModule, String artifactVersion, String artifactName, String artifactClassifier, String artifactExtension);
 

@Query("{ 'artifactGroupId' : ?0, 'artifactModule' : ?1, 'artifactVersion' : ?2, 'artifactName' : ?3, 'artifactClassifier' : ?4, 'artifactExtension' : ?5 }")
Iterable<BinaryArtifact> findByAttributes(String artifactGroupId, String artifactModule, String artifactVersion, String artifactName, String artifactClassifier, String artifactExtension);
 

@Query("{ 'authors.1': { $exists: true } }")
Flux<Book> booksWithFewAuthors();
 

@Query(value="{'application.components.$id': {$in : ?0 }}")
List<Dashboard> findByApplicationComponentIdsIn(Collection<ObjectId> componentIds);
 

@Query(value = "{'eid': {'$in' : ?0 }}")
List<PortfolioResponse> getByEids(List<String> eids);
 

@Query(value = "{'collectorItems.SCM._id': ?0}")
List<Component> findBySCMCollectorItemId(ObjectId scmCollectorItemId);
 

@Query(value="{'projectId' : ?0, options.iterationId : ?1}")
RallyFeature findByRallyWidgetDetails(String projectId,String iterationId);
 

@Query(value = "{ 'collectorId' : ?0 }")
List<Team> findByCollectorId(ObjectId collectorId);
 

@Query("{id: {$gt: ?0}}")
List<Event> findGreaterThanId(Long id, Sort sort);
 

@Query(value = " {'appId' : ?0, 'isUnlimitedData' : ?1}")
StashDetailsInfo checkByAppIdAndIsUnlimitedData(String appId, boolean isUnlimitedData);
 

@Query(value = "{'severity' : {$in : ?0}, 'openTime' : {$gt : ?1, $lt : ?2}}", count = true)
long countIncidentsBySeverityAndOpenTimeBetween (String[] severityValues, long startDate, long endDate);
 

@Query(value = " {'eid' : {$in : ?0 }}")
List<ExecutiveSummaryList> getEids(List<String> reportings);
 

@Query(value = " {'sNumber' : ?0 }")
List<Feature> getStoryByNumber(String sNumber);
 

@Query(value="{ 'collectorItemId': ?0, 'scmCommitTimestamp': { $gt: ?1 }}")
List<Commit> findByCollectorItemIdAndScmCommitTimestamp(ObjectId collectorItemid, Long scmCommitTimestampThreshold);
 

@Query(value = "{'severity' : {$in : ?0}, 'openTime' : {$gt : ?1, $lt : ?2}}")
Page<Incident> findIncidentsBySeverityAndOpenTimeBetween (String[] severityValues, long startDate, long endDate, Pageable pageable);
 

@Query(value="{'options.projectId' : ?0}")
CollectorItem findByJiraProjectId(String projectId);
 

@Query(value="{'type': {$in : [null, 'Team']}}")
List<Dashboard> findTeamDashboards();
 

@Query(value = " {'appId' : ?0}")
StashDashboardInfo checkByAppId(String appId);
 

@Query(value = " {'appId' : ?0, 'isUnlimitedData' : ?1}")
StashDashboardInfo checkByAppIdAndIsUnlimitedData(String appId, boolean isUnlimitedData);
 

@Query(value = "{ 'collectorId' : ?0 }")
List<TeamInventory> findByCollectorId(ObjectId collectorId);
 

@Query(value="{'options.projectId' : ?2, 'niceName' : ?1, 'collectorId' : ?0}")
CollectorItem findByCollectorIdNiceNameAndProjectId(ObjectId collectorId, String niceName, String projectId);
 

@Query(value = "{ collectorItemId:  ?0 }")
CloudVirtualNetwork findByCollectorItemId(ObjectId collectorItemId);
 

@Query(value="{ 'collectorId': { $in: ?0 }, ?1 : {$regex : '.*?2.*', $options: 'i'}}")
Page<CollectorItem> findByCollectorIdAndSearchField(List<ObjectId> collectorId, String searchField, String searchFieldValue, Pageable pageable);