Archiving of Quote Data [message #415803] |
Wed, 29 July 2009 06:28  |
dilipn_nitw@yahoo.com
Messages: 16 Registered: July 2009 Location: India
|
Junior Member |

|
|
Hi Friends,
I have the following requirement -
Please proceed to systematically clean up PWR Quotations with the following conditions for all ORGS:
1. Quotes with a "QUOTE START DATE " of 2007 and under WITH NO link to ASL, BOD, Not Approved, no Quote End Date; archive this history so that it is not visable to the current PWR quote screen.
2. Quotes with a "QUOTE END DATE" that is over 1 year old;
archive this history so that it is not visable to the current PWR quote screen.
I had not worked on this kind of requirement before.
Thanks In Advance!
Thanks & Regards
Ramya Nomula
|
|
|
Re: Archiving of Quote Data [message #415808 is a reply to message #415803] |
Wed, 29 July 2009 06:35   |
ThomasG
Messages: 3212 Registered: April 2005 Location: Heilbronn, Germany
|
Senior Member |
|
|
You could possibly do it with select, insert and delete statements once you have figured out how it is actually set up inside the database. (What table with what columns there are)
|
|
|
Re: Archiving of Quote Data [message #415812 is a reply to message #415803] |
Wed, 29 July 2009 06:54   |
Frank
Messages: 7901 Registered: March 2000
|
Senior Member |
|
|
dilipn_nitw@yahoo.com wrote on Wed, 29 July 2009 13:28 | Hi Friends,
I have the following requirement -
[snip]
I had not worked on this kind of requirement before.
|
Did the thought ever occur to you to ask the person who handed you this requirement? You'd rather ask total strangers then show the person who assigns you work that you might need some extra clarification or that you're not up to your work.
Guess what happens if you clear this one, only with our help.
|
|
|
|
|
|