# V7 issue "column User.$and does not exist"

**URL:** <https://community.forestadmin.com/t/v7-issue-column-user-and-does-not-exist/2163>\
**Category:** Help me!\
**Created:** [March 23, 2021, 6:31pm UTC](https://community.forestadmin.com/t/v7-issue-column-user-and-does-not-exist/2163 "2021-03-23T18:31:05Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![austinrupie](https://dub1.discourse-cdn.com/flex013/user_avatar/community.forestadmin.com/austinrupie/32/1100_2.png) [@austinrupie](https://community.forestadmin.com/u/austinrupie)\
**Post date:** [March 23, 2021, 6:31pm UTC](https://community.forestadmin.com/t/v7-issue-column-user-and-does-not-exist/2163/1 "2021-03-23T18:31:05Z")

</div>

This is happening with every table in our DB when we migrated to v7.

```javascript
module.exports = async function (app) {
  const liana = await Liana.init({
    configDir: path.join(__dirname, '../forest'),
    envSecret: process.env.FOREST_ENV_SECRET,
    authSecret: process.env.FOREST_AUTH_SECRET,
    objectMapping: sequelize.Sequelize, // Sequelize was already exported in v6
    connections: { default: sequelize },
    integrations: {
      intercom: {
        accessToken: process.env.INTERCOM_ACCESS_TOKEN,
        intercom: intercomClient,
        mapping: ['User.email']
      }
    }
  });

  app.use(liana);

  console.log(chalk.cyan('Your admin panel is available here: https://app.forestadmin.com/projects'));
};

```

## Expected behavior

For it to not use the old operators.

## Actual behavior

What is the current behavior?

## Failure Logs

 ![Screen Shot 2021-03-23 at 11.29.53 AM](https://europe1.discourse-cdn.com/flex013/uploads/forest/original/2X/5/50b76960865e077e49d97f292d01dc7b5322bda5.jpeg)

## Context

Please provide any relevant information about your setup.

- Package Version: ^7.2.2
- Express Version: ^4.17.1
- Sequelize Version: ^5.22.4
- Database Dialect: PG
- Database Version: 11
- Project Name: Rupie

---

<div class="post-metadata">

**Author:** ![austinrupie](https://dub1.discourse-cdn.com/flex013/user_avatar/community.forestadmin.com/austinrupie/32/1100_2.png) [@austinrupie](https://community.forestadmin.com/u/austinrupie)\
**Post date:** [March 23, 2021, 6:37pm UTC](https://community.forestadmin.com/t/v7-issue-column-user-and-does-not-exist/2163/2 "2021-03-23T18:37:38Z")

</div>

![Screen Shot 2021-03-23 at 11.37.21 AM](https://europe1.discourse-cdn.com/flex013/uploads/forest/original/2X/0/06798b74a21226713781eceef423400d84047429.jpeg)

Also getting this with Smart Segments

---

<div class="post-metadata">

**Author:** ![austinrupie](https://dub1.discourse-cdn.com/flex013/user_avatar/community.forestadmin.com/austinrupie/32/1100_2.png) [@austinrupie](https://community.forestadmin.com/u/austinrupie)\
**Post date:** [March 23, 2021, 6:38pm UTC](https://community.forestadmin.com/t/v7-issue-column-user-and-does-not-exist/2163/3 "2021-03-23T18:38:23Z")

</div>

![Screen Shot 2021-03-23 at 11.38.00 AM](https://europe1.discourse-cdn.com/flex013/uploads/forest/original/2X/e/eddf389fa8dda7ac8cbbadbf105d8b2c95915caa.jpeg)

Also this when I try to load a vanilla list of Users.

---

<div class="post-metadata">

**Author:** ![austinrupie](https://dub1.discourse-cdn.com/flex013/user_avatar/community.forestadmin.com/austinrupie/32/1100_2.png) [@austinrupie](https://community.forestadmin.com/u/austinrupie)\
**Post date:** [March 23, 2021, 6:38pm UTC](https://community.forestadmin.com/t/v7-issue-column-user-and-does-not-exist/2163/4 "2021-03-23T18:38:35Z")

</div>

Yeah v7 is broken ☹

---

<div class="post-metadata">

**Author:** ![GuillaumeGautreau](https://dub1.discourse-cdn.com/flex013/user_avatar/community.forestadmin.com/guillaumegautreau/32/557_2.png) [@GuillaumeGautreau](https://community.forestadmin.com/u/GuillaumeGautreau)\
**Post date:** [March 24, 2021, 7:58am UTC](https://community.forestadmin.com/t/v7-issue-column-user-and-does-not-exist/2163/5 "2021-03-24T07:58:26Z")

</div>

Hello @austinrupie,

Thanks for your feedback.

Did you follow the [upgrade documentation to the v7](https://docs.forestadmin.com/documentation/how-tos/maintain/upgrade-notes-sql-mongodb/upgrade-to-v7)?

This v7 is quite new but it’s not broken, we are using it daily and we don’t experience this issue. So I guess it’ll be possible to find what causes errors with your project.

Can you please share with us the SQL to create a table for which you have this issue, and also the model declaration for this table? It’ll help a lot reproducing the issue on our side.
