EPrints Technical Mailing List Archive

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

Message: #10318

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

[EP-tech] Query for IRSTATS2 Download from Access Table

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

Our repo is currently under repocessing the data. And it takes a very long time to reach 2025.
I plan to do a quick query directly from the access table. I can't get the same or near the same as shown in the IRStat screen (for previous year)

Example for 2013
Repo Stat Screen shows -186,757

Query from the access table  - 282,322
Query with condition referring_entity_id !='' - 165,815

My query is 
SELECT COUNT(*) AS Jumlah
FROM access a LEFT JOIN eprint b ON a.referent_id=b.eprintid
WHERE a.datestamp_year='2013' AND service_type_id='?fulltext=yes' AND referring_entity_id !='' AND eprint_status='archive'

Is there any other condition I should add to at least be near the one shown in the EPrint page?

Izwan
UiTM Digital Library

PENAFIAN: E-mel ini dan apa-apa fail yang dihantar bersama-samanya ("Mesej") adalah dihasratkan hanya untuk kegunaan penerima yang dinyatakan di atas dan mungkin mengandungi maklumat yang tidak umum, bermilik, istimewa, sulit dan dikecualikan dari penzahiran di bawah undang-undang yang terpakai termasuklah Akta Rahsia Rasmi 1972. BACA SELANJUTNYA...

DISCLAIMER : This e-mail and any files transmitted with it ("Message") is intended only for the use of the recipient(s) named above and may contain information that is non-public,  proprietary,  privileged,  confidential  and  exempt  from  disclosure under applicable law including the Official Secrets Act 1972. READ MORE...