Dear All,
My library uses DDC scheme of classification and we are looking for a
report that will count items checked out allowing us to select day(s) of
issue, select itemtype and group the statistics by DDC 10 broad classes.
*EXAMPLE*
IN a date range say 1st-31st March 2020.
*DDC Class | NO.
Hi Rogan,
After following your advice to have same filters for both queries, I now are
able to get the results I desire.
I also removed the join for biblioitems and indeed it was not necessary.
No words can express my sincere appreciation for the time you took to help me
out. I can only say a big
Hi James,
One simple way to handle it is with a case statement. The
following example has a static between filter for the dates but it
illustrates this approach. You can also do some cleaning to make sure there
aren't spaces in front and it assumes that all of your DDC numbers in fact
start with
Hi Rogan and Team,
I really appreciate your assistance towards my problem. The query does
indeed work to answer my need. Another query was also pushed to me towards
the same.
I'm now looking for a way to SUM my answer to get the total number of books
issued. Any suggestions would be most welcome
Hi James,
If I'm understanding correctly you want an additional row giving a sum of
all the numbers in addition to the per class one? The simplest way it
occurs to me to do that is with a UNION ALL statement. I've taken some
filters out for brevity but this illustrates the approach:
SELECT CON
Hi James,
The query I posted worked with my quick test. Could you post your query as
it is now?
On Sat, Mar 14, 2020 at 9:52 AM muiru james wrote:
> Hi Rogan and All,
>
> I cant thank you enough for the tremendous effort you have put towards
> helping me solve my problem.
>
> You do indeed u
Hi Rogan,
I reintroduced two filters date abd itemtype. So that i can sekect any date be
it weekly monthly or quarterly etc. I also have different itemtypes sone of
which do not start wih a digit and I need to filter them out yo get accurate
results. (Your advice on whether the filters might be
Hi James,
A few thoughts from skimming it.
1) I don't see where you're using biblioitems anywhere in the report unless
I'm just not seeing it so you probably don't need it for a join. I don't
think it'll hurt anything other than slow the report less than you'll even
notice but still ... if not
8 matches
Mail list logo