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
