Search for objects with no assigned storage

bowbot

This may seem obvious to some, so forgive me for not quite getting it. How to find objects with no storage location?

seth

It depends upon how you're tracking location. There are several possibilities.

bowbot

Three approaches I have taken:

[1] If I search (ca_storage_locations.idno:)

I get a list of every object int he collection about 50K

If I search (ca_storage_locations.idno:)

I get every object in a related storage location about 18K

Is it possible to do a reverse wildcard? 

[2] Another approach was to search by collective access object id.

Everything above 18K does not have a storage location

Searching by the object ID created by the application (ca_objects.object_id:*)

Yields zero results

[3] There is legacy location text  field where I can search and capture a few thousand, but the remainder are blank.  

I can pull the blank ones up using [BLANK]  but there are some with locations. I could make a set and remove the locations leaving only the blanks. and combine the other few thousand in to a complete of set of objects with no known location.

zelten

If I understood right your question and you can query the sql server you can use a query like this:SELECT object_id FROM ca_objects WHERE deleted=0 AND object_id NOT IN (  SELECT object_id   FROM ca_objects_x_storage_locations  );