# Get Item Record Set Data Based on Organization Owner

**URL:** https://forum.innovativeusers.org/t/get-item-record-set-data-based-on-organization-owner/1216
**Category:** Polaris Repository
**Tags:** cp-migration, polaris-items
**Created:** [June 2, 2023, 9:01pm UTC](https://forum.innovativeusers.org/t/get-item-record-set-data-based-on-organization-owner/1216 "2023-06-02T21:01:45Z")
**Posts on this page:** 1
**Page:** 1

<div class="post-metadata">

### Author: ![system](https://forum.innovativeusers.org/uploads/db7787/original/2X/8/8519ee8eef6492f310ea87d4ce482d931f01eef2.png) [@system](https://forum.innovativeusers.org/u/system)
#### Post date: [June 2, 2023, 9:01pm UTC](https://forum.innovativeusers.org/t/get-item-record-set-data-based-on-organization-owner/1216/1 "2023-06-02T21:01:45Z")

</div>

# Get Item Record Set Data Based on Organization Owner

This query pulls item record information from item record sets based upon a given record set owner. So if you need to see the information in record sets owned by branch or library, this will get that for you.

```SQL
SELECT
    rs.RecordSetID AS [Record Set ID],
    rs.Name AS [Record Set Name],
    br.BrowseTitle AS [Browse Title],
    o.Name AS [Record Set Owner],
    c.Name AS [Collection],
    mat.Description AS [Material Type],
    br.BrowseAuthor AS [Browse Author],
    br.BrowseCallNo AS [Call Number],
    ird.VolumeNumber AS [Volume],
    ist.Description AS [Circ Status],
    cir.Barcode AS [Item Barcode],
    cir.LastCircTransactionDate AS [Last Circ Transaction],
    irs.ItemRecordID AS [Item Record ID]

FROM
    Polaris.Polaris.RecordSets rs WITH (NOLOCK)

INNER JOIN
    Polaris.Polaris.ItemRecordSets irs WITH (NOLOCK) ON irs.RecordSetID = rs.RecordSetID
INNER JOIN
    Polaris.Polaris.CircItemRecords cir WITH (NOLOCK) ON irs.ItemRecordID = cir.ItemRecordID
INNER JOIN
    Polaris.Polaris.Collections c WITH (NOLOCK) ON c.CollectionID = cir.AssignedCollectionID
INNER JOIN
    Polaris.Polaris.Organizations o WITH (NOLOCK) ON o.OrganizationID = rs.OrganizationOwnerID
INNER JOIN
    Polaris.Polaris.MaterialTypes mat WITH (NOLOCK) ON mat.MaterialTypeID = cir.MaterialTypeID
INNER JOIN
    Polaris.Polaris.BibliographicRecords br WITH (NOLOCK) ON br.BibliographicRecordID = cir.AssociatedBibRecordID
INNER JOIN
    Polaris.Polaris.ItemRecordDetails ird WITH (NOLOCK) ON ird.ItemRecordID = cir.ItemRecordID
INNER JOIN
    Polaris.Polaris.ItemStatuses ist WITH (NOLOCK) ON ist.ItemStatusID = cir.ItemStatusID

WHERE
    rs.ObjectTypeID = 3 -- Item Records specifically
AND
    rs.OrganizationOwnerID IN () -- Put in your OrganizationID here to select owners

ORDER BY
    [Record Set Name] ASC

```