Hi Darren, It may help if you turn on the log to exam the actual SQL queries being executed. To do that please modify log4perl.conf file under conf folder, set:
log4perl.logger = INFO,logFile log4perl.appender.logFile.filename = /full/path/to/the/log/file.log [put the real full path to the log file as your choice] Restart Apache and fire three queries with filter set to one of the follows respectively: <Filter name = "pipeline" value = "KOMP-CSD"/> or <Filter name = "pipeline" value = "EUCOMM"/> or <Filter name = "pipeline" value = "KOMP-CSD,EUCOMM"/> Then look into the log file for SQL statements which should be able to give you some more information. Help this helps! Junjun On 11-01-31 6:19 AM, "Darren Oakley" <[email protected]> wrote: Hi All, Hope you can help me with this one... I have a filter on one of our marts (www.knockoutmouse.org <http://www.knockoutmouse.org/> , idcc_targ_rep dataset) configured as a multi-select like so: --- <FilterCollection displayName="Pipeline" internalName="pipeline"> <FilterDescription displayName="Pipeline" displayType="list" field="pipeline" internalName="pipeline" key="id_1022_key" legal_qualifiers="=" multipleValues="1" qualifier="=" style="menu" tableConstraint="main" type="list"> <Option displayName="KOMP-CSD" internalName="KOMP-CSD" isSelectable="true" value="KOMP-CSD"/> <Option displayName="KOMP-Regeneron" internalName="KOMP-Regeneron" isSelectable="true" value="KOMP-Regeneron"/> <Option displayName="EUCOMM" internalName="EUCOMM" isSelectable="true" value="EUCOMM"/> <Option displayName="NorCOMM" internalName="NorCOMM" isSelectable="true" value="NorCOMM"/> <Option displayName="mirKO" internalName="mirKO" isSelectable="true" value="mirKO"/> </FilterDescription> </FilterCollection> --- But, it's producing unexpected results when you query for either of the pipelines separately, or together... i.e. the following xml: --- <?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE Query> <Query virtualSchemaName = "default" formatter = "CSV" header = "0" uniqueRows = "1" count = "" datasetConfigVersion = "0.6" > <Dataset name = "idcc_targ_rep" interface = "default" > <Filter name = "pipeline" value = "KOMP-CSD,EUCOMM"/> <Attribute name = "escell_clone" /> </Dataset> </Query> --- retrieves 129816 rows of data, but when you do the different pipelines separately, they do not add up to this number... KOMP-CSD on its own is 59440 EUCOMM on its own is 76076 So, combined they give 135516 rows of results - 5700 more than the first query! The attribute i'm selecting ('escell_clone') is unique for every row in the database, so it's not that i'm getting duplicates for the separate queries. Any ideas as to why i'm getting this shortfall in the first query? Is there something wrong with the way I set up the filter? Any help is much appreciated. :) Thanks, Daz
_______________________________________________ Users mailing list [email protected] https://lists.biomart.org/mailman/listinfo/users
