publications table improvements

[kelle]

because the shortname field includes numbers, we can't filter on it. E.g., searching for "cruz" gives no results while "cruz02" finds one record.

This table should be modified to allow filtering on first author last name.

[kelle]

ok, well, filtering actually worked for me in SQLite (v 3.8.0) but didn't work for @paigegiorlagodfrey. I asked her to update her sqllite browser and try again.

[hover2pi]

You just do db.search('cruz', 'publications') or if you just want to search the short name column db.search('cruz', 'publications', columns=['shortname']). Is that what you want?