sql - Get hierarchy only for updated records -

-

i have couple of tables resource data

resource ---------- rid |  rname | updatedstamp r1    res1      01-jul-2015 r2    res2      01-jul-2015 r3    res3      01-jul-2015 r4    res4      01-jul-2015 r5    res5      01-jul-2015 r15   res15      01-aug-2015  resourcetree ---------- parid | rid  | updatedstamp --------------------------- null  r1       01-jul-2015 r1    r2       01-aug-2015 r2    r3       01-jul-2015 r3    r4       01-jul-2015   r4    r5       01-jul-2015 r14   r15      01-jul-2015

i need select query fetch records updated on or after '01-aug-2015'. also, need fetch details of child resources of parent updated on '01-aug-2015'

so in case, need fetch records resource table updated on 01-aug-2015. in case r15. additionally, should fetch details resource_tree table update has happened on or post 01-aug-2015 . in case r2 r3 r4 r5.

results 

parid rid rname r14   r15 res15 r1    r2  res2 r2    r3  res3 r3    r4  res4 r4    r5  res5

query tried far

select rt.parid,r.id,r.rname resources r, resourcetree rt r.rid = rt.rid   , (r.updatedstamp >= '01-aug-2015' or rt.updatedstamp  >= '01-aug-2015') start rt.parid ='r1'  ,  connect prior rt.rid=rt.parid

this may not elegant solution;

with temp_tbl_1 (    -- "rid" updatedstamp >= '01-aug-2015' both tables   select rid   resourcetree   updatedstamp >= '01-aug-2015'   union   select rid   resource   updatedstamp >= '01-aug-2015' ), temp_tbl_2 (     select parid, rid     resourcetree     start rid in (select distinct rid temp_tbl_1)     connect prior rid = parid     ) select t.parid, t.rid, r.rname  temp_tbl_2 t join resource r on r.rid = t.rid

Comments

Post a Comment

Popular posts from this blog

python - pip install -U PySide error -

-
does know how avoid following error when running pip install -u pyside per official website instructions here: https://pypi.python.org/pypi/pyside/#installing-pyside-on-a-mac-os-x-system note have done brew install qt successfully. you using pip version 7.0.3, version 7.1.2 available. should consider upgrading via 'pip install --upgrade pip' command. collecting pyside using cached pyside-1.2.4.tar.gz installing collected packages: pyside running setup.py install pyside complete output command /applications/anaconda/bin/python -c "import setuptools, tokenize;__file__='/private/var/folders/dy/ttgqhqqx3g9bsbsnqnxsk2z80000gq/t/pip-build-cpxemt/pyside/setup.py';exec(compile(getattr(tokenize, 'open', open)(__file__).read().replace('\r\n', '\n'), __file__, 'exec'))" install --record /var/folders/dy/ttgqhqqx3g9bsbsnqnxsk2z80000gq/t/pip-0r7hri-record/install-record.txt --single-version-externally-managed --compile: ...
Read more

arrays - C++ error: a brace-enclosed initializer is not allowed here before ‘{’ token -

-
simple question: i'm trying initialize array within c++ class declaration: using namespace std; #include <string> class myclass{ public: string myarray[] = {"a","b","c"}; }; and i'm getting error: error: brace-enclosed initializer not allowed here before ‘{’ token no, without complied c++11 compiler, cannot initialize member array in declaration. have initialize array member in constructor. , don't use open array if know number of elements initialize array.
Read more

cytoscape.js - How to add nodes to Dagre layout with Cytoscape -

-
i trying add nodes dagre graph through cityscape.js. problem nodes not painted. code have: cy.add({ group: "nodes", data: { id:"n0",name:"n0",weight: 75 }, }); $.ajax(url).done(function(jsontree){ var newnodes=[]; for(var i=1;i<6;i++){ //var child = jsontree.result[i]; newnodes.push( { group: "nodes", data: { id: "n"+i, name:"n"+i}}, { group: "edges", data: { id: "e"+i, source: "n0", target: "n"+i } } ); } cy.add(newnodes); any ideas? have used loaded function reload graph not work. not know if have use specific function reload graph. thank in advance. you need add positions new nodes. cytoscape.js docs : it important note positions of newly added nodes must defined when calling cy.add(). nodes can not placed in graph without valid position — otherwise not displayed. yo...
Read more