"or" operator for condition

[sveip]

Trying to query select one,two,three from stats where myCond='40002' or myCond='40007' and time <= 1463142720s and time >= 1463142660s

Tried with

const reader = client.query('stats');
reader.addField('one', 'two', 'three');
reader.start = start;
reader.condition("myCond='40002' or myCond='40007'");

In this case the condition is ignored. If I only enter one condition without "or" operator it is considered and included in the query.

How can I add several conditions on the same field as one would do with "or" operator?

[vicanso]

In the previous version, you can use as follows:

const QL = require("influx-ql");
const ql = new QL();
ql.measurement = 'stats';
ql.addField('one', 'two', 'three');
ql.start = '1463142660s';
ql.end = '1463142720s';
ql.addCondition("myCond='40002' or myCond='40007'");
console.info(ql.toSelect());

Now I have updated a new version to enhance the condition function

const QL = require("influx-ql");
const ql = new QL();
ql.measurement = 'stats';
ql.addField('one', 'two', 'three');
ql.start = '1463142660s';
ql.end = '1463142720s';
ql.condition("myCond='40002' or myCond='40007'");
console.info(ql.toSelect());

[sveip]

Thanks! Would it be an idea to support conditions as key-value pairs where they value can be an array in a case like i have above?

-----Original Message-----
From: "Tree Xie" notifications@github.com
Sent: ‎13/‎05/‎2016 17:22
To: "vicanso/influx-ql" influx-ql@noreply.github.com
Cc: "sveip" petersveistrup@gmail.com; "Author" author@noreply.github.com
Subject: Re: [vicanso/influx-ql] "or" operator for condition (#2)

In the previous version, you can use as follows:
const QL = require("influx-ql");
const ql = new QL();
ql.measurement = 'stats';
ql.addField('one', 'two', 'three');
ql.start = '1463142660s';
ql.end = '1463142720s';
ql.addCondition("myCond='40002' or myCond='40007'");
console.info(ql.toSelect());Now I have updated a new version to enhance condition function
const QL = require("influx-ql");
const ql = new QL();
ql.measurement = 'stats';
ql.addField('one', 'two', 'three');
ql.start = '1463142660s';
ql.end = '1463142720s';
ql.condition("myCond='40002' or myCond='40007'");
console.info(ql.toSelect());—
You are receiving this because you authored the thread.
Reply to this email directly or view it on GitHub

[vicanso]

Now I have updated a new version, , you can use as follows:

const QL = require("influx-ql");
const ql = new QL();
ql.measurement = 'stats';
ql.addField('one', 'two', 'three');
ql.start = '1463142660s';
ql.end = '1463142720s';
ql.condition('myCond', ['40002', '40007']);
console.info(ql.toSelect());

[sveip]

Great, thanks! :-) Will try it out.

-----Original Message-----
From: "Tree Xie" notifications@github.com
Sent: ‎14/‎05/‎2016 15:57
To: "vicanso/influx-ql" influx-ql@noreply.github.com
Cc: "sveip" petersveistrup@gmail.com; "Author" author@noreply.github.com
Subject: Re: [vicanso/influx-ql] "or" operator for condition (#2)

Now I have updated a new version, , you can use as follows:
const QL = require("influx-ql");
const ql = new QL();
ql.measurement = 'stats';
ql.addField('one', 'two', 'three');
ql.start = '1463142660s';
ql.end = '1463142720s';
ql.condition('myCond', ['40002', '40007']);
console.info(ql.toSelect());—
You are receiving this because you authored the thread.
Reply to this email directly or view it on GitHub