StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
11440175
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2012-07-11T19:39:57.857
FavoriteCount
0
LastActivityDate
2012-07-11T19:45:46.263
LastEditDate
2012-07-11T19:45:46.263
LastEditorUserId
929796
OwnerUserId
929796
ParentId
11436239
PostTypeId
2
Score
0
ViewCount
0
LastEditorDisplayName
text
Body
Here's an alternative to Romans that I've tried. It uses $this->api->memorize to store a GET variable chosen in the drop down list in a session variable. Then in the Form, you can set default the chosen value by using recall in the model. Something like this in page/things <pre><code> // load the javascript function (see later) $this->js()->_load('your_univ'); /*****************************************************************/ /* Code to populate drop down lists - amend where as required*/ $catList=$this->api->db->dsql()->table('category c') ->field('c.id') ->field('c.name') ->where('c.type',$cat_type) ->order('c.id') ->do_getAssoc(); // Check if one is set on URL or default from config and memorize the value if ($_GET['cat']){ $cat=$_GET['cat']; } else { $cat=$this->api-getConfig('idCat'); } $this->api->memorize('category',$cat); $f=$p->add('Form',null,null,array('form_empty')) ->setFormClass('horizontal bottom-padded'); $l1=$f->addField('dropdown','category')->setValueList($catList)->set($cat); // calls a bit of javascript described later to reload with the parameter $l1->js('change')->univ()->yourfunc($p->api->getDestinationURL(null), $l1); .. rest of your page code goes here .. </code></pre> Then in /lib/Model/Category.php Add the following recall for the field <pre><code> $this->addField('idCat')->system(true)->visible(false) ->defaultValue($this->api->recall('category')); </code></pre> Note the system(true) and visible(False) means it wont show up and wont be changeable on the CRUD but you can play around with the options so it shows in the CRUD grid but not in the form. Finally, the little bit of javascript to make the reload work (Romans might advise a better way to do this). Make sure yourfunc matches in the page and in the js. in /templates/js/your_univ.js add the following <pre><code> $.each({ yourfunc: function(url, name){ document.location.href=url+'&cat='+$(name).val(); }, },$.univ._import); </code></pre> I've got code similar to this working in my own pages. You can probably make it work as a POST as well as the drop down is a form if you dont want the cat to show on the URL.
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POIs it possible to force the value of a new CRUD form field?
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. USTrevor North
UserOwnerUserId
1. USTrevor North
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. This table or related slice is empty.
VotesPostIdCreationDate
1. This table or related slice is empty.
CommentsPostId
1. This table or related slice is empty.

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.