Query field: this combo box can be used to enter the query field.
Operator: this combo can be used to enter a simple SQL operator. Operators referenced in the combo entry are "=", "!=", "<", ">", "<=", ">=" and "like", but you can also enter any SQL operator ("in",...).
Value: this combo box can be used to specify a value for the specified query field. String values may be entered without 'quotes', except when you enter specific SQL operators like "in" ; in this case, you should enter the complete value, with the exact SQL syntax.
Add button: this button is used to add the currently entered parameter value in the corresponding list. Value placed in the list is the exact SQL query code.
Delete buttons: these buttons are used to delete currently selected parameter in the corresponding list.
Clear buttons: these buttons are used to completely erase all query parameters in the corresponding list.
Combine fields with AND/OR: if fields are combined with 'AND' (default value), all the values given for several fields must have been specified on a given film or image for it to be retrieved by the query ; if fields are combined with 'OR', a film or image is retrieved by the query just if one of the fields values is found. Several values for a same field are always combined by 'OR'.
Combine keywords with AND/OR: if keywords are combined with 'OR' (default value), a film or image is retrieved by query if one of the given keywords is found ; if keywords are combined with 'AND', every given keywords have to be found for a film or image to be retrieved by query.
Combine fields and images with AND/OR: the "AND / OR" radio buttons placed between films and images query parameters just means : do you want to combine film and images query values with 'AND' (in which case both of them have to be verified) or with 'OR' (in which case just one of them have to be verified).
the films list displays any film corresponding to the films query, or any film containing images corresponding to the images query.
if a query is entered on images, the images list displays images of the selected film corresponding to the images query ; if no query is entered on images, the images list displays all images of the currently selected film.
![]() | Combining films parameters with 'AND' or keywords with 'OR' can take a rather long time... |