Hi Syed, I have been using Mart Explorer because Phil Jones ran a session on using Biomart at the Uni, so I was more familiar with it. I will try to get martview working myself first, then see what happens from there. Thank you for your quick response to my problem Jennifer
-----Original Message----- From: Syed Haider [mailto:[email protected]] Sent: 21 April 2009 12:58 To: Mead, Jennifer Cc: [email protected] Subject: Re: [mart-dev] query does not constrain anything Hi Jennifer, The WHERE clause is dropping the filter value thats suggests it probably relates to query compiler of MartExplorer. MartExplorer is not well supported and maintained anymore, I would suggest to move to MartView and see if you can reproduce the problem. To save time, if your database is either: - public accessible, send me the connection params OR - if its of reasonable size, send me the dump and i will setup a test instance of MartView with your data and see if we can reproduce the problem on MartView. Hope this helps, Syed Mead, Jennifer wrote: > My biomart is not working when I run queries from mart explorer. For > example, I can enter a term in the filter on which I want to constrain > my results and click a few attribute check boxes for the things I'd like > to display. The problem is that results for everything is returned (for > that column), not just the items corresponding to my filter search term. > > I have enabled logging so I can monitor the SQL which underlies the > query I am trying to run. I see that in the 'where' clause there is no > mention of my search term e.g. no ' where pep_seq = "FGHASGGALSK" ', if > I am filtering on peptide sequence. > > Could anyone give me a clue as to what's going on here? I'm guessing > it's the mart I've created, but not sure. I have only one table (main) > and one table (dm), linked via keys - these look ok to me. Could my > issue be that I have multiple key fields? > > Thanks > > Jenny > > > > > > > > > > >
