<?xml version="1.0" encoding="utf-8"?>
<feed xml:lang="en" xmlns="http://www.w3.org/2005/Atom"><title>Recent posts to Trends from database data</title><link href="https://forge.codesys.com/forge/talk/Runtime/thread/a2264e8ad4/" rel="alternate"/><link href="https://forge.codesys.com/forge/talk/Runtime/thread/a2264e8ad4/feed.atom" rel="self"/><id>https://forge.codesys.com/forge/talk/Runtime/thread/a2264e8ad4/</id><updated>2020-02-27T16:45:52.135000Z</updated><subtitle>Recent posts to Trends from database data</subtitle><entry><title>Trends from database data</title><link href="https://forge.codesys.com/forge/talk/Runtime/thread/a2264e8ad4/?limit=25#a737" rel="alternate"/><published>2020-02-27T16:45:52.135000Z</published><updated>2020-02-27T16:45:52.135000Z</updated><author><name>witalis</name><uri>https://forge.codesys.com/u/witalis/</uri></author><id>https://forge.codesys.comb21a3be76b66db5622283f26a9fc304604c8c9fc</id><summary type="html">&lt;div class="markdown_content"&gt;&lt;p&gt;Thank You Edwin for You fast answer&lt;/p&gt;
&lt;p&gt;I think, I will try with the integrated sqlite. Probably this is enough for this project. &lt;br/&gt;
As I understand -&amp;gt; there is option to record observed variables, whose values are stored in integrated SQLite, is it right? I need to store data for at least 2 years, I will have about 15 analog variables.&lt;/p&gt;
&lt;p&gt;I will also play with XY element. Maybe I will put 2 buttons "&amp;lt;&amp;lt;" "&amp;gt;&amp;gt;" with the trend. Pressing these buttons would load another time period from database to temporary array. This I think would automatically refresh the trend.&lt;/p&gt;&lt;/div&gt;</summary></entry><entry><title>Trends from database data</title><link href="https://forge.codesys.com/forge/talk/Runtime/thread/a2264e8ad4/?limit=25#37eb" rel="alternate"/><published>2020-02-27T16:45:51.073000Z</published><updated>2020-02-27T16:45:51.073000Z</updated><author><name>eschwellinger</name><uri>https://forge.codesys.com/u/eschwellinger/</uri></author><id>https://forge.codesys.com64872e5f12da1c746d7f52e08ad146bcd026a819</id><summary type="html">&lt;div class="markdown_content"&gt;&lt;p&gt;Hi,&lt;br/&gt;
the integrated trend is using a sqlite database.&lt;br/&gt;
At the moment it is not possible to connect this to an external database.&lt;br/&gt;
Sure to access your sql database is possible by the following store products:&lt;br/&gt;
&lt;a class="" href="https://store.codesys.com/catalogsearch/result/?q=sql" rel="nofollow"&gt;https://store.codesys.com/catalogsearch/result/?q=sql&lt;/a&gt;&lt;br/&gt;
Not sure if this helps,&lt;br/&gt;
if you have these values in an array you might use the new xy element (since 3.5SP12 available )to show the values.&lt;/p&gt;
&lt;p&gt;If you need an XY element example project please let me know - there will come an example to the CODESYS store,&lt;br/&gt;
this will take some time.&lt;br/&gt;
BR&lt;br/&gt;
Edwin&lt;/p&gt;&lt;/div&gt;</summary></entry><entry><title>Trends from database data</title><link href="https://forge.codesys.com/forge/talk/Runtime/thread/a2264e8ad4/?limit=25#e1fe" rel="alternate"/><published>2020-02-27T16:45:48.578000Z</published><updated>2020-02-27T16:45:48.578000Z</updated><author><name>witalis</name><uri>https://forge.codesys.com/u/witalis/</uri></author><id>https://forge.codesys.com47203b95b6b4ec10795a1a0180d69f5b207644c1</id><summary type="html">&lt;div class="markdown_content"&gt;&lt;p&gt;Hi all,&lt;/p&gt;
&lt;p&gt;I'm considering to use Codesys 3.5 (Control Win SL) as simple SCADA software. Is there possibility to draw trends for historical data stored e.g in MySQL or PostgreSQL database? &lt;br/&gt;
I would do it as loading the data(specified timeperiod from database) buffer to array, then this array would be presented as the trend.&lt;br/&gt;
Is there easy way to do this or You have better ideas?&lt;br/&gt;
I have few knowledge about Codesys.&lt;/p&gt;&lt;/div&gt;</summary></entry></feed>