Cascading fields or Multi level tree populated from changing HFSQL DB or csv file
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)
-
repo owner -
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.
-
reporter Just one further question about the 2 tables (having the same name).
-
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
-
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.
-
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"
-
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?
-
reporter We can use GoToMeeting
-
repo owner -
reporter When are you available to start the meeting please? I'm available now until 4pm (paris time)
-
repo owner Unfortunately, I am unavailable today, maybe tomorrow?
-
reporter OK 10am-11am ok for you?
-
reporter CET Paris Time
-
repo owner 14-16 Paris time
-
reporter Sorry, I have a meeting on that time slot. May be at 16.30? if possible
-
repo owner Yes. It's even better for me
-
reporter OK cool so tomorrow 16h30
-
repo owner Can you send me list of questions?
-
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
-
repo owner are we talking about an external database?
-
reporter yes
-
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
-
reporter Do you have an example so that I can follow
-
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
-
repo owner Are you developer?
-
reporter No
-
reporter I'm connected to the meeting
-
reporter u there?
-
repo owner -
repo owner - changed status to wontfix
- Log in to comment
Hi!
1) You can use two tables:
AO_AA9326_OPTION contains values
AO_AA9326_OPTION contains schemas info
select level1(without parent)
select level2(with parent)
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.