VolkovLabs / business-text

The Business Text panel plugin allows you to construct a text visualization template from the values of a dataset returned by a data source query.
https://volkovlabs.io
Apache License 2.0
83 stars 13 forks source link

Is there a way to access other data sources in panel without merging into a single frame #273

Closed craftzneko closed 9 months ago

craftzneko commented 9 months ago

I have mixed data sources on my panel, that contain very different data sets, i want to build two tables using this data. Everything is setup but the issue i have is being able to access the second queries data. I cant merge this using transformations as this panel also provides data to other panels which are set to process the data differently so it creates a mess. Is there a way to access the data in the other query like data.data[1] 👍

craftzneko commented 9 months ago

Just realised i was a few version behind and read your latest blog post for the release 4.3.0. Amazing work!! Updated and changed the template to ALL DATA now and i can see i can access this in JS using this context.data.data[1] or [0] depending on the query. My only question would be I had this table setup for data source 0 in HTML without using Each loop as the data only ever contains a single value

  <tr>
    <td>OS:</td>
    <td>{{this.summaryjson.OS}}</td>
    <td>&nbsp;</td> <!-- Blank cell for the gap -->
    <td>Make:</td>
    <td>{{this.summaryjson.Make}}</td>
  </tr>
  <tr>
    <td>Build:</td>
    <td>{{this.summaryjson.OSBuild}}</td>
    <td>&nbsp;</td> <!-- Blank cell for the gap -->
    <td>Model:</td>
    <td>{{this.summaryjson.Model}}</td>
  </tr>

When i am using ALL data is there a way to reference just the first returned values from the first query or do i still need to use each now.

mikhail-vl commented 9 months ago

@craftzneko You can reference specific row in the dataset like as described in the documentation: https://volkovlabs.io/plugins/volkovlabs-dynamictext-panel/recipes/#specific-row-in-the-data

craftzneko commented 9 months ago

@mikhail-vl unfortunately that means changing the data source to all rows, which means i loose the second query data. It doesnt seem to work for ALL DATA. I have now added it via each so its no worries but was wondering