Hi Sherman,
if you have Discovery enabled and you want to make a query which will
select all items that have a fulltext (i.e. a bistream in the TEXT bundle),
you can just use this Solr query in the DSpace search box: fulltext:*
This will also correctly restrict search results to the current
community/collection.
If this is not the usage you have in mind, you can do this:
On Wed, Dec 26, 2012 at 7:41 AM, LIBRIS Reference (LIBRIS)
lib...@nie.edu.sg wrote:
Q1. We need to create to a new Dublin Core (DC) metadata field,
dc.description.fulltext. How do we go about it?
Just use the administrator's interface to add the field (Registries -
Metadata).
Q2. We need to insert a metadata entry, dc.description.fulltext=Yes for
every record in a community (say, DB ID=3) How do we go about it?
1) back up your database
2) look up the metadata field name (element and qualifier columns) in the
metadatafieldregistry table and find its metadata_field_id
3) use this code to insert the values (FIELD_ID is the value you found in
2), ITEM_ID is the internal ID of the item to which you want to add
metadata):
INSERT INTO metadatavalue (item_id, metadata_field_id,
text_value)VALUES (ITEM_ID, FIELD_ID, 'Yes')
Code is untested, from the top of my head. Remember to back up!
Regards,
~~helix84
Compulsory reading: DSpace Mailing List Etiquette
https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette
--
Master Visual Studio, SharePoint, SQL, ASP.NET, C# 2012, HTML5, CSS,
MVC, Windows 8 Apps, JavaScript and much more. Keep your skills current
with LearnDevNow - 3,200 step-by-step video tutorials by Microsoft
MVPs and experts. ON SALE this month only -- learn more at:
http://p.sf.net/sfu/learnmore_122712___
DSpace-tech mailing list
DSpace-tech@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/dspace-tech
List Etiquette: https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette