Package: Db\Table
Can specify a range of valid Item IDs or an individual ID
Parameters: |
|
---|---|
Returns: | void |
Run the search filter on the SELECT statement
Parameters: |
|
---|---|
Returns: | void |
Build the simple search.
The search query consists of a derived table that is INNER JOINed to themain SQL query. That derived table is a union of two SELECT queries. Thefirst query searches the FULLTEXT index on the items_elements table, andthe second query searches the tags table for every word in the searchterms and assigns each found result a rank of ‘1’. That should maketagged items show up higher on the found results list for a given search.
Parameters: |
|
---|
Build the advanced search.
Parameters: |
|
---|
Apply a filter to the items based on whether or not they should be public
Parameters: |
|
---|---|
Returns: | void |
Parameters: |
|
---|
Filter the SELECT statement based on an item’s collection
Parameters: |
|
---|---|
Returns: | void |
Filter the SELECT statement based on the item Type
Parameters: |
|
---|---|
Returns: | void |
Query must look like the following in order to correctly retrieve items that have all the tags provided (in this example, all items that are tagged both ‘foo’ and ‘bar’):
SELECT i.idFROM omeka_items iWHERE(i.id IN(SELECT tg.record_id as idFROM omeka_records_tags tgINNER JOIN omeka_tags t ON t.id = tg.tag_idWHERE t.name = ‘foo’ AND tg.record_type = ‘Item’)AND i.id IN(SELECT tg.record_id as idFROM omeka_records_tags tgINNER JOIN omeka_tags t ON t.id = tg.tag_idWHERE t.name = ‘bar’ AND tg.record_type = ‘Item’))...
Parameters: |
|
---|---|
Returns: | void |
Filter the SELECT based on the user who owns the item
Parameters: |
|
---|---|
Returns: | void |
Filter SELECT statement based on items that are not tagged with a specific set of tags
Parameters: |
|
---|---|
Returns: | void |
Filter SELECT statement based on whether items have a derivative image file.
Parameters: |
|
---|---|
Returns: | void |
Possible options: ‘public’,’user’,’featured’,’collection’,’type’,’tag’, ‘excludeTags’, ‘search’, ‘range’, ‘advanced’, ‘hasImage’,
Parameters: |
|
---|---|
Returns: | void |
Enables sorting based on ElementSet,Element field strings.
Parameters: |
|
---|
This is a kind of simple factory that spits out proper beginnings of SQL statements when retrieving items
Returns: | Omeka_Db_Select |
---|
Return the first item accessible to the current user.
Returns: | Item|null |
---|
Return the last item accessible to the current user.
Returns: | Item|null |
---|
Parameters: |
|
---|
Parameters: |
|
---|
Parameters: |
|
---|