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()
}
}