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