Limit a child IDO in a Dataview to single result

I'm trying to modify Dataview for a user so it includes a transaction date and transaction number from SLMatlTrans. The logic/linking is working great, but it's returning every record that matches. I only want the first record (I'm sorting by descended). Is it possible in the Dataview setup to achieve this or will I simply have to write a CLM so I can grab the earliest date?

Find more posts tagged with

General Discussions

Accepted answers

All comments

Rees Howel

I think this would be best handled via a Derived Property in the Parent IDO rather than trying to limit a child IDO. The Implementation in the Derived Property should accommodate select top 1 x type statements.

Stephen Cena

I like that. And of course, since I posted this question the request/project is being sidelined for the moment.

unknown

My recommendation is to go with the CLM - especially when going against SLMatlTrans. Is this going to replace the existing report or be a different report? If a different report you might want to create a new IDO (and/or copy/derive from the standard) so that users of the standard report don't need to pay the price/overhead of additional data being retrieved that they don't need.

Copyright © 2025 Infor. All rights reserved.