Dataview Source

You can also just create your own view and replace the grid with one
populated by your new view.

However, you would probably be better off just updating the existing grid as
per your original plan.

If you open the Custom Object Explorer from the Customization Tools Dialog
you can view all the epiDataViews that are used on the form, along with the
code to read/update the values in particular fields. Where is your other
data coming from? If it is being entered on this form or another form that
uses the 'ActiveWork' epiDataView, you can just update it via the
epiDataView without worrying about what table it is actually on.

It's always good to know where your data is going, but technically speaking
you don't HAVE to.


On Wed, May 5, 2010 at 10:45 PM, Kevin Simon <ksimon8fw@...> wrote:

>
>
> Sean,
>
> Thanks for the idea. You wouldn't happen to have a little snippet of code
> that does something similar to this, would you? Fighting the syntax seems
> to be half the battle.
>
> Kevin
>
>
> From: vantage@yahoogroups.com <vantage%40yahoogroups.com> [mailto:
> vantage@yahoogroups.com <vantage%40yahoogroups.com>] On Behalf Of
> Sean McDaniel
> Sent: Wednesday, May 05, 2010 1:34 PM
>
> To: vantage@yahoogroups.com <vantage%40yahoogroups.com>
> Subject: RE: [Vantage] Dataview Source
>
> We've had problems updating the grids as well.
>
> One option is to add a textbox on the form (disable it) and then hook
> into the epiNotification initialize event to update the information in
> our textbox based on the selected row in the grid.
>
> Not ideal, but it gets the job done.
>
> From: vantage@yahoogroups.com <vantage%40yahoogroups.com> <mailto:
> vantage%40yahoogroups.com <vantage%2540yahoogroups.com>>
> [mailto:vantage@yahoogroups.com <vantage%40yahoogroups.com> <mailto:
> vantage%40yahoogroups.com <vantage%2540yahoogroups.com>> ] On
> Behalf
> Of Kevin Simon
> Sent: Wednesday, May 05, 2010 12:57 PM
> To: vantage@yahoogroups.com <vantage%40yahoogroups.com> <mailto:
> vantage%40yahoogroups.com <vantage%2540yahoogroups.com>>
> Subject: RE: [Vantage] Dataview Source
>
> Did that already. Work Queue just uses the same standard calls that you
> get
> if you start and end activity - it's using the Labor methods.
>
> What I tried is updating all the LaborHed.ShortChar01 fields to the
> value
> "LaborHed", the LaborDtl.ShortChar01 fields to the value "LaborDtl", and
> so
> on with JobHead, JobOper, JobOpDtl. Then, I was hoping to display the
> ShortChar01 on the grid that comes from the source "ActiveWork", and see
> what it displayed. It didn't display anything.
>
> Thanks.
>
> From: vantage@yahoogroups.com <vantage%40yahoogroups.com> <mailto:
> vantage%40yahoogroups.com <vantage%2540yahoogroups.com>>
> <mailto:vantage%40yahoogroups.com <vantage%2540yahoogroups.com>>
> [mailto:vantage@yahoogroups.com <vantage%40yahoogroups.com> <mailto:
> vantage%40yahoogroups.com <vantage%2540yahoogroups.com>>
> <mailto:vantage%40yahoogroups.com <vantage%2540yahoogroups.com>> ] On
> Behalf Of
> Sean McDaniel
> Sent: Wednesday, May 05, 2010 12:27 PM
> To: vantage@yahoogroups.com <vantage%40yahoogroups.com> <mailto:
> vantage%40yahoogroups.com <vantage%2540yahoogroups.com>>
> <mailto:vantage%40yahoogroups.com <vantage%2540yahoogroups.com>>
> Subject: RE: [Vantage] Dataview Source
>
> Try doing a trace. While doing an update. The methods used are typically
> close to the name of the tables used.
>
> From: vantage@yahoogroups.com <vantage%40yahoogroups.com> <mailto:
> vantage%40yahoogroups.com <vantage%2540yahoogroups.com>>
> <mailto:vantage%40yahoogroups.com <vantage%2540yahoogroups.com>>
> <mailto:vantage%40yahoogroups.com <vantage%2540yahoogroups.com>>
> [mailto:vantage@yahoogroups.com <vantage%40yahoogroups.com> <mailto:
> vantage%40yahoogroups.com <vantage%2540yahoogroups.com>>
> <mailto:vantage%40yahoogroups.com <vantage%2540yahoogroups.com>>
> <mailto:vantage%40yahoogroups.com <vantage%2540yahoogroups.com>> ] On
> Behalf
> Of ksimon8fw
> Sent: Wednesday, May 05, 2010 12:22 PM
> To: vantage@yahoogroups.com <vantage%40yahoogroups.com> <mailto:
> vantage%40yahoogroups.com <vantage%2540yahoogroups.com>>
> <mailto:vantage%40yahoogroups.com <vantage%2540yahoogroups.com>>
> <mailto:vantage%40yahoogroups.com <vantage%2540yahoogroups.com>>
> Subject: [Vantage] Dataview Source
>
> We're in Epicor 9 which has the WorkQueue module. When I open the
> customization, there's a grid view available, for which the source is
> "ActiveWork". However, "ActiveWork" is not a progress table, it is
> obviously some sort of "view", combining Labor and Job information.
>
> How do I find out what the source of that view is? I've got additional
> information I want to display in that grid, and I have UD fields
> available (ShortChar01 in this case). When I display ShortChar01 on the
> grid, it is obviously empty.
>
> I've updated the various ShortChar01 fields on other tables that this
> could pull from (LaborDtl, JobOper, JobOpDtl), but none of those values
> make it to the ActiveWork view.
>
> Does anyone know where to find this information?
>
> Thanks.
> Kevin
>
> [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]
We're in Epicor 9 which has the WorkQueue module. When I open the customization, there's a grid view available, for which the source is "ActiveWork". However, "ActiveWork" is not a progress table, it is obviously some sort of "view", combining Labor and Job information.

