gistfile1.java

Map<String, Integer>listDistinctDepositionalEnvironments(query) {
		HibernateCriteriaBuilder builder = OutcropSection.createCriteria()
		Collection results = builder.list {
			resultTransformer(AliasToEntityMapResultTransformer.INSTANCE)
			query.modern ? isNotNull("modernDepositionalSetting") : isNotNull("depositionalSetting")
			eq("grossDepositionalEnvironment", query.grossDepEnv)
			depositionalSetting {
				if(query.basinType) 'in'("basinType", query.basinType)
				if(query.paleoClimate)'in'("paleoClimate", query.paleoClimate)
			}
			depositionalEnvironment {
				if(query.depEnv) 'in'("type", query.depEnv)
				subEnvironment {
					if(query.subDepEnv) 'in'("type", query.subDepEnv)
					isNotEmpty("architecturalElement") //to not get back outcrops that does not have archielements
					architecturalElement {
						if(query.archiEleType) 'in'("type", query.archiEleType)
						isNotNull("avgGeometry")
					}
				}
			}
			projections {
				depositionalEnvironment {
					groupProperty("type", "keyName")
					subEnvironment {
						architecturalElement {
							count("id", "countValue")
						}
					}
				}
			}
		}