Thanks very much Daz et al, I have got the PKs working in the mart explorer now. One little issue I have now is with my 'year' data. Mart explorer displays the years in my query results as '2006-01-01', when I store only '2006' (as year datatype) in my biomart MySQL database. Any ideas why that is? It's not major but just a bit unexpected. Jenny
From: Darren Oakley [mailto:[email protected]] Sent: 17 April 2009 13:21 To: Mead, Jennifer Cc: [email protected] Subject: Re: [mart-dev] explorer and primary keys Hi Jenny, The naive import import in MartEditor ignores the primary keys for the tables, that's why they've not shown up. Just copy one of the other attributes/filters from the same table and then change the field name to match the primary key column. Cheers, Daz Mead, Jennifer wrote: I have successfully created a mart using my MySQL database, and I can view the filters/ attributes in the explorer, querying works using the explorer. The problem is that my primary key fields are missing from the explorer (but are present in the underlying biomart version of my database). Can anyone give me an idea of how I can get the explorer to see all my fields (including the keys)? The PKs happen to be very important for my interface design. Is the problem perhaps that I have multiple PKs 'MUL' (i.e. compound PKs) in my table? Thanks Jenny -- The Wellcome Trust Sanger Institute is operated by Genome Research Limited, a charity registered in England with number 1021457 and a company registered in England with number 2742969, whose registered office is 215 Euston Road, London, NW1 2BE.
