Styjun

How could an armless race establish civilization?

How do ohm meters measure high resistances?

Quantum jump/leap, exist or not, and instantaneous or not (for electrons)?

How do I create a new column in a dataframe from an existing column using conditions?

Reusable spacecraft: why still have fairings detach, instead of open/close?

Why wasn't EBCDIC designed with contiguous alphanumeric characters?

Do home values typically rise and fall consistently across different price ranges?

What election rules and voting rights are guaranteed by the US Constitution?

Undetectable mail tracker

Why did the Apple //e make a hideous noise if you inserted the disk upside down?

How to handle async subshell exit

Cooking a nice pan seared steak for picky eaters

"I am [the / an] owner of a bookstore"?

What prevents a US state from colonizing a smaller state?

Why isn't UDP with reliability (implemented at Application layer) a substitute of TCP?

Where to connect the fuse and why?

Why do movie directors use brown tint on Mexico cities?

How can I know if a PDF file was created via LaTeX or XeLaTeX?

Why doesn't SpaceX land boosters in Africa?

Origin of the convolution theorem

Could you fall off a planet if it was being accelerated by engines?

Is ALTER TABLE ... DROP COLUMN really a metadata only operation?

Can purchasing tickets for high holidays services count as maaser?

Adjective for 'made of pus' or 'corrupted by pus' or something of something of pus

Spring/Java Mongo query: How to add values of a field from multiple documents as an array while grouping/projecting

How to remove a field completely from a MongoDB document?mongodb group values by multiple fieldsHow to merge array field in document in Mongo aggregationSpring data mongo db query on inner fields of embedded document (DBRef)Mongo Query On Multiple Fields Of Sub-DocumentGroup by array of document in Spring Mongo DbMongo aggregate group by multiple valuesmongo group and project for nested documentsProject as nested document in spring mongoQuery on Embedded Array Of Document in mongo based on multiple fields in spring

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;

0

My records look like below:

 
 domain: 'ABC',
 technology: 'Java',
 appName: 'app1',
 environment: 'Dev',
 version : '1_1',

 domain: 'ABC',
 technology: 'Java',
 appName: 'app1',
 environment: 'SQA',
 version : '1_1',

 domain: 'ABC',
 technology: 'Java',
 appName: 'app2',
 environment: 'Dev',
 version : '1_1',

 domain: 'DEF',
 technology: '.NET',
 appName: 'app3',
 environment: 'SQA',
 version: '1_3'

 

Final result is to get the list of apps's environment and version grouped by domain and tech(1 to 1 mapping between these two). Environment/Domain/Tech will be input. if that environment does not exist, then I still want to show on result, with version as N/A.

[
 
 "domain": "ABC",
 "technology": "Java",
 "apps": [ 
 
 "appName": "app1",
 "environment": ["Dev","SQA"],
 "version": ["1_1", "1_1"],
 "hasVersionDiff": false
 , 
 
 "appName": "app2",
 "environment": ["Dev","SQA"],
 "version": ["1_1", "N/A"],
 "hasVersionDiff": true ]
 ,
 
 "domain": "DEF",
 "technology": ".NET",
 "apps": [ 
 "appName": "app3",
 "environment": ["Dev","SQA"],
 "version": ["N/A", "1_1"],
 "hasVersionDiff": true
 
 ]
 ]

So far I have tried below:

Aggregation agg = Aggregation.newAggregation(
 Aggregation.match(cr),

Aggregation.group("domain").first("technology").as("technology")
 .addToSet(new BasicDBObject() 
 
 put("technology", "$technology");
 put("domain", "$domain");
 put("environment","$environment");
 put("version", "$version");
 put("appName", "$appName");
 
 
 ).as("apps"));

But this is giving me result as below, where for each app it is showing me two diff record for each env, also I am not able figure out how to apply hasVersionDiff value for them:

