2

[zjm138238]

select LOGICID from v where GLOBALSYSADMIN="王江平:13823208291" limit 10000; select @rid from ( TRAVERSE out() FROM #17:0 MAXDEPTH 4 ) limit 100000

[zjm138238]

select LOGICID from v where SERVERROOM = "深圳数据中心" limit 10000; select LOGICID from v where GLOBALMAINDEPARTMENTNAME='系统支持室' limit 10000; select @rid from v where OSVERSION='Microsoft Windows Server 2008 R2‘ limit 10000; select @rid from v where REGIONCODE='深圳' limit 10000; select @rid from v where STATUS="使用中" limit 10000; select @rid from v where MIP="10.1.229.137" limit 10000; select @rid from v where MAINBACKUP="主" limit 10000; select @rid from VM where UPDATETIME>"2016-08-22 15:33:16" and UPDATETIME<"2016-11-25 15:33:16"

[zjm138238]

Microsoft Windows Server 2008 R2 Enterprise x64 Service Pack 1 Build 7601 (08-10-2014)

[zjm138238]

select @rid from v where OSVERSION = 'Microsoft Windows Server 2008 R2 Enterprise x64 Service Pack 1 Build 7601 (08-10-2014)' limit 10000;

[zjm138238]

set the following: ridBag.sbtreeBonsaiToEmbeddedToThreshold=2147483647 (it's not a typo, it's just like that) do an update V remove NONEXISTINGPROPERTY

[zjm138238]

match (a)-[1..4]->(b) where a.LOGICID='UPS14' return b.LOGICID; match (a)-[1..4]->(b:VM) where a.LOGICID='UPS14' return b.LOGICID; start n=node() where n.GLOBALSYSADMIN="王江平:13823208291" return n .LOGICID; start n=node() where n.GLOBALSYSADMIN=~".江." return n .LOGICID; match (b) where b.SERVERROOM='深圳数据中心' return b.LOGICID; match (a) where a.GLOBALMAINDEPARTMENTNAME='系统支持室'return a.LOGICID; match (b) where b.OSVERSION='Microsoft Windows Server 2008 R2 (64-bit)' return distinct b.LOGICID; match (a) where a.REGIONCODE='深圳'return distinct a.LOGICID; match (a) where a.STATUS="使用中" return a.LOGICID; match (a) where a.MIP="10.1.229.137" return a.LOGICID; match (a) where a.MAINBACKUP="主" return a.LOGICID; match (a:VM) where a.UPDATETIME>"2016-08-22 15:33:16" and a.UPDATETIME<"2016-11-25 15:33:16" return a.LOGICID; select @rid from VM where UPDATETIME>"2016-08-22 15:33:16" and UPDATETIME<"2016-11-25 15:33:16"

[zjm138238]

select @Rid from VM where UPDATETIME>"2016-08-22 15:33:16" and UPDATETIME<"2017-06-20 15:33:16"

[zjm138238]

http://idea.iteblog.com/key.php

[zjm138238]

try ( Session session = newSession( AccessMode.READ, context ); Transaction tx = beginTransaction( session, context ) ) { StatementResult result = tx.run( "MATCH (n) RETURN n LIMIT 1" ); List records = result.list(); if ( !records.isEmpty() ) { Record record = single( records ); Node node = record.get( 0 ).asNode(); assertNotNull( node ); }

        context.readCompleted( result.summary() );
        tx.success();
    }
}

[zjm138238]

CREATE (t:test {attr1: "value 1", attr2: "value 2"}); MATCH (a:test) SET a.DESCRIPTION = "1111" RETURN a;

[zjm138238]

create class Test extends V; insert into Test content {"attr1": "value 1", "attr2": "value 2"} insert into Test(attr1,attr2,attr3) values("1","1","1")

[zjm138238]

match p=((a:UPS)-[*..4]->(b:NETWORK)) where a.LOGICID ='UPS20' and b.HOSTNAME='SZ7FC07U28-WN1-KX-C5KA' return p; select $path from (TRAVERSE out("影响") FROM #17:3 MAXDEPTH 4) where HOSTNAME='SZ7FC07U28-WN1-KX-C5KA'