|
||||||||
|
This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira |
||||||||
------------------------------------------------------------------------------ Learn the latest--Visual Studio 2012, SharePoint 2013, SQL 2012, more! Discover the easy way to master current and previous Microsoft technologies and advance your career. Get an incredible 1,500+ hours of step-by-step tutorial videos with LearnDevNow. Subscribe today and save! http://pubads.g.doubleclick.net/gampad/clk?id=58040911&iu=/4140/ostg.clktrk
_______________________________________________ Dspace-devel mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/dspace-devel
source /opt/setvars
sudo -u postgres echo "select text_value from metadatavalue, item where metadata_field_id = 71 and metadatavalue.item_id = item.item_id and item.in_archive = 't' and item.withdrawn = 'f';" | psql -t -d dspace | sort | uniq -c | sort -n
sudo -u postgres echo "select text_value from metadatavalue, item where metadata_field_id = 77 and metadatavalue.item_id = item.item_id and item.in_archive = 't' and item.withdrawn = 'f';" | psql -t -d restricted_dspace | sort | uniq -c | sort -n
sudo -u postgres echo "select item.withdrawn from item where item.in_archive = 't' and item.withdrawn = 'f';" | psql -t -d restricted_dspace | sort | uniq -c | sort -n
sudo -u postgres echo "select item.withdrawn from item where item.in_archive = 't' and item.withdrawn = 'f';" | psql -t -d dspace | sort | uniq -c | sort -n
sudo -u postgres echo "select collection.name from item, collection2item, collection where item.item_id = collection2item.item_id and collection.collection_id = collection2item.collection_id and item.in_archive = 't' and item.withdrawn = 'f';" | psql -t -d restricted_dspace | sort | uniq -c