Opasnet Base UI: Difference between revisions
Jump to navigation
Jump to search
mNo edit summary |
mNo edit summary |
||
| Line 8: | Line 8: | ||
SELECT * FROM obj WHERE ident="<object identifier>"; | SELECT * FROM obj WHERE ident="<object identifier>"; | ||
</code> | </code> | ||
=== Newest act === | |||
<code> | |||
SELECT series_id FROM actobj WHERE obj_id=<object id> ORDER BY series_id DESC LIMIT 0,1; | |||
</code> | |||
[[category:extension]] | [[category:extension]] | ||
Revision as of 13:09, 1 March 2010
This special page implements user interface to fetch data from the Opasnet Base -database.
Queries
This chapter describes the queries that Base UI executes.
Basic object data
SELECT * FROM obj WHERE ident="<object identifier>";
Newest act
SELECT series_id FROM actobj WHERE obj_id=<object id> ORDER BY series_id DESC LIMIT 0,1;