/
Instances, Holdings, Items - Cross-tenant query expectations (ECS)

Instances, Holdings, Items - Cross-tenant query expectations (ECS)

The expected behaviors documented on this page are specific to the Lists app (and FQM) when querying Instance, Holdings, and Item records within in an ECS environment. The behavior is dependent on what context you’re querying from - whether your active affiliation is the Central tenant, or if your active affiliation is a Member tenant. To make it easier to distinguish the context at a glance, the table header color indicates the active affiliation: blue indicates the active affiliation is the Central tenant, and gray indicates the active affiliation is a member tenant.

General background:

Instance records -

Querying Instance records when active affiliation is Central tenant

Assume the user has required affiliations and permissions

Record type

Included in results?

Record type

Included in results?

Instance in active affiliation (Central):

  • Shared instance (Instance sharing enabled)

  • Local instance (Instance sharing disabled)

Yes

Instance in non-active affiliation (Member):

  • Instance local to non-active affiliation

Yes

Querying Instance records when active affiliation is a Member tenant

Assume the user has required affiliations and permissions

Record type

Included in results?

Record type

Included in results?

Instance in active affiliation (Member)

  • Instance local to active affiliation

True

Instance in non-active affiliation (Central)

  • Instances shared from Central tenant (Instance sharing enabled)

True

Instance in non-active affiliation (other Member or Central)

  • Instance local to non-active affiliation (other Member)

  • Instance local to Central tenant (Instance sharing disabled)

False

Holdings records

Querying Holdings records when active affiliation is Central tenant

Assume the user has required affiliations and permissions

Record type

Included in results?

Record type

Included in results?

Holdings in active affiliation (Central):

  • associated with shared instance

  • associated with instance local to active affiliation

True

Holdings in non-active affiliation (Member):

  • associated with shared instance

  • associated with instance local to non-active affiliation

True

Querying Holdings records when active affiliation is a Member tenant

Assume the user has required affiliations and permissions

Record type

Included in results?

Record type

Included in results?

Holdings in active affiliation (Member):

  • associated with shared instance

  • associated with instance local to active affiliation

True

Holdings in non-active affiliation (other Member or Central):

  • associated with shared instance

  • associated with instance local to non-active affiliation

False

Item records

Querying Item records when active affiliation is Central tenant

Assume the user has required affiliations and permissions

Record type

Included in results?

Record type

Included in results?

Item in active affiliation (Central):

  • associated with shared instance

  • associated with instance local to active affiliation

True

Items in non-active affiliation (Member):

  • associated with shared instance

  • associated with instance local to non-active affiliation

True

Querying Item records when active affiliation is a Member tenant

Assume the user has required affiliations and permissions

Record type

Included in results?

Record type

Included in results?

Item in active affiliation (Member):

  • associated with shared instance

  • associated with instance local to active affiliation

True

Item in non-active affiliation (other Member or Central):

  • associated with shared instance

  • associated with instance local to non-active affiliation

False