Hi, I'm prototyping an accounting system based around OQGraph but I've hit a stop
Here's my data:
simple select on my graph table:
latch, origid, destid, weight, seq, linkid
WHERE latch = '1'
AND linkid > 0
AND destid = 22;
which is expected and works. Perfect for updating all the parent accounts in one go.
select linkid from sa_coa_graph where latch = ''
and origid = 0;
gives nothing. Not what I'm expecting. In this case I'd expect a result containing linkid == 1 i.e. the first hop link. Setting origid to any other 'parent' gives no first hop links as described in docs at https://mariadb.com/kb/en/library/oqgraph-examples/
In this case I want to use OQGraph to help me reconstruct the tree back into my parent program (PHP).As there is no functionality to get the linkage in any form of tree, I assumed you'd intended that this mechanism was a step towards doing so.
Am I missing something?