How do I find out what the source of that view is? I've got additional information I want to display in that grid, and I have UD fields available (ShortChar01 in this case). When I display ShortChar01 on the grid, it is obviously empty.

I've updated the various ShortChar01 fields on other tables that this could pull from (LaborDtl, JobOper, JobOpDtl), but none of those values make it to the ActiveWork view.

Does anyone know where to find this information?

Thanks.
Kevin
Try doing a trace. While doing an update. The methods used are typically
close to the name of the tables used.



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of ksimon8fw
Sent: Wednesday, May 05, 2010 12:22 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Dataview Source





We're in Epicor 9 which has the WorkQueue module. When I open the
customization, there's a grid view available, for which the source is
"ActiveWork". However, "ActiveWork" is not a progress table, it is
obviously some sort of "view", combining Labor and Job information.

How do I find out what the source of that view is? I've got additional
information I want to display in that grid, and I have UD fields
available (ShortChar01 in this case). When I display ShortChar01 on the
grid, it is obviously empty.

I've updated the various ShortChar01 fields on other tables that this
could pull from (LaborDtl, JobOper, JobOpDtl), but none of those values
make it to the ActiveWork view.

Does anyone know where to find this information?

Thanks.
Kevin





[Non-text portions of this message have been removed]
Did that already. Work Queue just uses the same standard calls that you get
if you start and end activity - it's using the Labor methods.



What I tried is updating all the LaborHed.ShortChar01 fields to the value
"LaborHed", the LaborDtl.ShortChar01 fields to the value "LaborDtl", and so
on with JobHead, JobOper, JobOpDtl. Then, I was hoping to display the
ShortChar01 on the grid that comes from the source "ActiveWork", and see
what it displayed. It didn't display anything.



Thanks.



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Sean McDaniel
Sent: Wednesday, May 05, 2010 12:27 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Dataview Source





Try doing a trace. While doing an update. The methods used are typically
close to the name of the tables used.

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of ksimon8fw
Sent: Wednesday, May 05, 2010 12:22 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Dataview Source

We're in Epicor 9 which has the WorkQueue module. When I open the
customization, there's a grid view available, for which the source is
"ActiveWork". However, "ActiveWork" is not a progress table, it is
obviously some sort of "view", combining Labor and Job information.

How do I find out what the source of that view is? I've got additional
information I want to display in that grid, and I have UD fields
available (ShortChar01 in this case). When I display ShortChar01 on the
grid, it is obviously empty.

I've updated the various ShortChar01 fields on other tables that this
could pull from (LaborDtl, JobOper, JobOpDtl), but none of those values
make it to the ActiveWork view.

Does anyone know where to find this information?

Thanks.
Kevin

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





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

