Skip to Content
avatar image
Former Member

Showing cardName in addition to CardCode in selection critetia

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

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

    Hi,

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

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 14, 2017 at 06:00 AM

    you can do as

    where t0.[cardname]=[0%]

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 15, 2017 at 03:36 PM

    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 .

    Add comment
    10|10000 characters needed 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]

  • Dec 12, 2017 at 01:22 PM

    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

    Add comment
    10|10000 characters needed characters exceeded