TOPIC:

Filter FK by created_by 01 Dec 2017 10:30 #15465

MorganL
Topic Author
Offline
Platinum Member
Posts: 438
Thank you received: 53

I want an FK field on a form to only list records created by the logged in user. This is working fine for filters, but seems to be missing from FK fields.

It is worth noting that this is one of my two remaining legacy projects (not ORM)

Here is what I have

	<?php
	// Associated Title
	$field = $fieldSet['jform_associated_title'];
	$field->jdomOptions = array(
		'groupBy' => array(
			'type' => 'type'
		),

		'created_by' => $this->item->created_by, /// THIS WAS ADDED BY ME
		'list' => $this->lists['fk']['associated_title']
	);
	?>
	<div class="control-group <?php echo 'field-' . $field->id . $field->responsive; ?>">
		<div class="control-label">
			<?php echo $field->label; ?>
		</div>

		<div class="controls">
			<?php echo $field->input; ?>
		</div>
	</div>
	<?php echo(MyComponentHelperHtmlValidator::loadValidator($field)); ?>

The cretaed by filter was added by me thinking it would work. but it doesnt. Is there an option I can use in the JDom options to filter the FK Select field (single choice) by the logged in users records like the filter dropdown does

Morgan Leecy MCSE

Novell / Linux
PHP. MYSQL, Apache, node.js
Coldfusion, JQuery, HTML5
Joomla

Please Log in or Create an account to join the conversation.

Filter FK by created_by 01 Dec 2017 19:08 #15468

Romkabouter Offline Elite Member Posts: 310 Thank you received: 131	When I encountered this, I solved it by overriding the $this->lists or use 'list' => $associated_title_model->getItems(); $associated_title_model would be a model from what you need and then adding wheres and such: $model->addWhere('a.created_by='.(int)$user->id)
	Please Log in or Create an account to join the conversation.

Page:
1

Forum

General discussions

News & Chillout

Filter FK by created_by

Time to create page: 0.072 seconds

“

”

Freakin' Awesome!!! J-Cook is simply awesome - whether you're a highly experienced developer or complete novice whether you're building a small inventory component or a complete community solution! The beauty comes from a fast slick and reliable platform that readily provides developers with everything they'll need to build the backbone of a solid and secure component with wizards for authoring access publishing aliasing created/modified by dates... you name it COOK provides it! J-Cook really surpasses all of the 'competition' as far as MVC tools are concerned! Try love it and get cooking!
learnthrusong (JED)

TOPIC:

Filter FK by created_by 01 Dec 2017 10:30 #15465

Filter FK by created_by 01 Dec 2017 19:08 #15468

Get Started

Newsletter