Item Importances


Items on lists can be given a level of importance. This is used to indicate to students that they may wish to pay more or less attention to certain works.

Libraries often use the item importance in their purchase decision making processes and so want to track items which have importances and those that don’t

Questions you might be asking


This recipe includes some queries that use events.

There are a few things to be aware of when working with events in Talis Aspire Advanced MIS. Events are grouped into time windows with a count or sum per time window. Events are available for the last 30 days with a 1 hour granularity, and for the last 36 months with a 1 day granularity. Also as Talis add more events into Advanced MIS you may want to check when the first event of a particular class appears, as it may not be available for the full time range you are interested in.

Here are a couple of queries to see how far back event data is available:

-- data available since:
select min(time_window) from f_event_timeseries_24hr;

-- data available since for specific event:
select min(time_window) from f_event_timeseries_24hr
WHERE event_class = '';

It may be that there are different dates returned. For example, the reading intentions were only added to Advanced MIS from December 2018, but we have events in the database going back to May 2018.

A Basic Query

We start with a simple query to find out how many items do not have an importance set.

-- count the items
select count(item_guid)
from f_rl_items
where importance = '';

-- which items are they?
select item_url
from f_rl_items
where importance = '';

We could then look to see how many items there are for each importance type:

select importance, count(importance)
from f_rl_items
group by importance;

Which gives something like

Suggested for student purchase700

Linking importances to the hierarchy

We need to know that lists are linked to the hierarchy, and items are linked to lists. We need to also know about the hierarchy, for example that there are schools or departments which have modules, and it is these modules which are linked to lists

     f_rl_items items,
     f_rl_hierarchy_descendants hierarchy,
     f_rl_lists lists
      -- join lists to the hierarchy
      lists.hierarchy_url = hierarchy.url
      -- join lists to their items
      lists.list_guid = items.list_guid
      -- look for only nodes in the hierarchy that have a descendant of type 'Module'
          in (
              select url
              from f_rl_hierarchy
              where type = 'Module'
group by
order by

This might give us something like this which can then be processed into a chart

urlimportancecount for student purchase1 for student purchase132 for student purchase4 for student purchase49

Assumptions and limitations

Things to try

You could also now link in the f_event_timeseries_24hr table, looking for list.item.view events linked to the items that have importances.