Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Exclude additional records

Former Member

‎2010 Oct 19 6:50 AM

0 Kudos
183

Hi all,

We have a infoset and query, which were working fine so far.

I have one zfield in my infoset, in my query output, this zfield will show 1 as value for one record.

But due to some scenarios, the value 1 is coming for multiple records in my output.

So i want to see only first record in my output, if more than one record with value 1 for my zfield.

Ex: If 3 records displaying with 1 as output value for my zfield, i want to see only the first record and the rest should be excluded.

Hope this can be done using CHECK function in record processing section of coding area in SQ02.

Thanks in Advance.

Regards,

Srinu

1 REPLY 1

Former Member

‎2010 Oct 20 12:34 PM

0 Kudos
89

Hi,

check the tables used in the infoset to identify the one(s) that deliver more than one entry for your selection criteria in the query.

Define your selection criteria in the query in a way (or restrict it in the infoset-definition) that those tables deliver only one record.

Best regards, Christian