Vincent, By removing an attribute, you are removing a join between the datasets and hence you get the results as essentially a join translates to an intersection between the operands.
Syed On 12 December 2012 11:48, Vincent Le Texier < [email protected]> wrote: > Hello Everyone, > I have an issue regarding the attributes. > A far as I know, the query engine uses the filters to restrict the output > and attributes > *are only used* to display the values. > > From the same filter (restriction on the chromosome 2), This query returns > no results : > > PREFIX accesspoint: > <http://lumiere.lyon.fnclcc.fr/ICGC/martsemantics/genomicdb_process_test_config/ontology#><http://lumiere.lyon.fnclcc.fr/ICGC/martsemantics/genomicdb_process_test_config/ontology#> > PREFIX class: <biomart:// > lumiere.lyon.fnclcc.fr/ICGC/martsemantics/genomicdb_process_test_config/ontology/class# > > > PREFIX dataset: <biomart:// > lumiere.lyon.fnclcc.fr/ICGC/martsemantics/genomicdb_process_test_config/ontology/dataset# > > > PREFIX attribute: <biomart:// > lumiere.lyon.fnclcc.fr/ICGC/martsemantics/genomicdb_process_test_config/ontology/attribute# > > > > SELECT ?a0 ?a1 ?a2 ?a3 ?a4 > FROM dataset:public > WHERE { > ?mart attribute:process__simplemut_analysis__chr_106 "2" . > ?mart attribute:process__simplemut_analysis__end_pos_106 ?a0 . > ?mart attribute:process__simplemut_analysis__chr_106 ?a1 . > ?mart attribute:process__simplemut_analysis__start_pos_106 ?a2 . > ?mart attribute:sample__acc_1040 ?a3 . > ?mart attribute:file__library_sequence_file__run_acc_1018 ?a4 > } > > > Otherwise,I get results if I remove the attribute sample__acc_1040 > > > PREFIX accesspoint: > <http://lumiere.lyon.fnclcc.fr/ICGC/martsemantics/genomicdb_process_test_config/ontology#><http://lumiere.lyon.fnclcc.fr/ICGC/martsemantics/genomicdb_process_test_config/ontology#> > PREFIX class: <biomart:// > lumiere.lyon.fnclcc.fr/ICGC/martsemantics/genomicdb_process_test_config/ontology/class# > > > PREFIX dataset: <biomart:// > lumiere.lyon.fnclcc.fr/ICGC/martsemantics/genomicdb_process_test_config/ontology/dataset# > > > PREFIX attribute: <biomart:// > lumiere.lyon.fnclcc.fr/ICGC/martsemantics/genomicdb_process_test_config/ontology/attribute# > > > > SELECT ?a0 ?a1 ?a2 ?a3 > FROM dataset:public > WHERE { > ?mart attribute:process__simplemut_analysis__chr_106 "2" . > ?mart attribute:process__simplemut_analysis__end_pos_106 ?a0 . > ?mart attribute:process__simplemut_analysis__chr_106 ?a1 . > ?mart attribute:process__simplemut_analysis__start_pos_106 ?a2 . > ?mart attribute:file__library_sequence_file__run_acc_1018 ?a3 > } > > I have three datasets (genomicDB, SampleTraker Sample and SampleTracker > File). I made a link from > GenomicDB to SampleTraker Sample and GenomicDB to SampleTracker File (*The > links are correct*). > From GenomicDB : > If I use attributes only from SampleTraker Sample *or *SampleTracker > File, I'll get the expected result. > If I use attributes from SampleTraker Sample *(*attribute sample__acc_1040) > *and* SampleTracker File (file__library_sequence_file__run_acc_1018), > I'll get no results. > > Any ideas ? I am a bit lost with that ! > > > -- > > _______________________________________________ > Users mailing list > [email protected] > https://lists.biomart.org/mailman/listinfo/users > >
_______________________________________________ Users mailing list [email protected] https://lists.biomart.org/mailman/listinfo/users
