Home filter with yes ,no and all in postgres
Reply: 0

filter with yes ,no and all in postgres

user511 Published in April 26, 2018, 1:44 pm

I have a table in Postgres like

id phone_number
1 null
2 444444444
3 null
4 48572444444
5 4822555555

and there is a filter like has_value.Filter contain 3 value 'Yes','No' and 'Select All'.I want to filter data on basis of this filter if 'yes' then shown all id and mobile number which have a mobile number. if 'no' it must show null mobile number.if 'All' then all record.

You need to login account before you can post.

About| Privacy statement| Terms of Service| Advertising| Contact us| Help| Sitemap|
Processed in 0.344771 second(s) , Gzip On .

© 2016 Powered by mzan.com design MATCHINFO