Merge Datasets Blank Title 117632

Yahoo Archive
1
No I have moved on to trying to build an updateable BAQ that allows me to change UDfields that then are mapped via BPM BOs to the actual data in the form I want to change.... it's not going well lol

reply Signature




Joshua Giese

CTO

920.437.6400 Ext. 337

Site ID: 27450-E905700B2-SQL64

----- Original Message -----

From: "tkoch77" <tkoch77@...>
To: vantage@yahoogroups.com
Sent: Wednesday, January 30, 2013 1:01:27 PM
Subject: [Vantage] Re: Merge Datasets



Did you ever find a way to accomplish this?

--- In vantage@yahoogroups.com , "jgiese1988" wrote:
>
> Yeah I have used that method in other screens for small datasets, but this one gets too large, would run way to slow :S
>
> --- In vantage@yahoogroups.com , Ted Koch wrote:
> >
> > This is a post from Jose, not sure if this would get you what you need...
> >
> > http://www.usdoingstuff.com/2012/06/15/add-column-to-grid-in-epicor-specifically-to-chart-tracker/
> >
> >
> >
> >
> > ________________________________
> > From: jgiese1988
> > To: vantage@yahoogroups.com
> > Sent: Thursday, January 24, 2013 10:49 AM
> > Subject: [Vantage] Re: Merge Datasets
> >
> > Sorry about that ha ha... The sucky part is the information in the Adjust Global Sched screen is the dataview "JobNum" but is all fields from JobHead just condensed down into 10 available fields. I just need a few more fields from JobHead that are not available in their "custom" dataview! BAH
> >
> > --- In vantage@yahoogroups.com , "Scotty K." wrote:
> > >
> > > Sorry, I misunderstood/misread your question.
> > > I have never had the need to add an additional table to a native grid, but
> > > I though I saw a post in the last year describing how....
> > >
> > > On Thu, Jan 24, 2013 at 9:25 AM, jgiese1988 <
> > > epicor-team@> wrote:
> > >
> > > > **
> > > >
> > > >
> > > > And the screen maintains functionality? I think I'm missing something
> > > > critical about your response? I mean if I build a new dashboard I can
> > > > create a BAQ that includes everything I need sure, but if I want to just
> > > > add read only columns to a native grid, and have the screen maintain it's
> > > > functionality that still doesn't get me where I need to be does it? I'm not
> > > > sure.
> > > >
> > > > --- In vantage@yahoogroups.com , "Scotty K." wrote:
> > > > >
> > > > > We do this with SQL Unions. We replicate progress data to SQL and then
> > > > > create external BAQs to pull into a dashboard.
> > > > > There is a rumor that the next release of ICE will give you the ablility
> > > > to
> > > > > use Unions in BAQs.
> > > > >
> > > > > Scott
> > > > >
> > > > > On Thu, Jan 24, 2013 at 8:00 AM, jgiese1988 <
> > > > > epicor-team@> wrote:
> > > > >
> > > > > > **
> > > > > >
> > > > > >
> > > > > > Is there any point or way in the system that you can merge two tables
> > > > > > together. I really would like to add more JobHead information to the
> > > > Adjust
> > > > > > Global Sched grid, so that we can sort jobs by certain fields, then
> > > > > > re-sequence them from there. I know I can load the data per row on
> > > > init,
> > > > > > but if you load even 250 jobs into the grid it's pretty slow. There
> > > > has to
> > > > > > be some way to do it on the back end or something no? Otherwise if I
> > > > built
> > > > > > a new dashboard that made the SchedSeq an updatable field, would that
> > > > work
> > > > > > just like the Adjust Global Sched form or does it do anything else
> > > > that I
> > > > > > would miss.
> > > > > >
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > > > [Non-text portions of this message have been removed]
> > > > >
> > > >
> > > >
> > > >
> > >
> > >
> > > [Non-text portions of this message have been removed]
> > >
> >
> >
> >
> >
> > ------------------------------------
> >
> > Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
> > (1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
> > (2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
> > (3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/linksYahoo ! Groups Links
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>





[Non-text portions of this message have been removed]
2
Is there any point or way in the system that you can merge two tables together. I really would like to add more JobHead information to the Adjust Global Sched grid, so that we can sort jobs by certain fields, then re-sequence them from there. I know I can load the data per row on init, but if you load even 250 jobs into the grid it's pretty slow. There has to be some way to do it on the back end or something no? Otherwise if I built a new dashboard that made the SchedSeq an updatable field, would that work just like the Adjust Global Sched form or does it do anything else that I would miss.
3
We do this with SQL Unions. We replicate progress data to SQL and then
create external BAQs to pull into a dashboard.
There is a rumor that the next release of ICE will give you the ablility to
use Unions in BAQs.

Scott

On Thu, Jan 24, 2013 at 8:00 AM, jgiese1988 <
epicor-team@...> wrote:

> **
>
>
> Is there any point or way in the system that you can merge two tables
> together. I really would like to add more JobHead information to the Adjust
> Global Sched grid, so that we can sort jobs by certain fields, then
> re-sequence them from there. I know I can load the data per row on init,
> but if you load even 250 jobs into the grid it's pretty slow. There has to
> be some way to do it on the back end or something no? Otherwise if I built
> a new dashboard that made the SchedSeq an updatable field, would that work
> just like the Adjust Global Sched form or does it do anything else that I
> would miss.
>
>
>


[Non-text portions of this message have been removed]
4
And the screen maintains functionality? I think I'm missing something critical about your response? I mean if I build a new dashboard I can create a BAQ that includes everything I need sure, but if I want to just add read only columns to a native grid, and have the screen maintain it's functionality that still doesn't get me where I need to be does it? I'm not sure.

--- In vantage@yahoogroups.com, "Scotty K." wrote:
>
> We do this with SQL Unions. We replicate progress data to SQL and then
> create external BAQs to pull into a dashboard.
> There is a rumor that the next release of ICE will give you the ablility to
> use Unions in BAQs.
>
> Scott
>
> On Thu, Jan 24, 2013 at 8:00 AM, jgiese1988 <
> epicor-team@...> wrote:
>
> > **
> >
> >
> > Is there any point or way in the system that you can merge two tables
> > together. I really would like to add more JobHead information to the Adjust
> > Global Sched grid, so that we can sort jobs by certain fields, then
> > re-sequence them from there. I know I can load the data per row on init,
> > but if you load even 250 jobs into the grid it's pretty slow. There has to
> > be some way to do it on the back end or something no? Otherwise if I built
> > a new dashboard that made the SchedSeq an updatable field, would that work
> > just like the Adjust Global Sched form or does it do anything else that I
> > would miss.
> >
> >
> >
>
>
> [Non-text portions of this message have been removed]
>
5
Sorry, I misunderstood/misread your question.
I have never had the need to add an additional table to a native grid, but
I though I saw a post in the last year describing how....

On Thu, Jan 24, 2013 at 9:25 AM, jgiese1988 <
epicor-team@...> wrote:

> **
>
>
> And the screen maintains functionality? I think I'm missing something
> critical about your response? I mean if I build a new dashboard I can
> create a BAQ that includes everything I need sure, but if I want to just
> add read only columns to a native grid, and have the screen maintain it's
> functionality that still doesn't get me where I need to be does it? I'm not
> sure.
>
> --- In vantage@yahoogroups.com, "Scotty K." wrote:
> >
> > We do this with SQL Unions. We replicate progress data to SQL and then
> > create external BAQs to pull into a dashboard.
> > There is a rumor that the next release of ICE will give you the ablility
> to
> > use Unions in BAQs.
> >
> > Scott
> >
> > On Thu, Jan 24, 2013 at 8:00 AM, jgiese1988 <
> > epicor-team@...> wrote:
> >
> > > **
> > >
> > >
> > > Is there any point or way in the system that you can merge two tables
> > > together. I really would like to add more JobHead information to the
> Adjust
> > > Global Sched grid, so that we can sort jobs by certain fields, then
> > > re-sequence them from there. I know I can load the data per row on
> init,
> > > but if you load even 250 jobs into the grid it's pretty slow. There
> has to
> > > be some way to do it on the back end or something no? Otherwise if I
> built
> > > a new dashboard that made the SchedSeq an updatable field, would that
> work
> > > just like the Adjust Global Sched form or does it do anything else
> that I
> > > would miss.
> > >
> > >
> > >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>


[Non-text portions of this message have been removed]
6
Sorry about that ha ha... The sucky part is the information in the Adjust Global Sched screen is the dataview "JobNum" but is all fields from JobHead just condensed down into 10 available fields. I just need a few more fields from JobHead that are not available in their "custom" dataview! BAH

--- In vantage@yahoogroups.com, "Scotty K." wrote:
>
> Sorry, I misunderstood/misread your question.
> I have never had the need to add an additional table to a native grid, but
> I though I saw a post in the last year describing how....
>
> On Thu, Jan 24, 2013 at 9:25 AM, jgiese1988 <
> epicor-team@...> wrote:
>
> > **
> >
> >
> > And the screen maintains functionality? I think I'm missing something
> > critical about your response? I mean if I build a new dashboard I can
> > create a BAQ that includes everything I need sure, but if I want to just
> > add read only columns to a native grid, and have the screen maintain it's
> > functionality that still doesn't get me where I need to be does it? I'm not
> > sure.
> >
> > --- In vantage@yahoogroups.com, "Scotty K." wrote:
> > >
> > > We do this with SQL Unions. We replicate progress data to SQL and then
> > > create external BAQs to pull into a dashboard.
> > > There is a rumor that the next release of ICE will give you the ablility
> > to
> > > use Unions in BAQs.
> > >
> > > Scott
> > >
> > > On Thu, Jan 24, 2013 at 8:00 AM, jgiese1988 <
> > > epicor-team@> wrote:
> > >
> > > > **
> > > >
> > > >
> > > > Is there any point or way in the system that you can merge two tables
> > > > together. I really would like to add more JobHead information to the
> > Adjust
> > > > Global Sched grid, so that we can sort jobs by certain fields, then
> > > > re-sequence them from there. I know I can load the data per row on
> > init,
> > > > but if you load even 250 jobs into the grid it's pretty slow. There
> > has to
> > > > be some way to do it on the back end or something no? Otherwise if I
> > built
> > > > a new dashboard that made the SchedSeq an updatable field, would that
> > work
> > > > just like the Adjust Global Sched form or does it do anything else
> > that I
> > > > would miss.
> > > >
> > > >
> > > >
> > >
> > >
> > > [Non-text portions of this message have been removed]
> > >
> >
> >
> >
>
>
> [Non-text portions of this message have been removed]
>
7
This is a post from Jose, not sure if this would get you what you need...

http://www.usdoingstuff.com/2012/06/15/add-column-to-grid-in-epicor-specifically-to-chart-tracker/




________________________________
From: jgiese1988 <epicor-team@...>
To: vantage@yahoogroups.com
Sent: Thursday, January 24, 2013 10:49 AM
Subject: [Vantage] Re: Merge Datasets

Sorry about that ha ha... The sucky part is the information in the Adjust Global Sched screen is the dataview "JobNum" but is all fields from JobHead just condensed down into 10 available fields. I just need a few more fields from JobHead that are not available in their "custom" dataview! BAH

--- In vantage@yahoogroups.com, "Scotty K."Â wrote:
>
> Sorry, I misunderstood/misread your question.
> I have never had the need to add an additional table to a native grid, but
> I though I saw a post in the last year describing how....
>
> On Thu, Jan 24, 2013 at 9:25 AM, jgiese1988 <
> epicor-team@...> wrote:
>
> > **
> >
> >
> > And the screen maintains functionality? I think I'm missing something
> > critical about your response? I mean if I build a new dashboard I can
> > create a BAQ that includes everything I need sure, but if I want to just
> > add read only columns to a native grid, and have the screen maintain it's
> > functionality that still doesn't get me where I need to be does it? I'm not
> > sure.
> >
> > --- In vantage@yahoogroups.com, "Scotty K." wrote:
> > >
> > > We do this with SQL Unions. We replicate progress data to SQL and then
> > > create external BAQs to pull into a dashboard.
> > > There is a rumor that the next release of ICE will give you the ablility
> > to
> > > use Unions in BAQs.
> > >
> > > Scott
> > >
> > > On Thu, Jan 24, 2013 at 8:00 AM, jgiese1988 <
> > > epicor-team@> wrote:
> > >
> > > > **
> > > >
> > > >
> > > > Is there any point or way in the system that you can merge two tables
> > > > together. I really would like to add more JobHead information to the
> > Adjust
> > > > Global Sched grid, so that we can sort jobs by certain fields, then
> > > > re-sequence them from there. I know I can load the data per row on
> > init,
> > > > but if you load even 250 jobs into the grid it's pretty slow. There
> > has to
> > > > be some way to do it on the back end or something no? Otherwise if I
> > built
> > > > a new dashboard that made the SchedSeq an updatable field, would that
> > work
> > > > just like the Adjust Global Sched form or does it do anything else
> > that I
> > > > would miss.
> > > >
> > > >
> > > >
> > >
> > >
> > > [Non-text portions of this message have been removed]
> > >
> >
> >Â
> >
>
>
> [Non-text portions of this message have been removed]
>




------------------------------------

Useful links for the Yahoo!Groups Vantage Board are: ( Note:Â You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.%c2%a0
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links



[Non-text portions of this message have been removed]
8
Yeah I have used that method in other screens for small datasets, but this one gets too large, would run way to slow :S

--- In vantage@yahoogroups.com, Ted Koch wrote:
>
> This is a post from Jose, not sure if this would get you what you need...
>
> http://www.usdoingstuff.com/2012/06/15/add-column-to-grid-in-epicor-specifically-to-chart-tracker/
>
>
>
>
> ________________________________
> From: jgiese1988
> To: vantage@yahoogroups.com
> Sent: Thursday, January 24, 2013 10:49 AM
> Subject: [Vantage] Re: Merge Datasets
>
> Sorry about that ha ha... The sucky part is the information in the Adjust Global Sched screen is the dataview "JobNum" but is all fields from JobHead just condensed down into 10 available fields. I just need a few more fields from JobHead that are not available in their "custom" dataview! BAH
>
> --- In vantage@yahoogroups.com, "Scotty K."Â wrote:
> >
> > Sorry, I misunderstood/misread your question.
> > I have never had the need to add an additional table to a native grid, but
> > I though I saw a post in the last year describing how....
> >
> > On Thu, Jan 24, 2013 at 9:25 AM, jgiese1988 <
> > epicor-team@> wrote:
> >
> > > **
> > >
> > >
> > > And the screen maintains functionality? I think I'm missing something
> > > critical about your response? I mean if I build a new dashboard I can
> > > create a BAQ that includes everything I need sure, but if I want to just
> > > add read only columns to a native grid, and have the screen maintain it's
> > > functionality that still doesn't get me where I need to be does it? I'm not
> > > sure.
> > >
> > > --- In vantage@yahoogroups.com, "Scotty K." wrote:
> > > >
> > > > We do this with SQL Unions. We replicate progress data to SQL and then
> > > > create external BAQs to pull into a dashboard.
> > > > There is a rumor that the next release of ICE will give you the ablility
> > > to
> > > > use Unions in BAQs.
> > > >
> > > > Scott
> > > >
> > > > On Thu, Jan 24, 2013 at 8:00 AM, jgiese1988 <
> > > > epicor-team@> wrote:
> > > >
> > > > > **
> > > > >
> > > > >
> > > > > Is there any point or way in the system that you can merge two tables
> > > > > together. I really would like to add more JobHead information to the
> > > Adjust
> > > > > Global Sched grid, so that we can sort jobs by certain fields, then
> > > > > re-sequence them from there. I know I can load the data per row on
> > > init,
> > > > > but if you load even 250 jobs into the grid it's pretty slow. There
> > > has to
> > > > > be some way to do it on the back end or something no? Otherwise if I
> > > built
> > > > > a new dashboard that made the SchedSeq an updatable field, would that
> > > work
> > > > > just like the Adjust Global Sched form or does it do anything else
> > > that I
> > > > > would miss.
> > > > >
> > > > >
> > > > >
> > > >
> > > >
> > > > [Non-text portions of this message have been removed]
> > > >
> > >
> > >Â
> > >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>
>
> ------------------------------------
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note:Â You must have already linked your email address to a yahoo id to enable access. )
> (1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.%c2%a0
> (2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
> (3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
>
>
>
> [Non-text portions of this message have been removed]
>
9
Did you ever find a way to accomplish this?

--- In vantage@yahoogroups.com, "jgiese1988" wrote:
>
> Yeah I have used that method in other screens for small datasets, but this one gets too large, would run way to slow :S
>
> --- In vantage@yahoogroups.com, Ted Koch wrote:
> >
> > This is a post from Jose, not sure if this would get you what you need...
> >
> > http://www.usdoingstuff.com/2012/06/15/add-column-to-grid-in-epicor-specifically-to-chart-tracker/
> >
> >
> >
> >
> > ________________________________
> > From: jgiese1988
> > To: vantage@yahoogroups.com
> > Sent: Thursday, January 24, 2013 10:49 AM
> > Subject: [Vantage] Re: Merge Datasets
> >
> > Sorry about that ha ha... The sucky part is the information in the Adjust Global Sched screen is the dataview "JobNum" but is all fields from JobHead just condensed down into 10 available fields. I just need a few more fields from JobHead that are not available in their "custom" dataview! BAH
> >
> > --- In vantage@yahoogroups.com, "Scotty K."Â wrote:
> > >
> > > Sorry, I misunderstood/misread your question.
> > > I have never had the need to add an additional table to a native grid, but
> > > I though I saw a post in the last year describing how....
> > >
> > > On Thu, Jan 24, 2013 at 9:25 AM, jgiese1988 <
> > > epicor-team@> wrote:
> > >
> > > > **
> > > >
> > > >
> > > > And the screen maintains functionality? I think I'm missing something
> > > > critical about your response? I mean if I build a new dashboard I can
> > > > create a BAQ that includes everything I need sure, but if I want to just
> > > > add read only columns to a native grid, and have the screen maintain it's
> > > > functionality that still doesn't get me where I need to be does it? I'm not
> > > > sure.
> > > >
> > > > --- In vantage@yahoogroups.com, "Scotty K." wrote:
> > > > >
> > > > > We do this with SQL Unions. We replicate progress data to SQL and then
> > > > > create external BAQs to pull into a dashboard.
> > > > > There is a rumor that the next release of ICE will give you the ablility
> > > > to
> > > > > use Unions in BAQs.
> > > > >
> > > > > Scott
> > > > >
> > > > > On Thu, Jan 24, 2013 at 8:00 AM, jgiese1988 <
> > > > > epicor-team@> wrote:
> > > > >
> > > > > > **
> > > > > >
> > > > > >
> > > > > > Is there any point or way in the system that you can merge two tables
> > > > > > together. I really would like to add more JobHead information to the
> > > > Adjust
> > > > > > Global Sched grid, so that we can sort jobs by certain fields, then
> > > > > > re-sequence them from there. I know I can load the data per row on
> > > > init,
> > > > > > but if you load even 250 jobs into the grid it's pretty slow. There
> > > > has to
> > > > > > be some way to do it on the back end or something no? Otherwise if I
> > > > built
> > > > > > a new dashboard that made the SchedSeq an updatable field, would that
> > > > work
> > > > > > just like the Adjust Global Sched form or does it do anything else
> > > > that I
> > > > > > would miss.
> > > > > >
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > > > [Non-text portions of this message have been removed]
> > > > >
> > > >
> > > >Â
> > > >
> > >
> > >
> > > [Non-text portions of this message have been removed]
> > >
> >
> >
> >
> >
> > ------------------------------------
> >
> > Useful links for the Yahoo!Groups Vantage Board are: ( Note:Â You must have already linked your email address to a yahoo id to enable access. )
> > (1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.%c2%a0
> > (2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
> > (3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>