Is this a new restriction? I have created filters and attributes for columns with a _key suffix and they work fine for me.
For example, I have a filter on a field called "marker_accession_id_105_key". The internalName for the filter is "marker_accession_id_105" and key is "marker_accession_id_105_key". On 4/17/09 8:01 AM, "Syed Haider" <[email protected]> wrote: Hi Jennifer, You need to replicate the primart key column if you want it to be displayed on the interface. any column with _key suffix would strictly be used for internal processing and wont be available on the interface.. Hope this helps, Syed 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 > -- Glen L. Beane Software Engineer The Jackson Laboratory Phone (207) 288-6153
