BAM dump of all changed items?

Yahoo Archive
1
The BitFlag field in OrderHed tracks whether or not there are change logs associated with an Order to be displayed.

The value is 8 when there are changes, 0 when there are none.

--- In vantage@yahoogroups.com, "Patrick Parker" <scrumbus@...> wrote:
>
> I'm trying personally not to use the BAM embedded logs because I don't want our database to bloat larger than it has to. There should be some integrated way of managing old alert entries. I may have to use the change log for now until I get something more intricate working.
>
> Does anyone know beyond the ChgLog table where the OrderHed denotes that there's a change log associated with an entry? I'm working in my test environment and after deleting the log entries for an order, the order still has the icon triggered that indicates there's changes associated with it.
>
> Figured it would have been some bit field on the OrderHed table but haven't found it yet.
>
> --- In vantage@yahoogroups.com, Steven Gotschall <sgotschall@> wrote:
> >
> > The changelog is updated through a BAM. In BAM maintenance, select the table and the fields you want to log, and on the action tab you select "Create Log". If you don't apply any rules, then it will log any and all changes made to the fields you listed for that table. I have quite a few of them selected form my OrderHed and OrderDtl tables. You can also set up an email notification if you want, but this can be a real pain with it sending out tons of emails no one cares about. I just log it and then if there is a question on the order then I look at the log.
> >
> >
> >
> >
> > ________________________________
> > From: Patrick Parker <scrumbus@>
> > To: vantage@yahoogroups.com
> > Sent: Monday, June 8, 2009 3:26:25 PM
> > Subject: [Vantage] BAM dump of all changed items?
> >
> >
> >
> >
> >
> > I'm looking to make a good email notification of when someone changes a sales order (we've got a problem with sales people causing major problems with changes and then later everyone denies they made a change).
> >
> > So... I realize I could iterate through each field manually in the BAM and see if it's changed and include it in the email body, but I'm wondering if there's a simpler way to extract all the changes in a save.
> >
> > I see there's a ChgLogGA reference listed in the help that says it's the record of the change log, but after testing I guess I'm not sure how that's utilized.
> >
> > Anyone tackled something similar?
> >
> >
> >
> >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
2
I'm looking to make a good email notification of when someone changes a sales order (we've got a problem with sales people causing major problems with changes and then later everyone denies they made a change).

So... I realize I could iterate through each field manually in the BAM and see if it's changed and include it in the email body, but I'm wondering if there's a simpler way to extract all the changes in a save.

I see there's a ChgLogGA reference listed in the help that says it's the record of the change log, but after testing I guess I'm not sure how that's utilized.

Anyone tackled something similar?
3
The changelog is updated through a BAM. In BAM maintenance, select the table and the fields you want to log, and on the action tab you select "Create Log". If you don't apply any rules, then it will log any and all changes made to the fields you listed for that table. I have quite a few of them selected form my OrderHed and OrderDtl tables. You can also set up an email notification if you want, but this can be a real pain with it sending out tons of emails no one cares about. I just log it and then if there is a question on the order then I look at the log.




________________________________
From: Patrick Parker <scrumbus@...>
To: vantage@yahoogroups.com
Sent: Monday, June 8, 2009 3:26:25 PM
Subject: [Vantage] BAM dump of all changed items?





I'm looking to make a good email notification of when someone changes a sales order (we've got a problem with sales people causing major problems with changes and then later everyone denies they made a change).

So... I realize I could iterate through each field manually in the BAM and see if it's changed and include it in the email body, but I'm wondering if there's a simpler way to extract all the changes in a save.

I see there's a ChgLogGA reference listed in the help that says it's the record of the change log, but after testing I guess I'm not sure how that's utilized.

Anyone tackled something similar?







[Non-text portions of this message have been removed]
4
I'm trying personally not to use the BAM embedded logs because I don't want our database to bloat larger than it has to. There should be some integrated way of managing old alert entries. I may have to use the change log for now until I get something more intricate working.

Does anyone know beyond the ChgLog table where the OrderHed denotes that there's a change log associated with an entry? I'm working in my test environment and after deleting the log entries for an order, the order still has the icon triggered that indicates there's changes associated with it.

Figured it would have been some bit field on the OrderHed table but haven't found it yet.

--- In vantage@yahoogroups.com, Steven Gotschall <sgotschall@...> wrote:
>
> The changelog is updated through a BAM. In BAM maintenance, select the table and the fields you want to log, and on the action tab you select "Create Log". If you don't apply any rules, then it will log any and all changes made to the fields you listed for that table. I have quite a few of them selected form my OrderHed and OrderDtl tables. You can also set up an email notification if you want, but this can be a real pain with it sending out tons of emails no one cares about. I just log it and then if there is a question on the order then I look at the log.
>
>
>
>
> ________________________________
> From: Patrick Parker <scrumbus@...>
> To: vantage@yahoogroups.com
> Sent: Monday, June 8, 2009 3:26:25 PM
> Subject: [Vantage] BAM dump of all changed items?
>
>
>
>
>
> I'm looking to make a good email notification of when someone changes a sales order (we've got a problem with sales people causing major problems with changes and then later everyone denies they made a change).
>
> So... I realize I could iterate through each field manually in the BAM and see if it's changed and include it in the email body, but I'm wondering if there's a simpler way to extract all the changes in a save.
>
> I see there's a ChgLogGA reference listed in the help that says it's the record of the change log, but after testing I guess I'm not sure how that's utilized.
>
> Anyone tackled something similar?
>
>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>