Bugzilla – Attachment 11447 Details for
Bug 8587
Add a serial lifespan to serial subscriptions
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
saved sql report we use
file_8587.txt (text/plain), 1.18 KB, created by
Maxime Pelletier
on 2012-08-08 14:52:37 UTC
(
hide
)
Description:
saved sql report we use
Filename:
MIME Type:
Creator:
Maxime Pelletier
Created:
2012-08-08 14:52:37 UTC
Size:
1.18 KB
patch
obsolete
>SELECT > biblio.title AS "Abonnement", > subscription.subscriptionid AS "No. Abonnement", > serial.serialseq AS "No. Séquence", > serial.serialid AS "No. périodique", > ExtractValue(biblioitems.marcxml, '//record/datafield[@tag="952"]/subfield[@code="2"]') AS "Classification", > ExtractValue(biblioitems.marcxml, '//record/datafield[@tag="952"]/subfield[@code="o"]') AS "Cote", > ExtractValue(biblioitems.marcxml, '//record/datafield[@tag="952"]/subfield[@code="c"]') AS "Emplacement", > serial.planneddate AS "Date réception", > DATE_ADD(serial.planneddate, INTERVAL subscription.seriallifespan YEAR) AS "Date d'expiration", > CONCAT(CAST(subscription.seriallifespan as CHAR(2)), ' ans') AS "Durée de vie", > serial.notes AS "Note périodique", > subscription.notes AS "Note abonnement" >FROM > subscription > INNER JOIN serial > ON subscription.subscriptionid = serial.subscriptionid > INNER JOIN biblioitems > ON serial.biblionumber = biblioitems.biblionumber > INNER JOIN biblio > ON biblioitems.biblionumber = biblio.biblionumber >WHERE > serial.status = 2 > AND subscription.seriallifespan != -1 > AND DATE_ADD(serial.planneddate, INTERVAL subscription.seriallifespan YEAR) < now()
You cannot view the attachment while viewing its details because your browser does not support IFRAMEs.
View the attachment on a separate page
.
View Attachment As Raw
Actions:
View
Attachments on
bug 8587
:
11424
|
11437
| 11447 |
11513
|
17600
|
19415
|
19416
|
30636
|
30637
|
30953
|
41217