"Is not null" (#1132283) / TMS-Plugins

Comments

6
Alex started the conversation
April 12, 2017 at 5:29am
Hello
In my query need to sort out a few fields and only show that is not null. Is this possible?
6
Alex replied
April 12, 2017 at 8:13am
I almost solved this problem. Just put all the values from s1 to s27 and are not showing these columns. And added the column with the formula: s1+s2+s3+s4+s5+s6+s7+s8+s9+s10+s11+s12+s13+s14+s15+s16+s17+s18+s19+s20+s21+s22+s23+s24+s25+s26+s27
But the amount is obtained by error - an extra digit 6039250! See screenshot from phpMyadmin, there are no numbers 6039350! where is she?
Ant the screenshot "the first 5 results" - 6039250! where is she?
6
Alex replied
April 12, 2017 at 8:37am
it turns out that if you remove the numbers from the names of the columns, everything works! For example, sa and not s1. But this is nonsense!
1,894
Miloš replied
April 12, 2017 at 3:13pm
Hi Alex,
Thank you for your purchase.

Can you please point me to the table ID so I can take a look.
Thank you.
Kind Regards,

Miloš Jovanović
[email protected]

Rate my support
Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/

wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs

Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community

You can try wpDataTables add-ons before purchasing on these sandbox sites:

Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables
6
Alex replied
April 12, 2017 at 6:10pm
Hi Bogdan
Sorry, but this site I can't give access
But now everything works, I removed the numbers from column names

1 Like