I tried putting a simple message box on the Preprocessing of
"DynamicQuery.ExecuteDashBoardQuery" and i got this error when saving the
BPM
"DynamicQuery.ExecuteDashBoardQuery" and i got this error when saving the
BPM
On Mon, Jul 23, 2012 at 7:11 PM, John Driggers <waffqle@...> wrote:
> Whats your code look like?
>
> *John Driggers*
> **
> *Chief Data Wrangler*
> *
> *
> *I have an Epicor blog <http://usdoingstuff.com/>. How useful is that?*
> *
> *:: 904.404.9233
> :: waffqle@...
> :: http://www.usdoingstuff.com <http://www.usdoingstuff.com/>
>
> *
>
> *
>
>
>
> On Mon, Jul 23, 2012 at 1:15 PM, Ephraim Feldman <effgroups@...
> >wrote:
>
> > **
> >
> >
> > i tried that but when i save my BPM i get an error :
> >
> > Compilation error: Invalid datatype specified: dataset-handle. Specify a
> > datatype such as 'character' or the name of a class. (5638)
> > ** D:\Epicor9\Epicor904\bpmExec\LiveBPM\bo\DynamicQuery\DynamicQuery.p
> > Could not understand line 207. (196)
> >
> >
> > On Sat, Jul 21, 2012 at 9:56 AM, John Driggers <waffqle@...>
> wrote:
> >
> > > Just run a trace when you refresh the dashboard. You should see it
> > calling
> > > 'dynamicquery.execute' or something similar. You should be able to just
> > > stick your BPM on there and look at the context data to see if it's
> > calling
> > > the query you're interested in before you mess with anything.
> > >
> > > Can't say I've actually done this, but it should work just fine.
> > >
> > > *John Driggers*
> > > **
> > > *Chief Data Wrangler*
> > > *
> > > *
> > > *I have an Epicor blog <http://usdoingstuff.com/>. How useful is
> that?*
> > > *
> > > *:: 904.404.9233
> > > :: waffqle@...
> > > :: http://www.usdoingstuff.com <http://www.usdoingstuff.com/>
> > >
> > > *
> >
> > >
> > > *
> > >
> > >
> > >
> > > On Fri, Jul 20, 2012 at 5:02 PM, <effgroups@...> wrote:
> > >
> > > > **
> >
> > > >
> > > >
> > > > So no one has any idea how to go about this?
> > > >
> > > >
> > > > Ephraim Feldman
> > > >
> > > > -----Original Message-----
> > > > From: effgroups@...
> > > > Date: Fri, 20 Jul 2012 12:39:12
> > > > To: Vantage Yahoo Group<vantage@yahoogroups.com>
> > > > Reply-To: effgroups@...
> > > > Subject: Re: [Vantage] Running a BPM when refreshing a dashboard
> > > >
> > > > Its not information gathered from the dashboard but rather a process
> > that
> > > > I need to run before the data for the dashboard is queried.
> > > >
> > > > To explain more :
> > > > We are a make to order company so all of our order lines have jobs
> > > > attached to it.
> > > > I want to go tru all open releases and check for each the BOM and see
> > if
> > > > we have on hand all the material. If we don't I want to flag the
> > release
> > > on
> > > > checkbox01.
> > > > I know there is shortcomings with this approach but for now that's ok
> > > with
> > > > us.
> > > >
> > > > Then in the dashboard I show all open releases and the flag if it has
> > all
> > > > MTL in inventory.
> > > >
> > > >
> > > > Ephraim Feldman
> > > >
> > > > -----Original Message-----
> > > > From: jose@...
> > > > Sender: vantage@yahoogroups.com
> > > > Date: Fri, 20 Jul 2012 11:06:37
> > > > To: Vantage<vantage@yahoogroups.com>
> > > > Reply-To: vantage@yahoogroups.com
> > > > Subject: Re: [Vantage] Running a BPM when refreshing a dashboard
> > > >
> > > > No ofense but why would you want to do this? It seems like there is
> > very
> > > > little you could gather from someone refreshing a dashboard.
> > > > Sent from my Verizon Wireless BlackBerry
> > > >
> > > > -----Original Message-----
> > > > From: Ephraim Feldman <effgroups@...>
> > > > Sender: vantage@yahoogroups.com
> > > > Date: Thu, 19 Jul 2012 22:51:06
> > > > To: <vantage@yahoogroups.com>
> > > > Reply-To: vantage@yahoogroups.com
> > > > Subject: [Vantage] Running a BPM when refreshing a dashboard
> > > >
> > > > Hi all
> > > >
> > > > I want to run a process that will update some UD fields when a
> > particular
> > > > dashboard is refreshed.
> > > > Its not just one record but i need to iterate trough the Orderdtl
> table
> > > on
> > > > a specific range and update a UD field.
> > > >
> > > > How can i accomplish that?
> > > >
> > > > I tried putting a BPM on the dynamicquery.execute dashboard method
> but
> > i
> > > > got errors saving the BPM
> > > >
> > > >
> > > > Any help would be appreciated.
> > > >
> > > > thanks
> > > >
> > > > Ephraim
> > > >
> > > >
> > > > [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]
> > >
> > >
> > >
> > > ------------------------------------
> >
> > >
> > > 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]
>
>
>
> ------------------------------------
>
> 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]