[orientdb] Re: Filter vertices collection with a wildcard operator

Thanks for your reply, you helped me to find the answer. Yes, I had to think from the opposite direction of the edge, i.e. select from ATS_NAMAbbr where dval like "ABS%" and then get the vertices, instances of ETSAbbr, (shortname Abbreviation) by expanding the in() of LTSval select

[orientdb] Filter vertices collection with a wildcard operator

Hi, I have a vertex class Abbreviation with a lightweight edge LTSval that links another vertex class with a string property dval select expand(out_LTSval) from Abbreviation

[orientdb] SQL CRUD RESTful TRANSFORMATIONS IN MATHEMATICA AND ORIENTDB

>From Declarative to Functional Database Operations GUDA is a new alternative, functional way to program databases. The functional set of RESTful API commands Get, Update, Delete, and Add is built in a concise and succinct way to assimilate CRUD database operations. This functional RESTful API

[orientdb] Result set of vertices with an empty collection of edges, vertices

Hi, this might be a simple question but I am confused, please help. I am using OrientDB 2.1.9 and I am experimenting with VehicleHistoryGraph database. >From Studio, Browse mode, set limit to 9 records only. Now I am entering this simple query select out() from Person The result set I

[orientdb] Re: Result set of vertices with an empty collection of edges, vertices

Yes it does help, thank you On Friday, 22 January 2016 15:47:54 UTC+2, Athanassios Hatzis wrote: > > Hi, > this might be a simple question but I am confused, please help. > > I am using OrientDB 2.1.9 and I am experimenting with VehicleHistoryGraph > database. > From Stu

[orientdb] Select... Where SQL command parsing problem

Conside this simple SQL Select command select from CLA where price5 and the server responds with the following error com.orientechnologies.orient.core.sql.OCommandSQLParsingException: Error on parsing command at position #27: Invalid keyword '5' If you change the command to select from CLA

[orientdb] Re: EmbeddedSet vs LinkSet

Thank you for your replies, my question is more specific on data type EMBEDDEDSET of linked type LINK. Your replies are for EMBEDDEDSET of linked type STRING. I am asking this because I see that you have not limited the Linked_Type attribute when you specify a new property with Type

[orientdb] Re: EmbeddedSet vs LinkSet

@Alessandro you think. but I have tested this and it looks like it does not behave correctly ;-) Plus the fact that you have not replied if there is any purpose of not restricting the options of Link_Type. e.g. EmbeddedSet of EmbeddedSet for example.. Thanks any way -- --- You

[orientdb] TRUNCATE RECORD sql command on deleting a record that does not exist

It seems that truncate record command does not check whether the record exists or not. This might be not a critical problem since you are deleting the records anyway but the response is wrong, i.e. counts records that do not exist. It should count only the records that previously existed and

[orientdb] Re: Problem with the Size of HTTP Message Body

I am reporting on OrientDB Community version 2.1 I have tested HTTP POST with a 10kB size, there is no problem this time. -- --- 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

[orientdb] EmbeddedSet vs LinkSet

What is the difference between EMBEDDEDSET of Link and LINKSET -- --- 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

[orientdb] Cannot change property type from LINK to STRING

OrientDB Community Version 2.1 I have a document database, schema full defined class with no records, and a property of type LINK, From OrientDB Studio, I have tried to change the type of property from LINK to STRING and I got the error message

[orientdb] Re: About delete orientdb sql command and log of db operations

OK this works delete from CL where @rid = #12:2 and this one too truncate record #12:2 and this one truncate record 12:2 but not this one delete from CL where @rid = 12:2 Please note that it does not return any error but the record is not deleted ! tested on OrientDB Server v2.0.13 -- ---

[orientdb] Re: attribute value history

Incidentally the procedure that Luca described is very similar to what has been designed in Freebase Graphd is a log-structured or append-only store. To “modify” a primitive, for example by changing the value, you write a new primitive carrying the modification and use the prev to indicate

[orientdb] OrientDB JDBC OpenSQLConnection in Mathematica : Execution of SQL failed

Hi, I am trying to execute SQL commands from inside Mathematica Notebook. I could do this using REST API but JDBC is a more direct method. So I have tried to open a connection with the JDBC OrientDB driver that you provide and this was successful. But when I tried to execute an SQL command. It

[orientdb] About delete orientdb sql command and log of db operations

Hi, I am using OrientDB 2.1 rc5 When you execute an sql delete command on the OrientDB Studio, such as delete from CL where rid=12:2 and then select from CL You get back also the list of deleted records including the one currently deleted right ? But there is not any indication that the

[orientdb] Problem with the Size of HTTP Message Body

Hi, I am experiencing a problem trying to POST an HTTP message body with a size that is over 1024 characters. The strange thing is that Google Chrome Postman App does not complain with the size of the body and the batch script is successfully executed on the server. But I need to use Wolfram

[orientdb] Re: Problems parsing OrientDB sql commands with nested quotes ?

One solution is to replace the single quotes with double quotes, I have tested with both update and insert and it works. update 11:3 set description=Ashes of Time Redux is a 2008 film directed by Wong Kar-wai.\\n \\ n \\ \ For Ashes of Time, Wong Kar-wai swapped the conventions of the

Re: [orientdb] Update links of multiple records bidirectionally

Hi Luca, I like your answer, it looks quick and easy but I am running into errors when I tried to execute your commands I am using the latest version of OrientDB community release, OrientDB Server v2.0.11 I am running this server and then I am executing your command from inside OrientDB

[orientdb] Update links of multiple records bidirectionally

I have two tables with the same number of records at each cluster. Record positions are ordered in exactly the same way, incrementally, in both clusters. I have defined two fields of type LINK one at each table. I would like to run a routine that links bidirectionally each record. I am using

[orientdb] Re: Update en embedded list of string field by adding another string value

UTC+3, Ziink A wrote: Try update PERSON *ADD* favColours=['red'] where perName='Luca' or update PERSON *ADD* favColours='red' where perName='Luca' On Thursday, June 11, 2015 at 7:53:50 AM UTC-7, Athanassios Hatzis wrote: Hi, I am a newcomer please help with the following I have created

[orientdb] Update en embedded list of string field by adding another string value

Hi, I am a newcomer please help with the following I have created a class PERSON and a collection property favColours CREATE PROPERTY PERSON.favColours EMBEDDEDLIST STRING Then I created a record INSERT INTO PERSON content {perName:'Luca',perAge:34} Then I have updated successfully that