If it works by just changing the internalName, thats even better.
Apologies for earlier suggestion.
Best,
Syed
Glen Beane wrote:
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