Skip to content

MSSQL parameter limit of 2100 Issue #311

@vbedekar

Description

@vbedekar

I have a nested model and the underlying query that executes does a IN clause with more than 2100 parameters. MYSQL cant take this.
Usually its recommended to handle this my breaking up the IN parameter list and chaining the sublists by doing multiple OR's

v_portfolio_api
    .query()
    .eager('[trading_group.head_traders.trader, traders.trader]')
    .then(function(portfolios) {
      res.status(200).json(portfolios);
    });

Do you have a solution? Can the ORM handle this for MSSQL?

Metadata

Metadata

Assignees

No one assigned

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions