EPrints Technical Mailing List Archive

See the EPrints wiki for instructions on how to join this mailing list and related information.

Message: #08963

< Previous (by date) | Next (by date) > | < Previous (in thread) | Next (in thread) > | Messages - Most Recent First | Threads - Most Recent First

[EP-tech] Browse by year

CAUTION: This e-mail originated outside the University of Southampton.

Hi,

Values for the date_year column in roughly fifty records in our
repository may not be inserted correctly. As a result, the 'browse by
year' view for such entries is incorrectly created and not clickable.
The following link will take you to a screenshot of the browse view by
year:

https://eur03.safelinks.protection.outlook.com/?url=https%3A%2F%2Findianinstituteofscience-my.sharepoint.com%2F%3Ai%3A%2Fg%2Fpersonal%2Ffrancis&amp;data=05%7C01%7Ceprints-tech%40ecs.soton.ac.uk%7C8477d037b96949ead0bd08da42d766e0%7C4a5378f929f44d3ebe89669d03ada9d8%7C0%7C0%7C637895790448893728%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C2000%7C%7C%7C&amp;sdata=4uPFKrVmXAqy2Vgeirk89eZzRt5HIe1aRIQC%2BH1DBtA%3D&amp;reserved=0
iisc ac in/EQhONAS12hxMseEf7e8lHMUBU0D8IuwQhdbkLrekIGJj1g?e=e1yxHP

As evident from the screenshot, the last item in the third column is
not clickable.

What SQL statement should I use to obtain these records? I've tried
the SQL commands below, but they all return empty sets:

select eprintid, title, official_url from eprint where date_year  like '  %';
select eprintid, title, official_url from eprint where date_year  like ' % '
select eprintid, title, official_url from eprint where date_year  like '  % '

Thanks for your attention.

Best regards, Francis