Styjun

Upper Bound for a Sum

how to change dot to underline in multiple file-names?

Why is it to say 'paucis post diebus'?

Is there a command-line tool for converting html files to pdf?

How to increase Solr JVM memory

Why wasn't interlaced CRT scanning done back and forth?

Are valid inequalities worth the effort given modern solver preprocessing options?

The warlock of firetop mountain, what's the deal with reference 192?

Write The Shortest Program To Check If A Binary Tree Is Balanced

Variable doesn't parse as string

Does a humanoid possessed by a ghost register as undead to a paladin's Divine Sense?

Can a Sikh enter a buddhist temple with a turban?

How do the surviving Asgardians get to Earth?

Why is Heisenberg shown dead in Negro y Azul?

If someone else uploads my GPL'd code to Github without my permission, is that a copyright violation?

ZFS on Linux: Which mountpoint option when mounting manually per script?

“The Fourier transform cannot measure two phases at the same frequency.” Why not?

Is a switch from R to Python worth it?

Pronouns when writing from the point of view of a robot

Need reasons why a satellite network would not work

Would this winged human/angel be able to fly?

Piece de Resistance - Introduction & Ace and A's

Did Logical Positivism fail because it simply denied human emotion?

Repeated! Factorials!

TypeError: attr[0].indexOf is not a function

Unable to create child instance for one-to-many on Sequelize.jsSequelize TypeError build.save is not a functionMany to many self reference in Sequelize in twitter like web-appTypeError: defineCall is not a function at Sequelize.importSequelize findOne error: TypeError indexOf undefinedSequelize not accepting valid moment.js object in where clauseCannot read property 'source' of undefined when trying to add association in queryGenerator.SelectQuery in Sequelize ORMModel.create with hasTrigger true return typeError attribute.type.toSql is not a functionDynamically add attributes to sequelize.js queryTypeError: UserModel.create is not a function, Sequelize

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;

0

While querying through sequelize:

where["tenant_id"] = tenant_id;
 where[datecheck] = 
 $gte: from,
 $lte: to,
 $ne: null
 ;
group = [ group_by + '_id' , "stage_type"];
attributes = [[group_by + '_id', 'id'], [group_by + '_name', 'group'], ["stage_type", 'type'], [ sequelize.literal('SUM(`stage_value`)'), 'count']];

Model.findAll(
 attributes: attributes,
 where: where,
 group: group
 );

I get this error:

Data TypeError: attr[0].indexOf is not a function

at attributes.map.attr (
sequelize/lib/dialects/abstract/query-generator.js:1244:28)

sequelize.js

share|improve this question

edited Apr 1 at 20:07

marc_s

599k135135 gold badges11491149 silver badges12851285 bronze badges

asked Mar 27 at 2:51

PragnaPragna

144 bronze badges

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Can you share the raw query that is getting executed?
  
  – Rohit Dalal
  Mar 27 at 5:15
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  SELECT tenant_id AS id, tenant_name AS group, stage_type AS type, COUNT(candidate_id) AS count FROM funnel_reports AS funnel_reports WHERE funnel_reports.tenant_id = '10' AND (funnel_reports.stage_date >= '2018-05-31 18:30:00' AND funnel_reports.stage_date <= '2019-02-28 18:30:00') GROUP BY tenant_id, stage_type;
  
  – Pragna
  Mar 27 at 6:58
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  That query I want to run through sequelize but it is throwing an error. I am using sequelize 4.38.0 version
  
  – Pragna
  Mar 27 at 6:59
  

  
  
  
  

add a comment | 

0

While querying through sequelize:

where["tenant_id"] = tenant_id;
 where[datecheck] = 
 $gte: from,
 $lte: to,
 $ne: null
 ;
group = [ group_by + '_id' , "stage_type"];
attributes = [[group_by + '_id', 'id'], [group_by + '_name', 'group'], ["stage_type", 'type'], [ sequelize.literal('SUM(`stage_value`)'), 'count']];

Model.findAll(
 attributes: attributes,
 where: where,
 group: group
 );

I get this error:

Data TypeError: attr[0].indexOf is not a function

at attributes.map.attr (
sequelize/lib/dialects/abstract/query-generator.js:1244:28)

sequelize.js

share|improve this question

edited Apr 1 at 20:07

marc_s

599k135135 gold badges11491149 silver badges12851285 bronze badges

asked Mar 27 at 2:51

PragnaPragna

144 bronze badges

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Can you share the raw query that is getting executed?
  
  – Rohit Dalal
  Mar 27 at 5:15
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  SELECT tenant_id AS id, tenant_name AS group, stage_type AS type, COUNT(candidate_id) AS count FROM funnel_reports AS funnel_reports WHERE funnel_reports.tenant_id = '10' AND (funnel_reports.stage_date >= '2018-05-31 18:30:00' AND funnel_reports.stage_date <= '2019-02-28 18:30:00') GROUP BY tenant_id, stage_type;
  
  – Pragna
  Mar 27 at 6:58
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  That query I want to run through sequelize but it is throwing an error. I am using sequelize 4.38.0 version
  
  – Pragna
  Mar 27 at 6:59
  

  
  
  
  

add a comment | 

While querying through sequelize:

where["tenant_id"] = tenant_id;
 where[datecheck] = 
 $gte: from,
 $lte: to,
 $ne: null
 ;
group = [ group_by + '_id' , "stage_type"];
attributes = [[group_by + '_id', 'id'], [group_by + '_name', 'group'], ["stage_type", 'type'], [ sequelize.literal('SUM(`stage_value`)'), 'count']];

Model.findAll(
 attributes: attributes,
 where: where,
 group: group
 );

I get this error:

Data TypeError: attr[0].indexOf is not a function

at attributes.map.attr (
sequelize/lib/dialects/abstract/query-generator.js:1244:28)

sequelize.js

share|improve this question

edited Apr 1 at 20:07

marc_s

599k135135 gold badges11491149 silver badges12851285 bronze badges

asked Mar 27 at 2:51

PragnaPragna

144 bronze badges

where["tenant_id"] = tenant_id;
 where[datecheck] = 
 $gte: from,
 $lte: to,
 $ne: null
 ;
group = [ group_by + '_id' , "stage_type"];
attributes = [[group_by + '_id', 'id'], [group_by + '_name', 'group'], ["stage_type", 'type'], [ sequelize.literal('SUM(`stage_value`)'), 'count']];

Model.findAll(
 attributes: attributes,
 where: where,
 group: group
 );

share|improve this question

edited Apr 1 at 20:07

marc_s

599k135135 gold badges11491149 silver badges12851285 bronze badges

asked Mar 27 at 2:51

PragnaPragna

144 bronze badges

share|improve this question

edited Apr 1 at 20:07

marc_s

599k135135 gold badges11491149 silver badges12851285 bronze badges

asked Mar 27 at 2:51

PragnaPragna

144 bronze badges

edited Apr 1 at 20:07

marc_s

599k135135 gold badges11491149 silver badges12851285 bronze badges

edited Apr 1 at 20:07

marc_s

599k135135 gold badges11491149 silver badges12851285 bronze badges

asked Mar 27 at 2:51

PragnaPragna

144 bronze badges

asked Mar 27 at 2:51

PragnaPragna

144 bronze badges