Numeric columns not shown once using Fields(Optional)

  • Resolved Maarten van Loon

    (@maarten-van-loon)


    10 years, 7 months ago

    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://www.ads-software.com/plugins/exports-and-reports/

Viewing 8 replies - 1 through 8 (of 8 total)
  • Plugin Author Scott Kingsley Clark

    (@sc0ttkclark)

    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

    (@maarten-van-loon)

    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

    (@sc0ttkclark)

    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

    (@maarten-van-loon)

    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

    (@sc0ttkclark)

    Have you tried entering the “kostengroep.uurprijs” into the field “Real Name” option?

    Thread Starter Maarten van Loon

    (@maarten-van-loon)

    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

    (@sc0ttkclark)

    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

    (@maarten-van-loon)

    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.