> ## Documentation Index
> Fetch the complete documentation index at: https://forest-docs-cli-reference-headless-commands.mintlify.site/llms.txt
> Use this file to discover all available pages before exploring further.

# View tickets related to a user

Now, let's say we want to access the tickets for a user of my database. We are going to use the email address as the foreign key between the database model (`Users` table) and Zendesk tickets.

First, we need to create the [Smart Relationship](https://docs.forestadmin.com/documentation/reference-guide/relationships/create-a-smart-relationship) between `Users` and `zendesk_tickets` as follows:

```javascript theme={null}
collection('users', {
  actions: [],
  fields: [
    {
      field: 'ze_requested_tickets',
      type: ['String'],
      reference: 'zendesk_tickets.id',
    },
  ],
  segments: [],
});
```

Then, we need to implement the Smart Relationship route. This route will query the Zendesk tickets related to the user's email (requested field on `zendesk_tickets`).

```javascript theme={null}
const { getTickets } = require('../services/zendesk-tickets-service');

router.get(
  '/users/:userId/relationships/ze_requested_tickets',
  async (request, response, next) => {
    // Get the user email for filtering on requester
    const user = await users.findByPk(request.params.userId);
    const additionalFilter = `requester:${user.email}`;
    getTickets(request, response, next, additionalFilter);
  }
);
```

Now, you should see the requested tickets for a user:

<img src="https://mintcdn.com/forest-docs-cli-reference-headless-commands/nZXPMP2NYE1BOXuA/images/legacy/javascript-agents/image%20(505).png?fit=max&auto=format&n=nZXPMP2NYE1BOXuA&q=85&s=70f07902948e6c6f4c97152ee9b8519a" alt="" width="1187" height="417" data-path="images/legacy/javascript-agents/image (505).png" />