Filter data on google charts extension

All WYSIWYG Web Builder support issues that are not covered in the forums below.
Forum rules
IMPORTANT NOTE!!

DO YOU HAVE A QUESTION OR PROBLEM AND WANT QUICK HELP?
THEN PLEASE SHARE A "DEMO" PROJECT.



PLEASE READ THE FORUM RULES BEFORE YOU POST:
http://www.wysiwygwebbuilder.com/forum/viewtopic.php?f=12&t=1901

MUST READ:
http://www.wysiwygwebbuilder.com/getting_started.html
WYSIWYG Web Builder FAQ
Post Reply
marcin_kor
 
 
Posts: 3
Joined: Mon Feb 27, 2023 1:59 pm

Filter data on google charts extension

Post by marcin_kor »

hello, I'm trying to create a chart from mysql database using google charts extension (paid), but not really, is it possible to use date parameters from datapicker and combobox in where condition (mysql filter)?

marcin
User avatar
Pablo
 
Posts: 23608
Joined: Sun Mar 28, 2004 12:00 pm
Location: Europe
Contact:

Re: Filter data on google charts extension

Post by Pablo »

There is no standard solution for this, this will require a custom script.
marcin_kor
 
 
Posts: 3
Joined: Mon Feb 27, 2023 1:59 pm

Re: Filter data on google charts extension

Post by marcin_kor »

So this mysql filter can only contain a statically typed condition, no variable can be used there (in a non-script solution)?
User avatar
Pablo
 
Posts: 23608
Joined: Sun Mar 28, 2004 12:00 pm
Location: Europe
Contact:

Re: Filter data on google charts extension

Post by Pablo »

The filter will be added as 'WHERE' clause, so technically it can also be a PHP variable.
$sql = "SELECT * FROM `TABLE` WHERE $filter";
marcin_kor
 
 
Posts: 3
Joined: Mon Feb 27, 2023 1:59 pm

Re: Filter data on google charts extension

Post by marcin_kor »

Thanks for the info.

marcin
Post Reply