Skip to Content
0

Showing cardName in addition to CardCode in selection critetia

Dec 11, 2017 at 11:22 AM

61

avatar image
Former Member

Hello;

I have a parameter OCRD.CardCode.

On selecting criteria I see only CardCode and # of records.

how to present the CradName in the selection criteria .

Thanks

Dov.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

4 Answers

avatar image
Former Member Dec 12, 2017 at 01:39 PM
0

Hi,

That's what I want but on criteria selection Dovi am getting CardCode column and Number of records column

Share
10 |10000 characters needed characters left characters exceeded
I H Dec 14, 2017 at 06:00 AM
0

you can do as

where t0.[cardname]=[0%]

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Dec 15, 2017 at 03:36 PM
0

Hi.

I tried this

SELECT T0.[CardCode], T0.[CardName] FROM OCRD T0 where T0.[CardCode]=[%0]

or

SELECT T0.[CardCode], T0.[CardName] FROM OCRD T0 where T0.[CardName]=[%0]

It does not work I am still getting on specified criteria either CardCode OR CardName but not both .

Show 1 Share
10 |10000 characters needed characters left characters exceeded

what is the purpose for you to display cardname and cardcode at the selection criteria? Because both are actually similar.

But, if you still want the selection criteria to display both cardname and cardcode, i think you can try this.

SELECT T0.[CardCode], T0.[CardName]

FROM OCRD T0

where T0.[CardCode]=[%0] or T0.[CardName]=[%1]

0
Robert Joesel Dec 12, 2017 at 01:22 PM
0

Hi Dov,

do you want something like this

SELECT T0.[CardCode], T0.[CardName] FROM OCRD T0

this will give you the Business Partner Code and the Business Partner Name

Share
10 |10000 characters needed characters left characters exceeded