« Fields in DSPACE eperson table that are empty, fixed or small | Main | Select to find ascii control characters in DSPACE (i.e. in the postgres DB) »

Handles of items that have been withdrawn from DSPACE Instance of UDC

dspace_ir=> select handle  from item,handle   where resource_id=item_id AND resource_type_id =2 AND withdrawn='t';
 handle 
--------
 59457
 59456
 91897
 59624
 52302
 52304
 1417
 59224
 1564
 1556
 1597
 59696
 52294
 52295
 54922
 1635
 1652
 1641
 1642
 1634
 1654
 1643
 1640
 1638
 1650
 1648
 1639
 1637
 1636
 1631
 1632
 47185
 1693
 1657
 1700
 1656
 1667
 1699
 1666
 57139
 56283
 1714
 1713
 53967
 1962
 1959
 1924
 1941
 1917
 1921
 1956
 1945
 235
 52291
 52301
 52293
 52303
 52305
 52306
 2140
 4308
 2255
 4071
 52308
 2342
 4252
 2421
 2411
 2424
 2420
 2423
 4396
 47036
 3992
 4122
 2610
 2599
 2614
 46794
 2779
 2870
 2851
 2880
 5763
 56296
 3226
 3393
 3391
 3394
 3422
 48945
 3468
 4948
 5022
 5027
 1056
 1149
 1072
 56320
 54792
 59699
 4183
 47738
 4459
 4468
 57299
 4489
 4576
 57302
 92517
 45722
 4779
 4842
 4781
 53859
 4862
 4886
 4848
 4429
 50922
 56358
 103371
 5866
 4997
 57063
 53867
 5141
 57052
 104500
 57199
 57141
 107249
 109941
 100004
 97262
 98554
 50549
 48018
 104356
(139 rows)

Post a comment

(If you haven't left a comment here before, you may need to be approved by the site owner before your comment will appear. Until then, it won't appear on the entry. Thanks for waiting.)