When I create a new Matrix Item and use a Dimension Set that we've previously saved (shoe size is what we use as Dimension 1), is there a way to get the Attribute value of Dimension 1 to automatically fill Subdescription 1? Again, for us, the Attribute of Dimension 1 is shoe size - and we want Subdescription 1 to be shoe size. If this can't happen automatically, is there a script we can run to have Dimension 1 fill Subdescription 1?
Thanks,
Additional info: We used to run the following script to get Subdescription 1 filled with the size, but that was with 1.3, maybe because Matrix Detail1 is now called Dimension1 it's not working? I know we had to change some other scripts because of name changes from 1.3 to 2.0. Here's the script...
-- 2.2. Move Matrix Detail1 to SubDescription1 (Only if SubDescription1 is blank, otherwise leave it as is - NOTE - if you are changing a size that's already existing, you need to physically change the size in the parent item and in the Subdescription1):
UPDATE Item SET Item.SubDescription1 = b.Detail1 FROM Item LEFT JOIN (SELECT Itemid, ItemClassID, Detail1, Detail2, Detail3 FROM ItemClassComponent LEFT JOIN ItemClass ON ItemClassComponent.ItemClassID = ItemClass.ID WHERE ClassType = 0) b ON Item.ID = b.ItemID LEFT JOIN ItemClass ON b.ItemClassID = ItemClass.ID WHERE b.Detail1 IS NOT NULL AND Item.SubDescription1 IS NULL
hi Kris, as far as the structure concern it is same, some more fields are added to the itemclass table. but update should work and I tried already this. Let me know how you are handling using the proceudre or trigger make sure the trigger is enabled and created in the RMS 2.0 database.
Akber
"Kris" wrote:
BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.