Hi, Thanks,
Can we have some example, at some point they want to see whole data in the table, but thats fine if it loads in chunks, so not sure how to handle at GetNextPage…
I did try something but it only returned the first 10 or last 10 rows if I set page size to 10
Code:

public class PaginationState
{
public int LastProcessedServiceIndex { get; set; }
public int LastProcessedParameterIndex { get; set; }
}

private PaginationState _paginationState = new PaginationState();
private const int PageSize = 10;
public GQIPage GetNextPage(GetNextPageInputArgs args)
{
_logger.Information("Fetching next page");
var rows = new List<GQIRow>();
List<GetParameterResponseMessage> paramInfo = new List<GetParameterResponseMessage>();

int currentRowCount = 0; // To keep track of how many rows have been processed so far

try
{
_logger.Information($"TEST: {_paginationState.LastProcessedServiceIndex}");
// Iterate through services starting from the last processed service index
for (int serviceIndex = _paginationState.LastProcessedServiceIndex; serviceIndex < serviceList.Count; serviceIndex++)
{
var service = serviceList[serviceIndex];
var childInfos = service.Children?.ToList();
_paginationState.LastProcessedParameterIndex = 0; // Reset the parameter index
if (childInfos.Count > 0)
{
var reqParam = new List<DMSMessage>();
// Iterate through child services starting from the last processed parameter index
for (int childIndex = _paginationState.LastProcessedParameterIndex; childIndex < childInfos.Count; childIndex++)
{
_logger.Information($"TEST12: {_paginationState.LastProcessedParameterIndex}");
var childInfo = childInfos[childIndex];
var paramsNeeded = childInfo.Parameters
.Where(x => _resources.Any(y => y.ParamterId == x.ParameterID))
.ToList();

foreach (var parameter in paramsNeeded)
{
var msg = new GetParameterMessage(childInfo.DataMinerID, childInfo.ElementID,
parameter.ParameterID, parameter.FilterValue, true);
reqParam.Add(msg);
}

try
{
var responseMsg = _dms.SendMessages(reqParam.ToArray());
var response = responseMsg.OfType<GetParameterResponseMessage>().ToList();
paramInfo = response
.FindAll(x => !string.IsNullOrEmpty(x.Value.ToString()) && !x.Value.ToString().Equals("EMPTY", StringComparison.CurrentCultureIgnoreCase))
.ToList();
var cells = InitializeTableCells();
CreateElementRow(ref rows, childInfo, cells, paramInfo, service.Name);
currentRowCount++;
_logger.Information($"Count: {currentRowCount}");

// Stop if we've processed enough rows for the current page
if (currentRowCount >= PageSize)
{
break;
}
}
catch (Exception e)
{
_logger.Error($"Error fetching parameters: {e.Message}");
continue;
}

// Stop processing if we've reached the page size
if (currentRowCount >= PageSize)
{
_paginationState.LastProcessedParameterIndex = childIndex + 1; // Store where we left off
break;
}
}

// Stop processing if we've reached the page size
if (currentRowCount >= PageSize)
{
_paginationState.LastProcessedServiceIndex = serviceIndex + 1; // Store where we left off
break;
}
}

// Stop processing if we've reached the page size
if (currentRowCount >= PageSize)
{
break;
}
}

// Determine if there are more rows to process
bool hasNextPage = currentRowCount < rows.Count;

// Return the rows for the current page
_logger.Information(hasNextPage.ToString());
_logger.Information(currentRowCount.ToString() + " " + rows.Count.ToString());
return new GQIPage(rows.ToArray())
{
HasNextPage = hasNextPage
};
}
catch (Exception e)
{
_logger.Error($"Error fetching elements: {e.Message}");
return new GQIPage(rows.ToArray()) { HasNextPage = false };
}
}

Hi Ronald,
Yes it does add an row, but I think when HasNextPage = true it does reitinalizes all the values in class again, now I tweaked the code to send rows per service wise , then also pagination fails
Hope the below value is not initialized again

public static int LastProcessedServiceIndex = 0;
public GQIPage GetNextPage(GetNextPageInputArgs args)
{
_logger.Information("Fetching next page");
var rows = new List<GQIRow>();
List<GetParameterResponseMessage> paramInfo = new List<GetParameterResponseMessage>();
try
{
_logger.Information("SERVICE COUNT" + serviceList.Count.ToString());
_logger.Information($"TEST SERVICE: {LastProcessedServiceIndex}");
var service = serviceList[LastProcessedServiceIndex];

var childInfos = service.Children?.ToList();
if (childInfos.Count > 0)
{
var reqParam = new List<DMSMessage>();
for (int childIndex = 0; childIndex < childInfos.Count; childIndex++)
{
var childInfo = childInfos[childIndex];
var paramsNeeded = childInfo.Parameters
.Where(x => _resources.Any(y => y.ParamterId == x.ParameterID))
.ToList();

foreach (var parameter in paramsNeeded)
{
var msg = new GetParameterMessage(childInfo.DataMinerID, childInfo.ElementID,
parameter.ParameterID, parameter.FilterValue, true);
reqParam.Add(msg);
}

try
{
var responseMsg = _dms.SendMessages(reqParam.ToArray());
var response = responseMsg.OfType<GetParameterResponseMessage>().ToList();
paramInfo = response
.FindAll(x => !string.IsNullOrEmpty(x.Value.ToString()) && !x.Value.ToString().Equals("EMPTY", StringComparison.CurrentCultureIgnoreCase))
.ToList();
var cells = InitializeTableCells();
CreateElementRow(ref rows, childInfo, cells, paramInfo, service.Name);

}
catch (Exception e)
{
_logger.Error($"Error fetching parameters: {e.Message}");
continue;
}
}
}
LastProcessedServiceIndex++;

hasNextPage = LastProcessedServiceIndex != serviceList.Count;
return new GQIPage(rows.ToArray())
{
HasNextPage = hasNextPage
};
}
catch (Exception e)
{
_logger.Error($"Error fetching elements: {e.Message}");
return new GQIPage(rows.ToArray()) { HasNextPage = false };
}
}

Ok so for this piece
var service = serviceList[LastProcessedServiceIndex];

how can I handle this LastProcessedServiceIndex, so that it remains same for all query and not overwrite..I did remove static but still issue persits

and also,
on getNextPage call again when HasNextPage = true, will var rows = new List<GQIRow>();
be initialised again?