Skip to Content
avatar image
Former Member

Reg: Line chart for Sql Query

Hi Friends,

I have requirement to present live data from SQL database into MII server in the form of Line Chart . I could able to present live data in Bar, Grid and other chart types.

( OPC is connected to SQL database, Using IDBC connector, established connection to MII server)

Somehow, I am unable to present live data in the form of Line chart. with same parameter settings, I could acheive using tag query and present a line chart.

with Line chart using SQL query, I am getting only grid screen with out any trends.

I want to know whether it is possible to present Line chart for a SQL query . Please let me know if i need to do some workaround.

As I am very new to MII environment, I also request forum, to show some links on SPC chart types ( blogs or small examples from your workplace).

Thanks,

Suman

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Apr 29, 2013 at 05:50 AM

    Hi Suman,

    First, answer to your question if we can plot a line chart with a SQL qry is Yes, we can plot any type of chart with either a SQL,TAG or Xacute qry.

    Before suggesting any workaround to your issue, can you please tell if you are plotting the data against some Date Time value?

    Warm Regards,

    Anuj

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Suman,

      I dont think that plotting a line chart for a single record will be a good idea.

      Anyways, to answer your question, number of records has nothing to do with the chart type. But if you have a single record, you wont be able to see any lines plotted in the chart area, rather you will see a single marker because atleast two data points are required to see a line (basic geometry :-) ) in the chart and I think you must be getting this single marker in your chart area for that single record.

      Best Regards,

      Anuj