Menu Content

Support

> Forums, FAQs & Paid Support
Welcome, Guest
Username Password: Remember me

How to add a single record to a table?
(1 viewing) (1) Guest
Flash chart component for Joomla CMS.

NOTE: This category has been locked. If you have purchased paid version, please, use our Support Ticket system instead. If you are using free edition, please see the Community Support section.
  • Page:
  • 1
  • 2

TOPIC: How to add a single record to a table?

How to add a single record to a table? 11 years, 7 months ago #37117

This is a pretty simple problem, but the solution is way beyond me, so that is why I posted this question in the hope you can help me solve it.

I have a table that looks like this:


I have a page that looks like this:


What I want is a combination chart like this:


So, what is the question?

How can I add the selected record from the page, using the Nr. link to the Table in the first image on a temporary basis to display a chart like the combination chart above? What do I need to change in my query to achieve that? See the image below:


There is one additional problem. Why is the first row in the table always left out? The Top observation is never included in the query other than using the values as Category names.

Looking forward to your suggestions.
The topic has been locked.

Re: How to add a single record to a table? 11 years, 7 months ago #37154

  • maju
  • OFFLINE
  • Posts: 1107
Hello,

These combination charts are problematic and they do not allow you to set all data by SQL. Exactly, you can not set all those settings in configuration icon.
Additional problem can be solved by modifying you SQL query. You can see some examples on: demo.tramin.artio.cz/joomla25/components...mentation/useSql.php

SELECT '', 'category_name' UNION SELECT ...
ARTIO Support Team
The topic has been locked.

Re: How to add a single record to a table? 11 years, 7 months ago #37155

  • maju
  • OFFLINE
  • Posts: 1107
I think, there is possible some solution to load data dynamically from database. (e.g. preset options for every row). I created task in our project management for this problem. But it may take long time to release it.

If you need this solution fast, you can contact our paid custom support on Diese E-Mail-Adresse ist gegen Spambots geschützt! Du musst JavaScript aktivieren, damit Du sie sehen kannst. (copy to Diese E-Mail-Adresse ist gegen Spambots geschützt! Du musst JavaScript aktivieren, damit Du sie sehen kannst. ). There you can consult details.
ARTIO Support Team
The topic has been locked.

Re: How to add a single record to a table? 11 years, 7 months ago #37185

Your remark about UNION helped a lot to solve the second problem.

SELECT '','Total Time','Relative
Pref. Index','Disk I/O','MPEG2-DVD','H.264-BR'
UNION
(SELECT name, ideal, idealrpi, disk, mpeg, h264 FROM Percentiles LIMIT 0, 5)
UNION
(SELECT Computer_ID, total_time, crpi, Diskio, dvd, h264 FROM Personal_data WHERE Version LIKE 6.0 AND nr=36)

gives me the correct results in the table. I still have to figure out how to make the 'nr=36' condition in the last SELECT statement dynamic, to be used with fabrik links as a kind of 'Detail View', but the most pressing problem now is that updating the SQL query resets all my dataset preferences to a default that I do not want.

I want my datasets to look like this: ppbm7.com/index.php/results?showall=&start=5

Type, colours, line thickness, anchor radius, anchor angles, values, etc. are all changed after updating the SQL query to some default settings that make it - for my use at least - unworkable.

I need to be able to use real time SQL queries to update charts on-line but keep the layout I have once made. How can I set the defaults to these settings?
The topic has been locked.

Re: How to add a single record to a table? 11 years, 7 months ago #37191

  • maju
  • OFFLINE
  • Posts: 1107
Hello,

this functionality is not implemented. You can try to modify component code, but then we can not guarantee correct functionality of the component.
There is only default settings for colors:
administrator/components/com_artiofusioncharts/helpers/helper.php - function getColorsPoll() - line 905
ARTIO Support Team
The topic has been locked.

Re: How to add a single record to a table? 11 years, 7 months ago #37201

Upon saving a chart, the XML code generated is stored in a database table, __ARTIOFusioCarts or something simliar. Which component generates this XML code, because that module may be modified to retain my settings for the display, even though the data change.
The topic has been locked.
  • Page:
  • 1
  • 2
User Login Empty