12 replies

Calculation Heavy Resource with Historian Retrieval

Hello, was needing some help on a difficult problem. I have a calculation heavy resource (100+ calculations) that we would like to grab data out of our 3rd party historian sensor tables and perform calculations on as well as filter the results of certain calculations for metrics purposes. For example we would want to get the temperature over the course of a run and perform the average over the whole run. One caveat is that the sqlth_data tables are created weekly and have dynamic names for the tables that are stored in the partition tables and due to the historian data from tables require complex time-based filtering and dynamic table names its breaking my brain. I can make this work with calculate but i was hoping to make this work via expr is there something i am missing or could do that would help out my approach?

  def expression(_opts, _context) do
    expr(
      avg(
        equipment.tag_versions.tag_paths.tags.historical_data,
        field: :floatvalue,
        query: [
          filter: expr(
            tag_paths.tag_template.name == "Temperature" and
            t_stamp >= ^ref(:start_time_resolved) and
            t_stamp <= ^ref(:end_time_resolved) and
            dataintegrity == 192
          )
        ]
      )
    )
  end
end

  def expression(_opts, _context) do
    expr(
      avg(
        equipment.tag_versions.tag_paths.tags.historical_data,
        field: :floatvalue,
        query: [
          filter: expr(
            tag_paths.tag_template.name == "Temperature" and
            t_stamp >= ^ref(:start_time_resolved) and
            t_stamp <= ^ref(:end_time_resolved) and
            dataintegrity == 192
          )
        ]
      )
    )
  end
end

  def expression(_opts, _context) do
    expr(
      avg(
        equipment.tag_versions.tag_paths.tags.historical_data,
        field: :floatvalue,
        query: [
          filter: expr(
            tag_paths.tag_template.name == "Temperature" and
            t_stamp >= ^ref(:start_time_resolved) and
            t_stamp <= ^ref(:end_time_resolved) and
            dataintegrity == 192
          )
        ]
      )
    )
  end
end

  def expression(_opts, _context) do
    expr(
      avg(
        equipment.tag_versions.tag_paths.tags.historical_data,
        field: :floatvalue,
        query: [
          filter: expr(
            tag_paths.tag_template.name == "Temperature" and
            t_stamp >= ^ref(:start_time_resolved) and
            t_stamp <= ^ref(:end_time_resolved) and
            dataintegrity == 192
          )
        ]
      )
    )
  end
end

Calculation Heavy Resource with Historian Retrieval

Similar Threads

Similar Threads

Similar Threads