[

 
 "domain": "ABC",
 "technology": "Java",
 "apps": [ 
 "appName": "app1",
 "environment": ["DEV"],
 "version": ["1_1"],
 "hasVersionDiff": false 
 , 
 "appName": "app1",
 "environment": ["SQA"],
 "version": ["1_1"],
 "hasVersionDiff": false 
 
]
 

etc..

My model class is as below:
CompareResult has domain, technology and ArrayList apps
App has appName, List of environments, list of versions and hasVersionDiff boolean.

mongodb mongodb-query aggregation-framework spring-data-mongodb

share|improve this question

asked Mar 25 at 14:39

user2262292user2262292

2977 bronze badges

add a comment | 

0

My records look like below:

 
 domain: 'ABC',
 technology: 'Java',
 appName: 'app1',
 environment: 'Dev',
 version : '1_1',

 domain: 'ABC',
 technology: 'Java',
 appName: 'app1',
 environment: 'SQA',
 version : '1_1',

 domain: 'ABC',
 technology: 'Java',
 appName: 'app2',
 environment: 'Dev',
 version : '1_1',

 domain: 'DEF',
 technology: '.NET',
 appName: 'app3',
 environment: 'SQA',
 version: '1_3'

 

Final result is to get the list of apps's environment and version grouped by domain and tech(1 to 1 mapping between these two). Environment/Domain/Tech will be input. if that environment does not exist, then I still want to show on result, with version as N/A.

[
 
 "domain": "ABC",
 "technology": "Java",
 "apps": [ 
 
 "appName": "app1",
 "environment": ["Dev","SQA"],
 "version": ["1_1", "1_1"],
 "hasVersionDiff": false
 , 
 
 "appName": "app2",
 "environment": ["Dev","SQA"],
 "version": ["1_1", "N/A"],
 "hasVersionDiff": true ]
 ,
 
 "domain": "DEF",
 "technology": ".NET",
 "apps": [ 
 "appName": "app3",
 "environment": ["Dev","SQA"],
 "version": ["N/A", "1_1"],
 "hasVersionDiff": true
 
 ]
 ]

So far I have tried below:

Aggregation agg = Aggregation.newAggregation(
 Aggregation.match(cr),

Aggregation.group("domain").first("technology").as("technology")
 .addToSet(new BasicDBObject() 
 
 put("technology", "$technology");
 put("domain", "$domain");
 put("environment","$environment");
 put("version", "$version");
 put("appName", "$appName");
 
 
 ).as("apps"));

But this is giving me result as below, where for each app it is showing me two diff record for each env, also I am not able figure out how to apply hasVersionDiff value for them:

[

 
 "domain": "ABC",
 "technology": "Java",
 "apps": [ 
 "appName": "app1",
 "environment": ["DEV"],
 "version": ["1_1"],
 "hasVersionDiff": false 
 , 
 "appName": "app1",
 "environment": ["SQA"],
 "version": ["1_1"],
 "hasVersionDiff": false 
 
]
 

etc..

My model class is as below:
CompareResult has domain, technology and ArrayList apps
App has appName, List of environments, list of versions and hasVersionDiff boolean.

mongodb mongodb-query aggregation-framework spring-data-mongodb

share|improve this question

asked Mar 25 at 14:39

user2262292user2262292

2977 bronze badges

add a comment | 

My records look like below:

 
 domain: 'ABC',
 technology: 'Java',
 appName: 'app1',
 environment: 'Dev',
 version : '1_1',

 domain: 'ABC',
 technology: 'Java',
 appName: 'app1',
 environment: 'SQA',
 version : '1_1',

 domain: 'ABC',
 technology: 'Java',
 appName: 'app2',
 environment: 'Dev',
 version : '1_1',

 domain: 'DEF',
 technology: '.NET',
 appName: 'app3',
 environment: 'SQA',
 version: '1_3'

 

Final result is to get the list of apps's environment and version grouped by domain and tech(1 to 1 mapping between these two). Environment/Domain/Tech will be input. if that environment does not exist, then I still want to show on result, with version as N/A.

[
 
 "domain": "ABC",
 "technology": "Java",
 "apps": [ 
 
 "appName": "app1",
 "environment": ["Dev","SQA"],
 "version": ["1_1", "1_1"],
 "hasVersionDiff": false
 , 
 
 "appName": "app2",
 "environment": ["Dev","SQA"],
 "version": ["1_1", "N/A"],
 "hasVersionDiff": true ]
 ,
 
 "domain": "DEF",
 "technology": ".NET",
 "apps": [ 
 "appName": "app3",
 "environment": ["Dev","SQA"],
 "version": ["N/A", "1_1"],
 "hasVersionDiff": true
 
 ]
 ]

So far I have tried below:

Aggregation agg = Aggregation.newAggregation(
 Aggregation.match(cr),

Aggregation.group("domain").first("technology").as("technology")
 .addToSet(new BasicDBObject() 
 
 put("technology", "$technology");
 put("domain", "$domain");
 put("environment","$environment");
 put("version", "$version");
 put("appName", "$appName");
 
 
 ).as("apps"));

But this is giving me result as below, where for each app it is showing me two diff record for each env, also I am not able figure out how to apply hasVersionDiff value for them:

[

 
 "domain": "ABC",
 "technology": "Java",
 "apps": [ 
 "appName": "app1",
 "environment": ["DEV"],
 "version": ["1_1"],
 "hasVersionDiff": false 
 , 
 "appName": "app1",
 "environment": ["SQA"],
 "version": ["1_1"],
 "hasVersionDiff": false 
 
]
 

etc..

My model class is as below:
CompareResult has domain, technology and ArrayList apps
App has appName, List of environments, list of versions and hasVersionDiff boolean.

mongodb mongodb-query aggregation-framework spring-data-mongodb

share|improve this question

asked Mar 25 at 14:39

user2262292user2262292

2977 bronze badges

 
 domain: 'ABC',
 technology: 'Java',
 appName: 'app1',
 environment: 'Dev',
 version : '1_1',

 domain: 'ABC',
 technology: 'Java',
 appName: 'app1',
 environment: 'SQA',
 version : '1_1',

 domain: 'ABC',
 technology: 'Java',
 appName: 'app2',
 environment: 'Dev',
 version : '1_1',

 domain: 'DEF',
 technology: '.NET',
 appName: 'app3',
 environment: 'SQA',
 version: '1_3'

 

[
 
 "domain": "ABC",
 "technology": "Java",
 "apps": [ 
 
 "appName": "app1",
 "environment": ["Dev","SQA"],
 "version": ["1_1", "1_1"],
 "hasVersionDiff": false
 , 
 
 "appName": "app2",
 "environment": ["Dev","SQA"],
 "version": ["1_1", "N/A"],
 "hasVersionDiff": true ]
 ,
 
 "domain": "DEF",
 "technology": ".NET",
 "apps": [ 
 "appName": "app3",
 "environment": ["Dev","SQA"],
 "version": ["N/A", "1_1"],
 "hasVersionDiff": true
 
 ]
 ]

Aggregation agg = Aggregation.newAggregation(
 Aggregation.match(cr),

Aggregation.group("domain").first("technology").as("technology")
 .addToSet(new BasicDBObject() 
 
 put("technology", "$technology");
 put("domain", "$domain");
 put("environment","$environment");
 put("version", "$version");
 put("appName", "$appName");
 
 
 ).as("apps"));

 
 "domain": "ABC",
 "technology": "Java",
 "apps": [ 
 "appName": "app1",
 "environment": ["DEV"],
 "version": ["1_1"],
 "hasVersionDiff": false 
 , 
 "appName": "app1",
 "environment": ["SQA"],
 "version": ["1_1"],
 "hasVersionDiff": false 
 
]
 

share|improve this question

asked Mar 25 at 14:39

user2262292user2262292

2977 bronze badges

share|improve this question

asked Mar 25 at 14:39

user2262292user2262292

2977 bronze badges

asked Mar 25 at 14:39

user2262292user2262292

2977 bronze badges

asked Mar 25 at 14:39

user2262292user2262292

2977 bronze badges