Query - Unhide collectionobject id?

Get Help
1

Hi,

By default collection object “id” (collectionobject.collectionobjectid) is hidden in the CO query.

Is it possible to unhide the id so the users can add it easily in their queries? This field is not displayed in the schema config.

Thanks,

Alexis

2

Hi @alexis.beck,

The ID field in every table is meant to be hidden by default for the user. There are a few exceptions, but most (including collectionobject) have this field as hidden since there is not a corresponding Schema Config record for it.

In most cases, we expect users to query on user-assigned identifiers (e.g. CatalogNumber, AltCatalogNumber) or unique identifiers intended for publishing (GUID).

In your use case, is there a specific reason you regularly use ID in queries? Are you looking for cases where a particular record is absent, or do you search for it directly?

3

Hi @Grant ,

Thanks for the explanation.

For our mammal collection, tissues coming from other institutions often don’t have a catalog number. They do have sample IDs, but these are not unique by design. For such objects, we prefer to use an internal ID as the identifier. The ID field is very convenient for this purpose, as it is simple to read (whereas a GUID is too complex).

Best,

Alexis

4

Hi @alexis.beck,

I’ve opened a new feature request describing the functionality I believe you are looking for:

Can you let me know if this matches what you want to see?

1 Like
6

Perfect! Thanks!

7

This is related to this post by @sorosoro, and covered in this closed issue.
I think the solution to this issue would solve that one too!

2 Likes
8

Hi @nfshoobs– thanks so much for looking out!

I will merge these together. This significantly strengthens the request, as there is now interest from several major consortium members. :flexed_biceps:

9

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.