Smart Segment large data fetch issue

Issue Details

Hey,

I was wondering if smart segement has limitation on returned data volume.

We have a case that we have declared few segments : SegementA, SegmentB

and SegmentC should be not( SegmentA and SegmentB) .

in SegmentC the code looks as follows:

{
      name: "Ongoing Support",
      where: async () => {
        const segmentA = await SegmentAQuery();
        const segmentB = await SegmentBQuery();
      
        const data = [
          ...segmentA,
          ...segmentB,
        ];
        return { contactId: { [Op.notIn]: data } };
      },
    }

We see this works on local environment where data volumes is very small but returns an empty results while on production environment where we have large data volumes.

any ideas why we get this behavior?

Feature(s) impacted

Loading data from large data collection

Observed behavior

Fetching Smart segment returns values when working on local environment while on production which has a lot more data doesnt return value.

Expected behavior

Smart Segment should return data also on large collections.

Context

  • Project name: Empathy
  • Team name: Care Ops
  • Environment name: production
  • Agent (forest package) name & version: forest-express-sequelize: 8.4.8
  • Database type: Postgresql

Hello @RonenMeiri :wave:,

Can you make a copy as curl of your request to see if you have a return? :pray: This will allow us to determine if the problem you are experiencing is from the frontend. Thank you.

Kind regards,

Florian