Versions Compared

Old Version 90

changes.mady.by.user Jesse Martinez

Saved on

compared with

New Version 91

changes.mady.by.user Jesse Martinez

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Code Block
url-encoded
http://cspacetest.collectionspace.org:8180/cspace-services/collectionobjects?as=collectionobjects_common%3aobjectProductionDateGroupList%2F0%2FdateEarliestScalarValue++%3E%3D++TIMESTAMP++%221953-12-31T19:00:00%22++AND++collectionobjects_common%3aobjectProductionDateGroupList%2F0%2FdateLatestScalarValue++%3C%3D++TIMESTAMP++%221954-12-31T19:00:00%22

Other parameters

Note

In progress

Description

NXQL string

DB string

API query string

Required

is record status completed and publishable?

collectionobjects_common.recordStatus

collectionobjects_common.recordstatus = "completedpublish"

AND collectionobjects_common:recordStatus = 'completedpublish'

Y

is object record deleted?

CSpace specific flag

misc.lifestylestate <> 'deleted'

&wf_deleted=false

Y

sort by

CSpace specific flag

ORDER BY collectionspace_core.updatedat

&sortBy=collectionspace_core:updatedAt

N

show only objects from a specific tenant

implied

collectionspace_core.tenantid=42

implied

Y

...

Unfortunately, there is no way to request movement record's currentLocation column value in the Relation service payload, which would aid in quickly filtering by the location authority value. Each movement record returned will need to be examined.

Some Additionally, some CollectionObject records may have more than one related movement record. Only the most recent movement record should be used and this is determined by comparing the locationDate value of each.

...