I want to know the average between the ticket created and closed, so I need to know as I understand the update log of the ticket where can I find the table of this, and I can not find trouble ticket table it's not exists !!!
I can not find where the logs of an updated ticket exists in vtiger opensource 6.5
242 Views Asked by shrouk mansour At
1
There are 1 best solutions below
Related Questions in VTIGER
- Mysql Hosting requirements vtiger
- vTiger mail manager imap failed
- Batch Job on Windows Server 2012 Access denied
- Vtiger CRM Pick list Dependencies
- Text displayed on the vertical axis of the calendar
- How to configure the crontab with chmod privilege?
- calendar module take long time to load in vtiger5.4
- How to work with AppConnector in Vtiger?
- Cannot save Todo event on vTiger CRM 6.1
- Search by product code in SalesOrder vtiger
- Vtiger6 how to integrate with existing website
- Extending classes or Interface or Abstract - PHP Child Classes for MVC ref: Vtiger
- mkdir(): Permission denied in /var/www/vtiger/includes/runtime/Viewer.php
- no popup window asterisk 11 with vtiger crm
- A blank screen is showing after creating invoice
Related Questions in VTIGERCRM
- How to configure the crontab with chmod privilege?
- How to work with AppConnector in Vtiger?
- Vtiger 7 import special characters UTF8 doesn't work
- I can not find where the logs of an updated ticket exists in vtiger opensource 6.5
- Vtiger 7 workflow to create record in Quote Module
- Adding custom dropdown(values dynamically from db) in the lead form in vTiger
- How to import language pack in vtigercrm71?
- I want to install vtigercrm 7.0.1 with Wamp server
- how to add new field to vtiger_activity in vtiger crm
- vtiger 7.3 issue trying to save images in several modules - e.g. contacts, products, users
- Gsuite mail set up for vtiger mail manager
- what is bootstrap vtlib script in vtiger crm 7?
- vTiger 7.3.0 lead pagination next button is not working and it shows a different number of leads in each page
- Vtiger 7.1. Is there any way to modify the position of a Field or a Block using VTlib?
- create module for vtiger
Related Questions in DYNAMIC-PICKLIST-VTIGER
- I can not find where the logs of an updated ticket exists in vtiger opensource 6.5
- Adding custom dropdown(values dynamically from db) in the lead form in vTiger
- How to find the record_Id((module-type-id and module-record-id) separated by (x)) for REST API in vTiger CRM
- UPDATE and REVISE rest api is not working in vTiger CRM cloud service
- Get Module data of a user from Vtiger CRM
- VBA/Excel dynamic list control
- How to create custom field in contact module in vtiger CRM
- Error message when creating a contact in vtiger CRM
- Error when running a crm in php: Module name is missing or incorrect. Please check the module name
- I made module for vtiger 6.5 but it is not showing.
- How to change reply_to multiple email address in Vtiger 6.4 for all the outgoing mails via Mail Manager?
- vtiger 7.5 how to add dynamic picklist to module add new/edit form
- How to pass two parameters to a select to a SELECT query in vtiger?
- Vtiger - Editing the Picklistutils.php script to select certain values for custom fields
Trending Questions
- UIImageView Frame Doesn't Reflect Constraints
- Is it possible to use adb commands to click on a view by finding its ID?
- How to create a new web character symbol recognizable by html/javascript?
- Why isn't my CSS3 animation smooth in Google Chrome (but very smooth on other browsers)?
- Heap Gives Page Fault
- Connect ffmpeg to Visual Studio 2008
- Both Object- and ValueAnimator jumps when Duration is set above API LvL 24
- How to avoid default initialization of objects in std::vector?
- second argument of the command line arguments in a format other than char** argv or char* argv[]
- How to improve efficiency of algorithm which generates next lexicographic permutation?
- Navigating to the another actvity app getting crash in android
- How to read the particular message format in android and store in sqlite database?
- Resetting inventory status after order is cancelled
- Efficiently compute powers of X in SSE/AVX
- Insert into an external database using ajax and php : POST 500 (Internal Server Error)
Popular Questions
- How do I undo the most recent local commits in Git?
- How can I remove a specific item from an array in JavaScript?
- How do I delete a Git branch locally and remotely?
- Find all files containing a specific text (string) on Linux?
- How do I revert a Git repository to a previous commit?
- How do I create an HTML button that acts like a link?
- How do I check out a remote Git branch?
- How do I force "git pull" to overwrite local files?
- How do I list all files of a directory?
- How to check whether a string contains a substring in JavaScript?
- How do I redirect to another webpage?
- How can I iterate over rows in a Pandas DataFrame?
- How do I convert a String to an int in Java?
- Does Python have a string 'contains' substring method?
- How do I check if a string contains a specific word?
Changes are log in
vtiger_modtracker_basicandvtiger_modtracker_detail.In
vtiger_modtracker_basicyou can find crmid, who made the change, when and what (the status) Here the status values:In
vtiger_modtracker_detailyou can find which field has changed and the new and previous value.So for your need, you should join both tables and calcuate the delay between the creation time and the date where the ticket changes its status from open to close.