Organization chart extension

(3 posts) (2 voices)

Tags:

No tags yet.

  1. john, Member

    I can't figure out the last example, i think it is because i don't understand select 'dbr.org.target'. When i take remove it i get a basic org chart. I had to guess on how this data was supposed to look as i couldn't find an example so i must be providing the wrong information.

    This is my sp

    select 'dbr.title', 'Target browser'; select 'dbr.report', 'sp_DBR_organization_set_node_position', 'action_div[]', 'in_id=id', 'in_pos="l"', '"Position left"'; select 'dbr.report', 'sp_DBR_organization_set_node_position', 'action_div[]', 'in_id=id', 'in_pos="r"', '"Position right"'; select 'dbr.report', 'sp_DBR_organization_set_node_position', 'action_div[]', 'in_id=id', 'in_pos="u"', '"Position under"'; select 'dbr.org.chart';#, '{boxWidth:180}';

    select 'dbr.org.target', tbl_endpoint_id , weight, null, color, txt from test.tbl_endpoint_data;

    select id, parent, test.fn_org_node_position( id, parent ), concat('<b>', name, '</b>', char(10), location, char(10) ) /* Last linefeed makes room for the targets */ from test.tbl_endpoint where id < 3 order by id;

    This is my output with &export=sql

    select 'dbr.title', 'Target browser';

    select 'dbr.org.chart'; select 'dbr.org.target', 1, '0', null, '#FF7A00', 'this is the text' union all select 'dbr.org.target', 2, '2', null, '#FF7A00', '<b>3</b> other text';

    select 1 as 'id', 0 as 'parent', 'u' as 'test.fn_org_node_position( id, parent )', '<b>location 2</b> more text ' as 'concat(\'<b>\', name, \'</b>\', char(10), location, char(10) )' union all select 2, 0, '0', '<b>loc 3</b> more text ';

  2. myDBR Team, Key Master

    Just use 0 instead of null in third parameter for dbr.org.target (contrary to to the documentation, the newest buld fill fix the anomaly).

    The dbr.org.target option allows for you to color draw a bar inside the organization box (you can have multiple per box) with color and tooltip of your choice.

    --
    myDBR Team

  3. john, Member

    thanks change makes chart appear with colour bar but not tooltip, will try updating.
    fyi there is a typo on this page, search for ising
    https://mydbr.com/doc/content/extensions.organizationchart.html
    also target paramaters might be missing a header, unless they are supposed to be for autobalance

    autobalance
    Balance left and right nodes automatically. Default is 'auto'. Values can be 'l', 'r' and 'auto'

    Target parameters are: node_id, weight, null, color, text


Reply

You must log in to post.