Help to find the table and field for a grid view column

Yahoo Archive
1
I've done an extensive amount of work with the scheduling system and have pretty much picked apart how and where everything flows on that side of the fence. If the table is showing multiple resources assigned to one job/asm/oper my initial guess is that it could be one of two reasons (the third is its broke, well ignore that possibility for now). The first is that you have multiple scheduling blocks defined at the job/oper level in that BOO. The other is that one is the actual resource scheduled, the other may be from a 'what if' schedule. Look at the whatif column to determine that (it's a whatif schedule when the value is 1). Feel free to shoot me some screen shots off line if that doesn't shake out.



Rob Bucek
Production Control Manager
PH: (715) 284-5376 ext 311
Mobile: (715)896-4832
FAX: (715)284-4084
[Description: 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] On Behalf Of Karen Schoenung
Sent: Wednesday, September 19, 2012 10:12 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: Help to find the table and field for a grid view column



How did you know that I just also got that answer from Epicor...However, resourcetimeused shows multiple resourceIDs for this job and operation - what tells me the one that is actually scheduled?

From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf Of Rob Bucek
Sent: Wednesday, September 19, 2012 9:45 AM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Re: Help to find the table and field for a grid view column

resourcetimeused

Rob Bucek
Production Control Manager
PH: (715) 284-5376 ext 311
Mobile: (715)896-4832
FAX: (715)284-4084
[Description: cid:1.234354861@...<mailto:1.234354861%40web65412.mail.ac4.yahoo.com><mailto:1.234354861%40web65412.mail.ac4.yahoo.com>]<http://www.dsmfg.com/>
(Click the logo to view our site)<http://www.dsmfg.com/>

From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>] On Behalf Of Karen Schoenung
Sent: Wednesday, September 19, 2012 8:40 AM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Re: Help to find the table and field for a grid view column

The job I was checking into actually showed the second resource in the grid, but the detail tab has the field blank...

From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>] On Behalf Of b_ordway
Sent: Tuesday, September 18, 2012 4:47 PM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Re: Help to find the table and field for a grid view column

FYI...
I got curious about this one.
I tried changing a Resource & then rescheduling.

The ResourceID did show up in JobOprDtl then.
I wonder if it is just blank when it is the 1st or default resource in a group?

--- In vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>, "b_ordway" <cooner_55421@...<mailto:cooner_55421@...<mailto:cooner_55421@...%3cmailto:cooner_55421@...>>> wrote:
>
> Now that I looked a little closer you are correct.
> Even a the trace they are still using JobResources.
>
> Sorry, I was looking at the ResourceGrpID.
>
> --- In vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>, Karen Schoenung <kschoenung@> wrote:
> >
> > No Luck, the resourceID field is empty in JobOpDtl for a job that shows a resourceID in this grid...
> >
> > From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>] On Behalf Of b_ordway
> > Sent: Tuesday, September 18, 2012 11:33 AM
> > To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>
> > Subject: [Vantage] Re: Help to find the table and field for a grid view column
> >
> >
> >
> > You can try JobOpDtl.
> > JobResources is a collection which Epicor uses a lot for the grids on forms.
> >
> > I'm pretty sure they use the collections so they can load just the fields needed rather than the whole table.
> > Saving time for the client...
> >
> > --- In vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>, "Karen Schoenung" <kschoenung@<mailto:kschoenung@>> wrote:
> > >
> > > Hi,
> > >
> > > I want to find the table that holds the field shown in the "grid" view on job tracker, job details tab, operations tab,scheduling resources tab, scheduling resources tab, column named ResourceID...This shows it is from JobResources.ResourceID...But there is no table named JobResources...It shows it is "like" resource.resourceID...But the resource group could have one of two resources...How can I find out which of the resources is scheduled for this job?
> > >
> > > Thank you.
> > >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>

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

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

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



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

