Skip to Content
0
Former Member
Dec 04, 2008 at 03:10 PM

Trouble with restricting objects with same name

27 Views

Hello everyone,

I have a query with customer contacts. Those contacts have a reason code.

The technical name of the reason code consists of the reason group en the reason code.

For example: ZE0004/ZK04 (ZE0004 is reason group, ZK04 is reason code)

The reason code ZK04 is an old one, and cannot be used anymore.

Instead a new reason got the same code, but with another reason group; ZE0006/ZK04.

User only desire ZE0004/ZK04 in the query for records prior to this change. But since ZE0006/ZK04 exists I cannot select the first in the query.

As a result, the query shows the customer contacts with reason code ZE0006/ZK04,which is the wrong one!

How am I able to restrict the reason code to ZE0004/ZK04 and only see the results for this reason code?