You can change to bookmarkable form submissions, and you can restrict what appears in foreign key pull-downs.
GET vs. POST form methods
The plug-in assumes that you want to limit submissions to the POST method. This means that form submissions cannot be bookmarked. Often you will want to let your readers bookmark their submissions. If so, use allowGET to switch form submissions to the GET type.
<? $db->allowGET(); ?>
The plug-in will automatically display foreign keys as a series of choices. If you want to hide some of those choices, you can use a foreign filter to select only those choices you want.
For example, if you have a foreign key called “room”, and you only want to display the rooms where “public” is “yes”, you would use:
$publicRooms = array('public'=>'yes'); $view->foreignFilter('room', $publicRooms);
Or, if you have a category called “secret” through a foreign key called “category” and you want to make it invisible, you could use:
$categoryRestriction = array('title'=>array('operator'=>'not', 'value'=>'secret')); $view->foreignFilter('category', $categoryRestriction);
Direct access to the form
The SQL plug-in uses the Form Verification plug-in behind the scenes to manage forms. You can get direct access to the form object using $view->form or (if it hasn’t been created yet) using $view->getForm().