Without where key word check condition for < and > between parentheses

[Pugazharasan Thirumalai]

Hai ,

select outE('store_has_billing').inV()[gross_value =100] as grossValue from  #48:1635

If i run the above query it will execute, but if i use < or > for check condition its not working.

For example,

select outE('store_has_billing').inV()[gross_value > 100] as grossValue from  #48:1635.

By where condition we can execute the query but i need how to check condition between parentheses. 

Thanks and regards,

T.Pugazharasan

[Ivan Mainetti]

HAI,

you can't use < > in square parenthesis conditions.

Besides, could you share a small sample db for testing?

[Luigi Dell'Aquila]

Hi, 

Which version of OrientDB are you using?

We recently fixed some parsing issues in square brackets

Thanks

Luigi

2017-06-05 13:48 GMT+02:00 Ivan Mainetti <user.w...@gmail.com>:

HAI,

you can't use < > in square parenthesis conditions.

Il giorno lunedì 5 giugno 2017 12:59:37 UTC+2, Pugazharasan Thirumalai ha scritto:

Hai ,

select outE('store_has_billing').inV()[gross_value =100] as grossValue from  #48:1635

If i run the above query it will execute, but if i use < or > for check condition its not working.

For example,

select outE('store_has_billing').inV()[gross_value > 100] as grossValue from  #48:1635.

By where condition we can execute the query but i need how to check condition between parentheses. 

Thanks and regards,

T.Pugazharasan

--

---
You received this message because you are subscribed to the Google Groups "OrientDB" group.
To unsubscribe from this group and stop receiving emails from it, send an email to orient-database+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[Pugazharasan Thirumalai]

select outE('store_has_billing').inV().gross_value as gv from #48:1635

[887.16,2501.5,3075.1,1240.2,920,800,3044.5,2012.5,1092.5,5115.3,5375.7,2007.92,1150,1500,280,1498.5,200,180,853,1916,960,170,380,790,790,12860,790,1500.01,800,1773,12200,0,0,1650]

select from billing

METADATA			PROPERTIES												IN			OUT
@rid	@class	@version	discount_percentage	discount_value	reward_points_value	tax_value	gross_value	payment_mode	is_deleted	payment_status	bill_number	is_cancel	actual_tax_value	created_date	store_has_billing	appointment_has_billing	customer_has_billing	billing_has_payment_history	billing_has_billing_services
#339:0	billing	6	0	0	0	0	1630	#30:383	false	1	999-0	false	0	2016-01-08 13:04:12	#48:999	#351:4	#260:3	#425:0	#340:0 #340:1
#339:1	billing	6	0	0	0	0	686	#30:383	false	1	999-1	false	0	2016-01-08 13:08:16	#48:999	#351:5	#260:2	#425:1	#340:2
#339:2	billing	6	0	0	0	107.66	1764	#30:383	false	1	999-2	false	107.66	2016-01-08 13:10:40	#48:999	#351:6	#260:2	#425:2	#340:3
#339:3	billing	6	0	0	0	0	1198	#30:383	false	1	999-3	false	0	2016-01-06 13:13:59	#48:999	#351:7	#260:2	#425:3	#340:4 #340:5
#339:4	billing	6	0	0	0	0	850	#30:382	false	1	999-4	false	0	2016-01-08 13:17:19	#48:999	#351:8	#260:2	#425:4	#340:6
#339:5	billing	6	0	0	0	0	800	#30:382	false	1	999-5	false	0	2015-05-05 13:21:08	#48:999	#351:0	#260:1	#425:5

[Pugazharasan Thirumalai]

Studio version : 2.0

OrientDB version : 2.0.18

Home Page : https://github.com/orientechnologies/orientdb-studio

Copyrights : Orient Technologies LTD

License : Apache 2

We tried to migrate new version but facing problems on  change query on multiple places.

[Luigi Dell'Aquila]

Hi Pugazharasan,

v 2.0 is no longer supported, unfortunately in that version you cannot execute filtering with < > between square brackets

Thanks

Luigi

--

[Pugazharasan Thirumalai]

Hai Luigi,

Okay, Thank you.

Thanks and Regards,

T.Pugazharasan