Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hey guys, i need to create a solution where extract a table everyday and store it in qvd with the date and time when i extract it. but this data then is audit and some fields change, so i need to add into a weekly and monthly qvd with checked info.
In addition, the last data may have rows of an event that occurred on a previous day so i have to detect this new rows
Thanks!
Hi!
i have a table from database like this:
ID | input_date | event_date | name | place | mode | description |
12357 | 1/6/2019 | 30/5/2019 | Jhon | Place 1 | Mode A | description event mode A |
5461132 | 2/6/2019 | 2/6/2019 | Mary | Place 2 | Mode B | description event mode B |
1484155 | 3/6/2019 | 1/6/2019 | Peter | Place 3 | Mode A | description event mode A |
first of all i need to store it in a qvd with the date and time that was stored
ID | input_date | event_date | name | place | mode | description | qvd_date | qvd_time |
12357 | 1/6/2019 | 30/5/2019 | Jhon | Place 1 | Mode A | description event mode A | 1/6/2019 | 07:00 |
5461132 | 2/6/2019 | 2/6/2019 | Mary | Place 2 | Mode B | description event mode B | 2/6/2019 | 07:00 |
1484155 | 3/6/2019 | 1/6/2019 | Peter | Place 3 | Mode A | description event mode A | 3/6/2019 | 07:00 |
Then this new table goes to the audit team where they create new fields
ID | input_date | event_date | name | place | mode | description | qvd_date | qvd_time | audit_event_date | audit_place | audit_mode |
12357 | 1/6/2019 | 30/5/2019 | Jhon | Place 1 | Mode A | description event mode A | 1/6/2019 | 07:00 | 1/6/2019 | Place 2 | Mode B |
5461132 | 2/6/2019 | 2/6/2019 | Mary | Place 2 | Mode B | description event mode B | 2/6/2019 | 07:00 | 2/6/2019 | Place 4 | Mode B |
1484155 | 3/6/2019 | 1/6/2019 | Peter | Place 3 | Mode A | description event mode A | 3/6/2019 | 07:00 | 1/6/2019 | Place 5 | Mode A |
In addittion, when the team is auditing some information is added in the database with a previous date that is in audit, so i need to detect the new rows of the table.
Thanks!
@Anonymous