I want to find the table that holds the field shown in the "grid" view on job tracker, job details tab, operations tab,scheduling resources tab, scheduling resources tab, column named ResourceID...This shows it is from JobResources.ResourceIDÂ…But there is no table named JobResourcesÂ…It shows it is "like" resource.resourceIDÂ…But the resource group could have one of two resourcesÂ…How can I find out which of the resources is scheduled for this job?

Thank you.
3
You can try JobOpDtl.
JobResources is a collection which Epicor uses a lot for the grids on forms.

I'm pretty sure they use the collections so they can load just the fields needed rather than the whole table.
Saving time for the client...

--- In vantage@yahoogroups.com, "Karen Schoenung" <kschoenung@...> wrote:
>
> Hi,
>
> I want to find the table that holds the field shown in the "grid" view on job tracker, job details tab, operations tab,scheduling resources tab, scheduling resources tab, column named ResourceID...This shows it is from JobResources.ResourceIDÂ…But there is no table named JobResourcesÂ…It shows it is "like" resource.resourceIDÂ…But the resource group could have one of two resourcesÂ…How can I find out which of the resources is scheduled for this job?
>
> Thank you.
>
4
No Luck, the resourceID field is empty in JobOpDtl for a job that shows a resourceID in this grid...

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of b_ordway
Sent: Tuesday, September 18, 2012 11:33 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Help to find the table and field for a grid view column



You can try JobOpDtl.
JobResources is a collection which Epicor uses a lot for the grids on forms.

I'm pretty sure they use the collections so they can load just the fields needed rather than the whole table.
Saving time for the client...

--- In vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>, "Karen Schoenung" <kschoenung@...<mailto:kschoenung@...>> wrote:
>
> Hi,
>
> I want to find the table that holds the field shown in the "grid" view on job tracker, job details tab, operations tab,scheduling resources tab, scheduling resources tab, column named ResourceID...This shows it is from JobResources.ResourceID...But there is no table named JobResources...It shows it is "like" resource.resourceID...But the resource group could have one of two resources...How can I find out which of the resources is scheduled for this job?
>
> Thank you.
>



[Non-text portions of this message have been removed]
5
Now that I looked a little closer you are correct.
Even a the trace they are still using JobResources.

Sorry, I was looking at the ResourceGrpID.

--- In vantage@yahoogroups.com, Karen Schoenung <kschoenung@...> wrote:
>
> No Luck, the resourceID field is empty in JobOpDtl for a job that shows a resourceID in this grid...
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of b_ordway
> Sent: Tuesday, September 18, 2012 11:33 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: Help to find the table and field for a grid view column
>
>
>
> You can try JobOpDtl.
> JobResources is a collection which Epicor uses a lot for the grids on forms.
>
> I'm pretty sure they use the collections so they can load just the fields needed rather than the whole table.
> Saving time for the client...
>
> --- In vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>, "Karen Schoenung" <kschoenung@<mailto:kschoenung@>> wrote:
> >
> > Hi,
> >
> > I want to find the table that holds the field shown in the "grid" view on job tracker, job details tab, operations tab,scheduling resources tab, scheduling resources tab, column named ResourceID...This shows it is from JobResources.ResourceID...But there is no table named JobResources...It shows it is "like" resource.resourceID...But the resource group could have one of two resources...How can I find out which of the resources is scheduled for this job?
> >
> > Thank you.
> >
>
>
>
> [Non-text portions of this message have been removed]
>
6
FYI...
I got curious about this one.
I tried changing a Resource & then rescheduling.

The ResourceID did show up in JobOprDtl then.
I wonder if it is just blank when it is the 1st or default resource in a group?

