How do I iterate through table rows and cells

Trying to understand how to iterate through table and if the engineering label is = DASH NUM PL then return engineering description as --- and ... for Item A(figure 1). will use this in a report such as Job operation listing report to retrieve the values and show it there.

figure 1

figure 2

Find more posts tagged with

Syteline Development

Accepted answers

Legacy Contributor

made it work using below in case sb faces the same issue: (make sure to add parentheses and top 1)

(SELECT top 1 value FROM dbo.xxxxxxxxx WHERE label='DASH NUM PL')

also i've noticed that you can not add more than 4 secondary collections to the report.

Thank you!

All comments

Stephen Cena

I think I follow what you are asking, so I'll take a shot:

If this is a Mongoose report, then all the data that populates it is coming from a Custom Load Method (CLM). You should see which method is being used in the ride sidebar. To do what you're asking, you have a few options:

1. Modify the CLM so it includes the logic for retrieving the correct label.

2. In your IDO, create a Derived Field that checks to check the value of the Engineering Label and return the correct text.

3. Add the field into the IDO directly and populate it on every save. Then on the report you display that field.

Hope that helped!

Legacy Contributor

I think I'm going to try your second solution, thank you for your response!

Legacy Contributor

My SQL statement is as follows: (not using item as this table is filtered based on item in the report)

SELECT value FROM dbo.ue_hm_DrawingInformation WHERE label='DASH NUM PL'

Value=Engineering Description

Label=Engineering Label

ue_hm_DrawingInformation =My Table

I have tried to modify this but doesn't work,.

Stephen Cena

If this is being done in a derived field, the statement can be simplified. In the 'Implementation' field, try something like this:
CASE

WHEN (EngineeringLabel='DASH NUM PL') THEN '---'
ELSE '...'
END

Note that the SQL statements need to reference the IDO Property names and not the SQL table column names.

Try that and see what happened.

Legacy Contributor

It works on the form however ,when using the derived field on the report it returns nothing.

My SQL Statement based on your input:

CASE
WHEN (Label='DASH NUM PL') THEN VALUE
ELSE 'TEST'
END

On the form it shows the value and then test when doesn't meet the requirement but on the report when i add the collection to the report and link them using item as shown below:

it doesn't return anything, not sure why ?

Thanks again for your valuable input.

Copyright © 2025 Infor. All rights reserved.