dlex

Filter query on table kern/cb

{ "meta": [ "cb_cit", "cb_token_freq_abs", "cb_type_freq_abs" ], "data": [ [ "n$", 23817002, 549551 ], [ "en", 21807617, 911144 ], [ "er", 20397671, 810754 ], [ "e$", 16046745, 382684 ], [ "ch", 15767737, 640602 ], [ "r$", 13564729, 177304 ], [ "$d", 13511971, 26106 ], [ "de", 12217218, 237361 ], [ "t$", 10447580, 179843 ], [ "ei", 10414096, 314896 ] ] }

Use HTTP_ACCEPT: application/json to get JSON only.

12 columns in table /kern/cb

Column	Description	Data type	User documentation
cb_cit		String case-sensitive	/doc/cb_cit/
cb_token_freq_abs		int	/doc/cb_token_freq/
cb_token_freq_nor		float	/doc/cb_token_freq/
cb_token_freq_abslog		float	/doc/cb_token_freq/
cb_token_freq_norlog		float	/doc/cb_token_freq/
cb_token_freq_rank		float	/doc/cb_token_freq/
cb_token_freq_rank123		int	/doc/cb_token_freq/
cb_type_freq_abs		int	/doc/cb_type_freq/
cb_type_freq_nor		float	/doc/cb_type_freq/
cb_type_freq_abslog		float	/doc/cb_type_freq/
cb_type_freq_rank		float	/doc/cb_type_freq/
cb_type_freq_rank123		int	/doc/cb_type_freq/

Selecting columns

By default, only one or several default columns are displayed (e.g., the type). To select more columns, use the select parameter:

http://sr/dlexdb/kern/cb/filter/?select=COL1[,COL2...]

If using select, the default columns are discarded unless you include them manually.

The default column selection is subject to change. Don't rely on it in your application!

Sorting

http://sr/dlexdb/kern/cb/filter/?orderby=[-]COL

The default sort order is subject to change. Don't rely on it in your application!

Limit and offset

http://sr/dlexdb/kern/cb/filter/?top=N&skip=M

Filtering

http://sr/dlexdb/kern/cb/filter/?COL__OP=VALUE

All query parameters of the form COL__OP (two underscores), where COL is a column name and OP is an operator, will be interpreted as filter conditions.

Operators are:

eq	equals (for numbers or strings, case-sensitive)
eqi	equals (for strings, case-insensitive)
re	regular expression match (for strings, case-sensitive)
rei	regular expression match (for strings, case-insensitive)
ge	greater or equal (for numbers)
le	less or equal (for numbers)

Multiple filters on the same field using the same operator are not allowed. One of them would be chosen randomly while the others are discarded.

Case-insensitive string fields can be queried with either the eq or the eqi operator without difference.