Multiple Table Update on an Updateable Dashboard

Yahoo Archive
1
There is no cheating Ken, only winning ☺

Rob Bucek
Production Control Manager
PH: (715) 284-5376 ext 311
Mobile: (715)896-3119
FAX: (715)284-4084
[cid:1.234354861@...]<http://www.dsmfg.com/>
(Click the logo to view our site)<http://www.dsmfg.com/>

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Monday, July 21, 2014 12:40 PM
To: vantage
Subject: Re: [Vantage] Multiple Table Update on an Updateable Dashboard


Thanks Rob, not sure why I didn't remember that you can update multiple as long as they show in the tree view. We were able to update QuoteHed & QuoteDtl together. We then cheated on the Task and put it as a separate panel in the same dashboard.


On Fri, Jul 18, 2014 at 12:27 PM, Rob Bucek rbucek@...<mailto:rbucek@...> [vantage] <vantage@yahoogroups.com<mailto:vantage@yahoogroups.com>> wrote:


Ken,

I have updateable BAQ’s updating multiple tables. I have them doing it one of two ways depending on the tree structure brought in by the business object chosen under the Update Processing tab. If the tables you want are all associated as parent children in the tree structure you can update any of those tables assuming you meet business logic rules that are in place for the given fields you are trying to modify. If your table structure isn’t a natural join or you are attempting to update data and need to circumvent BL, then advanced BPM processing is your friend.

Rob Bucek
Production Control Manager
PH: (715) 284-5376 ext 311<tel:%28715%29%20284-5376%20ext%20311>
Mobile: (715)896-3119<tel:%28715%29896-3119>
FAX: (715)284-4084<tel:%28715%29284-4084>
[cid:1.234354861@...<mailto:cid%3A1.234354861@...>]<http://www.dsmfg.com/>
(Click the logo to view our site)<http://www.dsmfg.com/>

From: vantage@yahoogroups.com<mailto:vantage@yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage@yahoogroups.com>]
Sent: Friday, July 18, 2014 11:08 AM
To: vantage
Subject: [Vantage] Multiple Table Update on an Updateable Dashboard

Is there any method for being able to update multiple tables from a single BAQ?

We've got a Quote Dashboard we've created, we'd like to be able to update QuoteHed, QuoteDtl & Task fields from this dashboard. Is it possible?

[Non-text portions of this message have been removed]




[Non-text portions of this message have been removed]
2
Is there any method for being able to update multiple tables from a single BAQ?

We've got a Quote Dashboard we've created, we'd like to be able to update QuoteHed, QuoteDtl & Task fields from this dashboard. Â Is it possible?
3
Thank you for contacting IQuum, Inc. Effective June 9th, 2014, IQuum, Inc. became a wholly owned subsidiary of Roche Molecular Systems, Inc. Going forward, my new email address is adam.riffer@.... Please direct future correspondence there. Please note my IQuum e-mail address may not be functional after September 1, 2014. If you have any questions, please respond to me directly.
4
Thank you for contacting IQuum, Inc. Effective June 9th, 2014, IQuum, Inc. became a wholly owned subsidiary of Roche Molecular Systems, Inc. Going forward, my new email address is adam.riffer@.... Please direct future correspondence there. Please note my IQuum e-mail address may not be functional after September 1, 2014. If you have any questions, please respond to me directly.
5
Thank you for contacting IQuum, Inc. Effective June 9th, 2014, IQuum, Inc. became a wholly owned subsidiary of Roche Molecular Systems, Inc. Going forward, my new email address is adam.riffer@.... Please direct future correspondence there. Please note my IQuum e-mail address may not be functional after September 1, 2014. If you have any questions, please respond to me directly.
6
Thank you for contacting IQuum, Inc. Effective June 9th, 2014, IQuum, Inc. became a wholly owned subsidiary of Roche Molecular Systems, Inc. Going forward, my new email address is adam.riffer@.... Please direct future correspondence there. Please note my IQuum e-mail address may not be functional after September 1, 2014. If you have any questions, please respond to me directly.
7
Thank you for contacting IQuum, Inc. Effective June 9th, 2014, IQuum, Inc. became a wholly owned subsidiary of Roche Molecular Systems, Inc. Going forward, my new email address is adam.riffer@.... Please direct future correspondence there. Please note my IQuum e-mail address may not be functional after September 1, 2014. If you have any questions, please respond to me directly.
8
Thank you for contacting IQuum, Inc. Effective June 9th, 2014, IQuum, Inc. became a wholly owned subsidiary of Roche Molecular Systems, Inc. Going forward, my new email address is adam.riffer@.... Please direct future correspondence there. Please note my IQuum e-mail address may not be functional after September 1, 2014. If you have any questions, please respond to me directly.
9
Thank you for contacting IQuum, Inc. Effective June 9th, 2014, IQuum, Inc. became a wholly owned subsidiary of Roche Molecular Systems, Inc. Going forward, my new email address is adam.riffer@.... Please direct future correspondence there. Please note my IQuum e-mail address may not be functional after September 1, 2014. If you have any questions, please respond to me directly.
10
Thank you for contacting IQuum, Inc. Effective June 9th, 2014, IQuum, Inc. became a wholly owned subsidiary of Roche Molecular Systems, Inc. Going forward, my new email address is adam.riffer@.... Please direct future correspondence there. Please note my IQuum e-mail address may not be functional after September 1, 2014. If you have any questions, please respond to me directly.
11
Thank you for contacting IQuum, Inc. Effective June 9th, 2014, IQuum, Inc. became a wholly owned subsidiary of Roche Molecular Systems, Inc. Going forward, my new email address is adam.riffer@.... Please direct future correspondence there. Please note my IQuum e-mail address may not be functional after September 1, 2014. If you have any questions, please respond to me directly.
12
Thank you for contacting IQuum, Inc. Effective June 9th, 2014, IQuum, Inc. became a wholly owned subsidiary of Roche Molecular Systems, Inc. Going forward, my new email address is adam.riffer@.... Please direct future correspondence there. Please note my IQuum e-mail address may not be functional after September 1, 2014. If you have any questions, please respond to me directly.
13
Weee! We got another one!

