Support Needed on Zen Tao's DB Please - Thanks!
2016-03-24 17:39:31
riccardotomada

Hi Chunge,


First of all thank you for having created this software and for giving the option of downloading the open source version - personally amongst the best ALM open source softwares encountered so far!

In any case, I am writing to you as I am now trying to understand the DB (MySQL) aspect of Zen Tao, and was wondering if it is possible and available to get a detailed manual/information about it. I have seen that in the help section of the website there is one-page dedicated to this part, however, if there is the possibility to have more details it would be of great help.

For example, is it possibile to get an explanation of the structure of the tables; and specifically, is there a way to extract the time and date of the status of bugs? What I intend is, if a bug has been opened (status: Active) and the it is changed into status: Resolved and then into status: Closed how can I , through the DB (MySQL), obtain the relevant time and dates of the various statuses?


I please ask you to help me, if you can answer the raised questions but most of all if you have some sort of detailed manual.

I thank you very much in advance,


Best Regards,

Riccardo Tomada

2016-04-06 09:30:05
chunge

Hello, sorry for late reply.


There's a database help page in the zentao. you can find it at Admin-> develop->database.

2016-04-06 09:33:13
chunge

About the bug status:


when created, the status is active.

when resoled, the status changed to resolved, also the developer can choose resolution.

then the bug assigned to the user who created the bug, he can confirm the bug resolved or not.

If resolved, he can close the bug, the status changed to closed. can the bug's lifetime ove.

If not resolved, he can activate the bug, the status changed to active again, can be assigned to the resolver to fix it.

#3
2016-04-06 09:38:04
chunge

There're some fields in zt_bug table to recored the time and users. for example:


createdBy and createdDate

resolevedBy and resolvedDate

closedBy and closed Date.


There're also a table named zt_action which records all actions of every object.

#4
2016-04-08 22:17:15
riccardotomada

Hi Chunge,


No worries! In the interval that you replied to me I had seen those two tables (zt_action and zt_bug) and found a solution. Thanks for the reply as it confirms my findings!! In case other query arise, I'll contact you again, though I am pretty sure everything is now clear to me!


Thanks again for the support,

All the best,

Riccardo

#5
2016-04-11 17:09:11
chunge
, great!
#6
2023-08-14 15:41:10
Roy Albert
  • Visit: 3
  • Join Date: 2023-08-14
  • Last Login: 2023-09-21
Thank you for the thoughtful questions regarding accessing additional technical details on the ZenTao database structure and manipulating status data for bug tracking analysis. For software engineering students working on related assignments, services like urgent assignment writing help can provide MySQL and data modeling assistance. Understanding database schema design enables retrieving specific fields of interest, like timestamped state changes. While I don't have inside access to ZenTao documentation, you may try reaching out to their development team directly if detailed specs aren't publicly available. I appreciate you taking the initiative to understand underlying frameworks - that mindset will serve any IT role well. Best of luck with your continued database learnings!

#7
2023-08-25 18:28:09
Thomas Larry
  • Visit: 2
  • Join Date: 2023-08-25
  • Last Login: 2023-08-25
I'm delighted you're finding the open-source version of Zen Tao valuable for your project! Regarding your MySQL-related inquiries, while the website's current help section offers a brief overview, a more comprehensive guide or manual benefits users like you. Exploring a detailed [url=https://www.onlinedissertationhelp.com/case-study/case-study-assignment-help/] case study assignment help[/url] to focus on Zen Tao's DB aspects would enhance the user experience and understanding. Your enthusiasm for deeper insights is respected, and I hope such resources become available to support your exploration of Zen Tao's capabilities.
1/1