Skip to content
DataMiner DoJo

More results...

Generic selectors
Exact matches only
Search in title
Search in content
Post Type Selectors
Search in posts
Search in pages
Search in posts
Search in pages
Log in
Menu
  • Updates & Insights
  • Questions
  • Learning
    • E-learning Courses
    • Empower Replay: Limited Edition
    • Tutorials
    • Open Classroom Training
    • Certification
      • DataMiner Fundamentals
      • DataMiner Configurator
      • DataMiner Automation
      • Scripts & Connectors Developer: HTTP Basics
      • Scripts & Connectors Developer: SNMP Basics
      • Visual Overview – Level 1
      • Verify a certificate
    • Video Library
    • Books We Like
    • >> Go to DataMiner Docs
  • Expert Center
    • Solutions & Use Cases
      • Solutions
      • Use Case Library
    • Markets & Industries
      • Media production
      • Government & defense
      • Content distribution
      • Service providers
      • Partners
      • OSS/BSS
    • Agile
      • Agile Webspace
      • Everything Agile
        • The Agile Manifesto
        • Best Practices
        • Retro Recipes
      • Methodologies
        • The Scrum Framework
        • Kanban
        • Extreme Programming
      • Roles
        • The Product Owner
        • The Agile Coach
        • The Quality & UX Coach (QX)
    • DataMiner DevOps Professional Program
      • About the DevOps Program
      • DataMiner DevOps Support
  • Downloads
  • More
    • DataMiner Releases & Updates
    • Feature Suggestions
    • Climb the leaderboard!
    • Swag Shop
    • Contact
    • Global Feedback Survey
  • PARTNERS
    • All Partners
    • Technology Partners
    • Strategic Partner Program
    • Deal Registration
  • >> Go to dataminer.services

Adhoc – Getting table data from element

Solved362 views17th January 2025adhoc GQI
3
João Azevedo237 15th January 2025 0 Comments

Hi, evertyone! Hope you all are well!

I need to get the data from a table in my element to make a GQI and then use it in LCA. I have tried search in the documentation and kata videos, but nothing helped.

My table data is from a EPM element so i cant use the standard query method from LCA, and the table data only appears if i have all filters filled.

So im trying to make a GQI to use im my LCA, but i need help wth getting the table data.

My current code is:
[GQIMetaData(Name = “EPMQuery”)]
public sealed class EPMQuery : IGQIDataSource, IGQIOnInit, IGQIInputArguments
{
    private static readonly GQIStringColumn _city = new GQIStringColumn(“City”);
    private static readonly GQIStringColumn _neighborhood = new GQIStringColumn(“Neighborhood”);
    private static readonly GQIStringColumn _street = new GQIStringColumn(“Street”);

    private readonly GQIIntArgument _viewArgument = new GQIIntArgument(“View id”) { IsRequired = true };
    private readonly GQIIntArgument _elementArgument = new GQIIntArgument(“Element id”) { IsRequired = true };
    private readonly GQIIntArgument _tableArgument = new GQIIntArgument(“Table id”) { IsRequired = true };

private GQIDMS _dms;
private int _viewID;
private int _elementID;
private int _tableID;

    public GQIArgument[] GetInputArguments() => new[] { _viewArgument, _elementArgument, _tableArgument };

    public OnArgumentsProcessedOutputArgs OnArgumentsProcessed(OnArgumentsProcessedInputArgs args)
    {
        _viewID = args.GetArgumentValue(_viewArgument);
_elementID = args.GetArgumentValue(_elementArgument);
_tableID = args.GetArgumentValue(_tableArgument);
        return default;
    }

    public OnInitOutputArgs OnInit(OnInitInputArgs args)
    {
        _dms = args.DMS;
        return default;
    }

    public GQIColumn[] GetColumns()
{
return new GQIColumn[]
{
_city, _neighborhood, _street,
};
}

public GQIPage GetNextPage(GetNextPageInputArgs args)
{
var rows = _dms.SendMessage()
}
}

João Azevedo Selected answer as best 17th January 2025

1 Answer

  • Active
  • Voted
  • Newest
  • Oldest
3
Tom Waterbley [SLC] [DevOps Catalyst]8.89K Posted 16th January 2025 1 Comment

Hi João,

The message you are probably looking for is GetPartialTableMessage. To make things a bit easier you could use this class to send and parse the message.

Example:

var table = GqiGetPartialTable.GetTable(dmaId, elementId, tableId);

foreach (var row in table)
{
   var key = row.Key;
   var cells = row.Value;

   // …
}

Let me know if you need additional assistance.

João Azevedo Posted new comment 17th January 2025
João Azevedo commented 17th January 2025

Hi Tom, thank you for your help, it worked!

Please login to be able to comment or post an answer.

My DevOps rank

DevOps Members get more insights on their profile page.

My user earnings

0 Dojo credits

Spend your credits in our swag shop.

0 Reputation points

Boost your reputation, climb the leaderboard.

Promo banner DataMiner DevOps Professiona Program
DataMiner Integration Studio (DIS)
Empower Katas
Privacy Policy • Terms & Conditions • Contact

© 2025 Skyline Communications. All rights reserved.

DOJO Q&A widget

Can't find what you need?

? Explore the Q&A DataMiner Docs