Precisely Enterworks

 View Only

  • 1.  Sequencing Of Parent Nodes Within A Hierarchy

    Posted 05-06-2021 20:10
    Hi All.

    I've got a question that I'm hoping the community will be able to answer. Is there a way to query the ordering numbers of the structure of a hierarchy from an SQL query? Sequence ID in Hierarchy Catalog is good for sequencing products within a node. How can we have a number that shows which node comes first, then second and so on? Is there a system field that I'm not aware of that I can look up??

    Thanks,
    -Jon

    ------------------------------
    Jonathan Varo | PIM Lead
    Fender Musical Instruments | 480-845-5823
    ------------------------------


  • 2.  RE: Sequencing Of Parent Nodes Within A Hierarchy

    Posted 05-07-2021 08:33
    Hi Jon,

    Let me try to help you here.  Sequence numbers of a hierarchy/taxonomy are stored in b_code_set_detail table, field name is 'SEQUENCE_NUM'.   You may use the query below but modify the name of hierarchy based on your configuration.   hope it helps!

    select csd.code, csd.description,csd.SEQUENCE_NUM,csd.PARENT_CODE
    from dbo.B_CODE_SET_DETAIL csd
    inner join dbo.B_CODE_SET cs on csd.code_set_id=cs.code_set_id
    where cs.name ='<hierarchyName>' --it's name of hierarchy or taxonomy or code set
    order by 3;

    let me know if you have further questions.

    Best Regards,
    Sreehari

    ------------------------------
    Sreehari Seerla |
    | 3054961536
    ------------------------------