Olivier, I'm afraid this won't work, as the sqlExpression has to be a SQL expression that can be used anywhere, including WHERE clauses.
If you can create a view in your DB, that would be one way of solving the issue. Best, Richard On 7 Mar 2013, at 08:26, olivier evalet wrote: > Hi, > > I'm just wondering if there is a way to use aggregates COUNT for mapping? > > map:Entries_antibody a d2rq:PropertyBridge; > d2rq:belongsToClassMap map:Entries; > d2rq:property np:antibody; > d2rq:datatype xsd:integer; > d2rq:sqlExpression "COUNT(DISTINCT(antibody.unique_name))"; > d2rq:join "protein.identifier_id = > mapping_annotations.reference_identifier_id "; > d2rq:join "mapping_annotations.mapped_identifier_id = > antibody.identifier_id "; > d2rq:condition "mapping_annotations.cv_type_id = 5"; > d2rq:alias "sequence_identifiers AS antibody". > > > > With this mapping I get the postgres error: > ERROR: aggregates not allowed in WHERE clause > Any idea? > > -- olivier > > > ------------------------------------------------------------------------------ > Symantec Endpoint Protection 12 positioned as A LEADER in The Forrester > Wave(TM): Endpoint Security, Q1 2013 and "remains a good choice" in the > endpoint security space. For insight on selecting the right partner to > tackle endpoint security challenges, access the full report. > http://p.sf.net/sfu/symantec-dev2dev_______________________________________________ > d2rq-map-devel mailing list > d2rq-map-devel@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/d2rq-map-devel ------------------------------------------------------------------------------ Symantec Endpoint Protection 12 positioned as A LEADER in The Forrester Wave(TM): Endpoint Security, Q1 2013 and "remains a good choice" in the endpoint security space. For insight on selecting the right partner to tackle endpoint security challenges, access the full report. http://p.sf.net/sfu/symantec-dev2dev _______________________________________________ d2rq-map-devel mailing list d2rq-map-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/d2rq-map-devel
