BPM using WhereClause parameters?

Anybody got any suggestions??

I get the right value for the frozenQty showing in a Message box, but it doesn't work when trying to assign it to the CountedQty. The other one works without no problems, so i can't figure out what im missing here..


Private Sub edvtagView_EpiViewNotification(ByVal view As EpiDataView, ByVal args As EpiNotifyArgs)

try
If (args.NotifyType = EpiTransaction.NotifyType.Initialize) Then

If (args.Row > -1) Then

Dim frozenQty As Decimal = edvtagView.dataView(edvtagView.Row)("FrozenQOH")

messagebox.show(frozenQty)
view.dataView(args.Row)("CountedQty") = frozenQty
view.dataView(args.Row)("CountedBy") = "user"
view.dataView(args.Row)("CountedDate") = DateTime.Today
view.dataView(args.Row)("TagReturned") = False

End If
End If
Catch Ex as Exception
ExceptionBox.Show(Ex)

End Try
End Sub



--- In vantage@yahoogroups.com, "lisassar" <lisa.saren@...> wrote:
>
> Hi and thanks for your replies!
>
> Seems the BPM way is probabaly not the best way then.. not very familiar with customization coding though.
>
> Tried using the form event wizard, viewnotification, but can't get the frozen quantity populating correct (right now only giving errors, but compiling OK). Do I need to use a adapter or something to get the value? Seems to get the right value when I show it in a messagebox..
>
> Code snippet:
>
> Private Sub edvtagView_EpiViewNotification(ByVal view As EpiDataView, ByVal args As EpiNotifyArgs)
>
>
> If (args.NotifyType = EpiTransaction.NotifyType.Initialize) Then
>
> If (args.Row > -1) Then
> Dim frozenQty As Decimal = edvtagView.dataView(edvtagView.Row)("FrozenQOH")
> view.dataView(args.Row)("CountedQty") = frozenQty
> view.dataView(args.Row)("CountedBy") = "Test"
> view.dataView(args.Row)("CountedDate") = DateTime.Today
>
> End If
> End If
> End Sub
>
>
>
> --- In vantage@yahoogroups.com, John Driggers <waffqle@> wrote:
> >
> > Are you stuck using BPM for this?
> > While this is a pain as a BPM it's pretty trivial as customization to the
> > screen.
> > You just need to attach to the dataview notification and populate your
> > fields when it fires.
> >
> >
> > On Wed, Jun 12, 2013 at 11:38 AM, brenda mohr <brenda@> wrote:
> >
> > > **
> > >
> > >
> > > You could set a BPMData field to the where clause and then pull a
> > > substring and then use it from there... Little Rube Goldbergish, but if
> > > that's all you have....
> > >
> > > Brenda
> > >
> > > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> > > Of lisassar
> > > Sent: Wednesday, June 12, 2013 5:25 AM
> > > To: vantage@yahoogroups.com
> > > Subject: [Vantage] Re: BPM using WhereClause parameters?
> > >
> > > Anybody?
> > >
> > >
> > > --- In vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>,
> > > "lisassar" <lisa.saren@<mailto:lisa.saren@>> wrote:
> > > >
> > > > Hi,
> > > >
> > > > I'm trying to create a BPM in the Count Tag Entry (CCTag), after a user
> > > has choose a tagnum, I want to populate the Counted Qty and some other
> > > fields with values. I can't figure out how to get only the choosen TagNum
> > > to get assigned with the right values. Can't find any temp-tables to use
> > > and the only place I find the TagNum value is in the whereclause
> > > parameters, could I use that in someway in my code?
> > > >
> > > > The method I'm using is the CountTag.GetList (pre-processing), since
> > > that is the only one used when choosing a tagnum.
> > > >
> > > > Tried just usiing CCTag.Tagnum = TagNum, but that doesn't work. Any
> > > ideas?
> > > >
> > > >
> > > > for each CCTag where CCTag.Company = CUR-COMP no-lock no-error.
> > > >
> > > > if available ccTag then do:
> > > >
> > > > cctag.CountedQty = CCTag.FrozenQOH.
> > > > CCTag.CountedBy = ttCallContextClient.CurrentUserId.
> > > > CCTag.CountedDate = TODAY.
> > > > CCTag.TagReturned = Yes.
> > > >
> > > >
> > > > end.
> > > >
> > > > end.
> > > >
> > > >
> > > >
> > > > Kind regards,
> > > > Lisa
> > > >
> > >
> > > [Non-text portions of this message have been removed]
> > >
> > >
> > >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
Hi,

