We're Moving to a New Support Platform – Starting June 1st!

We’re excited to let you know that starting June 1st, we’ll be transitioning to a new support system that will be available directly on our product websites – Amelia, wpDataTables, and Report Builder. In fact, the new support platform is already live for Amelia and wpDataTables, and we encourage you to reach out to us there.

You'll always be able to reach us through a widget in the bottom right corner of each website, where you can ask questions, report issues, or simply get assistance.

While we still do not offer live support, a new advanced, AI-powered assistant, trained on our documentation, use cases, and real conversations with our team, is there to help with basic to intermediate questions in no time.

We're doing our best to make this transition smooth and hassle-free. After June 1st, this current support website will redirect you to the new "Contact Us" pages on our product sites.

Thanks for your continued support and trust – we’re excited to bring you an even better support experience!

Okay
  Public Ticket #867857
Show empty value as blank, not zero
Closed

Comments

  •  2
    Aidan started the conversation
    August 21, 2016 at 12:37pm

    Hi,

    I found this ticket showing the same issue, but changing the column data type to string doesn't solve it:

    http://wpdatatables.com/ticket/suppress-zeros/

    Some cells in my table will be empty, where the data isn't available. At the moment, the table is showing these as a zero value (0.00). It's better if these show as an empty cell.

    How do I do that? It doesn't work to change the data type to string. I need it to be a float, because searching the column with a number range is what the end-users will need to do.

    Thanks and regards,

    Aidan Sweeney

  • [deleted] replied
    August 22, 2016 at 12:45pm

    Hi,

    Thank you for your purchase.


    Please tell me what kind of table do you use? Is it server side or not? Also do you have zeros and empty spaces or just empty spaces? 


    Please help us make our product better by filling out this survey where you can also vote for new features.

    Hope this helps, 

    Miljko Milosevic

    [email protected]

  •  2
    Aidan replied
    August 22, 2016 at 11:01pm

    Hi Miljko,

    Yes, it's server-side. The data has both empty spaces and zeros.

    Ideally, I'd like the zeros to show as zero, and the empty spaces (null value/blank) to show as empty spaces.

    Thanks and regards,

    Aidan

  • [deleted] replied
    August 23, 2016 at 6:59pm

    Hi,


    It can be done as custom solution with hook for float column type -  wpdatatables_filter_float_cell but it will break sorting and probably number range filter. Problem is that blank space doesn't have value and because of that it need some workarounds  to make sorting and filtering working.


    Please help us make our product better by liking our Facebook page where you can see all news related to plugin.

    Hope this helps, 

    Miljko Milosevic

    [email protected]