Deleting row and sorting based on column value in global table

[anggoro_p]

Hi,

I need to delete some rows that have column value <= 0 and then sort ascending the remaining rows. I am using custom code on reset trigger. My code is as follows, but it doesn't seem to work. I think j parameter on deletetablerow means number of rows that will be deleted.

Anyone has an idea?

int j;
int k;
for (k = 1; k <= 28; k +=1);
{
    int delRow = 0;
    for (j = 1; j < 29; j += 1)
    {
        if (Table("ScheduledPicking_CO")["PickingTime"]<=0)
        {
            delRow = 1;
            break;
        } 
    }
    if (delRow = 1);
    {
        deletetablerow("ScheduledPicking_CO",j);
    } 
}

[anggoro_p]

@Raja Sekaran

[raja_sekaran · Accepted solution]

Hi @Anggoro P

I attached the sample model. deleterow-support-1.fsm

Use the below code to update the global table the way you wanted. I hope this helps you.

Table table = Table("GlobalTable1");
for (int j = 1; j <= table.numRows; j++)
{
    if (table[1] <= 0)
    {
        table.deleteRow(j);
        j--; 
    } 
}
table.sort(1);

[anggoro_p]

Hi @Raja Sekaran

Yes it works. Thanks!

However. I got another problem regarding the next reset. Because the content of current table that I resized and sorted is from another table that always has 28 rows, I can't do reset again after delete rows.

Update: I think I change the strategy. Please don't answer this question. Thanks