Search requirements:

sit and stare data
exposure time < 20 secs
target = active region.

One can do like this:

select * from eis_level0 where FMIR_SS="0" and TARGET="active region" and (date_obs between "2007-03-15" and "2007-03-20") and slit_id=1 order by date_obs

Haven't figure out how to choose "exposure time", any help?

Jian, 8-Mar-2008

I think that in that way it works, but I didn't find any for the dates that you said:

select * from eis_level0 where FMIR_SS='0' and TARGET='active region' and (date_obs between '2007-03-15' and '2007-04-20') and slit_id=1 and (obt_end-obt_time)/512/nexp <20 order by date_obs

Note: For some reason you cannot just copy the previous line, you have to rewrite the ' or " symbols, if not it gives a syntax error.

-David Pérez-Suárez 11-Mar-2008

I once had something similar to this copy-and-paste problem. Looking at it now, I think that it may be due to how the Wiki displays opening and closing quote marks. In the raw source, they are normal quote marks, as you would use in IDL. But when they are processed and displayed by the Wiki, they appear to change to the kind of quote marks that MS Word uses, i.e., "sixes and nines". Try Just substituting normal quote marks for those that appear. For example, when I do that, I get 34 results with the above search.

-Dave Williams, 17-Mar-2008