Tom Christie | Information Technology Manager | AGM Container Controls, Inc.<http://www.agmcontainer.com/> | tchristie@...<mailto:tchristie@...> | t: 520.881.2130 ext 2176

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Friday, July 18, 2014 9:11 AM
To: vantage@yahoogroups.com
Subject: Re: Re: Re: Re: Re: Re: Re: Re: Re: Re: [Vantage] Multiple Table Update on an Updateable Dashboard



Thank you for contacting IQuum, Inc. Effective June 9th, 2014, IQuum, Inc. became a wholly owned subsidiary of Roche Molecular Systems, Inc. Going forward, my new email address is adam.riffer@.... Please direct future correspondence there. Please note my IQuum e-mail address may not be functional after September 1, 2014. If you have any questions, please respond to me directly.



[Non-text portions of this message have been removed]
14

Write a BPM that will do this…

 

With the Advanced BPM processing

 

 

Marco Vissuet

Production Control (San Diego Division)

Systems Engineer (Corporate)

Pacific Contours Corporation

Cell (619)507-2311

San Diego Office (619)670-3900

Anaheim Office (714) 693-1260

Fax (619) 670-1643

mvissuet@...

http://www.pacificcontours.com/

"The information contained herein may be subject to the International Traffic in Arms Regulations (ITAR) Warning: - This document contains data whose export is restricted by the Arms Export Control Act (Title 22, U.S.C., Sec 2751, et seq.) as amended, or the Export Administration Act (Title 50, U.S.C., App 2401 et seq.) as amended. Violations of these export laws are subject to severe criminal and civil penalties.  Disseminate in accordance with provisions of DoD Directive 5230.25.

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Friday, July 18, 2014 9:08 AM
To: vantage
Subject: [Vantage] Multiple Table Update on an Updateable Dashboard

 

 

Is there any method for being able to update multiple tables from a single BAQ?

 

We've got a Quote Dashboard we've created, we'd like to be able to update QuoteHed, QuoteDtl & Task fields from this dashboard.  Is it possible?

15
Ken,

I have updateable BAQ’s updating multiple tables. I have them doing it one of two ways depending on the tree structure brought in by the business object chosen under the Update Processing tab. If the tables you want are all associated as parent children in the tree structure you can update any of those tables assuming you meet business logic rules that are in place for the given fields you are trying to modify. If your table structure isn’t a natural join or you are attempting to update data and need to circumvent BL, then advanced BPM processing is your friend.

Rob Bucek
Production Control Manager
PH: (715) 284-5376 ext 311
Mobile: (715)896-3119
FAX: (715)284-4084
[cid:1.234354861@...]<http://www.dsmfg.com/>
(Click the logo to view our site)<http://www.dsmfg.com/>

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Friday, July 18, 2014 11:08 AM
To: vantage
Subject: [Vantage] Multiple Table Update on an Updateable Dashboard


Is there any method for being able to update multiple tables from a single BAQ?

We've got a Quote Dashboard we've created, we'd like to be able to update QuoteHed, QuoteDtl & Task fields from this dashboard. Is it possible?



[Non-text portions of this message have been removed]
16
Thanks Rob, not sure why I didn't remember that you can update multiple as long as they show in the tree view. Â We were able to update QuoteHed & QuoteDtl together. Â We then cheated on the Task and put it as a separate panel in the same dashboard.


On Fri, Jul 18, 2014 at 12:27 PM, Rob Bucek rbucek@... [vantage] <vantage@yahoogroups.com> wrote:

 
<div>
  
  
  <p>Ken,


I have updateable BAQ’s updating multiple tables. I have them doing it one of two ways depending on the tree structure brought in by the business object chosen under the Update Processing tab. If the tables you want are all associated as parent children in the tree structure you can update any of those tables assuming you meet business logic rules that are in place for the given fields you are trying to modify. If your table structure isn’t a natural join or you are attempting to update data and need to circumvent BL, then advanced BPM processing is your friend.

Rob Bucek
Production Control Manager
PH: (715) 284-5376 ext 311
Mobile: (715)896-3119
FAX: (715)284-4084
[cid:1.234354861@...]<http://www.dsmfg.com/>
(Click the logo to view our site)<http://www.dsmfg.com/>

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Friday, July 18, 2014 11:08 AM

To: vantage
Subject: [Vantage] Multiple Table Update on an Updateable Dashboard



Is there any method for being able to update multiple tables from a single BAQ?


We've got a Quote Dashboard we've created, we'd like to be able to update QuoteHed, QuoteDtl & Task fields from this dashboard. Is it possible?


[Non-text portions of this message have been removed]

</div>
 


<div style="color:#fff;min-height:0;"></div>