I've been tasked with developing a dashboard that includes a grid view of sales order changes. The request is to show order #, line #, release #, date/time of the change, author of the change, and some kind of detail of the change.
Right now I can't get past the release # requirement because when I set up a Change Log on the OrderDtl table the line number gets posted in ChangeLog to the Key2 field in the format <OrderNum>~<LineNum>. I can't figure out how to make a BAQ that joins ChangeLog to OrderDtl on
SUBSTR(ChangeLog.Key2,(INSTR(ChangeLog.Key2,'~')))=OrderDtl.LineNum
(or something like it).
Has anyone tried to deal with this before? If so, how?
Nevermind that my grid view doesn't want to display enough of the LogText field to be at all helpful...
WILLIAM L. GANN
Database Administrator
Wastequip, Inc.
Nationally known for personal service
25800 Science Park Drive, Suite 140
Cleveland, Ohio 44122
* (216) 292-2554
* (216) 360-8533 direct
7 (216) 360-8559 fax
* BGann@...<mailto:BGann@...>
http://www.wastequip.com<http://www.wastequip.com/>
________________________________
NOTICE: This e-mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential or proprietary information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, immediately contact the sender by reply e-mail and destroy all copies of the original message.
[Non-text portions of this message have been removed]
Right now I can't get past the release # requirement because when I set up a Change Log on the OrderDtl table the line number gets posted in ChangeLog to the Key2 field in the format <OrderNum>~<LineNum>. I can't figure out how to make a BAQ that joins ChangeLog to OrderDtl on
SUBSTR(ChangeLog.Key2,(INSTR(ChangeLog.Key2,'~')))=OrderDtl.LineNum
(or something like it).
Has anyone tried to deal with this before? If so, how?
Nevermind that my grid view doesn't want to display enough of the LogText field to be at all helpful...
WILLIAM L. GANN
Database Administrator
Wastequip, Inc.
Nationally known for personal service
25800 Science Park Drive, Suite 140
Cleveland, Ohio 44122
* (216) 292-2554
* (216) 360-8533 direct
7 (216) 360-8559 fax
* BGann@...<mailto:BGann@...>
http://www.wastequip.com<http://www.wastequip.com/>
________________________________
NOTICE: This e-mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential or proprietary information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, immediately contact the sender by reply e-mail and destroy all copies of the original message.
[Non-text portions of this message have been removed]