• Replies 1 reply
  • Subscribers 337 subscribers
  • Views 60 views
  • Users 0 members are here
Related

Adding Prod Season into List Manager criteria

Tina Treants
$organization

We have tried for some time to add Production Season into List Manager as a criteria for lists. We do have a local ticket history table LP_Tck_hist. Can someone please layout the values needed for the various columns. I keep getting an Invalid Column Name error with regard to my value of !.prod_season. in Detail Column

Thanks in advance for your help.

Tina

Parents
  • $organization

    Hi Tina,

    Since local tables can vary from org to org, it is hard to tell you what your column information should be. If you can confirm that the table has a prod_season column it would probably be similar to our Season column, which would make it...

    Data Type = Number
    Edit Mask = (blank)
    Detail Tble = (name of your local table)
    Detail Col = !.prod_season
    Ref Tbl = vrs_season
    Ref Idcol = id
    Ref Desccol = description

    If you have not confirmed that there is a production season column I would suspect you don't have one.
    (edit: you probably have some sort of column for season, but it might night be named prod_season, like for example ours is just named season)
    Also, most local tables start with LT not LP, which suggests you are pointing to a local procedure which would not work.



    [edited by: Ryan Rowell at 2:22 PM (GMT -6) on 30 May 2012]
Reply
  • $organization

    Hi Tina,

    Since local tables can vary from org to org, it is hard to tell you what your column information should be. If you can confirm that the table has a prod_season column it would probably be similar to our Season column, which would make it...

    Data Type = Number
    Edit Mask = (blank)
    Detail Tble = (name of your local table)
    Detail Col = !.prod_season
    Ref Tbl = vrs_season
    Ref Idcol = id
    Ref Desccol = description

    If you have not confirmed that there is a production season column I would suspect you don't have one.
    (edit: you probably have some sort of column for season, but it might night be named prod_season, like for example ours is just named season)
    Also, most local tables start with LT not LP, which suggests you are pointing to a local procedure which would not work.



    [edited by: Ryan Rowell at 2:22 PM (GMT -6) on 30 May 2012]
Children
No Data