Exclude additional records

Former Member — Tue, 19 Oct 2010 05:50:21 GMT

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

Re: Exclude additional records

Former Member — Wed, 20 Oct 2010 11:34:00 GMT

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