Code Works One Way but Not Another When Testing For Values

ritagr · March 21st, 2013, 06:03 PM

Hello.

I have the following XML data.

Code:

        <DETAIL>
            <DETAILLINE>
                <SEQUENCE>000001</SEQUENCE>
                <RCDATA>
                    <RCDATALINE>
                        <RC>BR</RC>
                        <RCOVERRIDE>Y</RCOVERRIDE>
                    </RCDATALINE>
                    <RCDATALINE>
                        <RC>38</RC>
                        <RCOVERRIDE>N</RCOVERRIDE>
                    </RCDATALINE>
                </RCDATA>
            </DETAILLINE>
            <DETAILLINE>
                <SEQUENCE>000002</SEQUENCE>
                <RCDATA>
                    <RCDATALINE>
                        <RC>WU</RC>
                        <RCOVERRIDE>Y</RCOVERRIDE>
                    </RCDATALINE>
                    <RCDATALINE>
                        <RC>40</RC>
                        <RCOVERRIDE>N</RCOVERRIDE>
                    </RCDATALINE>
                </RCDATA>
            </DETAILLINE>
        </DETAIL>

I have this code that works correctly when checking for a <RC> not = 40.

Code:

/doc/EOB/DETAIL/DETAILLINE/RCDATA/RCDATALINE[RC!='40'][RC!=''][RCOVERRIDE!='Y']

However, when I want to test for a <RC> = 'WU' or 'WX', nothing is returned.

Code:

/doc/EOB/DETAIL/DETAILLINE/RCDATA/RCDATALINE[RC='WU'][RC='WX'][RCOVERRIDE!='Y']

I can create two separate tests but think there has to be a better way than this clumsy solution.

Thanks,
Rita

mhkay · March 22nd, 2013, 05:16 AM

It's perfectly possible for an RC value to be not equal to '' and not equal to '40' at the same time, but it's quite hard to be equal to 'WU' and equal to 'WX' at the same time.

ritagr · March 22nd, 2013, 12:55 PM

Yes, thank you, I see that now.
I was thinking that sentence equated to testing for RC = 'WU' OR 'WX'.