2. PHPRunner General questions
  3. [SOLVED]  show record if active
This topic is locked
[SOLVED]

 show record if active

 		8/2/2017 01:25:24
PHPRunner General questions
S
 shoppy author

Let me try to explain.
In my project I have records that are active an inactive.

To see witch is witch I colour the inactive ones red.

But some list become longer and longer and I would like to not show the inactive records by default.

Then I want a button to make them show when needed, active and inactive.
The field that makes them active or inactive is called 'status' and inactive = 2.
How can I do this
jadachDevClub member 8/2/2017

Why not use the new feature in v9.8 - Tabs and additional WHERE on List page?
Sergey Kornilov admin 8/2/2017

WHERE tabs is the way to go:

status='2'


or

status<>'2'
S
 		shoppy author 8/2/2017

I use 9.6 and cannot find it.

Is it only in 9.8?
jadachDevClub member 8/2/2017

Yes, this is new in 9.8. Definitely worth upgrading.
S
 		shoppy author 8/2/2017

I believe you but that's no option for me.
Is there another way for me to do this?
S
 		shoppy author 8/3/2017

For now I just used the query Designer and added an ascending on the 'status'.

So now they are under the active records and 'out of site'.
For now it is good.
Thanks for the advice