The recently released version 2.1.6 of Xamin has some enhanced capabilities for handling bibcode queries. For some time the web interface has allowed users to ask whether any tables have rows that index observations which are referenced in a particular article using the syntax
where xxxx is the 19 character bibcode. The new version gives a bit more feedback about which bibcode was used when such queries are made.
The zzbib table can be used to find tables and rows matching a particular bibcode in the batch interface with a syntax like
java -jar users.jar table=zzbib constraint=bibcode="'xxxx'"
java -jar users.jar table=zzbib constraint=bibcode="'2014Natur.505..378C'"
2014Natur.505..378C|rosmaster |seq_id |RP200984N00
2014Natur.505..378C|rosmaster |seq_id |RP201583N00
2014Natur.505..378C|rosmaster |seq_id |RP201584N00
2014Natur.505..378C|rosmaster |seq_id |RP201585N00
2014Natur.505..378C|rosmaster |seq_id |RP201586N00
2014Natur.505..378C|rosmaster |seq_id |RP201587N00
Number of rows: 6
Number of columns: 4
will find the rows in zzbib that reference a particular bibcode. The other fields in zzbib indicate the table, the column of the table used to id specific rows the table, and the value for that id. [Note that since the bibcode is a string parameter in the zzbib table, the bibcode must be enclosed in single quotes. The enclosing double quotes make sure that the single quotes are actually part of the parameter and not processed by the shell.]
In the new release of Xamin you can also add bibcode constraints to particular tables with the new bibcode parameter:
java -jar users.jar table=rosmaster bibcode=xxxx
We can repeat our example above but get the actual data for the ROSMASTER rows
java -jar users.jar table=rosmaster bibcode=2014Natur.505..378C
seq_id |instrument|exposure|ra |dec |name
RP201587N00|PSPCB | 7749|22 43 33.6|44 00 00|EV LAC
RP201586N00|PSPCB | 5928|22 43 07.2|44 10 12|EV LAC
RP201585N00|PSPCB | 4561|22 43 09.6|44 10 12|EV LAC
RP201584N00|PSPCB | 3854|22 43 07.2|44 12 36|EV LAC
RP201583N00|PSPCB | 3445|22 43 07.2|44 13 12|EV LAC
RP200984N00|PSPCB | 2673|22 46 50.4|44 19 48|GL 873
Number of rows: 6
Number of columns: 6
will find all the rows in rosmaster referred to in a particular bibcode. You can add additional constraints to the query if you like. In this context since we have special processing of the bibcode it need note be enclosed in quotes, but if the bibcode contains special characters like ampersand you may need to use quotes or some other mechanism to escape shell processing.