Support Needed on Zen Tao's DB Please - Thanks!
2016-03-24 17:39:31
  • Visit: 5
  • Join Date: 2016-03-24
  • Last Login: 2016-03-29

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

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

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.

2016-04-06 09:38:04

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.

2016-04-08 22:17:15
  • Visit: 5
  • Join Date: 2016-03-24
  • Last Login: 2016-03-29

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,


2016-04-11 17:09:11
, great!