--- In vantage@yahoogroups.com, "Kevin Simon" <ksimon8fw@...> wrote:
>
> Did that already. Work Queue just uses the same standard calls that you get
> if you start and end activity - it's using the Labor methods.
>
>
>
> What I tried is updating all the LaborHed.ShortChar01 fields to the value
> "LaborHed", the LaborDtl.ShortChar01 fields to the value "LaborDtl", and so
> on with JobHead, JobOper, JobOpDtl. Then, I was hoping to display the
> ShortChar01 on the grid that comes from the source "ActiveWork", and see
> what it displayed. It didn't display anything.
>
>
>
> Thanks.
>
>
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
> Sean McDaniel
> Sent: Wednesday, May 05, 2010 12:27 PM
> To: vantage@yahoogroups.com
> Subject: RE: [Vantage] Dataview Source
>
>
>
>
>
> Try doing a trace. While doing an update. The methods used are typically
> close to the name of the tables used.
>
> From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> [mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
> Behalf
> Of ksimon8fw
> Sent: Wednesday, May 05, 2010 12:22 PM
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> Subject: [Vantage] Dataview Source
>
> We're in Epicor 9 which has the WorkQueue module. When I open the
> customization, there's a grid view available, for which the source is
> "ActiveWork". However, "ActiveWork" is not a progress table, it is
> obviously some sort of "view", combining Labor and Job information.
>
> How do I find out what the source of that view is? I've got additional
> information I want to display in that grid, and I have UD fields
> available (ShortChar01 in this case). When I display ShortChar01 on the
> grid, it is obviously empty.
>
> I've updated the various ShortChar01 fields on other tables that this
> could pull from (LaborDtl, JobOper, JobOpDtl), but none of those values
> make it to the ActiveWork view.
>
> Does anyone know where to find this information?
>
> Thanks.
> Kevin
>
> [Non-text portions of this message have been removed]
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
We've had problems updating the grids as well.

One option is to add a textbox on the form (disable it) and then hook
into the epiNotification initialize event to update the information in
our textbox based on the selected row in the grid.

Not ideal, but it gets the job done.



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Kevin Simon
Sent: Wednesday, May 05, 2010 12:57 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Dataview Source





Did that already. Work Queue just uses the same standard calls that you
get
if you start and end activity - it's using the Labor methods.

What I tried is updating all the LaborHed.ShortChar01 fields to the
value
"LaborHed", the LaborDtl.ShortChar01 fields to the value "LaborDtl", and
so
on with JobHead, JobOper, JobOpDtl. Then, I was hoping to display the
ShortChar01 on the grid that comes from the source "ActiveWork", and see
what it displayed. It didn't display anything.

Thanks.

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of
Sean McDaniel
Sent: Wednesday, May 05, 2010 12:27 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Dataview Source

Try doing a trace. While doing an update. The methods used are typically
close to the name of the tables used.

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 ksimon8fw
Sent: Wednesday, May 05, 2010 12:22 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Dataview Source

We're in Epicor 9 which has the WorkQueue module. When I open the
customization, there's a grid view available, for which the source is
"ActiveWork". However, "ActiveWork" is not a progress table, it is
obviously some sort of "view", combining Labor and Job information.

How do I find out what the source of that view is? I've got additional
information I want to display in that grid, and I have UD fields
available (ShortChar01 in this case). When I display ShortChar01 on the
grid, it is obviously empty.

I've updated the various ShortChar01 fields on other tables that this
could pull from (LaborDtl, JobOper, JobOpDtl), but none of those values
make it to the ActiveWork view.

Does anyone know where to find this information?

Thanks.
Kevin

[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]
Sean,



Thanks for the idea. You wouldn't happen to have a little snippet of code
that does something similar to this, would you? Fighting the syntax seems
to be half the battle.



Kevin



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Sean McDaniel
Sent: Wednesday, May 05, 2010 1:34 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Dataview Source





We've had problems updating the grids as well.

One option is to add a textbox on the form (disable it) and then hook
into the epiNotification initialize event to update the information in
our textbox based on the selected row in the grid.

Not ideal, but it gets the job done.

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Kevin Simon
Sent: Wednesday, May 05, 2010 12:57 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Dataview Source

Did that already. Work Queue just uses the same standard calls that you
get
if you start and end activity - it's using the Labor methods.

What I tried is updating all the LaborHed.ShortChar01 fields to the
value
"LaborHed", the LaborDtl.ShortChar01 fields to the value "LaborDtl", and
so
on with JobHead, JobOper, JobOpDtl. Then, I was hoping to display the
ShortChar01 on the grid that comes from the source "ActiveWork", and see
what it displayed. It didn't display anything.

Thanks.

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
Sean McDaniel
Sent: Wednesday, May 05, 2010 12:27 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Dataview Source

Try doing a trace. While doing an update. The methods used are typically
close to the name of the tables used.

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 ksimon8fw
Sent: Wednesday, May 05, 2010 12:22 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Dataview Source

We're in Epicor 9 which has the WorkQueue module. When I open the
customization, there's a grid view available, for which the source is
"ActiveWork". However, "ActiveWork" is not a progress table, it is
obviously some sort of "view", combining Labor and Job information.

How do I find out what the source of that view is? I've got additional
information I want to display in that grid, and I have UD fields
available (ShortChar01 in this case). When I display ShortChar01 on the
grid, it is obviously empty.

I've updated the various ShortChar01 fields on other tables that this
could pull from (LaborDtl, JobOper, JobOpDtl), but none of those values
make it to the ActiveWork view.

Does anyone know where to find this information?

Thanks.
Kevin

[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]