--- In vantage@yahoogroups.com, "b_ordway" <cooner_55421@...> wrote:
>
> Now that I looked a little closer you are correct.
> Even a the trace they are still using JobResources.
>
> Sorry, I was looking at the ResourceGrpID.
>
> --- In vantage@yahoogroups.com, Karen Schoenung <kschoenung@> wrote:
> >
> > No Luck, the resourceID field is empty in JobOpDtl for a job that shows a resourceID in this grid...
> >
> > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of b_ordway
> > Sent: Tuesday, September 18, 2012 11:33 AM
> > To: vantage@yahoogroups.com
> > Subject: [Vantage] Re: Help to find the table and field for a grid view column
> >
> >
> >
> > You can try JobOpDtl.
> > JobResources is a collection which Epicor uses a lot for the grids on forms.
> >
> > I'm pretty sure they use the collections so they can load just the fields needed rather than the whole table.
> > Saving time for the client...
> >
> > --- In vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>, "Karen Schoenung" <kschoenung@<mailto:kschoenung@>> wrote:
> > >
> > > Hi,
> > >
> > > I want to find the table that holds the field shown in the "grid" view on job tracker, job details tab, operations tab,scheduling resources tab, scheduling resources tab, column named ResourceID...This shows it is from JobResources.ResourceID...But there is no table named JobResources...It shows it is "like" resource.resourceID...But the resource group could have one of two resources...How can I find out which of the resources is scheduled for this job?
> > >
> > > Thank you.
> > >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
7
The job I was checking into actually showed the second resource in the grid, but the detail tab has the field blank...

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of b_ordway
Sent: Tuesday, September 18, 2012 4:47 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Help to find the table and field for a grid view column



FYI...
I got curious about this one.
I tried changing a Resource & then rescheduling.

The ResourceID did show up in JobOprDtl then.
I wonder if it is just blank when it is the 1st or default resource in a group?

--- In vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>, "b_ordway" <cooner_55421@...<mailto:cooner_55421@...>> wrote:
>
> Now that I looked a little closer you are correct.
> Even a the trace they are still using JobResources.
>
> Sorry, I was looking at the ResourceGrpID.
>
> --- In vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>, Karen Schoenung <kschoenung@> wrote:
> >
> > No Luck, the resourceID field is empty in JobOpDtl for a job that shows a resourceID in this grid...
> >
> > From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf Of b_ordway
> > Sent: Tuesday, September 18, 2012 11:33 AM
> > To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
> > Subject: [Vantage] Re: Help to find the table and field for a grid view column
> >
> >
> >
> > You can try JobOpDtl.
> > JobResources is a collection which Epicor uses a lot for the grids on forms.
> >
> > I'm pretty sure they use the collections so they can load just the fields needed rather than the whole table.
> > Saving time for the client...
> >
> > --- In vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>, "Karen Schoenung" <kschoenung@<mailto:kschoenung@>> wrote:
> > >
> > > Hi,
> > >
> > > I want to find the table that holds the field shown in the "grid" view on job tracker, job details tab, operations tab,scheduling resources tab, scheduling resources tab, column named ResourceID...This shows it is from JobResources.ResourceID...But there is no table named JobResources...It shows it is "like" resource.resourceID...But the resource group could have one of two resources...How can I find out which of the resources is scheduled for this job?
> > >
> > > Thank you.
> > >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>



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

Rob Bucek
Production Control Manager
PH: (715) 284-5376 ext 311
Mobile: (715)896-4832
FAX: (715)284-4084
[Description: 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] On Behalf Of Karen Schoenung
Sent: Wednesday, September 19, 2012 8:40 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: Help to find the table and field for a grid view column



The job I was checking into actually showed the second resource in the grid, but the detail tab has the field blank...

From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf Of b_ordway
Sent: Tuesday, September 18, 2012 4:47 PM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Re: Help to find the table and field for a grid view column

FYI...
I got curious about this one.
I tried changing a Resource & then rescheduling.

The ResourceID did show up in JobOprDtl then.
I wonder if it is just blank when it is the 1st or default resource in a group?

