1. Yury Oboz Avatar Yury Oboz
  2. Jira Apps
  3. tree-customfield
  4. Issues

Cascading fields or Multi level tree populated from changing HFSQL DB or csv file

Issue #27 wontfix
Ghazi Ben Jalel created an issue

Hello, I'm working on a POC within Jira Service Desk and have some questions if possible: 1/ I would like to make a query on HSQLDB to get the list of the first Custom field level1 and then the second level 2 and then the third one level 3 in a cascading context. 2/ Is it possible to have real time values cascaded 3/ How cascading works if one value that has childs in level 2 disappears? 3/ What about show / hide custom fields after value selection on another custom field. 4/ Do we have the ability to export Jira service desk forms from JSD portal

1/, 2/, 3/ and 4/ are in the ticket creation from jira service dek portal via a customer profile (not agent).

5/ The last and not least question is whether you have plan to implement these features within jira Service Desk CLOUD as our priority is for cloud but didn't found add-ons answering my need on cloud.

PS: It would be great if we can schedule a little 30 min demo on these points.

Thanks and Regards, -g.

Comments (30)

  1. Yury Oboz repo owner

    Hi!

    1) You can use two tables:

    AO_AA9326_OPTION contains values

    AO_AA9326_OPTION contains schemas info

    select level1(without parent)

    select * from AO_AA9326_OPTION o
where o.parent_id is null and o.schema_id = 1

    select level2(with parent)

    select * from AO_AA9326_OPTION o
where o.schema_id = 1 and o.parent_id = 1; --Select children of value with id = 1

select * from AO_AA9326_OPTION o
where o.schema_id = 6 and o.parent_id in (select id from AO_AA9326_OPTION where parent_id is null); --Select all children of root values

    2) Values displayed as tree. It's maybe as statis or dynamic for bigger tree with many values

    3) Custom field stored only selected value(s), if this value(s) do not removed, then value will be.

    4) Not now

    5) This customfield use custom index for fast search by parents. It's not possible to make on cloud.

    PS: It would be great if we can schedule a little 30 min demo on these points. I can, but I do not speek english(very bad to be exact). Only text mode ;)

  2. Ghazi Ben Jalel reporter

    Hello Yury thanks for your quick answer. I would like some further clarifications if possible about these SQL queries: 1/ The database I would like to connect is already there in a proprietary application; it is not in the one of Jira Service Desk and it is a HFSQLDB type. Is this type of database supported by your addon? 2/ How to make the update dynamic (without need to updte queries at each time)? How many levels can be managed ? Can we manage 4 levels or more? 3/ If a ticket is already created yesterday with a value that is removed today from the used table; will the value stay in the ticket or will it be removed as it is no more in the database queried table? 4/ OK 5/ OK We can schedule a text messaging meeting and try to understand each other; no pb :) Is it possible to do this on next wednesday 16/01 (please send me the invite at your convenience between 10am and 4pm UTC+1 Paris Time)? Best, -g.

  4. Yury Oboz repo owner

    1) Add-on user JIRA API to communicate with DB. If this database is suportet by JIRA then not problem

    more: https://confluence.atlassian.com/adminjiraserver071/supported-platforms-802592168.html

    2) > How to make the update dynamic (without need to updte queries at each time)?

    What is this about?

    How many levels can be managed ? Can we manage 4 levels or more?

    Yes. Tree CustomField do not have limits for levels and values. But if tree contains more values(1000+) strongly recommended use dynamic tree(with this setting value will be loaded dynamically)

    3) Will be removed. But I and Atlassian does not recommended change values in database. Better case use rest API for update values in tree or export/import tree as XML

    We can schedule a text messaging meeting and try to understand each other; no pb :) Is it possible to do this on next wednesday 16/01 (please send me the invite at your convenience between 10am and 4pm UTC+1 Paris Time

    Yes

  5. Ghazi Ben Jalel reporter

    1/ I created a ticket for atlassian to get an answer on this but would rather use csv file if the change is not recommended in database as you said in 3/ 2/ I'm not using more than 100 entries even with the lower level. 3/ How can we do if we have changes in the source data, could we use csv files instead of database? and reload data with a scheduled task or on file change. For RESTAPI or XML how could we use them in this case? Please send me the invite if you are available in the timeslots I proposed if possible for you.

    Many thanks, -g.

  6. Yury Oboz repo owner

    3)

    a) You can download tree schema as xml, modify it, then upload to jira as new schema. Finally switch old schema to new schema

    b) For browse REST API methods, download Atlassian REST API Browser from marketplace, then open Admin->System->Rest API Browser. Uncheck "show only public APIs" and type in search "treecf"

    1111111111111111111111.png

  7. Yury Oboz repo owner

    Please send me the invite if you are available in the timeslots I proposed if possible for you. Maybe tuesday or thursday, wednesday I may not have time.

    What software you use for communicate?

  10. Ghazi Ben Jalel reporter

    When are you available to start the meeting please? I'm available now until 4pm (paris time)

  19. Ghazi Ben Jalel reporter

    I would like to see what is possible on Jira Service Desk server within points below: 1/ How to read data from a database or csv file and to setup a four level Tree based on that? 2/ How to update the Tree in a daily basis at each end of day by reading the modifications in database and updating the Tree. 3/ Little demo on REST API abilities. 4/ How to populate the Tree manually from a list as well

  22. Yury Oboz repo owner

    If you want automatization updated tree from external db, you need to write a service, which read data from db and update tree by REST

  24. Yury Oboz repo owner

    I can show REST API, or you can install "Atlassian REST API Browser" from marketplace and explore API yourself. REST API provides methods for create/delete/update/move values in tree and much more

  31. Log in to comment
Assignee
–
Type
proposal
Priority
major
Status
wontfix
Component
admin
Votes
0
Watchers
1
Jira: the preferred issue tracker for Bitbucket. Join the team!