Search found 29 matches

by admin
Thu May 17, 2018 5:08 am
Forum: Hot Tips
Topic: Get date range duration in DbFace
Replies: 0
Views: 4

Get date range duration in DbFace

Code: Select all

var fromDate = $('#fromDate').val().split('-');

var end = new moment($.trim(fromDate[1]));
var begin = new moment($.trim(fromDate[0]));

var diff = end.diff(begin, 'days');
by admin
Wed May 16, 2018 10:26 am
Forum: Hot Tips
Topic: Change the default timezone
Replies: 0
Views: 12

Change the default timezone

If you already set date.timezone entry in php.ini. DbFace will use the default timezone. If not set this entry in php.ini, DbFace will use UTC timezone. You can open index.php and find $tz = ini_get('date.timezone'); if ($tz == FALSE) { date_default_timezone_set( 'UTC' ); } change to date_default_ti...
by admin
Sat May 12, 2018 2:04 pm
Forum: Announcements / News / Information
Topic: DbFace V7.6(20180512) Released
Replies: 0
Views: 17

DbFace V7.6(20180512) Released

Hi,

We have uploaded a new hotfix for V7.6.

1). Not render correctly on some PHP version.
by admin
Sun May 06, 2018 1:57 am
Forum: Announcements / News / Information
Topic: DbFace V7.6(20180505) Released
Replies: 0
Views: 25

DbFace V7.6(20180505) Released

Hi, We just uploaded V7.6(20180505) that fixed some issues: 1). Move global logs and cache directories to user directory. We have moved all directories that require write permission into user directory. 2). Mongodb GridFS support You can view images stored in Mongodb GridFS collection in Data module...
by admin
Sat Apr 28, 2018 12:21 pm
Forum: MongoDB
Topic: Upgrade Mongodb Driver to V1.4.3
Replies: 0
Views: 24

Upgrade Mongodb Driver to V1.4.3

Hi,

Since the latest build, DbFace requires V1.4.3 Mongodb driver.
The old version Mongodb connection will cause 500 error.

Please upgrade your mongodb driver to V1.4.3, if you are using Mongodb before upgrading to the latest version.
by admin
Sat Apr 28, 2018 1:14 am
Forum: Announcements / News / Information
Topic: DbFace V7.6(20180430) Released
Replies: 0
Views: 38

DbFace V7.6(20180430) Released

Hi, We uploaded the latest build V7.6(20180430) that fixed some issues 1). "Keep me signed in" option in the Login page not work When this option checked, DbFace will save your username and password into client cookie. Once you open the Login page, DbFace will redirect you to the DbFace co...
by admin
Tue Apr 17, 2018 3:00 pm
Forum: Announcements / News / Information
Topic: DbFace V7.6(20180417) Released
Replies: 0
Views: 41

DbFace V7.6(20180417) Released

Hi, We just uploaded V7.6(20180417) with some minor style fixes: 1). FIX chart report application in dashboard height The chart report in dashboard is too small to see the result. 2). CSV upload for warehouse You can upload csv file into DbFace warehouse now 3). Bug fixes on MongoDb Support 4). Colo...
by admin
Sun Apr 15, 2018 2:19 am
Forum: Announcements / News / Information
Topic: DbFace V7.6(20180414) Released
Replies: 0
Views: 34

DbFace V7.6(20180414) Released

Hi, all DbFace V7.6(20180414) was just released. We have updated our download site, you can download the latest file from: https://www.dbface.com/download-dbface 1). Mobile Access URL generator for Viewers You can scan the account code to access your dbface viewer account by android /iPhone 2). Page...
by admin
Sun Apr 08, 2018 2:37 pm
Forum: Applications & Reports
Topic: Multiple SQL queries for Tabular Report
Replies: 0
Views: 45

Multiple SQL queries for Tabular Report

Hi,

At the latest verison(since V7.6) DbFace supports multiple SQL queries for tabular reports.
You can use multiple SQL queries splitted by ;.

DbFace will use the last query to generate tabular report.

Code: Select all

SET @var = 1;
SET @var = 2;
SELECT * from TABLE where column = @var
by admin
Fri Apr 06, 2018 2:01 pm
Forum: Hot Tips
Topic: Select all options for multiple select in Form
Replies: 0
Views: 47

Select all options for multiple select in Form

You can input

all

in the default value field.

DbFace will select all the options.