add batch remove batch split batch comment selection show hidden batches hide batch highlight batch
db<>fiddle
donate feedback about
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
version()
8.0.27
id status_from status_to logtime refno
1 N A 2021-06-01 00:00:00 LP01
2 A D 2021-10-01 00:00:00 LP01
3 D Y 2021-10-02 00:00:00 LP01
4 A N 2021-10-06 00:00:00 LP06
id status added_date updated_date refno logstat stat20211001
3 Y 2021-05-02 00:00:00 2021-10-02 00:00:00 LP01 A A
4 A 2021-05-01 00:00:00 2021-05-01 00:00:00 LP02 null A
5 S 2020-10-01 00:00:00 2020-10-01 00:00:00 LP03 null S
6 N 2021-05-01 00:00:00 2021-10-06 00:00:00 LP06 A A
11 D 2021-01-01 00:00:00 2021-01-01 00:00:00 LP04 null D
text c
Action 3
Draft 1
Let 0
Sold 1
Publish 0