Stay Connected with Us: Its All Free!

LIS Links Digest
LIS Links News and Announcements Email SubscriptionLIS Links News and Announcements Google Plus Page FollowLIS Links News and Announcements Facebook Page LikeLIS Links News and Announcements Twitter FollowLIS Links RSS Feed
LIS Links Jobs LIS Links Jobs Email Subscription LIS Links Jobs RSS Feed Subscription
LIS Links Events LIS Links Events Email Subscription LIS Links Events RSS Feed Subscription
LIS Links Forum LIS Links Forum Email Subscription LIS Links Forum RSS Feed Subscription
LIS Links Photo LIS Links Photo Email Subscription LIS Links Photo RSS Feed Subscription
LIS Links Video LIS Links Video Email Subscription LIS Links Video RSS Feed Subscription
Facebook Group | Google Plus Profile
To Join our Free Mobile Alert Send an SMS
JOIN LLINKS to 9220092200

24 Hours Approval Policy of LIS Links

If your Forum / Job / Event / Group / Photo / Video is not approved within 24 hours of posting, then you are requested kindly to report it Here

LIS Links Administrators

Members Administrator: Badan Barman
Event Administrator: B. Asadullah
Forum Administrator: Manjunath K S
Blog Administrator: Munesh Kumar
Photo Administrator: Niharika Saikia
Video Administrator: Selvam M
Chat Administrator: Äshök ßhatt
Group Administrator Kankana Baishya

LIS Links Statistics

1. Date of Origin: 26th February, 2008.
2. Creator: Badan Barman.
3. Daily Pageviews: 9,583 (Average).
4. Members: 20,590.
5. Discussions Postings: 8,552.
6. Job Postings: 5,246.
7. Events Postings: 973.
8. Photos Postings: 1,358.
9. Videos Postings: 4.
10. Groups: 133.
11. Broadcast Message Subscribers19,205.
12. LIS Links Digest Subscribers: 8,559.
13. SMS Subscribers: 542.
14. Google Plus Followers: 90.
15. Facebook Likes: 7,591.
16. Twitter Followers: 571.
17. Alexa Rank: 10,015 in India.

Dear Professional colleagues,

Is there any easy way to know the last Accession Number in Koha other than generating Accession Register Report.

Abdul Gafoor

MESCE,KERALA

Views: 385

Reply to This

Replies to This Forum

hello sir try this SQL CODE:

SELECT *
FROM items
WHERE
homebranch = Pick your branch|branches>>
AND barcode LIKE CONCAT( '%', Partial barcode value here>>, '%')

Thanks my dear friend.

Sir Koha Report about if you need help or if you have any questions ask me....
thank you sir

Thanks my dear for your kindness,

One more thing i would like to know how to generate Accession Register between a particular range. Example -Acc no from 2000 to 3000 or 5000 to 10000 etc. and in ascending order.

Pls guide me,

thanks and regards.

Hello sir,

I have an SQL programme for accession register between two barcodes.

The only problem is it is not sorted by decimal numbering, it gives binary sorting of barcode numbers. I request Murali Krishnan to help us to sort this issue.

Chitralekha

SELECT CONCAT('<a href=\"/cgi-bin/koha/catalogue/detail.pl?biblionumber=',biblio.biblionumber,'\">',biblio.biblionumber,'</a>') AS biblionumbers,
       items.barcode, items.dateaccessioned, items.itemcallnumber, biblioitems.isbn, biblio.author, biblio.title, biblioitems.pages,
       biblioitems.publishercode, biblioitems.place, biblio.copyrightdate, items.price, items.stocknumber,items.booksellerid, items.location   
FROM items
LEFT JOIN biblioitems ON (items.biblioitemnumber=biblioitems.biblioitemnumber)
LEFT JOIN biblio ON (biblioitems.biblionumber=biblio.biblionumber)
WHERE items.homebranch =Branch|branches>> AND
items.barcode BETWEEN Barcode from>> AND  Barcode to>> ORDER BY LPAD(items.barcode,40,' ') ASC



 Dear mam

I run the report, as you have directed a slight change is required. some of our professional friends should come to sort out this problem.

thanks and regards

RSS

© 2017   Created by Badan Barman.   Powered by

Badges  |  Report an Issue  |  Terms of Service