Hi,

I have an API call that returns this data:

public class MMUIData
{
public DateTime? Date { get; set; }
public string ScriptNumber { get; set; }

public int Skns { get; set; }

public string ShowCode { get; set; }

public string ShowName { get; set; }

public List<string> ProductNumbers { get; set; }
}

I currently have a table on my low code app that nicely groups this data by date and shows the information, however I now want to add the list of product numbers to the table if possible. Basically every row (script number), also has a list of product numbers so I was hoping to include that so each row has a drop down arrow where I see all the product numbers nested underneath.

I'm struggling on how to construct the GQI query though so any pointers would be great.

At the moment I return this table:

public GQIColumn[] GetColumns()
{
return new GQIColumn[] {
new GQIStringColumn("Date"),
new GQIStringColumn("Script Number"),
new GQIIntColumn("SKNs"),
new GQIStringColumn("Code"),
new GQIStringColumn("Title"),

};
}

But I'm unsure how to include the product numbers list.

Thanks, Carl