I'm trying to create a BPM in the Count Tag Entry (CCTag), after a user has choose a tagnum, I want to populate the Counted Qty and some other fields with values. I can't figure out how to get only the choosen TagNum to get assigned with the right values. Can't find any temp-tables to use and the only place I find the TagNum value is in the whereclause parameters, could I use that in someway in my code?

The method I'm using is the CountTag.GetList (pre-processing), since that is the only one used when choosing a tagnum.

Tried just usiing CCTag.Tagnum = TagNum, but that doesn't work. Any ideas?


for each CCTag where CCTag.Company = CUR-COMP no-lock no-error.

if available ccTag then do:

cctag.CountedQty = CCTag.FrozenQOH.
CCTag.CountedBy = ttCallContextClient.CurrentUserId.
CCTag.CountedDate = TODAY.
CCTag.TagReturned = Yes.


end.

end.



Kind regards,
Lisa
Anybody?

--- In vantage@yahoogroups.com, "lisassar" <lisa.saren@...> wrote:
>
> Hi,
>
> I'm trying to create a BPM in the Count Tag Entry (CCTag), after a user has choose a tagnum, I want to populate the Counted Qty and some other fields with values. I can't figure out how to get only the choosen TagNum to get assigned with the right values. Can't find any temp-tables to use and the only place I find the TagNum value is in the whereclause parameters, could I use that in someway in my code?
>
> The method I'm using is the CountTag.GetList (pre-processing), since that is the only one used when choosing a tagnum.
>
> Tried just usiing CCTag.Tagnum = TagNum, but that doesn't work. Any ideas?
>
>
> for each CCTag where CCTag.Company = CUR-COMP no-lock no-error.
>
> if available ccTag then do:
>
> cctag.CountedQty = CCTag.FrozenQOH.
> CCTag.CountedBy = ttCallContextClient.CurrentUserId.
> CCTag.CountedDate = TODAY.
> CCTag.TagReturned = Yes.
>
>
> end.
>
> end.
>
>
>
> Kind regards,
> Lisa
>
You could set a BPMData field to the where clause and then pull a substring and then use it from there... Little Rube Goldbergish, but if that's all you have....

Brenda

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of lisassar
Sent: Wednesday, June 12, 2013 5:25 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: BPM using WhereClause parameters?



Anybody?

--- In vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>, "lisassar" <lisa.saren@...<mailto:lisa.saren@...>> wrote:
>
> Hi,
>
> I'm trying to create a BPM in the Count Tag Entry (CCTag), after a user has choose a tagnum, I want to populate the Counted Qty and some other fields with values. I can't figure out how to get only the choosen TagNum to get assigned with the right values. Can't find any temp-tables to use and the only place I find the TagNum value is in the whereclause parameters, could I use that in someway in my code?
>
> The method I'm using is the CountTag.GetList (pre-processing), since that is the only one used when choosing a tagnum.
>
> Tried just usiing CCTag.Tagnum = TagNum, but that doesn't work. Any ideas?
>
>
> for each CCTag where CCTag.Company = CUR-COMP no-lock no-error.
>
> if available ccTag then do:
>
> cctag.CountedQty = CCTag.FrozenQOH.
> CCTag.CountedBy = ttCallContextClient.CurrentUserId.
> CCTag.CountedDate = TODAY.
> CCTag.TagReturned = Yes.
>
>
> end.
>
> end.
>
>
>
> Kind regards,
> Lisa
>



[Non-text portions of this message have been removed]
Are you stuck using BPM for this?
While this is a pain as a BPM it's pretty trivial as customization to the
screen.
You just need to attach to the dataview notification and populate your
fields when it fires.


On Wed, Jun 12, 2013 at 11:38 AM, brenda mohr <brenda@...> wrote:

