Access Upvise Standard apps database tables

You can query other application database tables using the Query.select(table, columns, where, orderby) method. Make sure you use the fully qualifed name for table which is appid.tablename

View All Tables in your Upvise Database

You can download a copy of your entire SQLite database and browse the data and the table structures on your computer with a compatible SQLite database file viewer (SQLite Browser for example).

• Go to your Upvise Web Account and click on the Settings icon on the top right of the toolbar
• Click Backup & Restore item
• Click on the Backup Now button
• Download the latest zipped database to your computer
• Unzip the file and open it with a SQLite database viewer

contacts.companies

column name	desription
id	primary key
name	full name
phone
fax	company fax
email	contact email
website	web site URL
note
street
zipcode	postal code
city
state
country
mapurl	geo-coordinates of contact address lat,long
groupid	id of the contact group in the contacts.groups table
regionid	id of the contact region in the contact.regions table
creationdate	DATE
owner

contacts.contacts

column name	description
id	primary key
name	full name
jobtitle	contact job title
companyid	id of the company in the contacts.companies table
email	contact email
email2	contact email2
mobile	mobile phone number
fax	contact fax
phone2
skypename	contact skype id
street
zipcode	postal code
city	city address
state
country
note
webpage
groupid	id of the contact group in the contacts.groups table
owner
regionid	id of the contact region in the contacts.regions table
productid
mapurl	geo-coordinates of contact address lat,long
salutation
creationdate	DATE

contacts.groups

column name	description
id	primary key
name	group name
owner	owner

contacts.regions

column name	description
id	primary key
name	region name

sales.products

column name	description
name	product name
code	product code
type	0:product, 1: service (INTEGER)
date	product date (DATE)
description
manufacturerid	id of manufacturer in contacts.companies table
categoryid	product category id in the sales.cateogries table
price	REAL
currency
discount	REAL
vat	REAL
purchaseprice	REAL
unitid	id of inut in the sales.units table
owner	owner

sales.categories

column name	description
id	primary key
name	category name
accountid	id of account in sales.account table

sales.units

column name	description
id	primary key
name	unit name

forms.forms

column name	description
id	primary key
name	form name
owner	form owner
date	form creation date (DATE)
templateid	form templateid from the forms.templates table
status	status 0:draft, 1:submitted (INTEGER)
value	JSON string containing all field values for the form
address	form address
geo	form geo-coordinates in the format lat,lng
linkedtable	name of the table of the linked record in the format appid.tablename
linkedid	primary key of the linked record in the linkedtable table
groupid	primary key of the form group in the forms.groups table

Tasks App

tasks.tasks

column name	description
id	primary key
name	task name
duedate	DATE
startdate	DATE
status	INTEGER. 0: open, 1: completed
priority	INTEGER. 2 is high priority
note	Task description
owner
listid	id of the task list
projectid	id of the linked project
contactid	id of the linked contact
companyid	id of the linked company
opportunityid	id of the linked deal
assetid	id of the linked asset

System.files

column name	description
id	primary key
name	name of the file
date	DATE.Creation date of the file
owner	name of the owner of the record
linkedtable	fully qualified name of the external table for thisrecord. example "myapp.mytable"
linkedrecid	id of the linked record for linkedtable
mime	MIME type of the file
size	INTEGER. Size of the file in bytes
folderid	id of the folder for the file
version	INTEGER. version number of the file
externalurl	URL of the file in case of a referenced file from Google Drive or Dropbox