Personalization, Customization and Productivity Tools

[csrogers2]

Is there a way to add the Item Extended Description field to the grid of the Item View?  I don't see it as an available field,

[Gator]

The only thing I can think of is to add a UDF to the item table (CI_Item) for the the extended description and then right a script to populate this UDF from the extended description table (CI_ExtendedDescription).

You can probably also add a Pre-Write script to the CI_Item table to update the value of the UDF if someone changes it.

[csrogers2]

Thanks Gator.  I think that is probably the way to go.  One of my colleagues came up with that same approach, and he is going to assist me in writing the script.

[jepritch]

Hi Charles,

I think to add the Extended Description to the view you'd have to be a master developer, in developer studio.  Gator's idea, can be done without scripting by just sourcing your udf to the ExtendedDescription table using the ExtendedDescKey.  However, you'd have to do a pass on the table to populate this for existing items.

Hope this helps

Elliott