--- In vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>, "b_ordway" <cooner_55421@...<mailto:cooner_55421@...>> wrote:
>
> Now that I looked a little closer you are correct.
> Even a the trace they are still using JobResources.
>
> Sorry, I was looking at the ResourceGrpID.
>
> --- In vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>, Karen Schoenung <kschoenung@> wrote:
> >
> > No Luck, the resourceID field is empty in JobOpDtl for a job that shows a resourceID in this grid...
> >
> > From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>] On Behalf Of b_ordway
> > Sent: Tuesday, September 18, 2012 11:33 AM
> > To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>
> > Subject: [Vantage] Re: Help to find the table and field for a grid view column
> >
> >
> >
> > You can try JobOpDtl.
> > JobResources is a collection which Epicor uses a lot for the grids on forms.
> >
> > I'm pretty sure they use the collections so they can load just the fields needed rather than the whole table.
> > Saving time for the client...
> >
> > --- In vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>, "Karen Schoenung" <kschoenung@<mailto:kschoenung@>> wrote:
> > >
> > > Hi,
> > >
> > > I want to find the table that holds the field shown in the "grid" view on job tracker, job details tab, operations tab,scheduling resources tab, scheduling resources tab, column named ResourceID...This shows it is from JobResources.ResourceID...But there is no table named JobResources...It shows it is "like" resource.resourceID...But the resource group could have one of two resources...How can I find out which of the resources is scheduled for this job?
> > >
> > > Thank you.
> > >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>

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



[Non-text portions of this message have been removed]
9
How did you know that I just also got that answer from Epicor...However, resourcetimeused shows multiple resourceIDs for this job and operation - what tells me the one that is actually scheduled?

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Rob Bucek
Sent: Wednesday, September 19, 2012 9:45 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: Help to find the table and field for a grid view column



resourcetimeused

Rob Bucek
Production Control Manager
PH: (715) 284-5376 ext 311
Mobile: (715)896-4832
FAX: (715)284-4084
[Description: cid:1.234354861@...<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>]<http://www.dsmfg.com/>
(Click the logo to view our site)<http://www.dsmfg.com/>

From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf Of Karen Schoenung
Sent: Wednesday, September 19, 2012 8:40 AM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Re: Help to find the table and field for a grid view column

The job I was checking into actually showed the second resource in the grid, but the detail tab has the field blank...

From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>] On Behalf Of b_ordway
Sent: Tuesday, September 18, 2012 4:47 PM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Re: Help to find the table and field for a grid view column

FYI...
I got curious about this one.
I tried changing a Resource & then rescheduling.

The ResourceID did show up in JobOprDtl then.
I wonder if it is just blank when it is the 1st or default resource in a group?

--- In vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>, "b_ordway" <cooner_55421@...<mailto:cooner_55421@...<mailto:cooner_55421@...%3cmailto:cooner_55421@...>>> wrote:
>
> Now that I looked a little closer you are correct.
> Even a the trace they are still using JobResources.
>
> Sorry, I was looking at the ResourceGrpID.
>
> --- In vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>, Karen Schoenung <kschoenung@> wrote:
> >
> > No Luck, the resourceID field is empty in JobOpDtl for a job that shows a resourceID in this grid...
> >
> > From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>] On Behalf Of b_ordway
> > Sent: Tuesday, September 18, 2012 11:33 AM
> > To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>
> > Subject: [Vantage] Re: Help to find the table and field for a grid view column
> >
> >
> >
> > You can try JobOpDtl.
> > JobResources is a collection which Epicor uses a lot for the grids on forms.
> >
> > I'm pretty sure they use the collections so they can load just the fields needed rather than the whole table.
> > Saving time for the client...
> >
> > --- In vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>, "Karen Schoenung" <kschoenung@<mailto:kschoenung@>> wrote:
> > >
> > > Hi,
> > >
> > > I want to find the table that holds the field shown in the "grid" view on job tracker, job details tab, operations tab,scheduling resources tab, scheduling resources tab, column named ResourceID...This shows it is from JobResources.ResourceID...But there is no table named JobResources...It shows it is "like" resource.resourceID...But the resource group could have one of two resources...How can I find out which of the resources is scheduled for this job?
> > >
> > > Thank you.
> > >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>

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

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



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