Forum - jschmidt-systemberatung.de

× php-RGraph and php-rgraph Joomla Content Plugin

CB substitution on Where statement

More
8 months 1 week ago #1293 by D
Hi,

The where country_name='[cb_country]' doesn't seem to work although the error in the front-end shows the correct value: county_name='Brazil' which is the country of the specific user.
The [ ] is used by Community Builder as field substitution so it works for the specific user.
It is important to me as each graph will change according to the corresponding related table data for the specific user.

When  I explicitly use county_name='Brazil' it works fine.

Any ideas?

Thanks

Please Log in or Create an account to join the conversation.

More
8 months 1 week ago - 7 months 1 week ago #1294 by jochen
Replied by jochen on topic CB substitution on Where statement
hi,

this problem has nothing to do with php-rgraph, as rgraph processes sql statements from plugin-parms. It seems for me that Community Builder should have replaced values before php-rgraph's processing.    
Last edit: 7 months 1 week ago by jochen.
The following user(s) said Thank You: D

Please Log in or Create an account to join the conversation.

More
8 months 1 week ago #1295 by D
Replied by D on topic CB substitution on Where statement
Will try to evaluate the cause a bit further and talk to the Joomlapolis team.

Thanks

Please Log in or Create an account to join the conversation.

More
8 months 4 days ago #1296 by D
Replied by D on topic CB substitution on Where statement
Hi,

You were right, the problem was in order. Changing plugins and loading CB before PHP-rgraph solved the issue.

By the way, is there a way to solve responsive issues somehow using a bars graph?

Thanks

Please Log in or Create an account to join the conversation.

More
8 months 4 days ago #1297 by jochen
Replied by jochen on topic CB substitution on Where statement
hi,

php-rgraph has a responive parameter which may be defined globally via pugin parms or via php-graph plugin tag for a single chart..
With it  you define how chart should be displayed if browser size (client size) is changed or if you are using a device like smartphone or tablet with smaller screensizes
  Parameter consist of 3 values (separated by commas):
           1. scale factor for resizing chart's properties
           2. small client size
           4. large client size

eg.: responsive="0.3,600,1100"

For more info see my docs. about plugin parameters:  www.jschmidt-systemberatung.de/index.php...6&Itemid=659&lang=en
The following user(s) said Thank You: D

Please Log in or Create an account to join the conversation.

Time to create page: 0.247 seconds
Powered by Kunena Forum
We use cookies

We use cookies on our website. Some of them are essential for the operation of the site, while others help us to improve this site and the user experience (tracking cookies). You can decide for yourself whether you want to allow cookies or not. Please note that if you reject them, you may not be able to use all the functionalities of the site.