Title: Numeric columns not shown once using Fields(Optional)
Last modified: August 21, 2016

---

# Numeric columns not shown once using Fields(Optional)

 *  Resolved [Maarten van Loon](https://wordpress.org/support/users/maarten-van-loon/)
 * (@maarten-van-loon)
 * [12 years ago](https://wordpress.org/support/topic/numeric-columns-not-shown-once-using-fieldsoptional/)
 * **issue 1)**
 * I wrote a query where I select some alphanumeric and some numeric fields. The
   query itself works fine (tested in phpadmin), and works in your plugin as long
   as I don’t use the part Fields(Optional).
 * I needed to add the fields in this part “Fields(Optional)”. because I want to
   use the search functionality. This works fine for all alpha fields, but not for
   the numeric fields. These columns remain empty (using ‘data type = Text’) or 
   all zeros if using data type = Number (no decimal). Type in the mySql database
   is decimal(12,0). Field created with your pods plugin.
 * If I change the datatype of the pods field to ‘plain text’ (varchar 255), the
   query works fine and now this column shows its data, even while using the “Fields(
   Optional)” part
 * It’ll be great if this could be fixed, so that numeric data is still shown correctly,
   when using the “Fields(Optional)” part?
 * **issue 2)**
 * Further, once there is the need to use this “Fields(optional)” part for just 
   one column, you must add all selected fields in this part. Otherwise only the
   added fields are shown in the result. Why is that the case? Now, I select 20 
   fields, and only 2 need to be searchable. To make these 2 columns searchable,
   I need to add all 20 fields in this “Fields(Optional)” part.
 * [https://wordpress.org/plugins/exports-and-reports/](https://wordpress.org/plugins/exports-and-reports/)

Viewing 8 replies - 1 through 8 (of 8 total)

 *  Plugin Author [Scott Kingsley Clark](https://wordpress.org/support/users/sc0ttkclark/)
 * (@sc0ttkclark)
 * [12 years ago](https://wordpress.org/support/topic/numeric-columns-not-shown-once-using-fieldsoptional/#post-4821863)
 * I’m not entirely sure what’s causing Issue 1 for you. Would have to do more testing
   to see, but unfortunately my time for this plugin is reduced compared to Pods
   itself.
 * By the way, our team is actually working on the next major iteration of Exports
   and Reports and it’ll have native Pods integration.
 * For Issue 2, yes, the intention was to add all fields to the list, that you want
   used. This makes it possible to select additional fields and use aliasing, for
   more complex situations and custom displays of certain column values.
 *  Thread Starter [Maarten van Loon](https://wordpress.org/support/users/maarten-van-loon/)
 * (@maarten-van-loon)
 * [12 years ago](https://wordpress.org/support/topic/numeric-columns-not-shown-once-using-fieldsoptional/#post-4821866)
 * Scott, maybe difficult to answer. Do you have any idea of the due date regarding
   this new Exports and Reports? And does it have, at least, the same query/sql 
   functionality compared to this current “exports-and-reports” plugin.
 * I have to say, it is great functionality, and can’t find anything like it within
   the worpress community. But at this moment, it does not work entirely (like the
   issue with numeric fields I have right now).
 *  Plugin Author [Scott Kingsley Clark](https://wordpress.org/support/users/sc0ttkclark/)
 * (@sc0ttkclark)
 * [12 years ago](https://wordpress.org/support/topic/numeric-columns-not-shown-once-using-fieldsoptional/#post-4821868)
 * I don’t have an ETA on the new iteration, it’s something that will take more 
   work to finish up. It will have the same query/sql/fields functionality as it
   has now, but with the added ability to query against Pods with a more streamlined
   admin page.
 * For issue 1, what’s your field name exactly?
 *  Thread Starter [Maarten van Loon](https://wordpress.org/support/users/maarten-van-loon/)
 * (@maarten-van-loon)
 * [12 years ago](https://wordpress.org/support/topic/numeric-columns-not-shown-once-using-fieldsoptional/#post-4821869)
 * I’ve created a more simple query for myself to test this issue:
 * **The query:**
 * SELECT kostengroep.`uurprijs` “Uurprijs”
    FROM `wp_pods_kostengroep` kostengroep
 * So, the field is kostengroep.`uurprijs` (sorry, dutch language)
 * If I just run the query using export/reports, it does work. Once I add the field
   below (fields/optional), the columns it shown, but remains empty. If I convert
   the field in pods (and in the database) to alphanumeric, everything works fine.
 *  Plugin Author [Scott Kingsley Clark](https://wordpress.org/support/users/sc0ttkclark/)
 * (@sc0ttkclark)
 * [12 years ago](https://wordpress.org/support/topic/numeric-columns-not-shown-once-using-fieldsoptional/#post-4822090)
 * Have you tried entering the “kostengroep.uurprijs” into the field “Real Name”
   option?
 *  Thread Starter [Maarten van Loon](https://wordpress.org/support/users/maarten-van-loon/)
 * (@maarten-van-loon)
 * [12 years ago](https://wordpress.org/support/topic/numeric-columns-not-shown-once-using-fieldsoptional/#post-4822091)
 * yes, absolutely.
 * I also needed to do this for all other alphanumeric fields to work. And when 
   I switch the pod field from “Plain number” to “plain text”, the query does work.
 *  Plugin Author [Scott Kingsley Clark](https://wordpress.org/support/users/sc0ttkclark/)
 * (@sc0ttkclark)
 * [12 years ago](https://wordpress.org/support/topic/numeric-columns-not-shown-once-using-fieldsoptional/#post-4822093)
 * What’s your localization set for numbers on your PHP/WP site? Is it x,xx where“,”
   is the decimal place, or is “.” the decimal?
 *  Thread Starter [Maarten van Loon](https://wordpress.org/support/users/maarten-van-loon/)
 * (@maarten-van-loon)
 * [12 years ago](https://wordpress.org/support/topic/numeric-columns-not-shown-once-using-fieldsoptional/#post-4822110)
 * x,xx
 * “,” is the decimal character, not “.”

Viewing 8 replies - 1 through 8 (of 8 total)

The topic ‘Numeric columns not shown once using Fields(Optional)’ is closed to new
replies.

 * ![](https://s.w.org/plugins/geopattern-icon/exports-and-reports.svg)
 * [Exports and Reports](https://wordpress.org/plugins/exports-and-reports/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/exports-and-reports/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/exports-and-reports/)
 * [Active Topics](https://wordpress.org/support/plugin/exports-and-reports/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/exports-and-reports/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/exports-and-reports/reviews/)

 * 8 replies
 * 2 participants
 * Last reply from: [Maarten van Loon](https://wordpress.org/support/users/maarten-van-loon/)
 * Last activity: [12 years ago](https://wordpress.org/support/topic/numeric-columns-not-shown-once-using-fieldsoptional/#post-4822110)
 * Status: resolved