Batch compute visibility for collection filtering

Queries visibility status for multiple collections in a single database call. Returns a data.table with collection UUIDs and their visibility flags.

Usage

get_collect_visibility(artists, collects, cn = NULL)

Arguments

artists

Character vector. Artist UUIDs.

collects

Character vector. Collection UUIDs.

cn

Database connection. If NULL, creates a connection via artcore::dbc() and closes it on exit. Pass an existing connection to batch multiple queries efficiently.

Value

data.table with columns:

collection_uuid

Collection UUID

is_visible

Logical visibility flag

Details

Visibility is determined by the following priority:

1. Explicit visibility_override takes precedence

2. Completed collections (status = 'complete') are visible by default

3. WIP collections inherit from artist's default_wip_collection_visibility

See also

Other settings: get_collection_settings(), get_collections_settings(), is_collection_visible(), update_collection_settings(), upsert_artist_preferences()