23.12.2024
11:25
Hi Guys,
I need your help to solve a problem.
I have an itemliste looks similar to this:
System-ID | System-Cost
100 | 1.000
100 | 1.500
200 | 2.000
300 | 100
300 | 1000
300 | 500
I need to find the System-ID with the highest cost over all and save this ID in a technical field to use ist further in the prozess.
Thanks in advance
23.12.2024
12:01
Hi,
you can do this using SQL
SELECT top 1 DET_Att1
FROM WFElementDetails
WHERE DET_WFDID = {WFD_ID}
AND DET_WFCONID = {WFCON:xxx}
ORDER BY DET_Att2 DESC
You need to replace:
xxx - your list ID
DET_Att1 - System-ID column
DET_Att2 - System-Cost column
Regards
23.12.2024
12:47
Hi,
you can do this using SQL
SELECT top 1 DET_Att1
FROM WFElementDetails
WHERE DET_WFDID = {WFD_ID}
AND DET_WFCONID = {WFCON:xxx}
ORDER BY DET_Att2 DESC
You need to replace:
xxx - your list ID
DET_Att1 - System-ID column
DET_Att2 - System-Cost column
Regards
Hei, thanks for quick reply!!
This works :-)
