Recent
`digitidefeedbackdb`.`vtiger_currency_grouping_pattern_seq`
`information_schema`.`ST_UNITS_OF_MEASURE`
`performance_schema`.`host_cache`
`performance_schema`.`keyring_component_status`
`performance_schema`.`events_statements_summary_by_program`
`digitidefeedbackdb`.`vtiger_attachmentsfolder_seq`
`sys`.`io_global_by_wait_by_bytes`
`sys`.`x$memory_by_host_by_current_bytes`
`digitidefeedbackdb`.`vtiger_cntactivityrel`
`digitidefeedbackdb`.`vtiger_attachmentsfolder`
Favorites
There are no favorite tables.
New
digitidefbdb
digitidefeedbackdb
information_schema
mysql
performance_schema
replication
sakila
sys
world
Navigation panel
Navigation tree
Servers
Databases
Tables
Navigation panel
Customize appearance of the navigation panel.
Navigation panel
Show databases navigation as tree
In the navigation panel, replaces the database tree with a selector
Link with main panel
Link with main panel by highlighting the current database or table.
Display logo
Show logo in navigation panel.
Logo link URL
URL where logo in the navigation panel will point to.
Logo link target
Open the linked page in the main window (
main
) or in a new one (
new
).
main
new
Enable highlighting
Highlight server under the mouse cursor.
Maximum items on first level
The number of items that can be displayed on each page on the first level of the navigation tree.
Minimum number of items to display the filter box
Defines the minimum number of items (tables, views, routines and events) to display a filter box.
Recently used tables
Maximum number of recently used tables; set 0 to disable.
Favorite tables
Maximum number of favorite tables; set 0 to disable.
Navigation panel width
Set to 0 to collapse navigation panel.
Navigation tree
Customize the navigation tree.
Navigation tree
Maximum items in branch
The number of items that can be displayed on each page of the navigation tree.
Group items in the tree
Group items in the navigation tree (determined by the separator defined in the Databases and Tables tabs above).
Enable navigation tree expansion
Whether to offer the possibility of tree expansion in the navigation panel.
Show tables in tree
Whether to show tables under database in the navigation tree
Show views in tree
Whether to show views under database in the navigation tree
Show functions in tree
Whether to show functions under database in the navigation tree
Show procedures in tree
Whether to show procedures under database in the navigation tree
Show events in tree
Whether to show events under database in the navigation tree
Expand single database
Whether to expand single database in the navigation tree automatically.
Servers
Servers display options.
Servers
Display servers selection
Display server choice at the top of the navigation panel.
Display servers as a list
Show server listing as a list instead of a drop down.
Databases
Databases display options.
Databases
Minimum number of databases to display the database filter box
Database tree separator
String that separates databases into different tree levels.
Tables
Tables display options.
Tables
Target for quick access icon
Structure
SQL
Search
Insert
Browse
Target for second quick access icon
Structure
SQL
Search
Insert
Browse
Table tree separator
String that separates tables into different tree levels.
Maximum table tree depth
Drop files here
SQL upload (
0
)
x
-
Show hidden navigation tree items.
Create view
Your browser has phpMyAdmin configuration for this domain. Would you like to import it for current session?
Yes
/
No
/
Delete settings
Javascript must be enabled past this point!
Server: 127.0.0.1:3307
Database: digitidefeedbackdb
Structure
SQL
Search
Query
(current)
Export
Import
Operations
Privileges
Routines
Events
Triggers
Designer
Console
Clear
History
Options
Debug SQL
Press Ctrl+Enter to execute query
Press Enter to execute query
ascending
descending
Order:
Debug SQL
Count
Execution order
Time taken
Order by:
Group queries
Ungroup queries
Collapse
Expand
Show trace
Hide trace
Count :
Time taken :
Options
Set default
Always expand query messages
Show query history at start
Show current browsing query
Execute queries on Enter and insert new line with Shift+Enter. To make this permanent, view settings.
Switch to dark theme
Collapse
Expand
Requery
Edit
Explain
Profiling
Query failed
Database :
Queried time :
Loading
ENUM/SET editor
Create view
Multi-table query
Query by example
Query window
*
apid
apilink
params
apdate
*
aslid
ipaddress
api
apiurl
requestparam
requestdatetime
responseparam
responsedatetime
*
workflow_id
module_name
summary
test
execution_condition
defaultworkflow
type
filtersavedinnew
schtypeid
schdayofmonth
schdayofweek
schannualdates
schtime
nexttrigger_time
status
workflowname
*
id
*
task_id
workflow_id
summary
task
*
workflowtasks_entitymethod_id
module_name
method_name
function_path
function_name
*
id
*
id
*
task_id
entity_id
do_after
relatedinfo
task_contents
*
template_id
module_name
title
template
*
workflow_id
entity_id
*
id
tasktypename
label
classname
classpath
templatepath
modules
sourcemodule
*
id
*
id
Category
Subcategory
Subsubcategory
Productcategory
*
accountid
account_no
accountname
parentid
account_type
industry
annualrevenue
rating
ownership
siccode
tickersymbol
phone
otherphone
email1
email2
website
fax
employees
emailoptout
notify_owner
isconvertedfromlead
tags
*
accountaddressid
bill_city
bill_code
bill_country
bill_state
bill_street
bill_pobox
*
accountratingid
rating
sortorderid
presence
*
accountid
*
accountaddressid
ship_city
ship_code
ship_country
ship_state
ship_pobox
ship_street
*
accounttypeid
accounttype
presence
picklist_valueid
sortorderid
color
*
id
*
actionid
actionname
securitycheck
*
activityid
subject
semodule
activitytype
date_start
due_date
time_start
time_end
sendnotification
duration_hours
duration_minutes
status
eventstatus
priority
location
notime
visibility
recurringtype
tags
*
activityid
*
activityid
productid
*
activitytypeid
activitytype
presence
picklist_valueid
sortorderid
color
*
id
*
activityid
recurrenceid
*
activity_id
reminder_time
reminder_sent
recurringid
*
reminderid
semodule
recordid
date_start
time_start
status
*
activity_viewid
activity_view
sortorderid
presence
*
id
*
creatorid
announcement
title
time
*
apilogsid
apitype
*
apilogsid
*
tabid
appname
sequence
visible
*
assetsid
asset_no
account
product
serialnumber
datesold
dateinservice
assetstatus
tagnumber
invoiceid
shippingmethod
shippingtrackingnumber
assetname
contact
tags
*
assetsid
*
assetstatusid
assetstatus
presence
picklist_valueid
sortorderid
color
*
id
*
server
port
username
password
version
*
userid
asterisk_extension
use_asterisk
*
from_number
from_name
to_number
callertype
flag
timer
refuid
*
uid
channel
from_number
from_name
to_number
callertype
timer
flag
pbxrecordid
relcrmid
*
attachmentsid
name
description
type
path
storedname
subject
*
folderid
foldername
description
createdby
sequence
*
id
*
auditid
userid
module
action
recordid
actiondate
*
blockid
tabid
blocklabel
sequence
show_title
visible
create_view
edit_view
detail_view
display_status
iscustom
*
id
*
branchid
branchname
*
branchid
cf_880
cf_882
cf_884
cf_886
cf_888
cf_890
cf_892
cf_894
cf_896
cf_898
cf_900
cf_902
cf_904
*
calendarsharedtypeid
calendarsharedtype
sortorderid
presence
*
id
*
id
module
fieldname
defaultcolor
isdefault
conditions
*
id
*
id
defaultid
userid
color
visible
*
id
*
calldetailid
leadname
*
calldetailid
*
calldurationid
callduration
sortorderid
presence
*
id
*
campaign_no
campaignname
campaigntype
campaignstatus
expectedrevenue
budgetcost
actualcost
expectedresponse
numsent
product_id
sponsor
targetaudience
targetsize
expectedresponsecount
expectedsalescount
expectedroi
actualresponsecount
actualsalescount
actualroi
campaignid
closingdate
tags
*
campaignid
accountid
campaignrelstatusid
*
campaignid
contactid
campaignrelstatusid
*
campaignid
leadid
campaignrelstatusid
*
campaignrelstatusid
campaignrelstatus
sortorderid
presence
color
*
id
*
campaignid
*
campaignstatusid
campaignstatus
presence
picklist_valueid
sortorderid
color
*
id
*
campaigntypeid
campaigntype
presence
picklist_valueid
sortorderid
color
*
id
*
carrierid
carrier
presence
picklist_valueid
sortorderid
color
*
id
*
cf_900id
cf_900
sortorderid
presence
color
*
id
*
cf_904id
cf_904
sortorderid
presence
color
*
id
*
cf_912id
cf_912
sortorderid
presence
color
*
id
*
cf_916id
cf_916
sortorderid
presence
color
*
id
*
cf_918id
cf_918
sortorderid
presence
color
*
id
*
cf_920id
cf_920
sortorderid
presence
color
*
id
*
cf_922id
cf_922
sortorderid
presence
color
*
id
*
cf_924id
cf_924
sortorderid
presence
color
*
id
*
cf_926id
cf_926
sortorderid
presence
color
*
id
*
cf_936id
cf_936
sortorderid
presence
color
*
id
*
cf_946id
cf_946
sortorderid
presence
color
*
id
*
cf_978id
cf_978
sortorderid
presence
color
*
id
*
cf_1018id
cf_1018
sortorderid
presence
color
*
id
*
cf_1030id
cf_1030
sortorderid
presence
color
*
id
*
cf_1034id
cf_1034
sortorderid
presence
color
*
id
*
cf_1038id
cf_1038
sortorderid
presence
color
*
id
*
cf_1054id
cf_1054
sortorderid
presence
color
*
id
*
cf_1056id
cf_1056
sortorderid
presence
color
*
id
*
cf_1058id
cf_1058
sortorderid
presence
color
*
id
*
cf_1060id
cf_1060
sortorderid
presence
color
*
id
*
cf_1062id
cf_1062
sortorderid
presence
color
*
id
*
cf_1070id
cf_1070
sortorderid
presence
color
*
id
*
cf_1072id
cf_1072
sortorderid
presence
color
*
id
*
cf_1074id
cf_1074
sortorderid
presence
color
*
id
*
cf_1096id
cf_1096
sortorderid
presence
color
*
id
*
cf_1120id
cf_1120
sortorderid
presence
color
*
id
*
cf_1146id
cf_1146
sortorderid
presence
color
*
id
*
cf_1148id
cf_1148
sortorderid
presence
color
*
id
*
cf_1150id
cf_1150
sortorderid
presence
color
*
id
*
cf_1152id
cf_1152
sortorderid
presence
color
*
id
*
cf_1164id
cf_1164
sortorderid
presence
color
*
id
*
contactid
activityid
*
contactaddressid
mailingcity
mailingstreet
mailingcountry
othercountry
mailingstate
mailingpobox
othercity
otherstate
mailingzip
otherzip
otherstreet
otherpobox
*
contactid
contact_no
accountid
salutation
firstname
lastname
email
phone
mobile
title
department
fax
reportsto
training
usertype
contacttype
otheremail
secondaryemail
donotcall
emailoptout
imagename
reference
notify_owner
isconvertedfromlead
tags
*
contactid
cf_1146
cf_1148
cf_1150
cf_1152
cf_1154
cf_1156
cf_1158
cf_1160
cf_1162
cf_1164
cf_1166
*
contactsubscriptionid
homephone
otherphone
assistant
assistantphone
birthday
laststayintouchrequest
laststayintouchsavedate
leadsource
*
contactid
potentialid
*
contract_priorityid
contract_priority
presence
picklist_valueid
sortorderid
color
*
id
*
contract_statusid
contract_status
presence
picklist_valueid
sortorderid
color
*
id
*
contract_typeid
contract_type
presence
picklist_valueid
sortorderid
color
*
id
*
cfmid
leadfid
accountfid
contactfid
potentialfid
editable
*
cfmid
potentialfid
projectfid
editable
*
crmid
smcreatorid
smownerid
modifiedby
setype
description
createdtime
modifiedtime
viewedtime
status
version
presence
deleted
smgroupid
source
label
*
crmid
module
relcrmid
relmodule
*
id
*
recordid
userid
starred
*
userid
setup_status
*
id
name
handler_file
frequency
laststart
lastend
status
module
sequence
description
*
currencyid
currency_name
currency_code
currency_symbol
*
id
*
currencyid
currency
sortorderid
presence
*
currency_decimal_separatorid
currency_decimal_separator
sortorderid
presence
*
id
*
currency_grouping_patternid
currency_grouping_pattern
sortorderid
presence
*
id
*
currency_grouping_separatorid
currency_grouping_separator
sortorderid
presence
*
id
*
id
currency_name
currency_code
currency_symbol
conversion_rate
currency_status
defaultid
deleted
*
id
*
currency_symbol_placementid
currency_symbol_placement
sortorderid
presence
*
id
*
cvid
subject
module
content
*
customerid
portal
support_start_date
support_end_date
*
tabid
fieldinfo
records_visible
*
tabid
prefkey
prefvalue
*
tabid
relatedmodules
*
id
url
default_assignee
support_notification
announcement
shortcuts
widgets
charts
*
tabid
visible
sequence
createrecord
editrecord
*
custommoduleid
custom_field_name
custom_date_field
*
custommoduleid
*
cvid
viewname
setdefault
setmetrics
entitytype
status
userid
*
id
*
cvid
groupid
*
cvid
roleid
*
cvid
rsid
*
cvid
userid
*
cvid
columnindex
columnname
comparator
value
groupid
column_condition
*
groupid
cvid
group_condition
condition_expression
*
cvid
columnindex
columnname
*
cvid
columnname
stdfilter
startdate
enddate
*
id
tabname
isdefault
sequence
appname
modulename
userid
*
shareid
share_groupid
to_groupid
permission
*
shareid
share_groupid
to_roleid
permission
*
shareid
share_groupid
to_roleandsubid
permission
*
shareid
tabid
relationtype
*
datashare_relatedmodule_id
tabid
relatedto_tabid
*
id
*
shareid
datashare_relatedmodule_id
permission
*
shareid
share_roleid
to_groupid
permission
*
shareid
share_roleid
to_roleid
permission
*
shareid
share_roleid
to_roleandsubid
permission
*
shareid
share_roleandsubid
to_groupid
permission
*
shareid
share_roleandsubid
to_roleid
permission
*
shareid
share_roleandsubid
to_roleandsubid
permission
*
date_formatid
date_format
sortorderid
presence
*
id
*
dayoftheweekid
dayoftheweek
sortorderid
presence
*
id
*
defaultactivitytypeid
defaultactivitytype
presence
picklist_valueid
sortorderid
*
id
*
defaultcalendarviewid
defaultcalendarview
sortorderid
presence
*
id
*
tabid
defaultviewname
query
*
defaulteventstatusid
defaulteventstatus
presence
picklist_valueid
sortorderid
*
id
*
defaultlandingpageid
defaultlandingpage
presence
picklist_valueid
sortorderid
color
*
id
*
default_record_viewid
default_record_view
sortorderid
presence
*
id
*
tabid
fieldid
visible
readonly
*
ruleid
tabid
permission
editstatus
*
id
*
districtmasterid
districtname
districtcode
country
state
districtactive
*
hrsid
hrs
sortorderid
presence
*
minsid
mins
sortorderid
presence
*
minutesid
duration_minutes
sortorderid
presence
color
*
id
*
emailid
from_email
to_email
cc_email
bcc_email
assigned_user_email
idlists
email_flag
*
crmid
setype
value
fieldid
*
id
tabid
prefs
userid
*
foldername
templatename
templatepath
subject
description
body
deleted
templateid
systemtemplate
module
*
id
*
crmid
mailid
accessdate
accesstime
*
crmid
mailid
access_count
click_count
*
tabid
modulename
tablename
fieldname
entityidfield
entityidcolumn
*
eventhandler_id
event_name
handler_path
handler_class
cond
is_active
dependent_on
*
id
*
eventhandler_module_id
module_name
handler_class
*
id
*
eventstatusid
eventstatus
presence
picklist_valueid
sortorderid
color
*
id
*
expectedresponseid
expectedresponse
presence
picklist_valueid
sortorderid
color
*
id
*
id
username
password
instanceurl
createdon
deleted
*
id
faq_no
product_id
question
answer
category
status
tags
*
faqcategories_id
faqcategories
presence
picklist_valueid
sortorderid
color
*
id
*
faqid
*
commentid
faqid
comments
createdtime
*
faqstatus_id
faqstatus
presence
picklist_valueid
sortorderid
color
*
id
*
userid
dontshow
*
tabid
fieldid
columnname
tablename
generatedtype
uitype
fieldname
fieldlabel
readonly
presence
defaultvalue
maximumlength
sequence
block
displaytype
typeofdata
quickcreate
quickcreatesequence
info_type
masseditable
helpinfo
summaryfield
headerfield
isunique
*
fieldid
module
relmodule
status
sequence
*
id
*
tag_id
tagger_id
object_id
tagged_on
module
*
id
tag
raw_tag
visibility
owner
*
id
*
glacctid
glacct
presence
picklist_valueid
sortorderid
color
*
id
*
event_id
calendar_id
user_id
*
service
access_token
refresh_token
userid
*
vtiger_field
google_field
google_field_type
google_custom_label
user
*
user
module
clientgroup
direction
enabled
*
groupid
containsgroupid
*
groupid
roleid
*
groupid
roleandsubid
*
groupid
groupname
description
*
stuffid
dashbdname
dashbdtype
*
stuffid
hometype
maxentries
setype
*
stuffid
modulename
maxentries
customviewid
setype
*
stuffid
fieldname
*
stuffid
reportid
reportcharttype
*
stuffid
url
maxentries
*
stuffid
stuffsequence
stufftype
userid
visible
stufftitle
*
id
*
userid
layout
*
hour_formatid
hour_format
sortorderid
presence
*
id
*
id
status
recordid
firstname
lastname
mobile
email
cf_1166
birthday
cf_1146
cf_1148
cf_1150
cf_1152
cf_1158
cf_1160
cf_1154
cf_1156
description
mailingstreet
otherstreet
mailingpobox
otherpobox
mailingcity
othercity
mailingstate
otherstate
mailingzip
otherzip
mailingcountry
othercountry
*
vtiger_import_lock_id
userid
tabid
importid
locked_since
*
id
*
id
name
module
content
has_header
deleted
date_entered
date_modified
assigned_user_id
is_published
*
importid
userid
tabid
field_mapping
default_values
merge_type
merge_fields
status
lineitem_currency_id
paging
*
id
*
industryid
industry
presence
picklist_valueid
sortorderid
color
*
id
*
chargeid
name
format
type
value
regions
istaxable
taxes
deleted
*
recordid
charges
*
notificationid
notificationname
notificationsubject
notificationbody
label
status
*
id
*
id
productid
sequence_no
quantity
listprice
discount_percent
discount_amount
comment
description
incrementondel
lineitem_id
tax1
tax2
tax3
image
purchase_cost
margin
*
id
*
id
shtax1
shtax2
shtax3
*
id
sequence_no
productid
quantity
*
taxid
taxname
taxlabel
percentage
deleted
method
type
compoundon
regions
*
id
*
id
type
tandc
*
id
*
activityid
inviteeid
status
*
invoiceid
subject
salesorderid
customerno
contactid
notes
invoicedate
duedate
invoiceterms
type
adjustment
salescommission
exciseduty
subtotal
total
taxtype
discount_percent
discount_amount
s_h_amount
shipping
accountid
terms_conditions
purchaseorder
invoicestatus
invoice_no
currency_id
conversion_rate
compound_taxes_info
pre_tax_total
received
balance
s_h_percent
potential_id
tags
region_id
*
invoicebilladdressid
bill_city
bill_code
bill_country
bill_state
bill_street
bill_pobox
*
invoiceid
*
invoiceshipaddressid
ship_city
ship_code
ship_country
ship_state
ship_street
ship_pobox
*
invoicestatusid
invoicestatus
presence
picklist_valueid
sortorderid
color
*
historyid
invoiceid
accountname
total
invoicestatus
lastmodified
*
id
*
salesorderid
recurring_frequency
start_period
end_period
last_recurring_date
payment_duration
invoice_status
*
id
name
prefix
label
lastupdated
sequence
isdefault
active
*
id
*
leadaddressid
city
code
state
pobox
country
phone
mobile
fax
lane
leadaddresstype
*
leadid
lead_no
email
interest
firstname
salutation
lastname
company
annualrevenue
industry
campaign
rating
leadstatus
leadsource
converted
designation
licencekeystatus
space
comments
priority
demorequest
partnercontact
productversion
product
maildate
nextstepdate
fundingsituation
purpose
evaluationstatus
transferdate
revenuetype
noofemployees
secondaryemail
assignleadchk
emailoptout
tags
*
leadid
cf_906
cf_908
cf_910
cf_912
cf_914
cf_916
cf_1030
cf_1032
cf_1034
cf_1036
cf_1038
cf_1040
cf_1042
cf_1044
cf_1046
cf_1048
cf_1050
cf_1052
cf_1054
cf_1056
cf_1058
cf_1060
cf_1062
cf_1064
cf_1066
cf_1068
cf_1070
cf_1072
cf_1074
cf_1076
cf_1078
cf_1080
cf_1082
cf_1084
cf_1086
cf_1088
cf_1090
cf_1092
cf_1094
cf_1096
cf_1098
cf_1100
cf_1102
cf_1104
cf_1106
cf_1108
cf_1110
cf_1112
cf_1114
cf_1116
cf_1118
cf_1120
cf_1122
cf_1124
cf_1126
cf_1128
cf_1130
cf_1132
cf_1134
cf_1136
cf_1138
cf_1140
cf_1142
cf_1144
*
leadsourceid
leadsource
presence
picklist_valueid
sortorderid
color
*
id
*
leadstageid
stage
sortorderid
presence
*
leadstatusid
leadstatus
presence
picklist_valueid
sortorderid
color
*
id
*
leadsubscriptionid
website
callornot
readornot
empct
*
lead_viewid
lead_view
sortorderid
presence
*
id
*
linkid
tabid
linktype
linklabel
linkurl
linkicon
sequence
handler_path
handler_class
handler
parent_link
*
id
*
login_id
user_name
user_ip
logout_time
login_time
status
*
id
fromname
fromemail
mailer
content_type
subject
body
relcrmid
failed
failreason
*
id
path
name
encoding
type
*
id
name
email
type
*
userid
muid
aname
lastsavedtime
attachid
path
cid
*
userid
mfrom
mto
mcc
mbcc
mdate
msubject
mbody
mcharset
misbodyhtml
mplainmessage
mhtmlmessage
muniqueid
mbodyparsed
muid
lastsavedtime
folder
mfolder
*
mailuid
crmid
emailid
*
scannerid
scannername
server
protocol
username
password
ssltype
sslmethod
auth_type
auth_expireson
mail_proxy
connecturl
searchfor
markas
isvalid
scanfrom
time_zone
*
actionid
scannerid
actiontype
module
lookup
sequence
*
folderid
scannerid
foldername
lastscan
rescan
enabled
*
scannerid
messageid
crmid
refids
*
ruleid
actionid
*
ruleid
scannerid
fromaddress
toaddress
subjectop
subject
bodyop
body
matchusing
sequence
assigned_to
cc
bcc
*
account_id
user_id
display_name
mail_id
account_name
mail_protocol
mail_username
mail_password
mail_servername
auth_type
auth_expireson
mail_proxy
box_refresh
mails_per_page
ssltype
sslmeth
int_mailer
status
set_default
sent_folder
*
manufacturerid
manufacturer
presence
picklist_valueid
sortorderid
color
*
id
*
id
handler_path
handler_class
sequence
deleted
*
modcommentsid
commentcontent
related_to
parent_comments
customer
userid
reasontoedit
is_private
filename
related_email_id
*
modcommentsid
*
num_id
semodule
prefix
start_id
cur_id
active
*
id
*
id
crmid
module
whodid
changedon
status
*
id
*
id
fieldname
prevalue
postvalue
*
id
targetmodule
targetid
changedon
*
tabid
visible
*
id
linkid
userid
filterid
title
data
position
reportid
dashboardtabid
size
*
userid
notebookid
contents
*
notesid
note_no
title
filename
notecontent
folderid
filetype
filelocationtype
filedownloadcount
filestatus
filesize
fileversion
tags
*
notesid
*
schedulednotificationid
schedulednotificationname
active
notificationsubject
notificationbody
label
type
*
id
*
no_of_currency_decimalsid
no_of_currency_decimals
sortorderid
presence
*
id
*
potstageid
stage
sortorderid
presence
probability
*
opptypeid
opportunity_type
presence
picklist_valueid
sortorderid
color
*
id
*
organization_id
organizationname
address
city
state
country
code
phone
fax
website
logoname
logo
vatid
*
id
*
share_action_id
tabid
*
share_action_id
share_action_name
*
othereventdurationid
othereventduration
sortorderid
presence
*
id
*
parenttabid
parenttab_label
sequence
visible
*
parenttabid
tabid
sequence
*
payment_duration_id
payment_duration
sortorderid
presence
color
*
id
*
pbxmanagerid
direction
callstatus
starttime
endtime
totalduration
billduration
recordingurl
sourceuuid
gateway
customer
user
customernumber
customertype
*
pbxmanagerid
*
id
gateway
parameters
*
crmid
setype
fnumber
rnumber
fieldname
*
picklistid
name
*
id
*
id
tabid
sourcefield
targetfield
sourcevalue
targetvalues
criteria
*
id
*
fieldname
module
transition_data
*
pobilladdressid
bill_city
bill_code
bill_country
bill_state
bill_street
bill_pobox
*
portalid
portalname
portalurl
sequence
setdefault
createdtime
*
id
user_name
user_password
type
cryptmode
last_login_time
login_time
logout_time
isactive
*
poshipaddressid
ship_city
ship_code
ship_country
ship_state
ship_street
ship_pobox
*
postatusid
postatus
presence
picklist_valueid
sortorderid
color
*
historyid
purchaseorderid
vendorname
total
postatus
lastmodified
*
id
*
potentialid
potential_no
related_to
potentialname
amount
currency
closingdate
typeofrevenue
nextstep
private
probability
campaignid
sales_stage
potentialtype
leadsource
productid
productversion
quotationref
partnercontact
remarks
runtimefee
followupdate
evaluationstatus
description
forecastcategory
outcomeanalysis
forecast_amount
isconvertedfromlead
contact_id
tags
converted
*
potentialid
*
historyid
potentialid
amount
stage
probability
expectedrevenue
closedate
lastmodified
*
pricebookid
pricebook_no
bookname
active
currency_id
tags
*
pricebookid
*
pricebookid
productid
listprice
usedcurrency
*
priorityid
priority
sortorderid
presence
*
productcategoryid
productcategory
presence
picklist_valueid
sortorderid
color
*
id
*
productid
*
productid
currencyid
converted_price
actual_price
*
productid
product_no
productname
productcode
productcategory
manufacturer
qty_per_unit
unit_price
weight
pack_size
sales_start_date
sales_end_date
start_date
expiry_date
cost_factor
commissionrate
commissionmethod
discontinued
usageunit
reorderlevel
website
taxclass
mfr_part_no
vendor_part_no
serialno
qtyinstock
productsheet
qtyindemand
glacct
vendor_id
imagename
currency_id
is_subproducts_viewable
purchase_cost
tags
*
productid
taxid
taxpercentage
regions
*
profileid
profilename
description
directly_related_to_role
*
profileid
tabid
fieldid
visible
readonly
*
profileid
globalactionid
globalactionpermission
*
profileid
tabid
operation
permissions
*
profileid
tabid
permissions
*
profileid
tabid
activityid
permission
*
id
*
progressid
progress
presence
picklist_valueid
sortorderid
color
*
id
*
projectid
projectname
project_no
startdate
targetenddate
actualenddate
targetbudget
projecturl
projectstatus
projectpriority
projecttype
progress
linktoaccountscontacts
tags
isconvertedfrompotential
potentialid
*
projectid
*
projectmilestoneid
projectmilestonename
projectmilestone_no
projectmilestonedate
projectid
projectmilestonetype
tags
*
projectmilestoneid
*
projectmilestonetypeid
projectmilestonetype
presence
picklist_valueid
sortorderid
color
*
id
*
projectpriorityid
projectpriority
presence
picklist_valueid
sortorderid
color
*
id
*
projectstatusid
projectstatus
presence
picklist_valueid
sortorderid
color
*
id
*
projecttaskid
projecttaskname
projecttask_no
projecttasktype
projecttaskpriority
projecttaskprogress
projecttaskhours
startdate
enddate
projectid
projecttasknumber
tags
projecttaskstatus
*
projecttaskid
*
projecttaskpriorityid
projecttaskpriority
presence
picklist_valueid
sortorderid
color
*
id
*
projecttaskprogressid
projecttaskprogress
presence
picklist_valueid
sortorderid
color
*
id
*
projecttaskstatusid
projecttaskstatus
presence
picklist_valueid
sortorderid
color
*
id
*
projecttasktypeid
projecttasktype
presence
picklist_valueid
sortorderid
color
*
id
*
status
defaultcolor
color
*
projecttypeid
projecttype
presence
picklist_valueid
sortorderid
color
*
id
*
purchaseorderid
subject
quoteid
vendorid
requisition_no
purchaseorder_no
tracking_no
contactid
duedate
carrier
type
adjustment
salescommission
exciseduty
total
subtotal
taxtype
discount_percent
discount_amount
s_h_amount
terms_conditions
postatus
currency_id
conversion_rate
compound_taxes_info
pre_tax_total
paid
balance
s_h_percent
tags
region_id
*
purchaseorderid
*
queryid
*
queryid
*
quoteid
subject
potentialid
quotestage
validtill
contactid
quote_no
subtotal
carrier
shipping
inventorymanager
type
adjustment
total
taxtype
discount_percent
discount_amount
s_h_amount
accountid
terms_conditions
currency_id
conversion_rate
compound_taxes_info
pre_tax_total
s_h_percent
tags
region_id
*
quotebilladdressid
bill_city
bill_code
bill_country
bill_state
bill_street
bill_pobox
*
quoteid
*
quoteshipaddressid
ship_city
ship_code
ship_country
ship_state
ship_street
ship_pobox
*
quotestageid
quotestage
presence
picklist_valueid
sortorderid
color
*
historyid
quoteid
accountname
total
quotestage
lastmodified
*
id
*
rating_id
rating
presence
picklist_valueid
sortorderid
color
*
id
*
recurringid
activityid
recurringdate
recurringtype
recurringfreq
recurringinfo
recurringenddate
*
recurringeventid
recurringtype
sortorderid
presence
color
*
id
*
recurring_frequency_id
recurring_frequency
sortorderid
presence
color
*
id
*
relation_id
tabid
related_tabid
name
sequence
label
presence
actions
relationfieldid
source
relationtype
*
entityid
action
rel_table
rel_column
ref_column
related_crm_ids
*
id
*
queryid
columnindex
columnname
comparator
value
groupid
column_condition
*
groupid
queryid
group_condition
condition_expression
*
reminder_intervalid
reminder_interval
sortorderid
presence
*
id
*
reportid
folderid
reportname
description
reporttype
queryid
state
customizable
category
owner
sharingtype
*
datefilterid
datecolumnname
datefilter
startdate
enddate
*
filterid
name
*
folderid
foldername
description
state
*
reportid
sortid
sortcolname
dategroupbycriteria
*
reportmodulesid
primarymodule
secondarymodules
*
reportid
shareid
setype
*
sortcolid
reportid
columnname
sortorder
*
reportsummaryid
summarytype
columnname
*
reportid
data
*
reportid
groupid
*
reportid
roleid
*
reportid
rsid
*
reportid
userid
*
roleid
rolename
parentrole
depth
allowassignedrecordsto
*
roleid
picklistvalueid
picklistid
sortid
*
roleid
profileid
*
id
*
rollupid
userid
tabid
rollup_status
*
rowheightid
rowheight
sortorderid
presence
*
id
*
rssid
rssurl
rsstitle
rsstype
starred
*
smid
activityid
*
smid
attachmentsid
*
smid
id
*
salesorderid
subject
potentialid
customerno
salesorder_no
quoteid
vendorterms
contactid
vendorid
duedate
carrier
pending
type
adjustment
salescommission
exciseduty
total
subtotal
taxtype
discount_percent
discount_amount
s_h_amount
accountid
terms_conditions
purchaseorder
sostatus
currency_id
conversion_rate
enable_recurring
compound_taxes_info
pre_tax_total
s_h_percent
tags
region_id
*
salesorderid
*
sales_stage_id
sales_stage
presence
picklist_valueid
sortorderid
color
*
id
*
salutationid
salutationtype
presence
picklist_valueid
sortorderid
color
*
id
*
reportid
recipients
schedule
format
next_trigger_time
*
reportid
scheduleid
recipients
schdate
schtime
schdayoftheweek
schdayofthemonth
schannualdates
specificemails
next_trigger_time
fileformat
*
crmid
activityid
*
id
*
crmid
attachmentsid
*
queryid
columnindex
columnname
*
queryid
startindex
numofobjects
*
id
*
crmid
notesid
*
crmid
productid
setype
quantity
*
serviceid
service_no
servicename
servicecategory
qty_per_unit
unit_price
sales_start_date
sales_end_date
start_date
expiry_date
discontinued
service_usageunit
website
taxclass
currency_id
commissionrate
tags
purchase_cost
*
servicecategoryid
servicecategory
presence
picklist_valueid
sortorderid
color
*
id
*
serviceid
*
servicecontractsid
start_date
end_date
sc_related_to
tracking_unit
total_units
used_units
subject
due_date
planned_duration
actual_duration
contract_status
priority
contract_type
progress
contract_no
tags
*
servicecontractsid
*
service_usageunitid
service_usageunit
presence
picklist_valueid
sortorderid
color
*
id
*
crmid
ticketid
*
blockid
label
sequence
*
id
*
fieldid
blockid
name
iconpath
description
linkto
sequence
active
pinned
*
id
*
userid
sharedid
*
userid
shareduserid
color
visible
*
taxid
taxname
taxlabel
percentage
deleted
method
type
compoundon
regions
*
id
*
id
uid
handler_path
handler_class
handler_function
handler_data
onetime
*
smslogid
customermobile
*
smslogid
*
smsnotifierid
message
status
*
smsnotifierid
*
id
password
isactive
providertype
username
parameters
*
smsnotifierid
tonumber
status
smsmessageid
needlookup
statusid
statusmessage
*
id
type
sessionid
*
sobilladdressid
bill_city
bill_code
bill_country
bill_state
bill_street
bill_pobox
*
soshipaddressid
ship_city
ship_code
ship_country
ship_state
ship_street
ship_pobox
*
sostatusid
sostatus
presence
picklist_valueid
sortorderid
color
*
historyid
salesorderid
accountname
total
sostatus
lastmodified
*
id
*
id
type
data
started
ended
loggedon
*
start_hourid
start_hour
sortorderid
presence
*
id
*
stId
country
state
*
statusid
status
presence
picklist_valueid
*
id
*
id
server
server_port
server_username
server_password
server_type
smtp_auth
smtp_auth_type
smtp_auth_expireson
server_path
from_email_field
*
tabid
name
presence
tabsequence
tablabel
modifiedby
modifiedtime
customized
ownedby
isentitytype
trial
version
parent
source
issyncable
allowduplicates
sync_action_for_duplicates
*
tabid
prefname
prefvalue
*
taskpriorityid
taskpriority
presence
picklist_valueid
sortorderid
color
*
id
*
taskstatusid
taskstatus
presence
picklist_valueid
sortorderid
color
*
id
*
taxclassid
taxclass
sortorderid
presence
*
id
*
regionid
name
*
ticketcategories_id
ticketcategories
presence
picklist_valueid
sortorderid
color
*
id
*
ticketid
from_portal
cf_918
cf_920
cf_922
cf_924
cf_926
cf_928
cf_930
cf_932
cf_934
cf_936
cf_938
cf_940
cf_942
cf_944
cf_946
cf_948
cf_950
cf_952
cf_954
cf_956
cf_958
cf_960
cf_962
cf_964
cf_966
cf_968
cf_970
cf_972
cf_974
cf_976
cf_978
cf_980
cf_982
cf_984
cf_986
cf_988
cf_990
cf_992
cf_994
cf_996
cf_998
cf_1000
cf_1002
cf_1004
cf_1006
cf_1008
cf_1010
cf_1012
cf_1014
cf_1016
cf_1018
cf_1020
cf_1022
cf_1024
cf_1026
cf_1028
*
commentid
ticketid
comments
ownerid
ownertype
createdtime
*
ticketpriorities_id
ticketpriorities
presence
picklist_valueid
sortorderid
color
*
id
*
ticketseverities_id
ticketseverities
presence
picklist_valueid
sortorderid
color
*
id
*
ticketstatus_id
ticketstatus
presence
picklist_valueid
sortorderid
color
*
id
*
ticket_titleid
ticket_title
sortorderid
presence
color
*
id
*
time_zoneid
time_zone
sortorderid
presence
*
id
*
userid
tabid
relatedtabid
sharedgroupid
*
userid
tabid
sharedgroupid
*
userid
tabid
relatedtabid
shareduserid
*
userid
tabid
shareduserid
*
userid
tabid
relatedtabid
sharedgroupid
*
userid
tabid
sharedgroupid
*
userid
tabid
relatedtabid
shareduserid
*
userid
tabid
shareduserid
*
id
user_id
module_name
item_id
item_summary
*
tracking_unitid
tracking_unit
presence
picklist_valueid
sortorderid
color
*
id
*
ticketid
ticket_no
groupname
parent_id
product_id
priority
severity
status
category
title
solution
update_log
version_id
hours
days
contact_id
tags
*
usageunitid
usageunit
presence
picklist_valueid
sortorderid
color
*
id
*
userid
tabid
fieldid
visible
*
userid
roleid
*
id
user_name
user_password
cal_color
first_name
last_name
reports_to_id
is_admin
currency_id
description
date_entered
date_modified
modified_user_id
title
department
phone_home
phone_mobile
phone_work
phone_other
phone_fax
email1
email2
secondaryemail
status
signature
address_street
address_city
address_state
address_country
address_postalcode
user_preferences
tz
holidays
namedays
workdays
weekstart
date_format
hour_format
start_hour
end_hour
is_owner
activity_view
lead_view
imagename
deleted
confirm_password
internal_mailer
reminder_interval
reminder_next_time
crypt_type
accesskey
theme
language
time_zone
currency_grouping_pattern
currency_decimal_separator
currency_grouping_separator
currency_symbol_placement
userlabel
defaultlandingpage
phone_crm_extension
no_of_currency_decimals
truncate_trailing_zeros
dayoftheweek
callduration
othereventduration
calendarsharedtype
default_record_view
leftpanelhide
rowheight
defaulteventstatus
defaultactivitytype
hidecompletedevents
defaultcalendarview
createdon
deactivatedon
*
groupid
userid
*
id
assigned_user_id
bean_type
bean_id
deleted
*
id
*
log_id
user_id
user_name
user_full_name
action
performed_by_id
performed_by_name
performed_by_full_name
ip_address
action_time
remarks
*
userid
tabid
default_cvid
*
vendorid
vendor_no
vendorname
phone
email
website
glacct
category
street
city
state
pobox
postalcode
country
description
tags
*
vendorid
*
vendorid
contactid
*
id
old_version
current_version
*
id
*
visibilityid
visibility
sortorderid
presence
color
*
id
*
id
name
publicid
enabled
targetmodule
description
ownerid
returnurl
captcha
roundrobin
roundrobin_userid
roundrobin_logic
*
id
webformid
fieldid
fieldname
neutralizedfield
defaultvalue
required
sequence
hidden
*
id
webformid
fieldname
fieldlabel
required
*
templateid
filename
module
date_entered
parent_type
data
description
filesize
filetype
deleted
*
appid
name
appkey
type
*
type
handlerclass
handlerpath
*
id
extensiontabid
module
sync_datetime
app_create_count
app_update_count
app_delete_count
app_skip_count
vt_create_count
vt_update_count
vt_delete_count
vt_skip_count
userid
*
id
app_create_ids
app_update_ids
app_delete_ids
app_skip_info
vt_create_ids
vt_update_ids
vt_delete_ids
vt_skip_info
*
syncserverid
details
flag
appid
*
id
serverid
clientid
clientmodifiedtime
appid
servermodifiedtime
serverappid
*
id
name
stateencodedvalues
userid
*
id
name
handler_path
handler_class
ismodule
*
fieldtypeid
table_name
field_name
fieldtype
*
id
*
entity_id
name_fields
index_field
table_name
*
fieldtypeid
type
*
id
*
webservice_entity_id
table_name
*
id
property_name
property_value
*
fieldtypeid
uitype
fieldtype
*
operationid
name
handler_path
handler_method
type
prelogin
*
operationid
name
type
sequence
*
id
*
fieldtypeid
type
*
userid
token
expiretime
*
zoneid
zonename
*
zoneid
select table
aparam
a_sbapi_logs
com_vtiger_workflows
com_vtiger_workflows_seq
com_vtiger_workflowtasks
com_vtiger_workflowtasks_entitymethod
com_vtiger_workflowtasks_entitymethod_seq
com_vtiger_workflowtasks_seq
com_vtiger_workflowtask_queue
com_vtiger_workflowtemplates
com_vtiger_workflow_activatedonce
com_vtiger_workflow_tasktypes
com_vtiger_workflow_tasktypes_seq
new_customer_suraj_bharadwaj_table
vtiger_account
vtiger_accountbillads
vtiger_accountrating
vtiger_accountscf
vtiger_accountshipads
vtiger_accounttype
vtiger_accounttype_seq
vtiger_actionmapping
vtiger_activity
vtiger_activitycf
vtiger_activityproductrel
vtiger_activitytype
vtiger_activitytype_seq
vtiger_activity_recurring_info
vtiger_activity_reminder
vtiger_activity_reminder_popup
vtiger_activity_view
vtiger_activity_view_seq
vtiger_announcement
vtiger_apilogs
vtiger_apilogscf
vtiger_app2tab
vtiger_assets
vtiger_assetscf
vtiger_assetstatus
vtiger_assetstatus_seq
vtiger_asterisk
vtiger_asteriskextensions
vtiger_asteriskincomingcalls
vtiger_asteriskincomingevents
vtiger_attachments
vtiger_attachmentsfolder
vtiger_attachmentsfolder_seq
vtiger_audit_trial
vtiger_blocks
vtiger_blocks_seq
vtiger_branch
vtiger_branchcf
vtiger_calendarsharedtype
vtiger_calendarsharedtype_seq
vtiger_calendar_default_activitytypes
vtiger_calendar_default_activitytypes_seq
vtiger_calendar_user_activitytypes
vtiger_calendar_user_activitytypes_seq
vtiger_calldetail
vtiger_calldetailcf
vtiger_callduration
vtiger_callduration_seq
vtiger_campaign
vtiger_campaignaccountrel
vtiger_campaigncontrel
vtiger_campaignleadrel
vtiger_campaignrelstatus
vtiger_campaignrelstatus_seq
vtiger_campaignscf
vtiger_campaignstatus
vtiger_campaignstatus_seq
vtiger_campaigntype
vtiger_campaigntype_seq
vtiger_carrier
vtiger_carrier_seq
vtiger_cf_900
vtiger_cf_900_seq
vtiger_cf_904
vtiger_cf_904_seq
vtiger_cf_912
vtiger_cf_912_seq
vtiger_cf_916
vtiger_cf_916_seq
vtiger_cf_918
vtiger_cf_918_seq
vtiger_cf_920
vtiger_cf_920_seq
vtiger_cf_922
vtiger_cf_922_seq
vtiger_cf_924
vtiger_cf_924_seq
vtiger_cf_926
vtiger_cf_926_seq
vtiger_cf_936
vtiger_cf_936_seq
vtiger_cf_946
vtiger_cf_946_seq
vtiger_cf_978
vtiger_cf_978_seq
vtiger_cf_1018
vtiger_cf_1018_seq
vtiger_cf_1030
vtiger_cf_1030_seq
vtiger_cf_1034
vtiger_cf_1034_seq
vtiger_cf_1038
vtiger_cf_1038_seq
vtiger_cf_1054
vtiger_cf_1054_seq
vtiger_cf_1056
vtiger_cf_1056_seq
vtiger_cf_1058
vtiger_cf_1058_seq
vtiger_cf_1060
vtiger_cf_1060_seq
vtiger_cf_1062
vtiger_cf_1062_seq
vtiger_cf_1070
vtiger_cf_1070_seq
vtiger_cf_1072
vtiger_cf_1072_seq
vtiger_cf_1074
vtiger_cf_1074_seq
vtiger_cf_1096
vtiger_cf_1096_seq
vtiger_cf_1120
vtiger_cf_1120_seq
vtiger_cf_1146
vtiger_cf_1146_seq
vtiger_cf_1148
vtiger_cf_1148_seq
vtiger_cf_1150
vtiger_cf_1150_seq
vtiger_cf_1152
vtiger_cf_1152_seq
vtiger_cf_1164
vtiger_cf_1164_seq
vtiger_cntactivityrel
vtiger_contactaddress
vtiger_contactdetails
vtiger_contactscf
vtiger_contactsubdetails
vtiger_contpotentialrel
vtiger_contract_priority
vtiger_contract_priority_seq
vtiger_contract_status
vtiger_contract_status_seq
vtiger_contract_type
vtiger_contract_type_seq
vtiger_convertleadmapping
vtiger_convertpotentialmapping
vtiger_crmentity
vtiger_crmentityrel
vtiger_crmentity_seq
vtiger_crmentity_user_field
vtiger_crmsetup
vtiger_cron_task
vtiger_currencies
vtiger_currencies_seq
vtiger_currency
vtiger_currency_decimal_separator
vtiger_currency_decimal_separator_seq
vtiger_currency_grouping_pattern
vtiger_currency_grouping_pattern_seq
vtiger_currency_grouping_separator
vtiger_currency_grouping_separator_seq
vtiger_currency_info
vtiger_currency_info_seq
vtiger_currency_symbol_placement
vtiger_currency_symbol_placement_seq
vtiger_customaction
vtiger_customerdetails
vtiger_customerportal_fields
vtiger_customerportal_prefs
vtiger_customerportal_relatedmoduleinfo
vtiger_customerportal_settings
vtiger_customerportal_tabs
vtiger_custommodule
vtiger_custommodulecf
vtiger_customview
vtiger_customview_seq
vtiger_cv2group
vtiger_cv2role
vtiger_cv2rs
vtiger_cv2users
vtiger_cvadvfilter
vtiger_cvadvfilter_grouping
vtiger_cvcolumnlist
vtiger_cvstdfilter
vtiger_dashboard_tabs
vtiger_datashare_grp2grp
vtiger_datashare_grp2role
vtiger_datashare_grp2rs
vtiger_datashare_module_rel
vtiger_datashare_relatedmodules
vtiger_datashare_relatedmodules_seq
vtiger_datashare_relatedmodule_permission
vtiger_datashare_role2group
vtiger_datashare_role2role
vtiger_datashare_role2rs
vtiger_datashare_rs2grp
vtiger_datashare_rs2role
vtiger_datashare_rs2rs
vtiger_date_format
vtiger_date_format_seq
vtiger_dayoftheweek
vtiger_dayoftheweek_seq
vtiger_defaultactivitytype
vtiger_defaultactivitytype_seq
vtiger_defaultcalendarview
vtiger_defaultcalendarview_seq
vtiger_defaultcv
vtiger_defaulteventstatus
vtiger_defaulteventstatus_seq
vtiger_defaultlandingpage
vtiger_defaultlandingpage_seq
vtiger_default_record_view
vtiger_default_record_view_seq
vtiger_def_org_field
vtiger_def_org_share
vtiger_def_org_share_seq
vtiger_districtmaster
vtiger_durationhrs
vtiger_durationmins
vtiger_duration_minutes
vtiger_duration_minutes_seq
vtiger_emaildetails
vtiger_emailslookup
vtiger_emails_recipientprefs
vtiger_emailtemplates
vtiger_emailtemplates_seq
vtiger_email_access
vtiger_email_track
vtiger_entityname
vtiger_eventhandlers
vtiger_eventhandlers_seq
vtiger_eventhandler_module
vtiger_eventhandler_module_seq
vtiger_eventstatus
vtiger_eventstatus_seq
vtiger_expectedresponse
vtiger_expectedresponse_seq
vtiger_extnstore_users
vtiger_faq
vtiger_faqcategories
vtiger_faqcategories_seq
vtiger_faqcf
vtiger_faqcomments
vtiger_faqstatus
vtiger_faqstatus_seq
vtiger_feedback
vtiger_field
vtiger_fieldmodulerel
vtiger_field_seq
vtiger_freetagged_objects
vtiger_freetags
vtiger_freetags_seq
vtiger_glacct
vtiger_glacct_seq
vtiger_google_event_calendar_mapping
vtiger_google_oauth2
vtiger_google_sync_fieldmapping
vtiger_google_sync_settings
vtiger_group2grouprel
vtiger_group2role
vtiger_group2rs
vtiger_groups
vtiger_homedashbd
vtiger_homedefault
vtiger_homemodule
vtiger_homemoduleflds
vtiger_homereportchart
vtiger_homerss
vtiger_homestuff
vtiger_homestuff_seq
vtiger_home_layout
vtiger_hour_format
vtiger_hour_format_seq
vtiger_import_1
vtiger_import_locks
vtiger_import_locks_seq
vtiger_import_maps
vtiger_import_queue
vtiger_import_queue_seq
vtiger_industry
vtiger_industry_seq
vtiger_inventorycharges
vtiger_inventorychargesrel
vtiger_inventorynotification
vtiger_inventorynotification_seq
vtiger_inventoryproductrel
vtiger_inventoryproductrel_seq
vtiger_inventoryshippingrel
vtiger_inventorysubproductrel
vtiger_inventorytaxinfo
vtiger_inventorytaxinfo_seq
vtiger_inventory_tandc
vtiger_inventory_tandc_seq
vtiger_invitees
vtiger_invoice
vtiger_invoicebillads
vtiger_invoicecf
vtiger_invoiceshipads
vtiger_invoicestatus
vtiger_invoicestatushistory
vtiger_invoicestatus_seq
vtiger_invoice_recurring_info
vtiger_language
vtiger_language_seq
vtiger_leadaddress
vtiger_leaddetails
vtiger_leadscf
vtiger_leadsource
vtiger_leadsource_seq
vtiger_leadstage
vtiger_leadstatus
vtiger_leadstatus_seq
vtiger_leadsubdetails
vtiger_lead_view
vtiger_lead_view_seq
vtiger_links
vtiger_links_seq
vtiger_loginhistory
vtiger_mailer_queue
vtiger_mailer_queueattachments
vtiger_mailer_queueinfo
vtiger_mailmanager_mailattachments
vtiger_mailmanager_mailrecord
vtiger_mailmanager_mailrel
vtiger_mailscanner
vtiger_mailscanner_actions
vtiger_mailscanner_folders
vtiger_mailscanner_ids
vtiger_mailscanner_ruleactions
vtiger_mailscanner_rules
vtiger_mail_accounts
vtiger_manufacturer
vtiger_manufacturer_seq
vtiger_mobile_alerts
vtiger_modcomments
vtiger_modcommentscf
vtiger_modentity_num
vtiger_modentity_num_seq
vtiger_modtracker_basic
vtiger_modtracker_basic_seq
vtiger_modtracker_detail
vtiger_modtracker_relations
vtiger_modtracker_tabs
vtiger_module_dashboard_widgets
vtiger_notebook_contents
vtiger_notes
vtiger_notescf
vtiger_notificationscheduler
vtiger_notificationscheduler_seq
vtiger_no_of_currency_decimals
vtiger_no_of_currency_decimals_seq
vtiger_opportunitystage
vtiger_opportunity_type
vtiger_opportunity_type_seq
vtiger_organizationdetails
vtiger_organizationdetails_seq
vtiger_org_share_action2tab
vtiger_org_share_action_mapping
vtiger_othereventduration
vtiger_othereventduration_seq
vtiger_parenttab
vtiger_parenttabrel
vtiger_payment_duration
vtiger_payment_duration_seq
vtiger_pbxmanager
vtiger_pbxmanagercf
vtiger_pbxmanager_gateway
vtiger_pbxmanager_phonelookup
vtiger_picklist
vtiger_picklistvalues_seq
vtiger_picklist_dependency
vtiger_picklist_seq
vtiger_picklist_transitions
vtiger_pobillads
vtiger_portal
vtiger_portalinfo
vtiger_poshipads
vtiger_postatus
vtiger_postatushistory
vtiger_postatus_seq
vtiger_potential
vtiger_potentialscf
vtiger_potstagehistory
vtiger_pricebook
vtiger_pricebookcf
vtiger_pricebookproductrel
vtiger_priority
vtiger_productcategory
vtiger_productcategory_seq
vtiger_productcf
vtiger_productcurrencyrel
vtiger_products
vtiger_producttaxrel
vtiger_profile
vtiger_profile2field
vtiger_profile2globalpermissions
vtiger_profile2standardpermissions
vtiger_profile2tab
vtiger_profile2utility
vtiger_profile_seq
vtiger_progress
vtiger_progress_seq
vtiger_project
vtiger_projectcf
vtiger_projectmilestone
vtiger_projectmilestonecf
vtiger_projectmilestonetype
vtiger_projectmilestonetype_seq
vtiger_projectpriority
vtiger_projectpriority_seq
vtiger_projectstatus
vtiger_projectstatus_seq
vtiger_projecttask
vtiger_projecttaskcf
vtiger_projecttaskpriority
vtiger_projecttaskpriority_seq
vtiger_projecttaskprogress
vtiger_projecttaskprogress_seq
vtiger_projecttaskstatus
vtiger_projecttaskstatus_seq
vtiger_projecttasktype
vtiger_projecttasktype_seq
vtiger_projecttask_status_color
vtiger_projecttype
vtiger_projecttype_seq
vtiger_purchaseorder
vtiger_purchaseordercf
vtiger_query
vtiger_querycf
vtiger_quotes
vtiger_quotesbillads
vtiger_quotescf
vtiger_quotesshipads
vtiger_quotestage
vtiger_quotestagehistory
vtiger_quotestage_seq
vtiger_rating
vtiger_rating_seq
vtiger_recurringevents
vtiger_recurringtype
vtiger_recurringtype_seq
vtiger_recurring_frequency
vtiger_recurring_frequency_seq
vtiger_relatedlists
vtiger_relatedlists_rb
vtiger_relatedlists_seq
vtiger_relcriteria
vtiger_relcriteria_grouping
vtiger_reminder_interval
vtiger_reminder_interval_seq
vtiger_report
vtiger_reportdatefilter
vtiger_reportfilters
vtiger_reportfolder
vtiger_reportgroupbycolumn
vtiger_reportmodules
vtiger_reportsharing
vtiger_reportsortcol
vtiger_reportsummary
vtiger_reporttype
vtiger_report_sharegroups
vtiger_report_sharerole
vtiger_report_sharers
vtiger_report_shareusers
vtiger_role
vtiger_role2picklist
vtiger_role2profile
vtiger_role_seq
vtiger_rollupcomments_settings
vtiger_rowheight
vtiger_rowheight_seq
vtiger_rss
vtiger_salesmanactivityrel
vtiger_salesmanattachmentsrel
vtiger_salesmanticketrel
vtiger_salesorder
vtiger_salesordercf
vtiger_sales_stage
vtiger_sales_stage_seq
vtiger_salutationtype
vtiger_salutationtype_seq
vtiger_scheduled_reports
vtiger_schedulereports
vtiger_seactivityrel
vtiger_seactivityrel_seq
vtiger_seattachmentsrel
vtiger_selectcolumn
vtiger_selectquery
vtiger_selectquery_seq
vtiger_senotesrel
vtiger_seproductsrel
vtiger_service
vtiger_servicecategory
vtiger_servicecategory_seq
vtiger_servicecf
vtiger_servicecontracts
vtiger_servicecontractscf
vtiger_service_usageunit
vtiger_service_usageunit_seq
vtiger_seticketsrel
vtiger_settings_blocks
vtiger_settings_blocks_seq
vtiger_settings_field
vtiger_settings_field_seq
vtiger_sharedcalendar
vtiger_shareduserinfo
vtiger_shippingtaxinfo
vtiger_shippingtaxinfo_seq
vtiger_shorturls
vtiger_smslog
vtiger_smslogcf
vtiger_smsnotifier
vtiger_smsnotifiercf
vtiger_smsnotifier_servers
vtiger_smsnotifier_status
vtiger_soapservice
vtiger_sobillads
vtiger_soshipads
vtiger_sostatus
vtiger_sostatushistory
vtiger_sostatus_seq
vtiger_sqltimelog
vtiger_start_hour
vtiger_start_hour_seq
vtiger_state_master
vtiger_status
vtiger_status_seq
vtiger_systems
vtiger_tab
vtiger_tab_info
vtiger_taskpriority
vtiger_taskpriority_seq
vtiger_taskstatus
vtiger_taskstatus_seq
vtiger_taxclass
vtiger_taxclass_seq
vtiger_taxregions
vtiger_ticketcategories
vtiger_ticketcategories_seq
vtiger_ticketcf
vtiger_ticketcomments
vtiger_ticketpriorities
vtiger_ticketpriorities_seq
vtiger_ticketseverities
vtiger_ticketseverities_seq
vtiger_ticketstatus
vtiger_ticketstatus_seq
vtiger_ticket_title
vtiger_ticket_title_seq
vtiger_time_zone
vtiger_time_zone_seq
vtiger_tmp_read_group_rel_sharing_per
vtiger_tmp_read_group_sharing_per
vtiger_tmp_read_user_rel_sharing_per
vtiger_tmp_read_user_sharing_per
vtiger_tmp_write_group_rel_sharing_per
vtiger_tmp_write_group_sharing_per
vtiger_tmp_write_user_rel_sharing_per
vtiger_tmp_write_user_sharing_per
vtiger_tracker
vtiger_tracking_unit
vtiger_tracking_unit_seq
vtiger_troubletickets
vtiger_usageunit
vtiger_usageunit_seq
vtiger_user2mergefields
vtiger_user2role
vtiger_users
vtiger_users2group
vtiger_users_last_import
vtiger_users_seq
vtiger_user_audit_log
vtiger_user_module_preferences
vtiger_vendor
vtiger_vendorcf
vtiger_vendorcontactrel
vtiger_version
vtiger_version_seq
vtiger_visibility
vtiger_visibility_seq
vtiger_webforms
vtiger_webforms_field
vtiger_webform_file_fields
vtiger_wordtemplates
vtiger_wsapp
vtiger_wsapp_handlerdetails
vtiger_wsapp_logs_basic
vtiger_wsapp_logs_details
vtiger_wsapp_queuerecords
vtiger_wsapp_recordmapping
vtiger_wsapp_sync_state
vtiger_ws_entity
vtiger_ws_entity_fieldtype
vtiger_ws_entity_fieldtype_seq
vtiger_ws_entity_name
vtiger_ws_entity_referencetype
vtiger_ws_entity_seq
vtiger_ws_entity_tables
vtiger_ws_fieldinfo
vtiger_ws_fieldtype
vtiger_ws_operation
vtiger_ws_operation_parameters
vtiger_ws_operation_seq
vtiger_ws_referencetype
vtiger_ws_userauthtoken
vtiger_zone
vtiger_zonecf
.
select column
Show
criteria
Sort
Ascending
Descending
Add as
AND
OR
Op
=
>
>=
<
<=
!=
LIKE
LIKE %...%
NOT LIKE
NOT LIKE %...%
IN (...)
NOT IN (...)
BETWEEN
NOT BETWEEN
IS NULL
IS NOT NULL
REGEXP
REGEXP ^...$
NOT REGEXP
Text
Another column
select table
aparam
a_sbapi_logs
com_vtiger_workflows
com_vtiger_workflows_seq
com_vtiger_workflowtasks
com_vtiger_workflowtasks_entitymethod
com_vtiger_workflowtasks_entitymethod_seq
com_vtiger_workflowtasks_seq
com_vtiger_workflowtask_queue
com_vtiger_workflowtemplates
com_vtiger_workflow_activatedonce
com_vtiger_workflow_tasktypes
com_vtiger_workflow_tasktypes_seq
new_customer_suraj_bharadwaj_table
vtiger_account
vtiger_accountbillads
vtiger_accountrating
vtiger_accountscf
vtiger_accountshipads
vtiger_accounttype
vtiger_accounttype_seq
vtiger_actionmapping
vtiger_activity
vtiger_activitycf
vtiger_activityproductrel
vtiger_activitytype
vtiger_activitytype_seq
vtiger_activity_recurring_info
vtiger_activity_reminder
vtiger_activity_reminder_popup
vtiger_activity_view
vtiger_activity_view_seq
vtiger_announcement
vtiger_apilogs
vtiger_apilogscf
vtiger_app2tab
vtiger_assets
vtiger_assetscf
vtiger_assetstatus
vtiger_assetstatus_seq
vtiger_asterisk
vtiger_asteriskextensions
vtiger_asteriskincomingcalls
vtiger_asteriskincomingevents
vtiger_attachments
vtiger_attachmentsfolder
vtiger_attachmentsfolder_seq
vtiger_audit_trial
vtiger_blocks
vtiger_blocks_seq
vtiger_branch
vtiger_branchcf
vtiger_calendarsharedtype
vtiger_calendarsharedtype_seq
vtiger_calendar_default_activitytypes
vtiger_calendar_default_activitytypes_seq
vtiger_calendar_user_activitytypes
vtiger_calendar_user_activitytypes_seq
vtiger_calldetail
vtiger_calldetailcf
vtiger_callduration
vtiger_callduration_seq
vtiger_campaign
vtiger_campaignaccountrel
vtiger_campaigncontrel
vtiger_campaignleadrel
vtiger_campaignrelstatus
vtiger_campaignrelstatus_seq
vtiger_campaignscf
vtiger_campaignstatus
vtiger_campaignstatus_seq
vtiger_campaigntype
vtiger_campaigntype_seq
vtiger_carrier
vtiger_carrier_seq
vtiger_cf_900
vtiger_cf_900_seq
vtiger_cf_904
vtiger_cf_904_seq
vtiger_cf_912
vtiger_cf_912_seq
vtiger_cf_916
vtiger_cf_916_seq
vtiger_cf_918
vtiger_cf_918_seq
vtiger_cf_920
vtiger_cf_920_seq
vtiger_cf_922
vtiger_cf_922_seq
vtiger_cf_924
vtiger_cf_924_seq
vtiger_cf_926
vtiger_cf_926_seq
vtiger_cf_936
vtiger_cf_936_seq
vtiger_cf_946
vtiger_cf_946_seq
vtiger_cf_978
vtiger_cf_978_seq
vtiger_cf_1018
vtiger_cf_1018_seq
vtiger_cf_1030
vtiger_cf_1030_seq
vtiger_cf_1034
vtiger_cf_1034_seq
vtiger_cf_1038
vtiger_cf_1038_seq
vtiger_cf_1054
vtiger_cf_1054_seq
vtiger_cf_1056
vtiger_cf_1056_seq
vtiger_cf_1058
vtiger_cf_1058_seq
vtiger_cf_1060
vtiger_cf_1060_seq
vtiger_cf_1062
vtiger_cf_1062_seq
vtiger_cf_1070
vtiger_cf_1070_seq
vtiger_cf_1072
vtiger_cf_1072_seq
vtiger_cf_1074
vtiger_cf_1074_seq
vtiger_cf_1096
vtiger_cf_1096_seq
vtiger_cf_1120
vtiger_cf_1120_seq
vtiger_cf_1146
vtiger_cf_1146_seq
vtiger_cf_1148
vtiger_cf_1148_seq
vtiger_cf_1150
vtiger_cf_1150_seq
vtiger_cf_1152
vtiger_cf_1152_seq
vtiger_cf_1164
vtiger_cf_1164_seq
vtiger_cntactivityrel
vtiger_contactaddress
vtiger_contactdetails
vtiger_contactscf
vtiger_contactsubdetails
vtiger_contpotentialrel
vtiger_contract_priority
vtiger_contract_priority_seq
vtiger_contract_status
vtiger_contract_status_seq
vtiger_contract_type
vtiger_contract_type_seq
vtiger_convertleadmapping
vtiger_convertpotentialmapping
vtiger_crmentity
vtiger_crmentityrel
vtiger_crmentity_seq
vtiger_crmentity_user_field
vtiger_crmsetup
vtiger_cron_task
vtiger_currencies
vtiger_currencies_seq
vtiger_currency
vtiger_currency_decimal_separator
vtiger_currency_decimal_separator_seq
vtiger_currency_grouping_pattern
vtiger_currency_grouping_pattern_seq
vtiger_currency_grouping_separator
vtiger_currency_grouping_separator_seq
vtiger_currency_info
vtiger_currency_info_seq
vtiger_currency_symbol_placement
vtiger_currency_symbol_placement_seq
vtiger_customaction
vtiger_customerdetails
vtiger_customerportal_fields
vtiger_customerportal_prefs
vtiger_customerportal_relatedmoduleinfo
vtiger_customerportal_settings
vtiger_customerportal_tabs
vtiger_custommodule
vtiger_custommodulecf
vtiger_customview
vtiger_customview_seq
vtiger_cv2group
vtiger_cv2role
vtiger_cv2rs
vtiger_cv2users
vtiger_cvadvfilter
vtiger_cvadvfilter_grouping
vtiger_cvcolumnlist
vtiger_cvstdfilter
vtiger_dashboard_tabs
vtiger_datashare_grp2grp
vtiger_datashare_grp2role
vtiger_datashare_grp2rs
vtiger_datashare_module_rel
vtiger_datashare_relatedmodules
vtiger_datashare_relatedmodules_seq
vtiger_datashare_relatedmodule_permission
vtiger_datashare_role2group
vtiger_datashare_role2role
vtiger_datashare_role2rs
vtiger_datashare_rs2grp
vtiger_datashare_rs2role
vtiger_datashare_rs2rs
vtiger_date_format
vtiger_date_format_seq
vtiger_dayoftheweek
vtiger_dayoftheweek_seq
vtiger_defaultactivitytype
vtiger_defaultactivitytype_seq
vtiger_defaultcalendarview
vtiger_defaultcalendarview_seq
vtiger_defaultcv
vtiger_defaulteventstatus
vtiger_defaulteventstatus_seq
vtiger_defaultlandingpage
vtiger_defaultlandingpage_seq
vtiger_default_record_view
vtiger_default_record_view_seq
vtiger_def_org_field
vtiger_def_org_share
vtiger_def_org_share_seq
vtiger_districtmaster
vtiger_durationhrs
vtiger_durationmins
vtiger_duration_minutes
vtiger_duration_minutes_seq
vtiger_emaildetails
vtiger_emailslookup
vtiger_emails_recipientprefs
vtiger_emailtemplates
vtiger_emailtemplates_seq
vtiger_email_access
vtiger_email_track
vtiger_entityname
vtiger_eventhandlers
vtiger_eventhandlers_seq
vtiger_eventhandler_module
vtiger_eventhandler_module_seq
vtiger_eventstatus
vtiger_eventstatus_seq
vtiger_expectedresponse
vtiger_expectedresponse_seq
vtiger_extnstore_users
vtiger_faq
vtiger_faqcategories
vtiger_faqcategories_seq
vtiger_faqcf
vtiger_faqcomments
vtiger_faqstatus
vtiger_faqstatus_seq
vtiger_feedback
vtiger_field
vtiger_fieldmodulerel
vtiger_field_seq
vtiger_freetagged_objects
vtiger_freetags
vtiger_freetags_seq
vtiger_glacct
vtiger_glacct_seq
vtiger_google_event_calendar_mapping
vtiger_google_oauth2
vtiger_google_sync_fieldmapping
vtiger_google_sync_settings
vtiger_group2grouprel
vtiger_group2role
vtiger_group2rs
vtiger_groups
vtiger_homedashbd
vtiger_homedefault
vtiger_homemodule
vtiger_homemoduleflds
vtiger_homereportchart
vtiger_homerss
vtiger_homestuff
vtiger_homestuff_seq
vtiger_home_layout
vtiger_hour_format
vtiger_hour_format_seq
vtiger_import_1
vtiger_import_locks
vtiger_import_locks_seq
vtiger_import_maps
vtiger_import_queue
vtiger_import_queue_seq
vtiger_industry
vtiger_industry_seq
vtiger_inventorycharges
vtiger_inventorychargesrel
vtiger_inventorynotification
vtiger_inventorynotification_seq
vtiger_inventoryproductrel
vtiger_inventoryproductrel_seq
vtiger_inventoryshippingrel
vtiger_inventorysubproductrel
vtiger_inventorytaxinfo
vtiger_inventorytaxinfo_seq
vtiger_inventory_tandc
vtiger_inventory_tandc_seq
vtiger_invitees
vtiger_invoice
vtiger_invoicebillads
vtiger_invoicecf
vtiger_invoiceshipads
vtiger_invoicestatus
vtiger_invoicestatushistory
vtiger_invoicestatus_seq
vtiger_invoice_recurring_info
vtiger_language
vtiger_language_seq
vtiger_leadaddress
vtiger_leaddetails
vtiger_leadscf
vtiger_leadsource
vtiger_leadsource_seq
vtiger_leadstage
vtiger_leadstatus
vtiger_leadstatus_seq
vtiger_leadsubdetails
vtiger_lead_view
vtiger_lead_view_seq
vtiger_links
vtiger_links_seq
vtiger_loginhistory
vtiger_mailer_queue
vtiger_mailer_queueattachments
vtiger_mailer_queueinfo
vtiger_mailmanager_mailattachments
vtiger_mailmanager_mailrecord
vtiger_mailmanager_mailrel
vtiger_mailscanner
vtiger_mailscanner_actions
vtiger_mailscanner_folders
vtiger_mailscanner_ids
vtiger_mailscanner_ruleactions
vtiger_mailscanner_rules
vtiger_mail_accounts
vtiger_manufacturer
vtiger_manufacturer_seq
vtiger_mobile_alerts
vtiger_modcomments
vtiger_modcommentscf
vtiger_modentity_num
vtiger_modentity_num_seq
vtiger_modtracker_basic
vtiger_modtracker_basic_seq
vtiger_modtracker_detail
vtiger_modtracker_relations
vtiger_modtracker_tabs
vtiger_module_dashboard_widgets
vtiger_notebook_contents
vtiger_notes
vtiger_notescf
vtiger_notificationscheduler
vtiger_notificationscheduler_seq
vtiger_no_of_currency_decimals
vtiger_no_of_currency_decimals_seq
vtiger_opportunitystage
vtiger_opportunity_type
vtiger_opportunity_type_seq
vtiger_organizationdetails
vtiger_organizationdetails_seq
vtiger_org_share_action2tab
vtiger_org_share_action_mapping
vtiger_othereventduration
vtiger_othereventduration_seq
vtiger_parenttab
vtiger_parenttabrel
vtiger_payment_duration
vtiger_payment_duration_seq
vtiger_pbxmanager
vtiger_pbxmanagercf
vtiger_pbxmanager_gateway
vtiger_pbxmanager_phonelookup
vtiger_picklist
vtiger_picklistvalues_seq
vtiger_picklist_dependency
vtiger_picklist_seq
vtiger_picklist_transitions
vtiger_pobillads
vtiger_portal
vtiger_portalinfo
vtiger_poshipads
vtiger_postatus
vtiger_postatushistory
vtiger_postatus_seq
vtiger_potential
vtiger_potentialscf
vtiger_potstagehistory
vtiger_pricebook
vtiger_pricebookcf
vtiger_pricebookproductrel
vtiger_priority
vtiger_productcategory
vtiger_productcategory_seq
vtiger_productcf
vtiger_productcurrencyrel
vtiger_products
vtiger_producttaxrel
vtiger_profile
vtiger_profile2field
vtiger_profile2globalpermissions
vtiger_profile2standardpermissions
vtiger_profile2tab
vtiger_profile2utility
vtiger_profile_seq
vtiger_progress
vtiger_progress_seq
vtiger_project
vtiger_projectcf
vtiger_projectmilestone
vtiger_projectmilestonecf
vtiger_projectmilestonetype
vtiger_projectmilestonetype_seq
vtiger_projectpriority
vtiger_projectpriority_seq
vtiger_projectstatus
vtiger_projectstatus_seq
vtiger_projecttask
vtiger_projecttaskcf
vtiger_projecttaskpriority
vtiger_projecttaskpriority_seq
vtiger_projecttaskprogress
vtiger_projecttaskprogress_seq
vtiger_projecttaskstatus
vtiger_projecttaskstatus_seq
vtiger_projecttasktype
vtiger_projecttasktype_seq
vtiger_projecttask_status_color
vtiger_projecttype
vtiger_projecttype_seq
vtiger_purchaseorder
vtiger_purchaseordercf
vtiger_query
vtiger_querycf
vtiger_quotes
vtiger_quotesbillads
vtiger_quotescf
vtiger_quotesshipads
vtiger_quotestage
vtiger_quotestagehistory
vtiger_quotestage_seq
vtiger_rating
vtiger_rating_seq
vtiger_recurringevents
vtiger_recurringtype
vtiger_recurringtype_seq
vtiger_recurring_frequency
vtiger_recurring_frequency_seq
vtiger_relatedlists
vtiger_relatedlists_rb
vtiger_relatedlists_seq
vtiger_relcriteria
vtiger_relcriteria_grouping
vtiger_reminder_interval
vtiger_reminder_interval_seq
vtiger_report
vtiger_reportdatefilter
vtiger_reportfilters
vtiger_reportfolder
vtiger_reportgroupbycolumn
vtiger_reportmodules
vtiger_reportsharing
vtiger_reportsortcol
vtiger_reportsummary
vtiger_reporttype
vtiger_report_sharegroups
vtiger_report_sharerole
vtiger_report_sharers
vtiger_report_shareusers
vtiger_role
vtiger_role2picklist
vtiger_role2profile
vtiger_role_seq
vtiger_rollupcomments_settings
vtiger_rowheight
vtiger_rowheight_seq
vtiger_rss
vtiger_salesmanactivityrel
vtiger_salesmanattachmentsrel
vtiger_salesmanticketrel
vtiger_salesorder
vtiger_salesordercf
vtiger_sales_stage
vtiger_sales_stage_seq
vtiger_salutationtype
vtiger_salutationtype_seq
vtiger_scheduled_reports
vtiger_schedulereports
vtiger_seactivityrel
vtiger_seactivityrel_seq
vtiger_seattachmentsrel
vtiger_selectcolumn
vtiger_selectquery
vtiger_selectquery_seq
vtiger_senotesrel
vtiger_seproductsrel
vtiger_service
vtiger_servicecategory
vtiger_servicecategory_seq
vtiger_servicecf
vtiger_servicecontracts
vtiger_servicecontractscf
vtiger_service_usageunit
vtiger_service_usageunit_seq
vtiger_seticketsrel
vtiger_settings_blocks
vtiger_settings_blocks_seq
vtiger_settings_field
vtiger_settings_field_seq
vtiger_sharedcalendar
vtiger_shareduserinfo
vtiger_shippingtaxinfo
vtiger_shippingtaxinfo_seq
vtiger_shorturls
vtiger_smslog
vtiger_smslogcf
vtiger_smsnotifier
vtiger_smsnotifiercf
vtiger_smsnotifier_servers
vtiger_smsnotifier_status
vtiger_soapservice
vtiger_sobillads
vtiger_soshipads
vtiger_sostatus
vtiger_sostatushistory
vtiger_sostatus_seq
vtiger_sqltimelog
vtiger_start_hour
vtiger_start_hour_seq
vtiger_state_master
vtiger_status
vtiger_status_seq
vtiger_systems
vtiger_tab
vtiger_tab_info
vtiger_taskpriority
vtiger_taskpriority_seq
vtiger_taskstatus
vtiger_taskstatus_seq
vtiger_taxclass
vtiger_taxclass_seq
vtiger_taxregions
vtiger_ticketcategories
vtiger_ticketcategories_seq
vtiger_ticketcf
vtiger_ticketcomments
vtiger_ticketpriorities
vtiger_ticketpriorities_seq
vtiger_ticketseverities
vtiger_ticketseverities_seq
vtiger_ticketstatus
vtiger_ticketstatus_seq
vtiger_ticket_title
vtiger_ticket_title_seq
vtiger_time_zone
vtiger_time_zone_seq
vtiger_tmp_read_group_rel_sharing_per
vtiger_tmp_read_group_sharing_per
vtiger_tmp_read_user_rel_sharing_per
vtiger_tmp_read_user_sharing_per
vtiger_tmp_write_group_rel_sharing_per
vtiger_tmp_write_group_sharing_per
vtiger_tmp_write_user_rel_sharing_per
vtiger_tmp_write_user_sharing_per
vtiger_tracker
vtiger_tracking_unit
vtiger_tracking_unit_seq
vtiger_troubletickets
vtiger_usageunit
vtiger_usageunit_seq
vtiger_user2mergefields
vtiger_user2role
vtiger_users
vtiger_users2group
vtiger_users_last_import
vtiger_users_seq
vtiger_user_audit_log
vtiger_user_module_preferences
vtiger_vendor
vtiger_vendorcf
vtiger_vendorcontactrel
vtiger_version
vtiger_version_seq
vtiger_visibility
vtiger_visibility_seq
vtiger_webforms
vtiger_webforms_field
vtiger_webform_file_fields
vtiger_wordtemplates
vtiger_wsapp
vtiger_wsapp_handlerdetails
vtiger_wsapp_logs_basic
vtiger_wsapp_logs_details
vtiger_wsapp_queuerecords
vtiger_wsapp_recordmapping
vtiger_wsapp_sync_state
vtiger_ws_entity
vtiger_ws_entity_fieldtype
vtiger_ws_entity_fieldtype_seq
vtiger_ws_entity_name
vtiger_ws_entity_referencetype
vtiger_ws_entity_seq
vtiger_ws_entity_tables
vtiger_ws_fieldinfo
vtiger_ws_fieldtype
vtiger_ws_operation
vtiger_ws_operation_parameters
vtiger_ws_operation_seq
vtiger_ws_referencetype
vtiger_ws_userauthtoken
vtiger_zone
vtiger_zonecf
.
select column
select table
aparam
a_sbapi_logs
com_vtiger_workflows
com_vtiger_workflows_seq
com_vtiger_workflowtasks
com_vtiger_workflowtasks_entitymethod
com_vtiger_workflowtasks_entitymethod_seq
com_vtiger_workflowtasks_seq
com_vtiger_workflowtask_queue
com_vtiger_workflowtemplates
com_vtiger_workflow_activatedonce
com_vtiger_workflow_tasktypes
com_vtiger_workflow_tasktypes_seq
new_customer_suraj_bharadwaj_table
vtiger_account
vtiger_accountbillads
vtiger_accountrating
vtiger_accountscf
vtiger_accountshipads
vtiger_accounttype
vtiger_accounttype_seq
vtiger_actionmapping
vtiger_activity
vtiger_activitycf
vtiger_activityproductrel
vtiger_activitytype
vtiger_activitytype_seq
vtiger_activity_recurring_info
vtiger_activity_reminder
vtiger_activity_reminder_popup
vtiger_activity_view
vtiger_activity_view_seq
vtiger_announcement
vtiger_apilogs
vtiger_apilogscf
vtiger_app2tab
vtiger_assets
vtiger_assetscf
vtiger_assetstatus
vtiger_assetstatus_seq
vtiger_asterisk
vtiger_asteriskextensions
vtiger_asteriskincomingcalls
vtiger_asteriskincomingevents
vtiger_attachments
vtiger_attachmentsfolder
vtiger_attachmentsfolder_seq
vtiger_audit_trial
vtiger_blocks
vtiger_blocks_seq
vtiger_branch
vtiger_branchcf
vtiger_calendarsharedtype
vtiger_calendarsharedtype_seq
vtiger_calendar_default_activitytypes
vtiger_calendar_default_activitytypes_seq
vtiger_calendar_user_activitytypes
vtiger_calendar_user_activitytypes_seq
vtiger_calldetail
vtiger_calldetailcf
vtiger_callduration
vtiger_callduration_seq
vtiger_campaign
vtiger_campaignaccountrel
vtiger_campaigncontrel
vtiger_campaignleadrel
vtiger_campaignrelstatus
vtiger_campaignrelstatus_seq
vtiger_campaignscf
vtiger_campaignstatus
vtiger_campaignstatus_seq
vtiger_campaigntype
vtiger_campaigntype_seq
vtiger_carrier
vtiger_carrier_seq
vtiger_cf_900
vtiger_cf_900_seq
vtiger_cf_904
vtiger_cf_904_seq
vtiger_cf_912
vtiger_cf_912_seq
vtiger_cf_916
vtiger_cf_916_seq
vtiger_cf_918
vtiger_cf_918_seq
vtiger_cf_920
vtiger_cf_920_seq
vtiger_cf_922
vtiger_cf_922_seq
vtiger_cf_924
vtiger_cf_924_seq
vtiger_cf_926
vtiger_cf_926_seq
vtiger_cf_936
vtiger_cf_936_seq
vtiger_cf_946
vtiger_cf_946_seq
vtiger_cf_978
vtiger_cf_978_seq
vtiger_cf_1018
vtiger_cf_1018_seq
vtiger_cf_1030
vtiger_cf_1030_seq
vtiger_cf_1034
vtiger_cf_1034_seq
vtiger_cf_1038
vtiger_cf_1038_seq
vtiger_cf_1054
vtiger_cf_1054_seq
vtiger_cf_1056
vtiger_cf_1056_seq
vtiger_cf_1058
vtiger_cf_1058_seq
vtiger_cf_1060
vtiger_cf_1060_seq
vtiger_cf_1062
vtiger_cf_1062_seq
vtiger_cf_1070
vtiger_cf_1070_seq
vtiger_cf_1072
vtiger_cf_1072_seq
vtiger_cf_1074
vtiger_cf_1074_seq
vtiger_cf_1096
vtiger_cf_1096_seq
vtiger_cf_1120
vtiger_cf_1120_seq
vtiger_cf_1146
vtiger_cf_1146_seq
vtiger_cf_1148
vtiger_cf_1148_seq
vtiger_cf_1150
vtiger_cf_1150_seq
vtiger_cf_1152
vtiger_cf_1152_seq
vtiger_cf_1164
vtiger_cf_1164_seq
vtiger_cntactivityrel
vtiger_contactaddress
vtiger_contactdetails
vtiger_contactscf
vtiger_contactsubdetails
vtiger_contpotentialrel
vtiger_contract_priority
vtiger_contract_priority_seq
vtiger_contract_status
vtiger_contract_status_seq
vtiger_contract_type
vtiger_contract_type_seq
vtiger_convertleadmapping
vtiger_convertpotentialmapping
vtiger_crmentity
vtiger_crmentityrel
vtiger_crmentity_seq
vtiger_crmentity_user_field
vtiger_crmsetup
vtiger_cron_task
vtiger_currencies
vtiger_currencies_seq
vtiger_currency
vtiger_currency_decimal_separator
vtiger_currency_decimal_separator_seq
vtiger_currency_grouping_pattern
vtiger_currency_grouping_pattern_seq
vtiger_currency_grouping_separator
vtiger_currency_grouping_separator_seq
vtiger_currency_info
vtiger_currency_info_seq
vtiger_currency_symbol_placement
vtiger_currency_symbol_placement_seq
vtiger_customaction
vtiger_customerdetails
vtiger_customerportal_fields
vtiger_customerportal_prefs
vtiger_customerportal_relatedmoduleinfo
vtiger_customerportal_settings
vtiger_customerportal_tabs
vtiger_custommodule
vtiger_custommodulecf
vtiger_customview
vtiger_customview_seq
vtiger_cv2group
vtiger_cv2role
vtiger_cv2rs
vtiger_cv2users
vtiger_cvadvfilter
vtiger_cvadvfilter_grouping
vtiger_cvcolumnlist
vtiger_cvstdfilter
vtiger_dashboard_tabs
vtiger_datashare_grp2grp
vtiger_datashare_grp2role
vtiger_datashare_grp2rs
vtiger_datashare_module_rel
vtiger_datashare_relatedmodules
vtiger_datashare_relatedmodules_seq
vtiger_datashare_relatedmodule_permission
vtiger_datashare_role2group
vtiger_datashare_role2role
vtiger_datashare_role2rs
vtiger_datashare_rs2grp
vtiger_datashare_rs2role
vtiger_datashare_rs2rs
vtiger_date_format
vtiger_date_format_seq
vtiger_dayoftheweek
vtiger_dayoftheweek_seq
vtiger_defaultactivitytype
vtiger_defaultactivitytype_seq
vtiger_defaultcalendarview
vtiger_defaultcalendarview_seq
vtiger_defaultcv
vtiger_defaulteventstatus
vtiger_defaulteventstatus_seq
vtiger_defaultlandingpage
vtiger_defaultlandingpage_seq
vtiger_default_record_view
vtiger_default_record_view_seq
vtiger_def_org_field
vtiger_def_org_share
vtiger_def_org_share_seq
vtiger_districtmaster
vtiger_durationhrs
vtiger_durationmins
vtiger_duration_minutes
vtiger_duration_minutes_seq
vtiger_emaildetails
vtiger_emailslookup
vtiger_emails_recipientprefs
vtiger_emailtemplates
vtiger_emailtemplates_seq
vtiger_email_access
vtiger_email_track
vtiger_entityname
vtiger_eventhandlers
vtiger_eventhandlers_seq
vtiger_eventhandler_module
vtiger_eventhandler_module_seq
vtiger_eventstatus
vtiger_eventstatus_seq
vtiger_expectedresponse
vtiger_expectedresponse_seq
vtiger_extnstore_users
vtiger_faq
vtiger_faqcategories
vtiger_faqcategories_seq
vtiger_faqcf
vtiger_faqcomments
vtiger_faqstatus
vtiger_faqstatus_seq
vtiger_feedback
vtiger_field
vtiger_fieldmodulerel
vtiger_field_seq
vtiger_freetagged_objects
vtiger_freetags
vtiger_freetags_seq
vtiger_glacct
vtiger_glacct_seq
vtiger_google_event_calendar_mapping
vtiger_google_oauth2
vtiger_google_sync_fieldmapping
vtiger_google_sync_settings
vtiger_group2grouprel
vtiger_group2role
vtiger_group2rs
vtiger_groups
vtiger_homedashbd
vtiger_homedefault
vtiger_homemodule
vtiger_homemoduleflds
vtiger_homereportchart
vtiger_homerss
vtiger_homestuff
vtiger_homestuff_seq
vtiger_home_layout
vtiger_hour_format
vtiger_hour_format_seq
vtiger_import_1
vtiger_import_locks
vtiger_import_locks_seq
vtiger_import_maps
vtiger_import_queue
vtiger_import_queue_seq
vtiger_industry
vtiger_industry_seq
vtiger_inventorycharges
vtiger_inventorychargesrel
vtiger_inventorynotification
vtiger_inventorynotification_seq
vtiger_inventoryproductrel
vtiger_inventoryproductrel_seq
vtiger_inventoryshippingrel
vtiger_inventorysubproductrel
vtiger_inventorytaxinfo
vtiger_inventorytaxinfo_seq
vtiger_inventory_tandc
vtiger_inventory_tandc_seq
vtiger_invitees
vtiger_invoice
vtiger_invoicebillads
vtiger_invoicecf
vtiger_invoiceshipads
vtiger_invoicestatus
vtiger_invoicestatushistory
vtiger_invoicestatus_seq
vtiger_invoice_recurring_info
vtiger_language
vtiger_language_seq
vtiger_leadaddress
vtiger_leaddetails
vtiger_leadscf
vtiger_leadsource
vtiger_leadsource_seq
vtiger_leadstage
vtiger_leadstatus
vtiger_leadstatus_seq
vtiger_leadsubdetails
vtiger_lead_view
vtiger_lead_view_seq
vtiger_links
vtiger_links_seq
vtiger_loginhistory
vtiger_mailer_queue
vtiger_mailer_queueattachments
vtiger_mailer_queueinfo
vtiger_mailmanager_mailattachments
vtiger_mailmanager_mailrecord
vtiger_mailmanager_mailrel
vtiger_mailscanner
vtiger_mailscanner_actions
vtiger_mailscanner_folders
vtiger_mailscanner_ids
vtiger_mailscanner_ruleactions
vtiger_mailscanner_rules
vtiger_mail_accounts
vtiger_manufacturer
vtiger_manufacturer_seq
vtiger_mobile_alerts
vtiger_modcomments
vtiger_modcommentscf
vtiger_modentity_num
vtiger_modentity_num_seq
vtiger_modtracker_basic
vtiger_modtracker_basic_seq
vtiger_modtracker_detail
vtiger_modtracker_relations
vtiger_modtracker_tabs
vtiger_module_dashboard_widgets
vtiger_notebook_contents
vtiger_notes
vtiger_notescf
vtiger_notificationscheduler
vtiger_notificationscheduler_seq
vtiger_no_of_currency_decimals
vtiger_no_of_currency_decimals_seq
vtiger_opportunitystage
vtiger_opportunity_type
vtiger_opportunity_type_seq
vtiger_organizationdetails
vtiger_organizationdetails_seq
vtiger_org_share_action2tab
vtiger_org_share_action_mapping
vtiger_othereventduration
vtiger_othereventduration_seq
vtiger_parenttab
vtiger_parenttabrel
vtiger_payment_duration
vtiger_payment_duration_seq
vtiger_pbxmanager
vtiger_pbxmanagercf
vtiger_pbxmanager_gateway
vtiger_pbxmanager_phonelookup
vtiger_picklist
vtiger_picklistvalues_seq
vtiger_picklist_dependency
vtiger_picklist_seq
vtiger_picklist_transitions
vtiger_pobillads
vtiger_portal
vtiger_portalinfo
vtiger_poshipads
vtiger_postatus
vtiger_postatushistory
vtiger_postatus_seq
vtiger_potential
vtiger_potentialscf
vtiger_potstagehistory
vtiger_pricebook
vtiger_pricebookcf
vtiger_pricebookproductrel
vtiger_priority
vtiger_productcategory
vtiger_productcategory_seq
vtiger_productcf
vtiger_productcurrencyrel
vtiger_products
vtiger_producttaxrel
vtiger_profile
vtiger_profile2field
vtiger_profile2globalpermissions
vtiger_profile2standardpermissions
vtiger_profile2tab
vtiger_profile2utility
vtiger_profile_seq
vtiger_progress
vtiger_progress_seq
vtiger_project
vtiger_projectcf
vtiger_projectmilestone
vtiger_projectmilestonecf
vtiger_projectmilestonetype
vtiger_projectmilestonetype_seq
vtiger_projectpriority
vtiger_projectpriority_seq
vtiger_projectstatus
vtiger_projectstatus_seq
vtiger_projecttask
vtiger_projecttaskcf
vtiger_projecttaskpriority
vtiger_projecttaskpriority_seq
vtiger_projecttaskprogress
vtiger_projecttaskprogress_seq
vtiger_projecttaskstatus
vtiger_projecttaskstatus_seq
vtiger_projecttasktype
vtiger_projecttasktype_seq
vtiger_projecttask_status_color
vtiger_projecttype
vtiger_projecttype_seq
vtiger_purchaseorder
vtiger_purchaseordercf
vtiger_query
vtiger_querycf
vtiger_quotes
vtiger_quotesbillads
vtiger_quotescf
vtiger_quotesshipads
vtiger_quotestage
vtiger_quotestagehistory
vtiger_quotestage_seq
vtiger_rating
vtiger_rating_seq
vtiger_recurringevents
vtiger_recurringtype
vtiger_recurringtype_seq
vtiger_recurring_frequency
vtiger_recurring_frequency_seq
vtiger_relatedlists
vtiger_relatedlists_rb
vtiger_relatedlists_seq
vtiger_relcriteria
vtiger_relcriteria_grouping
vtiger_reminder_interval
vtiger_reminder_interval_seq
vtiger_report
vtiger_reportdatefilter
vtiger_reportfilters
vtiger_reportfolder
vtiger_reportgroupbycolumn
vtiger_reportmodules
vtiger_reportsharing
vtiger_reportsortcol
vtiger_reportsummary
vtiger_reporttype
vtiger_report_sharegroups
vtiger_report_sharerole
vtiger_report_sharers
vtiger_report_shareusers
vtiger_role
vtiger_role2picklist
vtiger_role2profile
vtiger_role_seq
vtiger_rollupcomments_settings
vtiger_rowheight
vtiger_rowheight_seq
vtiger_rss
vtiger_salesmanactivityrel
vtiger_salesmanattachmentsrel
vtiger_salesmanticketrel
vtiger_salesorder
vtiger_salesordercf
vtiger_sales_stage
vtiger_sales_stage_seq
vtiger_salutationtype
vtiger_salutationtype_seq
vtiger_scheduled_reports
vtiger_schedulereports
vtiger_seactivityrel
vtiger_seactivityrel_seq
vtiger_seattachmentsrel
vtiger_selectcolumn
vtiger_selectquery
vtiger_selectquery_seq
vtiger_senotesrel
vtiger_seproductsrel
vtiger_service
vtiger_servicecategory
vtiger_servicecategory_seq
vtiger_servicecf
vtiger_servicecontracts
vtiger_servicecontractscf
vtiger_service_usageunit
vtiger_service_usageunit_seq
vtiger_seticketsrel
vtiger_settings_blocks
vtiger_settings_blocks_seq
vtiger_settings_field
vtiger_settings_field_seq
vtiger_sharedcalendar
vtiger_shareduserinfo
vtiger_shippingtaxinfo
vtiger_shippingtaxinfo_seq
vtiger_shorturls
vtiger_smslog
vtiger_smslogcf
vtiger_smsnotifier
vtiger_smsnotifiercf
vtiger_smsnotifier_servers
vtiger_smsnotifier_status
vtiger_soapservice
vtiger_sobillads
vtiger_soshipads
vtiger_sostatus
vtiger_sostatushistory
vtiger_sostatus_seq
vtiger_sqltimelog
vtiger_start_hour
vtiger_start_hour_seq
vtiger_state_master
vtiger_status
vtiger_status_seq
vtiger_systems
vtiger_tab
vtiger_tab_info
vtiger_taskpriority
vtiger_taskpriority_seq
vtiger_taskstatus
vtiger_taskstatus_seq
vtiger_taxclass
vtiger_taxclass_seq
vtiger_taxregions
vtiger_ticketcategories
vtiger_ticketcategories_seq
vtiger_ticketcf
vtiger_ticketcomments
vtiger_ticketpriorities
vtiger_ticketpriorities_seq
vtiger_ticketseverities
vtiger_ticketseverities_seq
vtiger_ticketstatus
vtiger_ticketstatus_seq
vtiger_ticket_title
vtiger_ticket_title_seq
vtiger_time_zone
vtiger_time_zone_seq
vtiger_tmp_read_group_rel_sharing_per
vtiger_tmp_read_group_sharing_per
vtiger_tmp_read_user_rel_sharing_per
vtiger_tmp_read_user_sharing_per
vtiger_tmp_write_group_rel_sharing_per
vtiger_tmp_write_group_sharing_per
vtiger_tmp_write_user_rel_sharing_per
vtiger_tmp_write_user_sharing_per
vtiger_tracker
vtiger_tracking_unit
vtiger_tracking_unit_seq
vtiger_troubletickets
vtiger_usageunit
vtiger_usageunit_seq
vtiger_user2mergefields
vtiger_user2role
vtiger_users
vtiger_users2group
vtiger_users_last_import
vtiger_users_seq
vtiger_user_audit_log
vtiger_user_module_preferences
vtiger_vendor
vtiger_vendorcf
vtiger_vendorcontactrel
vtiger_version
vtiger_version_seq
vtiger_visibility
vtiger_visibility_seq
vtiger_webforms
vtiger_webforms_field
vtiger_webform_file_fields
vtiger_wordtemplates
vtiger_wsapp
vtiger_wsapp_handlerdetails
vtiger_wsapp_logs_basic
vtiger_wsapp_logs_details
vtiger_wsapp_queuerecords
vtiger_wsapp_recordmapping
vtiger_wsapp_sync_state
vtiger_ws_entity
vtiger_ws_entity_fieldtype
vtiger_ws_entity_fieldtype_seq
vtiger_ws_entity_name
vtiger_ws_entity_referencetype
vtiger_ws_entity_seq
vtiger_ws_entity_tables
vtiger_ws_fieldinfo
vtiger_ws_fieldtype
vtiger_ws_operation
vtiger_ws_operation_parameters
vtiger_ws_operation_seq
vtiger_ws_referencetype
vtiger_ws_userauthtoken
vtiger_zone
vtiger_zonecf
.
select column
Show
criteria
Sort
Ascending
Descending
Add as
AND
OR
Op
=
>
>=
<
<=
!=
LIKE
LIKE %...%
NOT LIKE
NOT LIKE %...%
IN (...)
NOT IN (...)
BETWEEN
NOT BETWEEN
IS NULL
IS NOT NULL
REGEXP
REGEXP ^...$
NOT REGEXP
Text
Another column
select table
aparam
a_sbapi_logs
com_vtiger_workflows
com_vtiger_workflows_seq
com_vtiger_workflowtasks
com_vtiger_workflowtasks_entitymethod
com_vtiger_workflowtasks_entitymethod_seq
com_vtiger_workflowtasks_seq
com_vtiger_workflowtask_queue
com_vtiger_workflowtemplates
com_vtiger_workflow_activatedonce
com_vtiger_workflow_tasktypes
com_vtiger_workflow_tasktypes_seq
new_customer_suraj_bharadwaj_table
vtiger_account
vtiger_accountbillads
vtiger_accountrating
vtiger_accountscf
vtiger_accountshipads
vtiger_accounttype
vtiger_accounttype_seq
vtiger_actionmapping
vtiger_activity
vtiger_activitycf
vtiger_activityproductrel
vtiger_activitytype
vtiger_activitytype_seq
vtiger_activity_recurring_info
vtiger_activity_reminder
vtiger_activity_reminder_popup
vtiger_activity_view
vtiger_activity_view_seq
vtiger_announcement
vtiger_apilogs
vtiger_apilogscf
vtiger_app2tab
vtiger_assets
vtiger_assetscf
vtiger_assetstatus
vtiger_assetstatus_seq
vtiger_asterisk
vtiger_asteriskextensions
vtiger_asteriskincomingcalls
vtiger_asteriskincomingevents
vtiger_attachments
vtiger_attachmentsfolder
vtiger_attachmentsfolder_seq
vtiger_audit_trial
vtiger_blocks
vtiger_blocks_seq
vtiger_branch
vtiger_branchcf
vtiger_calendarsharedtype
vtiger_calendarsharedtype_seq
vtiger_calendar_default_activitytypes
vtiger_calendar_default_activitytypes_seq
vtiger_calendar_user_activitytypes
vtiger_calendar_user_activitytypes_seq
vtiger_calldetail
vtiger_calldetailcf
vtiger_callduration
vtiger_callduration_seq
vtiger_campaign
vtiger_campaignaccountrel
vtiger_campaigncontrel
vtiger_campaignleadrel
vtiger_campaignrelstatus
vtiger_campaignrelstatus_seq
vtiger_campaignscf
vtiger_campaignstatus
vtiger_campaignstatus_seq
vtiger_campaigntype
vtiger_campaigntype_seq
vtiger_carrier
vtiger_carrier_seq
vtiger_cf_900
vtiger_cf_900_seq
vtiger_cf_904
vtiger_cf_904_seq
vtiger_cf_912
vtiger_cf_912_seq
vtiger_cf_916
vtiger_cf_916_seq
vtiger_cf_918
vtiger_cf_918_seq
vtiger_cf_920
vtiger_cf_920_seq
vtiger_cf_922
vtiger_cf_922_seq
vtiger_cf_924
vtiger_cf_924_seq
vtiger_cf_926
vtiger_cf_926_seq
vtiger_cf_936
vtiger_cf_936_seq
vtiger_cf_946
vtiger_cf_946_seq
vtiger_cf_978
vtiger_cf_978_seq
vtiger_cf_1018
vtiger_cf_1018_seq
vtiger_cf_1030
vtiger_cf_1030_seq
vtiger_cf_1034
vtiger_cf_1034_seq
vtiger_cf_1038
vtiger_cf_1038_seq
vtiger_cf_1054
vtiger_cf_1054_seq
vtiger_cf_1056
vtiger_cf_1056_seq
vtiger_cf_1058
vtiger_cf_1058_seq
vtiger_cf_1060
vtiger_cf_1060_seq
vtiger_cf_1062
vtiger_cf_1062_seq
vtiger_cf_1070
vtiger_cf_1070_seq
vtiger_cf_1072
vtiger_cf_1072_seq
vtiger_cf_1074
vtiger_cf_1074_seq
vtiger_cf_1096
vtiger_cf_1096_seq
vtiger_cf_1120
vtiger_cf_1120_seq
vtiger_cf_1146
vtiger_cf_1146_seq
vtiger_cf_1148
vtiger_cf_1148_seq
vtiger_cf_1150
vtiger_cf_1150_seq
vtiger_cf_1152
vtiger_cf_1152_seq
vtiger_cf_1164
vtiger_cf_1164_seq
vtiger_cntactivityrel
vtiger_contactaddress
vtiger_contactdetails
vtiger_contactscf
vtiger_contactsubdetails
vtiger_contpotentialrel
vtiger_contract_priority
vtiger_contract_priority_seq
vtiger_contract_status
vtiger_contract_status_seq
vtiger_contract_type
vtiger_contract_type_seq
vtiger_convertleadmapping
vtiger_convertpotentialmapping
vtiger_crmentity
vtiger_crmentityrel
vtiger_crmentity_seq
vtiger_crmentity_user_field
vtiger_crmsetup
vtiger_cron_task
vtiger_currencies
vtiger_currencies_seq
vtiger_currency
vtiger_currency_decimal_separator
vtiger_currency_decimal_separator_seq
vtiger_currency_grouping_pattern
vtiger_currency_grouping_pattern_seq
vtiger_currency_grouping_separator
vtiger_currency_grouping_separator_seq
vtiger_currency_info
vtiger_currency_info_seq
vtiger_currency_symbol_placement
vtiger_currency_symbol_placement_seq
vtiger_customaction
vtiger_customerdetails
vtiger_customerportal_fields
vtiger_customerportal_prefs
vtiger_customerportal_relatedmoduleinfo
vtiger_customerportal_settings
vtiger_customerportal_tabs
vtiger_custommodule
vtiger_custommodulecf
vtiger_customview
vtiger_customview_seq
vtiger_cv2group
vtiger_cv2role
vtiger_cv2rs
vtiger_cv2users
vtiger_cvadvfilter
vtiger_cvadvfilter_grouping
vtiger_cvcolumnlist
vtiger_cvstdfilter
vtiger_dashboard_tabs
vtiger_datashare_grp2grp
vtiger_datashare_grp2role
vtiger_datashare_grp2rs
vtiger_datashare_module_rel
vtiger_datashare_relatedmodules
vtiger_datashare_relatedmodules_seq
vtiger_datashare_relatedmodule_permission
vtiger_datashare_role2group
vtiger_datashare_role2role
vtiger_datashare_role2rs
vtiger_datashare_rs2grp
vtiger_datashare_rs2role
vtiger_datashare_rs2rs
vtiger_date_format
vtiger_date_format_seq
vtiger_dayoftheweek
vtiger_dayoftheweek_seq
vtiger_defaultactivitytype
vtiger_defaultactivitytype_seq
vtiger_defaultcalendarview
vtiger_defaultcalendarview_seq
vtiger_defaultcv
vtiger_defaulteventstatus
vtiger_defaulteventstatus_seq
vtiger_defaultlandingpage
vtiger_defaultlandingpage_seq
vtiger_default_record_view
vtiger_default_record_view_seq
vtiger_def_org_field
vtiger_def_org_share
vtiger_def_org_share_seq
vtiger_districtmaster
vtiger_durationhrs
vtiger_durationmins
vtiger_duration_minutes
vtiger_duration_minutes_seq
vtiger_emaildetails
vtiger_emailslookup
vtiger_emails_recipientprefs
vtiger_emailtemplates
vtiger_emailtemplates_seq
vtiger_email_access
vtiger_email_track
vtiger_entityname
vtiger_eventhandlers
vtiger_eventhandlers_seq
vtiger_eventhandler_module
vtiger_eventhandler_module_seq
vtiger_eventstatus
vtiger_eventstatus_seq
vtiger_expectedresponse
vtiger_expectedresponse_seq
vtiger_extnstore_users
vtiger_faq
vtiger_faqcategories
vtiger_faqcategories_seq
vtiger_faqcf
vtiger_faqcomments
vtiger_faqstatus
vtiger_faqstatus_seq
vtiger_feedback
vtiger_field
vtiger_fieldmodulerel
vtiger_field_seq
vtiger_freetagged_objects
vtiger_freetags
vtiger_freetags_seq
vtiger_glacct
vtiger_glacct_seq
vtiger_google_event_calendar_mapping
vtiger_google_oauth2
vtiger_google_sync_fieldmapping
vtiger_google_sync_settings
vtiger_group2grouprel
vtiger_group2role
vtiger_group2rs
vtiger_groups
vtiger_homedashbd
vtiger_homedefault
vtiger_homemodule
vtiger_homemoduleflds
vtiger_homereportchart
vtiger_homerss
vtiger_homestuff
vtiger_homestuff_seq
vtiger_home_layout
vtiger_hour_format
vtiger_hour_format_seq
vtiger_import_1
vtiger_import_locks
vtiger_import_locks_seq
vtiger_import_maps
vtiger_import_queue
vtiger_import_queue_seq
vtiger_industry
vtiger_industry_seq
vtiger_inventorycharges
vtiger_inventorychargesrel
vtiger_inventorynotification
vtiger_inventorynotification_seq
vtiger_inventoryproductrel
vtiger_inventoryproductrel_seq
vtiger_inventoryshippingrel
vtiger_inventorysubproductrel
vtiger_inventorytaxinfo
vtiger_inventorytaxinfo_seq
vtiger_inventory_tandc
vtiger_inventory_tandc_seq
vtiger_invitees
vtiger_invoice
vtiger_invoicebillads
vtiger_invoicecf
vtiger_invoiceshipads
vtiger_invoicestatus
vtiger_invoicestatushistory
vtiger_invoicestatus_seq
vtiger_invoice_recurring_info
vtiger_language
vtiger_language_seq
vtiger_leadaddress
vtiger_leaddetails
vtiger_leadscf
vtiger_leadsource
vtiger_leadsource_seq
vtiger_leadstage
vtiger_leadstatus
vtiger_leadstatus_seq
vtiger_leadsubdetails
vtiger_lead_view
vtiger_lead_view_seq
vtiger_links
vtiger_links_seq
vtiger_loginhistory
vtiger_mailer_queue
vtiger_mailer_queueattachments
vtiger_mailer_queueinfo
vtiger_mailmanager_mailattachments
vtiger_mailmanager_mailrecord
vtiger_mailmanager_mailrel
vtiger_mailscanner
vtiger_mailscanner_actions
vtiger_mailscanner_folders
vtiger_mailscanner_ids
vtiger_mailscanner_ruleactions
vtiger_mailscanner_rules
vtiger_mail_accounts
vtiger_manufacturer
vtiger_manufacturer_seq
vtiger_mobile_alerts
vtiger_modcomments
vtiger_modcommentscf
vtiger_modentity_num
vtiger_modentity_num_seq
vtiger_modtracker_basic
vtiger_modtracker_basic_seq
vtiger_modtracker_detail
vtiger_modtracker_relations
vtiger_modtracker_tabs
vtiger_module_dashboard_widgets
vtiger_notebook_contents
vtiger_notes
vtiger_notescf
vtiger_notificationscheduler
vtiger_notificationscheduler_seq
vtiger_no_of_currency_decimals
vtiger_no_of_currency_decimals_seq
vtiger_opportunitystage
vtiger_opportunity_type
vtiger_opportunity_type_seq
vtiger_organizationdetails
vtiger_organizationdetails_seq
vtiger_org_share_action2tab
vtiger_org_share_action_mapping
vtiger_othereventduration
vtiger_othereventduration_seq
vtiger_parenttab
vtiger_parenttabrel
vtiger_payment_duration
vtiger_payment_duration_seq
vtiger_pbxmanager
vtiger_pbxmanagercf
vtiger_pbxmanager_gateway
vtiger_pbxmanager_phonelookup
vtiger_picklist
vtiger_picklistvalues_seq
vtiger_picklist_dependency
vtiger_picklist_seq
vtiger_picklist_transitions
vtiger_pobillads
vtiger_portal
vtiger_portalinfo
vtiger_poshipads
vtiger_postatus
vtiger_postatushistory
vtiger_postatus_seq
vtiger_potential
vtiger_potentialscf
vtiger_potstagehistory
vtiger_pricebook
vtiger_pricebookcf
vtiger_pricebookproductrel
vtiger_priority
vtiger_productcategory
vtiger_productcategory_seq
vtiger_productcf
vtiger_productcurrencyrel
vtiger_products
vtiger_producttaxrel
vtiger_profile
vtiger_profile2field
vtiger_profile2globalpermissions
vtiger_profile2standardpermissions
vtiger_profile2tab
vtiger_profile2utility
vtiger_profile_seq
vtiger_progress
vtiger_progress_seq
vtiger_project
vtiger_projectcf
vtiger_projectmilestone
vtiger_projectmilestonecf
vtiger_projectmilestonetype
vtiger_projectmilestonetype_seq
vtiger_projectpriority
vtiger_projectpriority_seq
vtiger_projectstatus
vtiger_projectstatus_seq
vtiger_projecttask
vtiger_projecttaskcf
vtiger_projecttaskpriority
vtiger_projecttaskpriority_seq
vtiger_projecttaskprogress
vtiger_projecttaskprogress_seq
vtiger_projecttaskstatus
vtiger_projecttaskstatus_seq
vtiger_projecttasktype
vtiger_projecttasktype_seq
vtiger_projecttask_status_color
vtiger_projecttype
vtiger_projecttype_seq
vtiger_purchaseorder
vtiger_purchaseordercf
vtiger_query
vtiger_querycf
vtiger_quotes
vtiger_quotesbillads
vtiger_quotescf
vtiger_quotesshipads
vtiger_quotestage
vtiger_quotestagehistory
vtiger_quotestage_seq
vtiger_rating
vtiger_rating_seq
vtiger_recurringevents
vtiger_recurringtype
vtiger_recurringtype_seq
vtiger_recurring_frequency
vtiger_recurring_frequency_seq
vtiger_relatedlists
vtiger_relatedlists_rb
vtiger_relatedlists_seq
vtiger_relcriteria
vtiger_relcriteria_grouping
vtiger_reminder_interval
vtiger_reminder_interval_seq
vtiger_report
vtiger_reportdatefilter
vtiger_reportfilters
vtiger_reportfolder
vtiger_reportgroupbycolumn
vtiger_reportmodules
vtiger_reportsharing
vtiger_reportsortcol
vtiger_reportsummary
vtiger_reporttype
vtiger_report_sharegroups
vtiger_report_sharerole
vtiger_report_sharers
vtiger_report_shareusers
vtiger_role
vtiger_role2picklist
vtiger_role2profile
vtiger_role_seq
vtiger_rollupcomments_settings
vtiger_rowheight
vtiger_rowheight_seq
vtiger_rss
vtiger_salesmanactivityrel
vtiger_salesmanattachmentsrel
vtiger_salesmanticketrel
vtiger_salesorder
vtiger_salesordercf
vtiger_sales_stage
vtiger_sales_stage_seq
vtiger_salutationtype
vtiger_salutationtype_seq
vtiger_scheduled_reports
vtiger_schedulereports
vtiger_seactivityrel
vtiger_seactivityrel_seq
vtiger_seattachmentsrel
vtiger_selectcolumn
vtiger_selectquery
vtiger_selectquery_seq
vtiger_senotesrel
vtiger_seproductsrel
vtiger_service
vtiger_servicecategory
vtiger_servicecategory_seq
vtiger_servicecf
vtiger_servicecontracts
vtiger_servicecontractscf
vtiger_service_usageunit
vtiger_service_usageunit_seq
vtiger_seticketsrel
vtiger_settings_blocks
vtiger_settings_blocks_seq
vtiger_settings_field
vtiger_settings_field_seq
vtiger_sharedcalendar
vtiger_shareduserinfo
vtiger_shippingtaxinfo
vtiger_shippingtaxinfo_seq
vtiger_shorturls
vtiger_smslog
vtiger_smslogcf
vtiger_smsnotifier
vtiger_smsnotifiercf
vtiger_smsnotifier_servers
vtiger_smsnotifier_status
vtiger_soapservice
vtiger_sobillads
vtiger_soshipads
vtiger_sostatus
vtiger_sostatushistory
vtiger_sostatus_seq
vtiger_sqltimelog
vtiger_start_hour
vtiger_start_hour_seq
vtiger_state_master
vtiger_status
vtiger_status_seq
vtiger_systems
vtiger_tab
vtiger_tab_info
vtiger_taskpriority
vtiger_taskpriority_seq
vtiger_taskstatus
vtiger_taskstatus_seq
vtiger_taxclass
vtiger_taxclass_seq
vtiger_taxregions
vtiger_ticketcategories
vtiger_ticketcategories_seq
vtiger_ticketcf
vtiger_ticketcomments
vtiger_ticketpriorities
vtiger_ticketpriorities_seq
vtiger_ticketseverities
vtiger_ticketseverities_seq
vtiger_ticketstatus
vtiger_ticketstatus_seq
vtiger_ticket_title
vtiger_ticket_title_seq
vtiger_time_zone
vtiger_time_zone_seq
vtiger_tmp_read_group_rel_sharing_per
vtiger_tmp_read_group_sharing_per
vtiger_tmp_read_user_rel_sharing_per
vtiger_tmp_read_user_sharing_per
vtiger_tmp_write_group_rel_sharing_per
vtiger_tmp_write_group_sharing_per
vtiger_tmp_write_user_rel_sharing_per
vtiger_tmp_write_user_sharing_per
vtiger_tracker
vtiger_tracking_unit
vtiger_tracking_unit_seq
vtiger_troubletickets
vtiger_usageunit
vtiger_usageunit_seq
vtiger_user2mergefields
vtiger_user2role
vtiger_users
vtiger_users2group
vtiger_users_last_import
vtiger_users_seq
vtiger_user_audit_log
vtiger_user_module_preferences
vtiger_vendor
vtiger_vendorcf
vtiger_vendorcontactrel
vtiger_version
vtiger_version_seq
vtiger_visibility
vtiger_visibility_seq
vtiger_webforms
vtiger_webforms_field
vtiger_webform_file_fields
vtiger_wordtemplates
vtiger_wsapp
vtiger_wsapp_handlerdetails
vtiger_wsapp_logs_basic
vtiger_wsapp_logs_details
vtiger_wsapp_queuerecords
vtiger_wsapp_recordmapping
vtiger_wsapp_sync_state
vtiger_ws_entity
vtiger_ws_entity_fieldtype
vtiger_ws_entity_fieldtype_seq
vtiger_ws_entity_name
vtiger_ws_entity_referencetype
vtiger_ws_entity_seq
vtiger_ws_entity_tables
vtiger_ws_fieldinfo
vtiger_ws_fieldtype
vtiger_ws_operation
vtiger_ws_operation_parameters
vtiger_ws_operation_seq
vtiger_ws_referencetype
vtiger_ws_userauthtoken
vtiger_zone
vtiger_zonecf
.
select column
select table
aparam
a_sbapi_logs
com_vtiger_workflows
com_vtiger_workflows_seq
com_vtiger_workflowtasks
com_vtiger_workflowtasks_entitymethod
com_vtiger_workflowtasks_entitymethod_seq
com_vtiger_workflowtasks_seq
com_vtiger_workflowtask_queue
com_vtiger_workflowtemplates
com_vtiger_workflow_activatedonce
com_vtiger_workflow_tasktypes
com_vtiger_workflow_tasktypes_seq
new_customer_suraj_bharadwaj_table
vtiger_account
vtiger_accountbillads
vtiger_accountrating
vtiger_accountscf
vtiger_accountshipads
vtiger_accounttype
vtiger_accounttype_seq
vtiger_actionmapping
vtiger_activity
vtiger_activitycf
vtiger_activityproductrel
vtiger_activitytype
vtiger_activitytype_seq
vtiger_activity_recurring_info
vtiger_activity_reminder
vtiger_activity_reminder_popup
vtiger_activity_view
vtiger_activity_view_seq
vtiger_announcement
vtiger_apilogs
vtiger_apilogscf
vtiger_app2tab
vtiger_assets
vtiger_assetscf
vtiger_assetstatus
vtiger_assetstatus_seq
vtiger_asterisk
vtiger_asteriskextensions
vtiger_asteriskincomingcalls
vtiger_asteriskincomingevents
vtiger_attachments
vtiger_attachmentsfolder
vtiger_attachmentsfolder_seq
vtiger_audit_trial
vtiger_blocks
vtiger_blocks_seq
vtiger_branch
vtiger_branchcf
vtiger_calendarsharedtype
vtiger_calendarsharedtype_seq
vtiger_calendar_default_activitytypes
vtiger_calendar_default_activitytypes_seq
vtiger_calendar_user_activitytypes
vtiger_calendar_user_activitytypes_seq
vtiger_calldetail
vtiger_calldetailcf
vtiger_callduration
vtiger_callduration_seq
vtiger_campaign
vtiger_campaignaccountrel
vtiger_campaigncontrel
vtiger_campaignleadrel
vtiger_campaignrelstatus
vtiger_campaignrelstatus_seq
vtiger_campaignscf
vtiger_campaignstatus
vtiger_campaignstatus_seq
vtiger_campaigntype
vtiger_campaigntype_seq
vtiger_carrier
vtiger_carrier_seq
vtiger_cf_900
vtiger_cf_900_seq
vtiger_cf_904
vtiger_cf_904_seq
vtiger_cf_912
vtiger_cf_912_seq
vtiger_cf_916
vtiger_cf_916_seq
vtiger_cf_918
vtiger_cf_918_seq
vtiger_cf_920
vtiger_cf_920_seq
vtiger_cf_922
vtiger_cf_922_seq
vtiger_cf_924
vtiger_cf_924_seq
vtiger_cf_926
vtiger_cf_926_seq
vtiger_cf_936
vtiger_cf_936_seq
vtiger_cf_946
vtiger_cf_946_seq
vtiger_cf_978
vtiger_cf_978_seq
vtiger_cf_1018
vtiger_cf_1018_seq
vtiger_cf_1030
vtiger_cf_1030_seq
vtiger_cf_1034
vtiger_cf_1034_seq
vtiger_cf_1038
vtiger_cf_1038_seq
vtiger_cf_1054
vtiger_cf_1054_seq
vtiger_cf_1056
vtiger_cf_1056_seq
vtiger_cf_1058
vtiger_cf_1058_seq
vtiger_cf_1060
vtiger_cf_1060_seq
vtiger_cf_1062
vtiger_cf_1062_seq
vtiger_cf_1070
vtiger_cf_1070_seq
vtiger_cf_1072
vtiger_cf_1072_seq
vtiger_cf_1074
vtiger_cf_1074_seq
vtiger_cf_1096
vtiger_cf_1096_seq
vtiger_cf_1120
vtiger_cf_1120_seq
vtiger_cf_1146
vtiger_cf_1146_seq
vtiger_cf_1148
vtiger_cf_1148_seq
vtiger_cf_1150
vtiger_cf_1150_seq
vtiger_cf_1152
vtiger_cf_1152_seq
vtiger_cf_1164
vtiger_cf_1164_seq
vtiger_cntactivityrel
vtiger_contactaddress
vtiger_contactdetails
vtiger_contactscf
vtiger_contactsubdetails
vtiger_contpotentialrel
vtiger_contract_priority
vtiger_contract_priority_seq
vtiger_contract_status
vtiger_contract_status_seq
vtiger_contract_type
vtiger_contract_type_seq
vtiger_convertleadmapping
vtiger_convertpotentialmapping
vtiger_crmentity
vtiger_crmentityrel
vtiger_crmentity_seq
vtiger_crmentity_user_field
vtiger_crmsetup
vtiger_cron_task
vtiger_currencies
vtiger_currencies_seq
vtiger_currency
vtiger_currency_decimal_separator
vtiger_currency_decimal_separator_seq
vtiger_currency_grouping_pattern
vtiger_currency_grouping_pattern_seq
vtiger_currency_grouping_separator
vtiger_currency_grouping_separator_seq
vtiger_currency_info
vtiger_currency_info_seq
vtiger_currency_symbol_placement
vtiger_currency_symbol_placement_seq
vtiger_customaction
vtiger_customerdetails
vtiger_customerportal_fields
vtiger_customerportal_prefs
vtiger_customerportal_relatedmoduleinfo
vtiger_customerportal_settings
vtiger_customerportal_tabs
vtiger_custommodule
vtiger_custommodulecf
vtiger_customview
vtiger_customview_seq
vtiger_cv2group
vtiger_cv2role
vtiger_cv2rs
vtiger_cv2users
vtiger_cvadvfilter
vtiger_cvadvfilter_grouping
vtiger_cvcolumnlist
vtiger_cvstdfilter
vtiger_dashboard_tabs
vtiger_datashare_grp2grp
vtiger_datashare_grp2role
vtiger_datashare_grp2rs
vtiger_datashare_module_rel
vtiger_datashare_relatedmodules
vtiger_datashare_relatedmodules_seq
vtiger_datashare_relatedmodule_permission
vtiger_datashare_role2group
vtiger_datashare_role2role
vtiger_datashare_role2rs
vtiger_datashare_rs2grp
vtiger_datashare_rs2role
vtiger_datashare_rs2rs
vtiger_date_format
vtiger_date_format_seq
vtiger_dayoftheweek
vtiger_dayoftheweek_seq
vtiger_defaultactivitytype
vtiger_defaultactivitytype_seq
vtiger_defaultcalendarview
vtiger_defaultcalendarview_seq
vtiger_defaultcv
vtiger_defaulteventstatus
vtiger_defaulteventstatus_seq
vtiger_defaultlandingpage
vtiger_defaultlandingpage_seq
vtiger_default_record_view
vtiger_default_record_view_seq
vtiger_def_org_field
vtiger_def_org_share
vtiger_def_org_share_seq
vtiger_districtmaster
vtiger_durationhrs
vtiger_durationmins
vtiger_duration_minutes
vtiger_duration_minutes_seq
vtiger_emaildetails
vtiger_emailslookup
vtiger_emails_recipientprefs
vtiger_emailtemplates
vtiger_emailtemplates_seq
vtiger_email_access
vtiger_email_track
vtiger_entityname
vtiger_eventhandlers
vtiger_eventhandlers_seq
vtiger_eventhandler_module
vtiger_eventhandler_module_seq
vtiger_eventstatus
vtiger_eventstatus_seq
vtiger_expectedresponse
vtiger_expectedresponse_seq
vtiger_extnstore_users
vtiger_faq
vtiger_faqcategories
vtiger_faqcategories_seq
vtiger_faqcf
vtiger_faqcomments
vtiger_faqstatus
vtiger_faqstatus_seq
vtiger_feedback
vtiger_field
vtiger_fieldmodulerel
vtiger_field_seq
vtiger_freetagged_objects
vtiger_freetags
vtiger_freetags_seq
vtiger_glacct
vtiger_glacct_seq
vtiger_google_event_calendar_mapping
vtiger_google_oauth2
vtiger_google_sync_fieldmapping
vtiger_google_sync_settings
vtiger_group2grouprel
vtiger_group2role
vtiger_group2rs
vtiger_groups
vtiger_homedashbd
vtiger_homedefault
vtiger_homemodule
vtiger_homemoduleflds
vtiger_homereportchart
vtiger_homerss
vtiger_homestuff
vtiger_homestuff_seq
vtiger_home_layout
vtiger_hour_format
vtiger_hour_format_seq
vtiger_import_1
vtiger_import_locks
vtiger_import_locks_seq
vtiger_import_maps
vtiger_import_queue
vtiger_import_queue_seq
vtiger_industry
vtiger_industry_seq
vtiger_inventorycharges
vtiger_inventorychargesrel
vtiger_inventorynotification
vtiger_inventorynotification_seq
vtiger_inventoryproductrel
vtiger_inventoryproductrel_seq
vtiger_inventoryshippingrel
vtiger_inventorysubproductrel
vtiger_inventorytaxinfo
vtiger_inventorytaxinfo_seq
vtiger_inventory_tandc
vtiger_inventory_tandc_seq
vtiger_invitees
vtiger_invoice
vtiger_invoicebillads
vtiger_invoicecf
vtiger_invoiceshipads
vtiger_invoicestatus
vtiger_invoicestatushistory
vtiger_invoicestatus_seq
vtiger_invoice_recurring_info
vtiger_language
vtiger_language_seq
vtiger_leadaddress
vtiger_leaddetails
vtiger_leadscf
vtiger_leadsource
vtiger_leadsource_seq
vtiger_leadstage
vtiger_leadstatus
vtiger_leadstatus_seq
vtiger_leadsubdetails
vtiger_lead_view
vtiger_lead_view_seq
vtiger_links
vtiger_links_seq
vtiger_loginhistory
vtiger_mailer_queue
vtiger_mailer_queueattachments
vtiger_mailer_queueinfo
vtiger_mailmanager_mailattachments
vtiger_mailmanager_mailrecord
vtiger_mailmanager_mailrel
vtiger_mailscanner
vtiger_mailscanner_actions
vtiger_mailscanner_folders
vtiger_mailscanner_ids
vtiger_mailscanner_ruleactions
vtiger_mailscanner_rules
vtiger_mail_accounts
vtiger_manufacturer
vtiger_manufacturer_seq
vtiger_mobile_alerts
vtiger_modcomments
vtiger_modcommentscf
vtiger_modentity_num
vtiger_modentity_num_seq
vtiger_modtracker_basic
vtiger_modtracker_basic_seq
vtiger_modtracker_detail
vtiger_modtracker_relations
vtiger_modtracker_tabs
vtiger_module_dashboard_widgets
vtiger_notebook_contents
vtiger_notes
vtiger_notescf
vtiger_notificationscheduler
vtiger_notificationscheduler_seq
vtiger_no_of_currency_decimals
vtiger_no_of_currency_decimals_seq
vtiger_opportunitystage
vtiger_opportunity_type
vtiger_opportunity_type_seq
vtiger_organizationdetails
vtiger_organizationdetails_seq
vtiger_org_share_action2tab
vtiger_org_share_action_mapping
vtiger_othereventduration
vtiger_othereventduration_seq
vtiger_parenttab
vtiger_parenttabrel
vtiger_payment_duration
vtiger_payment_duration_seq
vtiger_pbxmanager
vtiger_pbxmanagercf
vtiger_pbxmanager_gateway
vtiger_pbxmanager_phonelookup
vtiger_picklist
vtiger_picklistvalues_seq
vtiger_picklist_dependency
vtiger_picklist_seq
vtiger_picklist_transitions
vtiger_pobillads
vtiger_portal
vtiger_portalinfo
vtiger_poshipads
vtiger_postatus
vtiger_postatushistory
vtiger_postatus_seq
vtiger_potential
vtiger_potentialscf
vtiger_potstagehistory
vtiger_pricebook
vtiger_pricebookcf
vtiger_pricebookproductrel
vtiger_priority
vtiger_productcategory
vtiger_productcategory_seq
vtiger_productcf
vtiger_productcurrencyrel
vtiger_products
vtiger_producttaxrel
vtiger_profile
vtiger_profile2field
vtiger_profile2globalpermissions
vtiger_profile2standardpermissions
vtiger_profile2tab
vtiger_profile2utility
vtiger_profile_seq
vtiger_progress
vtiger_progress_seq
vtiger_project
vtiger_projectcf
vtiger_projectmilestone
vtiger_projectmilestonecf
vtiger_projectmilestonetype
vtiger_projectmilestonetype_seq
vtiger_projectpriority
vtiger_projectpriority_seq
vtiger_projectstatus
vtiger_projectstatus_seq
vtiger_projecttask
vtiger_projecttaskcf
vtiger_projecttaskpriority
vtiger_projecttaskpriority_seq
vtiger_projecttaskprogress
vtiger_projecttaskprogress_seq
vtiger_projecttaskstatus
vtiger_projecttaskstatus_seq
vtiger_projecttasktype
vtiger_projecttasktype_seq
vtiger_projecttask_status_color
vtiger_projecttype
vtiger_projecttype_seq
vtiger_purchaseorder
vtiger_purchaseordercf
vtiger_query
vtiger_querycf
vtiger_quotes
vtiger_quotesbillads
vtiger_quotescf
vtiger_quotesshipads
vtiger_quotestage
vtiger_quotestagehistory
vtiger_quotestage_seq
vtiger_rating
vtiger_rating_seq
vtiger_recurringevents
vtiger_recurringtype
vtiger_recurringtype_seq
vtiger_recurring_frequency
vtiger_recurring_frequency_seq
vtiger_relatedlists
vtiger_relatedlists_rb
vtiger_relatedlists_seq
vtiger_relcriteria
vtiger_relcriteria_grouping
vtiger_reminder_interval
vtiger_reminder_interval_seq
vtiger_report
vtiger_reportdatefilter
vtiger_reportfilters
vtiger_reportfolder
vtiger_reportgroupbycolumn
vtiger_reportmodules
vtiger_reportsharing
vtiger_reportsortcol
vtiger_reportsummary
vtiger_reporttype
vtiger_report_sharegroups
vtiger_report_sharerole
vtiger_report_sharers
vtiger_report_shareusers
vtiger_role
vtiger_role2picklist
vtiger_role2profile
vtiger_role_seq
vtiger_rollupcomments_settings
vtiger_rowheight
vtiger_rowheight_seq
vtiger_rss
vtiger_salesmanactivityrel
vtiger_salesmanattachmentsrel
vtiger_salesmanticketrel
vtiger_salesorder
vtiger_salesordercf
vtiger_sales_stage
vtiger_sales_stage_seq
vtiger_salutationtype
vtiger_salutationtype_seq
vtiger_scheduled_reports
vtiger_schedulereports
vtiger_seactivityrel
vtiger_seactivityrel_seq
vtiger_seattachmentsrel
vtiger_selectcolumn
vtiger_selectquery
vtiger_selectquery_seq
vtiger_senotesrel
vtiger_seproductsrel
vtiger_service
vtiger_servicecategory
vtiger_servicecategory_seq
vtiger_servicecf
vtiger_servicecontracts
vtiger_servicecontractscf
vtiger_service_usageunit
vtiger_service_usageunit_seq
vtiger_seticketsrel
vtiger_settings_blocks
vtiger_settings_blocks_seq
vtiger_settings_field
vtiger_settings_field_seq
vtiger_sharedcalendar
vtiger_shareduserinfo
vtiger_shippingtaxinfo
vtiger_shippingtaxinfo_seq
vtiger_shorturls
vtiger_smslog
vtiger_smslogcf
vtiger_smsnotifier
vtiger_smsnotifiercf
vtiger_smsnotifier_servers
vtiger_smsnotifier_status
vtiger_soapservice
vtiger_sobillads
vtiger_soshipads
vtiger_sostatus
vtiger_sostatushistory
vtiger_sostatus_seq
vtiger_sqltimelog
vtiger_start_hour
vtiger_start_hour_seq
vtiger_state_master
vtiger_status
vtiger_status_seq
vtiger_systems
vtiger_tab
vtiger_tab_info
vtiger_taskpriority
vtiger_taskpriority_seq
vtiger_taskstatus
vtiger_taskstatus_seq
vtiger_taxclass
vtiger_taxclass_seq
vtiger_taxregions
vtiger_ticketcategories
vtiger_ticketcategories_seq
vtiger_ticketcf
vtiger_ticketcomments
vtiger_ticketpriorities
vtiger_ticketpriorities_seq
vtiger_ticketseverities
vtiger_ticketseverities_seq
vtiger_ticketstatus
vtiger_ticketstatus_seq
vtiger_ticket_title
vtiger_ticket_title_seq
vtiger_time_zone
vtiger_time_zone_seq
vtiger_tmp_read_group_rel_sharing_per
vtiger_tmp_read_group_sharing_per
vtiger_tmp_read_user_rel_sharing_per
vtiger_tmp_read_user_sharing_per
vtiger_tmp_write_group_rel_sharing_per
vtiger_tmp_write_group_sharing_per
vtiger_tmp_write_user_rel_sharing_per
vtiger_tmp_write_user_sharing_per
vtiger_tracker
vtiger_tracking_unit
vtiger_tracking_unit_seq
vtiger_troubletickets
vtiger_usageunit
vtiger_usageunit_seq
vtiger_user2mergefields
vtiger_user2role
vtiger_users
vtiger_users2group
vtiger_users_last_import
vtiger_users_seq
vtiger_user_audit_log
vtiger_user_module_preferences
vtiger_vendor
vtiger_vendorcf
vtiger_vendorcontactrel
vtiger_version
vtiger_version_seq
vtiger_visibility
vtiger_visibility_seq
vtiger_webforms
vtiger_webforms_field
vtiger_webform_file_fields
vtiger_wordtemplates
vtiger_wsapp
vtiger_wsapp_handlerdetails
vtiger_wsapp_logs_basic
vtiger_wsapp_logs_details
vtiger_wsapp_queuerecords
vtiger_wsapp_recordmapping
vtiger_wsapp_sync_state
vtiger_ws_entity
vtiger_ws_entity_fieldtype
vtiger_ws_entity_fieldtype_seq
vtiger_ws_entity_name
vtiger_ws_entity_referencetype
vtiger_ws_entity_seq
vtiger_ws_entity_tables
vtiger_ws_fieldinfo
vtiger_ws_fieldtype
vtiger_ws_operation
vtiger_ws_operation_parameters
vtiger_ws_operation_seq
vtiger_ws_referencetype
vtiger_ws_userauthtoken
vtiger_zone
vtiger_zonecf
.
select column
Show
criteria
Sort
Ascending
Descending
Add as
AND
OR
Op
=
>
>=
<
<=
!=
LIKE
LIKE %...%
NOT LIKE
NOT LIKE %...%
IN (...)
NOT IN (...)
BETWEEN
NOT BETWEEN
IS NULL
IS NOT NULL
REGEXP
REGEXP ^...$
NOT REGEXP
Text
Another column
select table
aparam
a_sbapi_logs
com_vtiger_workflows
com_vtiger_workflows_seq
com_vtiger_workflowtasks
com_vtiger_workflowtasks_entitymethod
com_vtiger_workflowtasks_entitymethod_seq
com_vtiger_workflowtasks_seq
com_vtiger_workflowtask_queue
com_vtiger_workflowtemplates
com_vtiger_workflow_activatedonce
com_vtiger_workflow_tasktypes
com_vtiger_workflow_tasktypes_seq
new_customer_suraj_bharadwaj_table
vtiger_account
vtiger_accountbillads
vtiger_accountrating
vtiger_accountscf
vtiger_accountshipads
vtiger_accounttype
vtiger_accounttype_seq
vtiger_actionmapping
vtiger_activity
vtiger_activitycf
vtiger_activityproductrel
vtiger_activitytype
vtiger_activitytype_seq
vtiger_activity_recurring_info
vtiger_activity_reminder
vtiger_activity_reminder_popup
vtiger_activity_view
vtiger_activity_view_seq
vtiger_announcement
vtiger_apilogs
vtiger_apilogscf
vtiger_app2tab
vtiger_assets
vtiger_assetscf
vtiger_assetstatus
vtiger_assetstatus_seq
vtiger_asterisk
vtiger_asteriskextensions
vtiger_asteriskincomingcalls
vtiger_asteriskincomingevents
vtiger_attachments
vtiger_attachmentsfolder
vtiger_attachmentsfolder_seq
vtiger_audit_trial
vtiger_blocks
vtiger_blocks_seq
vtiger_branch
vtiger_branchcf
vtiger_calendarsharedtype
vtiger_calendarsharedtype_seq
vtiger_calendar_default_activitytypes
vtiger_calendar_default_activitytypes_seq
vtiger_calendar_user_activitytypes
vtiger_calendar_user_activitytypes_seq
vtiger_calldetail
vtiger_calldetailcf
vtiger_callduration
vtiger_callduration_seq
vtiger_campaign
vtiger_campaignaccountrel
vtiger_campaigncontrel
vtiger_campaignleadrel
vtiger_campaignrelstatus
vtiger_campaignrelstatus_seq
vtiger_campaignscf
vtiger_campaignstatus
vtiger_campaignstatus_seq
vtiger_campaigntype
vtiger_campaigntype_seq
vtiger_carrier
vtiger_carrier_seq
vtiger_cf_900
vtiger_cf_900_seq
vtiger_cf_904
vtiger_cf_904_seq
vtiger_cf_912
vtiger_cf_912_seq
vtiger_cf_916
vtiger_cf_916_seq
vtiger_cf_918
vtiger_cf_918_seq
vtiger_cf_920
vtiger_cf_920_seq
vtiger_cf_922
vtiger_cf_922_seq
vtiger_cf_924
vtiger_cf_924_seq
vtiger_cf_926
vtiger_cf_926_seq
vtiger_cf_936
vtiger_cf_936_seq
vtiger_cf_946
vtiger_cf_946_seq
vtiger_cf_978
vtiger_cf_978_seq
vtiger_cf_1018
vtiger_cf_1018_seq
vtiger_cf_1030
vtiger_cf_1030_seq
vtiger_cf_1034
vtiger_cf_1034_seq
vtiger_cf_1038
vtiger_cf_1038_seq
vtiger_cf_1054
vtiger_cf_1054_seq
vtiger_cf_1056
vtiger_cf_1056_seq
vtiger_cf_1058
vtiger_cf_1058_seq
vtiger_cf_1060
vtiger_cf_1060_seq
vtiger_cf_1062
vtiger_cf_1062_seq
vtiger_cf_1070
vtiger_cf_1070_seq
vtiger_cf_1072
vtiger_cf_1072_seq
vtiger_cf_1074
vtiger_cf_1074_seq
vtiger_cf_1096
vtiger_cf_1096_seq
vtiger_cf_1120
vtiger_cf_1120_seq
vtiger_cf_1146
vtiger_cf_1146_seq
vtiger_cf_1148
vtiger_cf_1148_seq
vtiger_cf_1150
vtiger_cf_1150_seq
vtiger_cf_1152
vtiger_cf_1152_seq
vtiger_cf_1164
vtiger_cf_1164_seq
vtiger_cntactivityrel
vtiger_contactaddress
vtiger_contactdetails
vtiger_contactscf
vtiger_contactsubdetails
vtiger_contpotentialrel
vtiger_contract_priority
vtiger_contract_priority_seq
vtiger_contract_status
vtiger_contract_status_seq
vtiger_contract_type
vtiger_contract_type_seq
vtiger_convertleadmapping
vtiger_convertpotentialmapping
vtiger_crmentity
vtiger_crmentityrel
vtiger_crmentity_seq
vtiger_crmentity_user_field
vtiger_crmsetup
vtiger_cron_task
vtiger_currencies
vtiger_currencies_seq
vtiger_currency
vtiger_currency_decimal_separator
vtiger_currency_decimal_separator_seq
vtiger_currency_grouping_pattern
vtiger_currency_grouping_pattern_seq
vtiger_currency_grouping_separator
vtiger_currency_grouping_separator_seq
vtiger_currency_info
vtiger_currency_info_seq
vtiger_currency_symbol_placement
vtiger_currency_symbol_placement_seq
vtiger_customaction
vtiger_customerdetails
vtiger_customerportal_fields
vtiger_customerportal_prefs
vtiger_customerportal_relatedmoduleinfo
vtiger_customerportal_settings
vtiger_customerportal_tabs
vtiger_custommodule
vtiger_custommodulecf
vtiger_customview
vtiger_customview_seq
vtiger_cv2group
vtiger_cv2role
vtiger_cv2rs
vtiger_cv2users
vtiger_cvadvfilter
vtiger_cvadvfilter_grouping
vtiger_cvcolumnlist
vtiger_cvstdfilter
vtiger_dashboard_tabs
vtiger_datashare_grp2grp
vtiger_datashare_grp2role
vtiger_datashare_grp2rs
vtiger_datashare_module_rel
vtiger_datashare_relatedmodules
vtiger_datashare_relatedmodules_seq
vtiger_datashare_relatedmodule_permission
vtiger_datashare_role2group
vtiger_datashare_role2role
vtiger_datashare_role2rs
vtiger_datashare_rs2grp
vtiger_datashare_rs2role
vtiger_datashare_rs2rs
vtiger_date_format
vtiger_date_format_seq
vtiger_dayoftheweek
vtiger_dayoftheweek_seq
vtiger_defaultactivitytype
vtiger_defaultactivitytype_seq
vtiger_defaultcalendarview
vtiger_defaultcalendarview_seq
vtiger_defaultcv
vtiger_defaulteventstatus
vtiger_defaulteventstatus_seq
vtiger_defaultlandingpage
vtiger_defaultlandingpage_seq
vtiger_default_record_view
vtiger_default_record_view_seq
vtiger_def_org_field
vtiger_def_org_share
vtiger_def_org_share_seq
vtiger_districtmaster
vtiger_durationhrs
vtiger_durationmins
vtiger_duration_minutes
vtiger_duration_minutes_seq
vtiger_emaildetails
vtiger_emailslookup
vtiger_emails_recipientprefs
vtiger_emailtemplates
vtiger_emailtemplates_seq
vtiger_email_access
vtiger_email_track
vtiger_entityname
vtiger_eventhandlers
vtiger_eventhandlers_seq
vtiger_eventhandler_module
vtiger_eventhandler_module_seq
vtiger_eventstatus
vtiger_eventstatus_seq
vtiger_expectedresponse
vtiger_expectedresponse_seq
vtiger_extnstore_users
vtiger_faq
vtiger_faqcategories
vtiger_faqcategories_seq
vtiger_faqcf
vtiger_faqcomments
vtiger_faqstatus
vtiger_faqstatus_seq
vtiger_feedback
vtiger_field
vtiger_fieldmodulerel
vtiger_field_seq
vtiger_freetagged_objects
vtiger_freetags
vtiger_freetags_seq
vtiger_glacct
vtiger_glacct_seq
vtiger_google_event_calendar_mapping
vtiger_google_oauth2
vtiger_google_sync_fieldmapping
vtiger_google_sync_settings
vtiger_group2grouprel
vtiger_group2role
vtiger_group2rs
vtiger_groups
vtiger_homedashbd
vtiger_homedefault
vtiger_homemodule
vtiger_homemoduleflds
vtiger_homereportchart
vtiger_homerss
vtiger_homestuff
vtiger_homestuff_seq
vtiger_home_layout
vtiger_hour_format
vtiger_hour_format_seq
vtiger_import_1
vtiger_import_locks
vtiger_import_locks_seq
vtiger_import_maps
vtiger_import_queue
vtiger_import_queue_seq
vtiger_industry
vtiger_industry_seq
vtiger_inventorycharges
vtiger_inventorychargesrel
vtiger_inventorynotification
vtiger_inventorynotification_seq
vtiger_inventoryproductrel
vtiger_inventoryproductrel_seq
vtiger_inventoryshippingrel
vtiger_inventorysubproductrel
vtiger_inventorytaxinfo
vtiger_inventorytaxinfo_seq
vtiger_inventory_tandc
vtiger_inventory_tandc_seq
vtiger_invitees
vtiger_invoice
vtiger_invoicebillads
vtiger_invoicecf
vtiger_invoiceshipads
vtiger_invoicestatus
vtiger_invoicestatushistory
vtiger_invoicestatus_seq
vtiger_invoice_recurring_info
vtiger_language
vtiger_language_seq
vtiger_leadaddress
vtiger_leaddetails
vtiger_leadscf
vtiger_leadsource
vtiger_leadsource_seq
vtiger_leadstage
vtiger_leadstatus
vtiger_leadstatus_seq
vtiger_leadsubdetails
vtiger_lead_view
vtiger_lead_view_seq
vtiger_links
vtiger_links_seq
vtiger_loginhistory
vtiger_mailer_queue
vtiger_mailer_queueattachments
vtiger_mailer_queueinfo
vtiger_mailmanager_mailattachments
vtiger_mailmanager_mailrecord
vtiger_mailmanager_mailrel
vtiger_mailscanner
vtiger_mailscanner_actions
vtiger_mailscanner_folders
vtiger_mailscanner_ids
vtiger_mailscanner_ruleactions
vtiger_mailscanner_rules
vtiger_mail_accounts
vtiger_manufacturer
vtiger_manufacturer_seq
vtiger_mobile_alerts
vtiger_modcomments
vtiger_modcommentscf
vtiger_modentity_num
vtiger_modentity_num_seq
vtiger_modtracker_basic
vtiger_modtracker_basic_seq
vtiger_modtracker_detail
vtiger_modtracker_relations
vtiger_modtracker_tabs
vtiger_module_dashboard_widgets
vtiger_notebook_contents
vtiger_notes
vtiger_notescf
vtiger_notificationscheduler
vtiger_notificationscheduler_seq
vtiger_no_of_currency_decimals
vtiger_no_of_currency_decimals_seq
vtiger_opportunitystage
vtiger_opportunity_type
vtiger_opportunity_type_seq
vtiger_organizationdetails
vtiger_organizationdetails_seq
vtiger_org_share_action2tab
vtiger_org_share_action_mapping
vtiger_othereventduration
vtiger_othereventduration_seq
vtiger_parenttab
vtiger_parenttabrel
vtiger_payment_duration
vtiger_payment_duration_seq
vtiger_pbxmanager
vtiger_pbxmanagercf
vtiger_pbxmanager_gateway
vtiger_pbxmanager_phonelookup
vtiger_picklist
vtiger_picklistvalues_seq
vtiger_picklist_dependency
vtiger_picklist_seq
vtiger_picklist_transitions
vtiger_pobillads
vtiger_portal
vtiger_portalinfo
vtiger_poshipads
vtiger_postatus
vtiger_postatushistory
vtiger_postatus_seq
vtiger_potential
vtiger_potentialscf
vtiger_potstagehistory
vtiger_pricebook
vtiger_pricebookcf
vtiger_pricebookproductrel
vtiger_priority
vtiger_productcategory
vtiger_productcategory_seq
vtiger_productcf
vtiger_productcurrencyrel
vtiger_products
vtiger_producttaxrel
vtiger_profile
vtiger_profile2field
vtiger_profile2globalpermissions
vtiger_profile2standardpermissions
vtiger_profile2tab
vtiger_profile2utility
vtiger_profile_seq
vtiger_progress
vtiger_progress_seq
vtiger_project
vtiger_projectcf
vtiger_projectmilestone
vtiger_projectmilestonecf
vtiger_projectmilestonetype
vtiger_projectmilestonetype_seq
vtiger_projectpriority
vtiger_projectpriority_seq
vtiger_projectstatus
vtiger_projectstatus_seq
vtiger_projecttask
vtiger_projecttaskcf
vtiger_projecttaskpriority
vtiger_projecttaskpriority_seq
vtiger_projecttaskprogress
vtiger_projecttaskprogress_seq
vtiger_projecttaskstatus
vtiger_projecttaskstatus_seq
vtiger_projecttasktype
vtiger_projecttasktype_seq
vtiger_projecttask_status_color
vtiger_projecttype
vtiger_projecttype_seq
vtiger_purchaseorder
vtiger_purchaseordercf
vtiger_query
vtiger_querycf
vtiger_quotes
vtiger_quotesbillads
vtiger_quotescf
vtiger_quotesshipads
vtiger_quotestage
vtiger_quotestagehistory
vtiger_quotestage_seq
vtiger_rating
vtiger_rating_seq
vtiger_recurringevents
vtiger_recurringtype
vtiger_recurringtype_seq
vtiger_recurring_frequency
vtiger_recurring_frequency_seq
vtiger_relatedlists
vtiger_relatedlists_rb
vtiger_relatedlists_seq
vtiger_relcriteria
vtiger_relcriteria_grouping
vtiger_reminder_interval
vtiger_reminder_interval_seq
vtiger_report
vtiger_reportdatefilter
vtiger_reportfilters
vtiger_reportfolder
vtiger_reportgroupbycolumn
vtiger_reportmodules
vtiger_reportsharing
vtiger_reportsortcol
vtiger_reportsummary
vtiger_reporttype
vtiger_report_sharegroups
vtiger_report_sharerole
vtiger_report_sharers
vtiger_report_shareusers
vtiger_role
vtiger_role2picklist
vtiger_role2profile
vtiger_role_seq
vtiger_rollupcomments_settings
vtiger_rowheight
vtiger_rowheight_seq
vtiger_rss
vtiger_salesmanactivityrel
vtiger_salesmanattachmentsrel
vtiger_salesmanticketrel
vtiger_salesorder
vtiger_salesordercf
vtiger_sales_stage
vtiger_sales_stage_seq
vtiger_salutationtype
vtiger_salutationtype_seq
vtiger_scheduled_reports
vtiger_schedulereports
vtiger_seactivityrel
vtiger_seactivityrel_seq
vtiger_seattachmentsrel
vtiger_selectcolumn
vtiger_selectquery
vtiger_selectquery_seq
vtiger_senotesrel
vtiger_seproductsrel
vtiger_service
vtiger_servicecategory
vtiger_servicecategory_seq
vtiger_servicecf
vtiger_servicecontracts
vtiger_servicecontractscf
vtiger_service_usageunit
vtiger_service_usageunit_seq
vtiger_seticketsrel
vtiger_settings_blocks
vtiger_settings_blocks_seq
vtiger_settings_field
vtiger_settings_field_seq
vtiger_sharedcalendar
vtiger_shareduserinfo
vtiger_shippingtaxinfo
vtiger_shippingtaxinfo_seq
vtiger_shorturls
vtiger_smslog
vtiger_smslogcf
vtiger_smsnotifier
vtiger_smsnotifiercf
vtiger_smsnotifier_servers
vtiger_smsnotifier_status
vtiger_soapservice
vtiger_sobillads
vtiger_soshipads
vtiger_sostatus
vtiger_sostatushistory
vtiger_sostatus_seq
vtiger_sqltimelog
vtiger_start_hour
vtiger_start_hour_seq
vtiger_state_master
vtiger_status
vtiger_status_seq
vtiger_systems
vtiger_tab
vtiger_tab_info
vtiger_taskpriority
vtiger_taskpriority_seq
vtiger_taskstatus
vtiger_taskstatus_seq
vtiger_taxclass
vtiger_taxclass_seq
vtiger_taxregions
vtiger_ticketcategories
vtiger_ticketcategories_seq
vtiger_ticketcf
vtiger_ticketcomments
vtiger_ticketpriorities
vtiger_ticketpriorities_seq
vtiger_ticketseverities
vtiger_ticketseverities_seq
vtiger_ticketstatus
vtiger_ticketstatus_seq
vtiger_ticket_title
vtiger_ticket_title_seq
vtiger_time_zone
vtiger_time_zone_seq
vtiger_tmp_read_group_rel_sharing_per
vtiger_tmp_read_group_sharing_per
vtiger_tmp_read_user_rel_sharing_per
vtiger_tmp_read_user_sharing_per
vtiger_tmp_write_group_rel_sharing_per
vtiger_tmp_write_group_sharing_per
vtiger_tmp_write_user_rel_sharing_per
vtiger_tmp_write_user_sharing_per
vtiger_tracker
vtiger_tracking_unit
vtiger_tracking_unit_seq
vtiger_troubletickets
vtiger_usageunit
vtiger_usageunit_seq
vtiger_user2mergefields
vtiger_user2role
vtiger_users
vtiger_users2group
vtiger_users_last_import
vtiger_users_seq
vtiger_user_audit_log
vtiger_user_module_preferences
vtiger_vendor
vtiger_vendorcf
vtiger_vendorcontactrel
vtiger_version
vtiger_version_seq
vtiger_visibility
vtiger_visibility_seq
vtiger_webforms
vtiger_webforms_field
vtiger_webform_file_fields
vtiger_wordtemplates
vtiger_wsapp
vtiger_wsapp_handlerdetails
vtiger_wsapp_logs_basic
vtiger_wsapp_logs_details
vtiger_wsapp_queuerecords
vtiger_wsapp_recordmapping
vtiger_wsapp_sync_state
vtiger_ws_entity
vtiger_ws_entity_fieldtype
vtiger_ws_entity_fieldtype_seq
vtiger_ws_entity_name
vtiger_ws_entity_referencetype
vtiger_ws_entity_seq
vtiger_ws_entity_tables
vtiger_ws_fieldinfo
vtiger_ws_fieldtype
vtiger_ws_operation
vtiger_ws_operation_parameters
vtiger_ws_operation_seq
vtiger_ws_referencetype
vtiger_ws_userauthtoken
vtiger_zone
vtiger_zonecf
.
select column
select table
aparam
a_sbapi_logs
com_vtiger_workflows
com_vtiger_workflows_seq
com_vtiger_workflowtasks
com_vtiger_workflowtasks_entitymethod
com_vtiger_workflowtasks_entitymethod_seq
com_vtiger_workflowtasks_seq
com_vtiger_workflowtask_queue
com_vtiger_workflowtemplates
com_vtiger_workflow_activatedonce
com_vtiger_workflow_tasktypes
com_vtiger_workflow_tasktypes_seq
new_customer_suraj_bharadwaj_table
vtiger_account
vtiger_accountbillads
vtiger_accountrating
vtiger_accountscf
vtiger_accountshipads
vtiger_accounttype
vtiger_accounttype_seq
vtiger_actionmapping
vtiger_activity
vtiger_activitycf
vtiger_activityproductrel
vtiger_activitytype
vtiger_activitytype_seq
vtiger_activity_recurring_info
vtiger_activity_reminder
vtiger_activity_reminder_popup
vtiger_activity_view
vtiger_activity_view_seq
vtiger_announcement
vtiger_apilogs
vtiger_apilogscf
vtiger_app2tab
vtiger_assets
vtiger_assetscf
vtiger_assetstatus
vtiger_assetstatus_seq
vtiger_asterisk
vtiger_asteriskextensions
vtiger_asteriskincomingcalls
vtiger_asteriskincomingevents
vtiger_attachments
vtiger_attachmentsfolder
vtiger_attachmentsfolder_seq
vtiger_audit_trial
vtiger_blocks
vtiger_blocks_seq
vtiger_branch
vtiger_branchcf
vtiger_calendarsharedtype
vtiger_calendarsharedtype_seq
vtiger_calendar_default_activitytypes
vtiger_calendar_default_activitytypes_seq
vtiger_calendar_user_activitytypes
vtiger_calendar_user_activitytypes_seq
vtiger_calldetail
vtiger_calldetailcf
vtiger_callduration
vtiger_callduration_seq
vtiger_campaign
vtiger_campaignaccountrel
vtiger_campaigncontrel
vtiger_campaignleadrel
vtiger_campaignrelstatus
vtiger_campaignrelstatus_seq
vtiger_campaignscf
vtiger_campaignstatus
vtiger_campaignstatus_seq
vtiger_campaigntype
vtiger_campaigntype_seq
vtiger_carrier
vtiger_carrier_seq
vtiger_cf_900
vtiger_cf_900_seq
vtiger_cf_904
vtiger_cf_904_seq
vtiger_cf_912
vtiger_cf_912_seq
vtiger_cf_916
vtiger_cf_916_seq
vtiger_cf_918
vtiger_cf_918_seq
vtiger_cf_920
vtiger_cf_920_seq
vtiger_cf_922
vtiger_cf_922_seq
vtiger_cf_924
vtiger_cf_924_seq
vtiger_cf_926
vtiger_cf_926_seq
vtiger_cf_936
vtiger_cf_936_seq
vtiger_cf_946
vtiger_cf_946_seq
vtiger_cf_978
vtiger_cf_978_seq
vtiger_cf_1018
vtiger_cf_1018_seq
vtiger_cf_1030
vtiger_cf_1030_seq
vtiger_cf_1034
vtiger_cf_1034_seq
vtiger_cf_1038
vtiger_cf_1038_seq
vtiger_cf_1054
vtiger_cf_1054_seq
vtiger_cf_1056
vtiger_cf_1056_seq
vtiger_cf_1058
vtiger_cf_1058_seq
vtiger_cf_1060
vtiger_cf_1060_seq
vtiger_cf_1062
vtiger_cf_1062_seq
vtiger_cf_1070
vtiger_cf_1070_seq
vtiger_cf_1072
vtiger_cf_1072_seq
vtiger_cf_1074
vtiger_cf_1074_seq
vtiger_cf_1096
vtiger_cf_1096_seq
vtiger_cf_1120
vtiger_cf_1120_seq
vtiger_cf_1146
vtiger_cf_1146_seq
vtiger_cf_1148
vtiger_cf_1148_seq
vtiger_cf_1150
vtiger_cf_1150_seq
vtiger_cf_1152
vtiger_cf_1152_seq
vtiger_cf_1164
vtiger_cf_1164_seq
vtiger_cntactivityrel
vtiger_contactaddress
vtiger_contactdetails
vtiger_contactscf
vtiger_contactsubdetails
vtiger_contpotentialrel
vtiger_contract_priority
vtiger_contract_priority_seq
vtiger_contract_status
vtiger_contract_status_seq
vtiger_contract_type
vtiger_contract_type_seq
vtiger_convertleadmapping
vtiger_convertpotentialmapping
vtiger_crmentity
vtiger_crmentityrel
vtiger_crmentity_seq
vtiger_crmentity_user_field
vtiger_crmsetup
vtiger_cron_task
vtiger_currencies
vtiger_currencies_seq
vtiger_currency
vtiger_currency_decimal_separator
vtiger_currency_decimal_separator_seq
vtiger_currency_grouping_pattern
vtiger_currency_grouping_pattern_seq
vtiger_currency_grouping_separator
vtiger_currency_grouping_separator_seq
vtiger_currency_info
vtiger_currency_info_seq
vtiger_currency_symbol_placement
vtiger_currency_symbol_placement_seq
vtiger_customaction
vtiger_customerdetails
vtiger_customerportal_fields
vtiger_customerportal_prefs
vtiger_customerportal_relatedmoduleinfo
vtiger_customerportal_settings
vtiger_customerportal_tabs
vtiger_custommodule
vtiger_custommodulecf
vtiger_customview
vtiger_customview_seq
vtiger_cv2group
vtiger_cv2role
vtiger_cv2rs
vtiger_cv2users
vtiger_cvadvfilter
vtiger_cvadvfilter_grouping
vtiger_cvcolumnlist
vtiger_cvstdfilter
vtiger_dashboard_tabs
vtiger_datashare_grp2grp
vtiger_datashare_grp2role
vtiger_datashare_grp2rs
vtiger_datashare_module_rel
vtiger_datashare_relatedmodules
vtiger_datashare_relatedmodules_seq
vtiger_datashare_relatedmodule_permission
vtiger_datashare_role2group
vtiger_datashare_role2role
vtiger_datashare_role2rs
vtiger_datashare_rs2grp
vtiger_datashare_rs2role
vtiger_datashare_rs2rs
vtiger_date_format
vtiger_date_format_seq
vtiger_dayoftheweek
vtiger_dayoftheweek_seq
vtiger_defaultactivitytype
vtiger_defaultactivitytype_seq
vtiger_defaultcalendarview
vtiger_defaultcalendarview_seq
vtiger_defaultcv
vtiger_defaulteventstatus
vtiger_defaulteventstatus_seq
vtiger_defaultlandingpage
vtiger_defaultlandingpage_seq
vtiger_default_record_view
vtiger_default_record_view_seq
vtiger_def_org_field
vtiger_def_org_share
vtiger_def_org_share_seq
vtiger_districtmaster
vtiger_durationhrs
vtiger_durationmins
vtiger_duration_minutes
vtiger_duration_minutes_seq
vtiger_emaildetails
vtiger_emailslookup
vtiger_emails_recipientprefs
vtiger_emailtemplates
vtiger_emailtemplates_seq
vtiger_email_access
vtiger_email_track
vtiger_entityname
vtiger_eventhandlers
vtiger_eventhandlers_seq
vtiger_eventhandler_module
vtiger_eventhandler_module_seq
vtiger_eventstatus
vtiger_eventstatus_seq
vtiger_expectedresponse
vtiger_expectedresponse_seq
vtiger_extnstore_users
vtiger_faq
vtiger_faqcategories
vtiger_faqcategories_seq
vtiger_faqcf
vtiger_faqcomments
vtiger_faqstatus
vtiger_faqstatus_seq
vtiger_feedback
vtiger_field
vtiger_fieldmodulerel
vtiger_field_seq
vtiger_freetagged_objects
vtiger_freetags
vtiger_freetags_seq
vtiger_glacct
vtiger_glacct_seq
vtiger_google_event_calendar_mapping
vtiger_google_oauth2
vtiger_google_sync_fieldmapping
vtiger_google_sync_settings
vtiger_group2grouprel
vtiger_group2role
vtiger_group2rs
vtiger_groups
vtiger_homedashbd
vtiger_homedefault
vtiger_homemodule
vtiger_homemoduleflds
vtiger_homereportchart
vtiger_homerss
vtiger_homestuff
vtiger_homestuff_seq
vtiger_home_layout
vtiger_hour_format
vtiger_hour_format_seq
vtiger_import_1
vtiger_import_locks
vtiger_import_locks_seq
vtiger_import_maps
vtiger_import_queue
vtiger_import_queue_seq
vtiger_industry
vtiger_industry_seq
vtiger_inventorycharges
vtiger_inventorychargesrel
vtiger_inventorynotification
vtiger_inventorynotification_seq
vtiger_inventoryproductrel
vtiger_inventoryproductrel_seq
vtiger_inventoryshippingrel
vtiger_inventorysubproductrel
vtiger_inventorytaxinfo
vtiger_inventorytaxinfo_seq
vtiger_inventory_tandc
vtiger_inventory_tandc_seq
vtiger_invitees
vtiger_invoice
vtiger_invoicebillads
vtiger_invoicecf
vtiger_invoiceshipads
vtiger_invoicestatus
vtiger_invoicestatushistory
vtiger_invoicestatus_seq
vtiger_invoice_recurring_info
vtiger_language
vtiger_language_seq
vtiger_leadaddress
vtiger_leaddetails
vtiger_leadscf
vtiger_leadsource
vtiger_leadsource_seq
vtiger_leadstage
vtiger_leadstatus
vtiger_leadstatus_seq
vtiger_leadsubdetails
vtiger_lead_view
vtiger_lead_view_seq
vtiger_links
vtiger_links_seq
vtiger_loginhistory
vtiger_mailer_queue
vtiger_mailer_queueattachments
vtiger_mailer_queueinfo
vtiger_mailmanager_mailattachments
vtiger_mailmanager_mailrecord
vtiger_mailmanager_mailrel
vtiger_mailscanner
vtiger_mailscanner_actions
vtiger_mailscanner_folders
vtiger_mailscanner_ids
vtiger_mailscanner_ruleactions
vtiger_mailscanner_rules
vtiger_mail_accounts
vtiger_manufacturer
vtiger_manufacturer_seq
vtiger_mobile_alerts
vtiger_modcomments
vtiger_modcommentscf
vtiger_modentity_num
vtiger_modentity_num_seq
vtiger_modtracker_basic
vtiger_modtracker_basic_seq
vtiger_modtracker_detail
vtiger_modtracker_relations
vtiger_modtracker_tabs
vtiger_module_dashboard_widgets
vtiger_notebook_contents
vtiger_notes
vtiger_notescf
vtiger_notificationscheduler
vtiger_notificationscheduler_seq
vtiger_no_of_currency_decimals
vtiger_no_of_currency_decimals_seq
vtiger_opportunitystage
vtiger_opportunity_type
vtiger_opportunity_type_seq
vtiger_organizationdetails
vtiger_organizationdetails_seq
vtiger_org_share_action2tab
vtiger_org_share_action_mapping
vtiger_othereventduration
vtiger_othereventduration_seq
vtiger_parenttab
vtiger_parenttabrel
vtiger_payment_duration
vtiger_payment_duration_seq
vtiger_pbxmanager
vtiger_pbxmanagercf
vtiger_pbxmanager_gateway
vtiger_pbxmanager_phonelookup
vtiger_picklist
vtiger_picklistvalues_seq
vtiger_picklist_dependency
vtiger_picklist_seq
vtiger_picklist_transitions
vtiger_pobillads
vtiger_portal
vtiger_portalinfo
vtiger_poshipads
vtiger_postatus
vtiger_postatushistory
vtiger_postatus_seq
vtiger_potential
vtiger_potentialscf
vtiger_potstagehistory
vtiger_pricebook
vtiger_pricebookcf
vtiger_pricebookproductrel
vtiger_priority
vtiger_productcategory
vtiger_productcategory_seq
vtiger_productcf
vtiger_productcurrencyrel
vtiger_products
vtiger_producttaxrel
vtiger_profile
vtiger_profile2field
vtiger_profile2globalpermissions
vtiger_profile2standardpermissions
vtiger_profile2tab
vtiger_profile2utility
vtiger_profile_seq
vtiger_progress
vtiger_progress_seq
vtiger_project
vtiger_projectcf
vtiger_projectmilestone
vtiger_projectmilestonecf
vtiger_projectmilestonetype
vtiger_projectmilestonetype_seq
vtiger_projectpriority
vtiger_projectpriority_seq
vtiger_projectstatus
vtiger_projectstatus_seq
vtiger_projecttask
vtiger_projecttaskcf
vtiger_projecttaskpriority
vtiger_projecttaskpriority_seq
vtiger_projecttaskprogress
vtiger_projecttaskprogress_seq
vtiger_projecttaskstatus
vtiger_projecttaskstatus_seq
vtiger_projecttasktype
vtiger_projecttasktype_seq
vtiger_projecttask_status_color
vtiger_projecttype
vtiger_projecttype_seq
vtiger_purchaseorder
vtiger_purchaseordercf
vtiger_query
vtiger_querycf
vtiger_quotes
vtiger_quotesbillads
vtiger_quotescf
vtiger_quotesshipads
vtiger_quotestage
vtiger_quotestagehistory
vtiger_quotestage_seq
vtiger_rating
vtiger_rating_seq
vtiger_recurringevents
vtiger_recurringtype
vtiger_recurringtype_seq
vtiger_recurring_frequency
vtiger_recurring_frequency_seq
vtiger_relatedlists
vtiger_relatedlists_rb
vtiger_relatedlists_seq
vtiger_relcriteria
vtiger_relcriteria_grouping
vtiger_reminder_interval
vtiger_reminder_interval_seq
vtiger_report
vtiger_reportdatefilter
vtiger_reportfilters
vtiger_reportfolder
vtiger_reportgroupbycolumn
vtiger_reportmodules
vtiger_reportsharing
vtiger_reportsortcol
vtiger_reportsummary
vtiger_reporttype
vtiger_report_sharegroups
vtiger_report_sharerole
vtiger_report_sharers
vtiger_report_shareusers
vtiger_role
vtiger_role2picklist
vtiger_role2profile
vtiger_role_seq
vtiger_rollupcomments_settings
vtiger_rowheight
vtiger_rowheight_seq
vtiger_rss
vtiger_salesmanactivityrel
vtiger_salesmanattachmentsrel
vtiger_salesmanticketrel
vtiger_salesorder
vtiger_salesordercf
vtiger_sales_stage
vtiger_sales_stage_seq
vtiger_salutationtype
vtiger_salutationtype_seq
vtiger_scheduled_reports
vtiger_schedulereports
vtiger_seactivityrel
vtiger_seactivityrel_seq
vtiger_seattachmentsrel
vtiger_selectcolumn
vtiger_selectquery
vtiger_selectquery_seq
vtiger_senotesrel
vtiger_seproductsrel
vtiger_service
vtiger_servicecategory
vtiger_servicecategory_seq
vtiger_servicecf
vtiger_servicecontracts
vtiger_servicecontractscf
vtiger_service_usageunit
vtiger_service_usageunit_seq
vtiger_seticketsrel
vtiger_settings_blocks
vtiger_settings_blocks_seq
vtiger_settings_field
vtiger_settings_field_seq
vtiger_sharedcalendar
vtiger_shareduserinfo
vtiger_shippingtaxinfo
vtiger_shippingtaxinfo_seq
vtiger_shorturls
vtiger_smslog
vtiger_smslogcf
vtiger_smsnotifier
vtiger_smsnotifiercf
vtiger_smsnotifier_servers
vtiger_smsnotifier_status
vtiger_soapservice
vtiger_sobillads
vtiger_soshipads
vtiger_sostatus
vtiger_sostatushistory
vtiger_sostatus_seq
vtiger_sqltimelog
vtiger_start_hour
vtiger_start_hour_seq
vtiger_state_master
vtiger_status
vtiger_status_seq
vtiger_systems
vtiger_tab
vtiger_tab_info
vtiger_taskpriority
vtiger_taskpriority_seq
vtiger_taskstatus
vtiger_taskstatus_seq
vtiger_taxclass
vtiger_taxclass_seq
vtiger_taxregions
vtiger_ticketcategories
vtiger_ticketcategories_seq
vtiger_ticketcf
vtiger_ticketcomments
vtiger_ticketpriorities
vtiger_ticketpriorities_seq
vtiger_ticketseverities
vtiger_ticketseverities_seq
vtiger_ticketstatus
vtiger_ticketstatus_seq
vtiger_ticket_title
vtiger_ticket_title_seq
vtiger_time_zone
vtiger_time_zone_seq
vtiger_tmp_read_group_rel_sharing_per
vtiger_tmp_read_group_sharing_per
vtiger_tmp_read_user_rel_sharing_per
vtiger_tmp_read_user_sharing_per
vtiger_tmp_write_group_rel_sharing_per
vtiger_tmp_write_group_sharing_per
vtiger_tmp_write_user_rel_sharing_per
vtiger_tmp_write_user_sharing_per
vtiger_tracker
vtiger_tracking_unit
vtiger_tracking_unit_seq
vtiger_troubletickets
vtiger_usageunit
vtiger_usageunit_seq
vtiger_user2mergefields
vtiger_user2role
vtiger_users
vtiger_users2group
vtiger_users_last_import
vtiger_users_seq
vtiger_user_audit_log
vtiger_user_module_preferences
vtiger_vendor
vtiger_vendorcf
vtiger_vendorcontactrel
vtiger_version
vtiger_version_seq
vtiger_visibility
vtiger_visibility_seq
vtiger_webforms
vtiger_webforms_field
vtiger_webform_file_fields
vtiger_wordtemplates
vtiger_wsapp
vtiger_wsapp_handlerdetails
vtiger_wsapp_logs_basic
vtiger_wsapp_logs_details
vtiger_wsapp_queuerecords
vtiger_wsapp_recordmapping
vtiger_wsapp_sync_state
vtiger_ws_entity
vtiger_ws_entity_fieldtype
vtiger_ws_entity_fieldtype_seq
vtiger_ws_entity_name
vtiger_ws_entity_referencetype
vtiger_ws_entity_seq
vtiger_ws_entity_tables
vtiger_ws_fieldinfo
vtiger_ws_fieldtype
vtiger_ws_operation
vtiger_ws_operation_parameters
vtiger_ws_operation_seq
vtiger_ws_referencetype
vtiger_ws_userauthtoken
vtiger_zone
vtiger_zonecf
.
select column
Show
criteria
Sort
Ascending
Descending
Add as
AND
OR
Op
=
>
>=
<
<=
!=
LIKE
LIKE %...%
NOT LIKE
NOT LIKE %...%
IN (...)
NOT IN (...)
BETWEEN
NOT BETWEEN
IS NULL
IS NOT NULL
REGEXP
REGEXP ^...$
NOT REGEXP
Text
Another column
select table
aparam
a_sbapi_logs
com_vtiger_workflows
com_vtiger_workflows_seq
com_vtiger_workflowtasks
com_vtiger_workflowtasks_entitymethod
com_vtiger_workflowtasks_entitymethod_seq
com_vtiger_workflowtasks_seq
com_vtiger_workflowtask_queue
com_vtiger_workflowtemplates
com_vtiger_workflow_activatedonce
com_vtiger_workflow_tasktypes
com_vtiger_workflow_tasktypes_seq
new_customer_suraj_bharadwaj_table
vtiger_account
vtiger_accountbillads
vtiger_accountrating
vtiger_accountscf
vtiger_accountshipads
vtiger_accounttype
vtiger_accounttype_seq
vtiger_actionmapping
vtiger_activity
vtiger_activitycf
vtiger_activityproductrel
vtiger_activitytype
vtiger_activitytype_seq
vtiger_activity_recurring_info
vtiger_activity_reminder
vtiger_activity_reminder_popup
vtiger_activity_view
vtiger_activity_view_seq
vtiger_announcement
vtiger_apilogs
vtiger_apilogscf
vtiger_app2tab
vtiger_assets
vtiger_assetscf
vtiger_assetstatus
vtiger_assetstatus_seq
vtiger_asterisk
vtiger_asteriskextensions
vtiger_asteriskincomingcalls
vtiger_asteriskincomingevents
vtiger_attachments
vtiger_attachmentsfolder
vtiger_attachmentsfolder_seq
vtiger_audit_trial
vtiger_blocks
vtiger_blocks_seq
vtiger_branch
vtiger_branchcf
vtiger_calendarsharedtype
vtiger_calendarsharedtype_seq
vtiger_calendar_default_activitytypes
vtiger_calendar_default_activitytypes_seq
vtiger_calendar_user_activitytypes
vtiger_calendar_user_activitytypes_seq
vtiger_calldetail
vtiger_calldetailcf
vtiger_callduration
vtiger_callduration_seq
vtiger_campaign
vtiger_campaignaccountrel
vtiger_campaigncontrel
vtiger_campaignleadrel
vtiger_campaignrelstatus
vtiger_campaignrelstatus_seq
vtiger_campaignscf
vtiger_campaignstatus
vtiger_campaignstatus_seq
vtiger_campaigntype
vtiger_campaigntype_seq
vtiger_carrier
vtiger_carrier_seq
vtiger_cf_900
vtiger_cf_900_seq
vtiger_cf_904
vtiger_cf_904_seq
vtiger_cf_912
vtiger_cf_912_seq
vtiger_cf_916
vtiger_cf_916_seq
vtiger_cf_918
vtiger_cf_918_seq
vtiger_cf_920
vtiger_cf_920_seq
vtiger_cf_922
vtiger_cf_922_seq
vtiger_cf_924
vtiger_cf_924_seq
vtiger_cf_926
vtiger_cf_926_seq
vtiger_cf_936
vtiger_cf_936_seq
vtiger_cf_946
vtiger_cf_946_seq
vtiger_cf_978
vtiger_cf_978_seq
vtiger_cf_1018
vtiger_cf_1018_seq
vtiger_cf_1030
vtiger_cf_1030_seq
vtiger_cf_1034
vtiger_cf_1034_seq
vtiger_cf_1038
vtiger_cf_1038_seq
vtiger_cf_1054
vtiger_cf_1054_seq
vtiger_cf_1056
vtiger_cf_1056_seq
vtiger_cf_1058
vtiger_cf_1058_seq
vtiger_cf_1060
vtiger_cf_1060_seq
vtiger_cf_1062
vtiger_cf_1062_seq
vtiger_cf_1070
vtiger_cf_1070_seq
vtiger_cf_1072
vtiger_cf_1072_seq
vtiger_cf_1074
vtiger_cf_1074_seq
vtiger_cf_1096
vtiger_cf_1096_seq
vtiger_cf_1120
vtiger_cf_1120_seq
vtiger_cf_1146
vtiger_cf_1146_seq
vtiger_cf_1148
vtiger_cf_1148_seq
vtiger_cf_1150
vtiger_cf_1150_seq
vtiger_cf_1152
vtiger_cf_1152_seq
vtiger_cf_1164
vtiger_cf_1164_seq
vtiger_cntactivityrel
vtiger_contactaddress
vtiger_contactdetails
vtiger_contactscf
vtiger_contactsubdetails
vtiger_contpotentialrel
vtiger_contract_priority
vtiger_contract_priority_seq
vtiger_contract_status
vtiger_contract_status_seq
vtiger_contract_type
vtiger_contract_type_seq
vtiger_convertleadmapping
vtiger_convertpotentialmapping
vtiger_crmentity
vtiger_crmentityrel
vtiger_crmentity_seq
vtiger_crmentity_user_field
vtiger_crmsetup
vtiger_cron_task
vtiger_currencies
vtiger_currencies_seq
vtiger_currency
vtiger_currency_decimal_separator
vtiger_currency_decimal_separator_seq
vtiger_currency_grouping_pattern
vtiger_currency_grouping_pattern_seq
vtiger_currency_grouping_separator
vtiger_currency_grouping_separator_seq
vtiger_currency_info
vtiger_currency_info_seq
vtiger_currency_symbol_placement
vtiger_currency_symbol_placement_seq
vtiger_customaction
vtiger_customerdetails
vtiger_customerportal_fields
vtiger_customerportal_prefs
vtiger_customerportal_relatedmoduleinfo
vtiger_customerportal_settings
vtiger_customerportal_tabs
vtiger_custommodule
vtiger_custommodulecf
vtiger_customview
vtiger_customview_seq
vtiger_cv2group
vtiger_cv2role
vtiger_cv2rs
vtiger_cv2users
vtiger_cvadvfilter
vtiger_cvadvfilter_grouping
vtiger_cvcolumnlist
vtiger_cvstdfilter
vtiger_dashboard_tabs
vtiger_datashare_grp2grp
vtiger_datashare_grp2role
vtiger_datashare_grp2rs
vtiger_datashare_module_rel
vtiger_datashare_relatedmodules
vtiger_datashare_relatedmodules_seq
vtiger_datashare_relatedmodule_permission
vtiger_datashare_role2group
vtiger_datashare_role2role
vtiger_datashare_role2rs
vtiger_datashare_rs2grp
vtiger_datashare_rs2role
vtiger_datashare_rs2rs
vtiger_date_format
vtiger_date_format_seq
vtiger_dayoftheweek
vtiger_dayoftheweek_seq
vtiger_defaultactivitytype
vtiger_defaultactivitytype_seq
vtiger_defaultcalendarview
vtiger_defaultcalendarview_seq
vtiger_defaultcv
vtiger_defaulteventstatus
vtiger_defaulteventstatus_seq
vtiger_defaultlandingpage
vtiger_defaultlandingpage_seq
vtiger_default_record_view
vtiger_default_record_view_seq
vtiger_def_org_field
vtiger_def_org_share
vtiger_def_org_share_seq
vtiger_districtmaster
vtiger_durationhrs
vtiger_durationmins
vtiger_duration_minutes
vtiger_duration_minutes_seq
vtiger_emaildetails
vtiger_emailslookup
vtiger_emails_recipientprefs
vtiger_emailtemplates
vtiger_emailtemplates_seq
vtiger_email_access
vtiger_email_track
vtiger_entityname
vtiger_eventhandlers
vtiger_eventhandlers_seq
vtiger_eventhandler_module
vtiger_eventhandler_module_seq
vtiger_eventstatus
vtiger_eventstatus_seq
vtiger_expectedresponse
vtiger_expectedresponse_seq
vtiger_extnstore_users
vtiger_faq
vtiger_faqcategories
vtiger_faqcategories_seq
vtiger_faqcf
vtiger_faqcomments
vtiger_faqstatus
vtiger_faqstatus_seq
vtiger_feedback
vtiger_field
vtiger_fieldmodulerel
vtiger_field_seq
vtiger_freetagged_objects
vtiger_freetags
vtiger_freetags_seq
vtiger_glacct
vtiger_glacct_seq
vtiger_google_event_calendar_mapping
vtiger_google_oauth2
vtiger_google_sync_fieldmapping
vtiger_google_sync_settings
vtiger_group2grouprel
vtiger_group2role
vtiger_group2rs
vtiger_groups
vtiger_homedashbd
vtiger_homedefault
vtiger_homemodule
vtiger_homemoduleflds
vtiger_homereportchart
vtiger_homerss
vtiger_homestuff
vtiger_homestuff_seq
vtiger_home_layout
vtiger_hour_format
vtiger_hour_format_seq
vtiger_import_1
vtiger_import_locks
vtiger_import_locks_seq
vtiger_import_maps
vtiger_import_queue
vtiger_import_queue_seq
vtiger_industry
vtiger_industry_seq
vtiger_inventorycharges
vtiger_inventorychargesrel
vtiger_inventorynotification
vtiger_inventorynotification_seq
vtiger_inventoryproductrel
vtiger_inventoryproductrel_seq
vtiger_inventoryshippingrel
vtiger_inventorysubproductrel
vtiger_inventorytaxinfo
vtiger_inventorytaxinfo_seq
vtiger_inventory_tandc
vtiger_inventory_tandc_seq
vtiger_invitees
vtiger_invoice
vtiger_invoicebillads
vtiger_invoicecf
vtiger_invoiceshipads
vtiger_invoicestatus
vtiger_invoicestatushistory
vtiger_invoicestatus_seq
vtiger_invoice_recurring_info
vtiger_language
vtiger_language_seq
vtiger_leadaddress
vtiger_leaddetails
vtiger_leadscf
vtiger_leadsource
vtiger_leadsource_seq
vtiger_leadstage
vtiger_leadstatus
vtiger_leadstatus_seq
vtiger_leadsubdetails
vtiger_lead_view
vtiger_lead_view_seq
vtiger_links
vtiger_links_seq
vtiger_loginhistory
vtiger_mailer_queue
vtiger_mailer_queueattachments
vtiger_mailer_queueinfo
vtiger_mailmanager_mailattachments
vtiger_mailmanager_mailrecord
vtiger_mailmanager_mailrel
vtiger_mailscanner
vtiger_mailscanner_actions
vtiger_mailscanner_folders
vtiger_mailscanner_ids
vtiger_mailscanner_ruleactions
vtiger_mailscanner_rules
vtiger_mail_accounts
vtiger_manufacturer
vtiger_manufacturer_seq
vtiger_mobile_alerts
vtiger_modcomments
vtiger_modcommentscf
vtiger_modentity_num
vtiger_modentity_num_seq
vtiger_modtracker_basic
vtiger_modtracker_basic_seq
vtiger_modtracker_detail
vtiger_modtracker_relations
vtiger_modtracker_tabs
vtiger_module_dashboard_widgets
vtiger_notebook_contents
vtiger_notes
vtiger_notescf
vtiger_notificationscheduler
vtiger_notificationscheduler_seq
vtiger_no_of_currency_decimals
vtiger_no_of_currency_decimals_seq
vtiger_opportunitystage
vtiger_opportunity_type
vtiger_opportunity_type_seq
vtiger_organizationdetails
vtiger_organizationdetails_seq
vtiger_org_share_action2tab
vtiger_org_share_action_mapping
vtiger_othereventduration
vtiger_othereventduration_seq
vtiger_parenttab
vtiger_parenttabrel
vtiger_payment_duration
vtiger_payment_duration_seq
vtiger_pbxmanager
vtiger_pbxmanagercf
vtiger_pbxmanager_gateway
vtiger_pbxmanager_phonelookup
vtiger_picklist
vtiger_picklistvalues_seq
vtiger_picklist_dependency
vtiger_picklist_seq
vtiger_picklist_transitions
vtiger_pobillads
vtiger_portal
vtiger_portalinfo
vtiger_poshipads
vtiger_postatus
vtiger_postatushistory
vtiger_postatus_seq
vtiger_potential
vtiger_potentialscf
vtiger_potstagehistory
vtiger_pricebook
vtiger_pricebookcf
vtiger_pricebookproductrel
vtiger_priority
vtiger_productcategory
vtiger_productcategory_seq
vtiger_productcf
vtiger_productcurrencyrel
vtiger_products
vtiger_producttaxrel
vtiger_profile
vtiger_profile2field
vtiger_profile2globalpermissions
vtiger_profile2standardpermissions
vtiger_profile2tab
vtiger_profile2utility
vtiger_profile_seq
vtiger_progress
vtiger_progress_seq
vtiger_project
vtiger_projectcf
vtiger_projectmilestone
vtiger_projectmilestonecf
vtiger_projectmilestonetype
vtiger_projectmilestonetype_seq
vtiger_projectpriority
vtiger_projectpriority_seq
vtiger_projectstatus
vtiger_projectstatus_seq
vtiger_projecttask
vtiger_projecttaskcf
vtiger_projecttaskpriority
vtiger_projecttaskpriority_seq
vtiger_projecttaskprogress
vtiger_projecttaskprogress_seq
vtiger_projecttaskstatus
vtiger_projecttaskstatus_seq
vtiger_projecttasktype
vtiger_projecttasktype_seq
vtiger_projecttask_status_color
vtiger_projecttype
vtiger_projecttype_seq
vtiger_purchaseorder
vtiger_purchaseordercf
vtiger_query
vtiger_querycf
vtiger_quotes
vtiger_quotesbillads
vtiger_quotescf
vtiger_quotesshipads
vtiger_quotestage
vtiger_quotestagehistory
vtiger_quotestage_seq
vtiger_rating
vtiger_rating_seq
vtiger_recurringevents
vtiger_recurringtype
vtiger_recurringtype_seq
vtiger_recurring_frequency
vtiger_recurring_frequency_seq
vtiger_relatedlists
vtiger_relatedlists_rb
vtiger_relatedlists_seq
vtiger_relcriteria
vtiger_relcriteria_grouping
vtiger_reminder_interval
vtiger_reminder_interval_seq
vtiger_report
vtiger_reportdatefilter
vtiger_reportfilters
vtiger_reportfolder
vtiger_reportgroupbycolumn
vtiger_reportmodules
vtiger_reportsharing
vtiger_reportsortcol
vtiger_reportsummary
vtiger_reporttype
vtiger_report_sharegroups
vtiger_report_sharerole
vtiger_report_sharers
vtiger_report_shareusers
vtiger_role
vtiger_role2picklist
vtiger_role2profile
vtiger_role_seq
vtiger_rollupcomments_settings
vtiger_rowheight
vtiger_rowheight_seq
vtiger_rss
vtiger_salesmanactivityrel
vtiger_salesmanattachmentsrel
vtiger_salesmanticketrel
vtiger_salesorder
vtiger_salesordercf
vtiger_sales_stage
vtiger_sales_stage_seq
vtiger_salutationtype
vtiger_salutationtype_seq
vtiger_scheduled_reports
vtiger_schedulereports
vtiger_seactivityrel
vtiger_seactivityrel_seq
vtiger_seattachmentsrel
vtiger_selectcolumn
vtiger_selectquery
vtiger_selectquery_seq
vtiger_senotesrel
vtiger_seproductsrel
vtiger_service
vtiger_servicecategory
vtiger_servicecategory_seq
vtiger_servicecf
vtiger_servicecontracts
vtiger_servicecontractscf
vtiger_service_usageunit
vtiger_service_usageunit_seq
vtiger_seticketsrel
vtiger_settings_blocks
vtiger_settings_blocks_seq
vtiger_settings_field
vtiger_settings_field_seq
vtiger_sharedcalendar
vtiger_shareduserinfo
vtiger_shippingtaxinfo
vtiger_shippingtaxinfo_seq
vtiger_shorturls
vtiger_smslog
vtiger_smslogcf
vtiger_smsnotifier
vtiger_smsnotifiercf
vtiger_smsnotifier_servers
vtiger_smsnotifier_status
vtiger_soapservice
vtiger_sobillads
vtiger_soshipads
vtiger_sostatus
vtiger_sostatushistory
vtiger_sostatus_seq
vtiger_sqltimelog
vtiger_start_hour
vtiger_start_hour_seq
vtiger_state_master
vtiger_status
vtiger_status_seq
vtiger_systems
vtiger_tab
vtiger_tab_info
vtiger_taskpriority
vtiger_taskpriority_seq
vtiger_taskstatus
vtiger_taskstatus_seq
vtiger_taxclass
vtiger_taxclass_seq
vtiger_taxregions
vtiger_ticketcategories
vtiger_ticketcategories_seq
vtiger_ticketcf
vtiger_ticketcomments
vtiger_ticketpriorities
vtiger_ticketpriorities_seq
vtiger_ticketseverities
vtiger_ticketseverities_seq
vtiger_ticketstatus
vtiger_ticketstatus_seq
vtiger_ticket_title
vtiger_ticket_title_seq
vtiger_time_zone
vtiger_time_zone_seq
vtiger_tmp_read_group_rel_sharing_per
vtiger_tmp_read_group_sharing_per
vtiger_tmp_read_user_rel_sharing_per
vtiger_tmp_read_user_sharing_per
vtiger_tmp_write_group_rel_sharing_per
vtiger_tmp_write_group_sharing_per
vtiger_tmp_write_user_rel_sharing_per
vtiger_tmp_write_user_sharing_per
vtiger_tracker
vtiger_tracking_unit
vtiger_tracking_unit_seq
vtiger_troubletickets
vtiger_usageunit
vtiger_usageunit_seq
vtiger_user2mergefields
vtiger_user2role
vtiger_users
vtiger_users2group
vtiger_users_last_import
vtiger_users_seq
vtiger_user_audit_log
vtiger_user_module_preferences
vtiger_vendor
vtiger_vendorcf
vtiger_vendorcontactrel
vtiger_version
vtiger_version_seq
vtiger_visibility
vtiger_visibility_seq
vtiger_webforms
vtiger_webforms_field
vtiger_webform_file_fields
vtiger_wordtemplates
vtiger_wsapp
vtiger_wsapp_handlerdetails
vtiger_wsapp_logs_basic
vtiger_wsapp_logs_details
vtiger_wsapp_queuerecords
vtiger_wsapp_recordmapping
vtiger_wsapp_sync_state
vtiger_ws_entity
vtiger_ws_entity_fieldtype
vtiger_ws_entity_fieldtype_seq
vtiger_ws_entity_name
vtiger_ws_entity_referencetype
vtiger_ws_entity_seq
vtiger_ws_entity_tables
vtiger_ws_fieldinfo
vtiger_ws_fieldtype
vtiger_ws_operation
vtiger_ws_operation_parameters
vtiger_ws_operation_seq
vtiger_ws_referencetype
vtiger_ws_userauthtoken
vtiger_zone
vtiger_zonecf
.
select column
mysqli::real_connect(): (HY000/1045): Access denied for user 'pma'@'localhost' (using password: NO)
Connection for controluser as defined in your configuration failed.