We created an updatable dashboard so our purchasing department can mass change our sheet part number to the roll stock part number. The problem is that it is not updating the description with the part description like it would if we did it manually. Any insight on this?
We’d need more information on how your UBAQ is set up to help diagnose. Which fields are updateable, what BO(s) is it calling, etc.?
You could either try to tweak the UBAQ to do this, or create an event in Application Studio to perform a GetByID with the updated part number to pull in the new description, depending on which way you want to go.
1 Like
Please see the attached. I would prefer to keep it to this query, but if that is not possible, I would not be opposed to an event. Our current workaround is a Vlookup on the part description that way the user can copy and paste directly back into the dashboard.
Add the Part table joined to JobMtl
Then the “Expression” for the material description will be (you will override it to) ttResult.Part_PartDescription
1 Like
The UpdateExt methods bypass a lot of the logic that is in the application. I believe any “change” method is skipped, which would explain why the description is not updated as the change in the part number is not triggering the change part number method.
3 Likes
I tried this in Pilot and it did not work. I thought that would work like it did with the BuyIt check box.
This is from Pilot
So it might not be possible to do this via the BAQ 
You can, but it would require “advanced baq” using code.
2 Likes
So can he not just use Update instead of UpdateExt? I guess I am just surprised (but not) at the limitation.
1 Like
UBAQs use UpdateExt and you can’t change it unless you do an Advanced one like @Chris_Conn said.
2 Likes
Oh well there you go.
1 Like
I will be researching advanced updatable BAQs
Not to discourage you too much, but be very careful. You can do bad things to your system\records quite easily.
2 Likes
So would you recommend an event in App Studio instead?