yii2 gridview hide empty column not working

Question

I want to hide yii2 gridview empty column if value is null but my code is not working.

I have tried this code:

[
 'attribute'=>'division',
 'value'=>'divisionName.name',
 'visible' => function ($data) {
  if ('divisionName.name' == NULL) {
   return '0'; // or return true;
  } else {
   return '1'; // or return false;
  }
 },
]

And then tried this:

[
 'attribute'=>'division',
 'value'=>'divisionName.name',
 'visible' => function ($data) {
  if ('divisionName.name' == NULL) {
   return  true;
  } else {
   return  false;
  }
 },
]

Above both line of codes not working.

If divisionName.name equal to null then hide entire column from gridview, what is wrong with this code?

This is totally confused, IMO. You cannot set a function for 'visible', only true or false is allowed. And this property is only evaluated once, it does not check for each row if there is a value or not and decides whether the column should be shown or not. And 'divisionName.name' == NULL is false - you compare a string with NULL. And if(...) return true; else return false; ... don't you know that this is absolutely superfluous? — robsch
– robsch, Commented Jul 12, 2016 at 12:28
@robsch in 'visible' attrinute you can assingn alos the result of a test .. — ScaisEdge
– ScaisEdge, Commented Jul 12, 2016 at 12:37

ScaisEdge · Accepted Answer · 2016-07-12 13:43:15Z

1

Seems you have also a logical problem because you would show a null value and hide a not null value ..

The right solution is based on an check for the hide/show condition before the widget is showed

$showDivision = myFunctioForShow(...);

[
     'attribute'=>'division',
      .....
      'visible' => $showDivision ,
] ,

edited Jul 12, 2016 at 13:43

answered Jul 11, 2016 at 19:15

ScaisEdge

133k10 gold badges98 silver badges111 bronze badges

Sign up to request clarification or add additional context in comments.

9 Comments

Muhammad Shahzad Over a year ago

Thanks I will try.

robsch Over a year ago

'division' == null is always false.

ScaisEdge Over a year ago

@robsch why 'division' == NULL is always false?

robsch Over a year ago

Don't you compare a string with NULL?

ScaisEdge Over a year ago

@robsch in this case 'division' si not a string but a key taht the gridview widget should convert the related column value to the proper value .. 'division' is not a literal string but the key for column gridview ..

|

Collectives™ on Stack Overflow

yii2 gridview hide empty column not working

1 Answer 1

9 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

9 Comments

Your Answer

Sign up or log in

Post as a guest

Related