PrevUsing SkylendarNext

Chart Loading/Saving

You can save a chart into the database with Save into DB, and the current chart will be saved with its current title, the current date and user's id. Obviously, you will be able to retrieve this chart with the Search for Charts menu item. Then, a dialog box will allow you to search by chart name or by SQL statement.

SQL Statement

This statement is the conditional part of a SELECT query, involving the Charts, Ring, Data and Restrictions tables. Here are a few more explanatory examples: 

Data.Name = 'John Doe'

All the charts with the John Doe's Dataset.

Data.Name = 'John Doe' AND Ring.RingNb = '2'

Same, but the Dataset dwells in the second ring.

Data.Name = 'John Doe' AND Restrictions.Name = 'With Stars'

Same, with 'With Stars' as its Restrictions set.

Charts.UserId = (SELECT usesysid FROM pg_user WHERE usename = current_user)

All my charts

EXTRACT(YEAR FROM Charts.Date) >= 2006

All the charts saved after 2006