Example of How a Search Method Is Created¶

The figure Example of how a search method is created with ALTER TABLE shows an example of how to add a search method to a view.

CREATE TABLE bookview
...
...
...
    ADD SEARCHMETHOD bookview_sm1 (
        CONSTRAINTS (
            ADD TITLE (any) OBL ONE
            ADD AUTHOR (like) OPT ONE
            ADD FORMAT NOS ZERO ()
            ADD PRICE NOS ZERO ()
        )
        OUTPUTLIST (TITLE, AUTHOR, FORMAT, PRICE)
    WRAPPER (xml booktest)
);

This example adds a search method called bookview_sm1 to the base view bookview. This search method has four query constraints. They indicate that to make a query to the source, the query has to provide a value for TITLE (specifying any number of values). Optionally, a search can be made for the attribute AUTHOR (specifying any number of values) and the operator like. Direct queries for the rest of the attributes (FORMAT, PRICE, etc.) are not admitted. Furthermore, the search method definition indicates that all the attributes appear in the output. Finally, the XML wrapper called booktest is associated with the search method. It will be responsible for extracting the results, when a query is executed using this search method.