> **
>
>
> You could set a BPMData field to the where clause and then pull a
> substring and then use it from there... Little Rube Goldbergish, but if
> that's all you have....
>
> Brenda
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> Of lisassar
> Sent: Wednesday, June 12, 2013 5:25 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: BPM using WhereClause parameters?
>
> Anybody?
>
>
> --- In vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>,
> "lisassar" <lisa.saren@...<mailto:lisa.saren@...>> wrote:
> >
> > Hi,
> >
> > I'm trying to create a BPM in the Count Tag Entry (CCTag), after a user
> has choose a tagnum, I want to populate the Counted Qty and some other
> fields with values. I can't figure out how to get only the choosen TagNum
> to get assigned with the right values. Can't find any temp-tables to use
> and the only place I find the TagNum value is in the whereclause
> parameters, could I use that in someway in my code?
> >
> > The method I'm using is the CountTag.GetList (pre-processing), since
> that is the only one used when choosing a tagnum.
> >
> > Tried just usiing CCTag.Tagnum = TagNum, but that doesn't work. Any
> ideas?
> >
> >
> > for each CCTag where CCTag.Company = CUR-COMP no-lock no-error.
> >
> > if available ccTag then do:
> >
> > cctag.CountedQty = CCTag.FrozenQOH.
> > CCTag.CountedBy = ttCallContextClient.CurrentUserId.
> > CCTag.CountedDate = TODAY.
> > CCTag.TagReturned = Yes.
> >
> >
> > end.
> >
> > end.
> >
> >
> >
> > Kind regards,
> > Lisa
> >
>
> [Non-text portions of this message have been removed]
>
>
>


[Non-text portions of this message have been removed]
Hi and thanks for your replies!

Seems the BPM way is probabaly not the best way then.. not very familiar with customization coding though.

Tried using the form event wizard, viewnotification, but can't get the frozen quantity populating correct (right now only giving errors, but compiling OK). Do I need to use a adapter or something to get the value? Seems to get the right value when I show it in a messagebox..

Code snippet:

Private Sub edvtagView_EpiViewNotification(ByVal view As EpiDataView, ByVal args As EpiNotifyArgs)


If (args.NotifyType = EpiTransaction.NotifyType.Initialize) Then

If (args.Row > -1) Then
Dim frozenQty As Decimal = edvtagView.dataView(edvtagView.Row)("FrozenQOH")
view.dataView(args.Row)("CountedQty") = frozenQty
view.dataView(args.Row)("CountedBy") = "Test"
view.dataView(args.Row)("CountedDate") = DateTime.Today

End If
End If
End Sub



--- In vantage@yahoogroups.com, John Driggers <waffqle@...> wrote:
>
> Are you stuck using BPM for this?
> While this is a pain as a BPM it's pretty trivial as customization to the
> screen.
> You just need to attach to the dataview notification and populate your
> fields when it fires.
>
>
> On Wed, Jun 12, 2013 at 11:38 AM, brenda mohr <brenda@...> wrote:
>
> > **
> >
> >
> > You could set a BPMData field to the where clause and then pull a
> > substring and then use it from there... Little Rube Goldbergish, but if
> > that's all you have....
> >
> > Brenda
> >
> > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> > Of lisassar
> > Sent: Wednesday, June 12, 2013 5:25 AM
> > To: vantage@yahoogroups.com
> > Subject: [Vantage] Re: BPM using WhereClause parameters?
> >
> > Anybody?
> >
> >
> > --- In vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>,
> > "lisassar" <lisa.saren@<mailto:lisa.saren@>> wrote:
> > >
> > > Hi,
> > >
> > > I'm trying to create a BPM in the Count Tag Entry (CCTag), after a user
> > has choose a tagnum, I want to populate the Counted Qty and some other
> > fields with values. I can't figure out how to get only the choosen TagNum
> > to get assigned with the right values. Can't find any temp-tables to use
> > and the only place I find the TagNum value is in the whereclause
> > parameters, could I use that in someway in my code?
> > >
> > > The method I'm using is the CountTag.GetList (pre-processing), since
> > that is the only one used when choosing a tagnum.
> > >
> > > Tried just usiing CCTag.Tagnum = TagNum, but that doesn't work. Any
> > ideas?
> > >
> > >
> > > for each CCTag where CCTag.Company = CUR-COMP no-lock no-error.
> > >
> > > if available ccTag then do:
> > >
> > > cctag.CountedQty = CCTag.FrozenQOH.
> > > CCTag.CountedBy = ttCallContextClient.CurrentUserId.
> > > CCTag.CountedDate = TODAY.
> > > CCTag.TagReturned = Yes.
> > >
> > >
> > > end.
> > >
> > > end.
> > >
> > >
> > >
> > > Kind regards,
> > > Lisa
> > >
> >
> > [Non-text portions of this message have been removed]
> >
> >
> >
>
>
> [Non-text portions of this message have been removed]
>