As previously announced via banners and our newsletters, support is no longer available through this platform.

For easier navigation, you can still click on "Submit a Ticket" here, choose the appropriate category, and you'll be redirected to the correct support channel for your plugin.

You can still access your previous tickets and browse public tickets, but please note that responding to tickets is no longer possible.

Paid customers: Please log in to your store account for support.

Pre-purchase questions: Use the support widget in the bottom-right corner of our websites:
https://wpamelia.com
https://wpdatatables.com
https://wpreportbuilder.com

Okay
  Public Ticket #2911327
Assigning the column with the variable
Closed

Comments

  • James Yang started the conversation

    In your documentation for report builder and wp data tables, it says to create variables when you create a report.  The variables are ${X}.  During the process, you link this report to a table you create in wp data tables.  

    How does the report builder know which column is ${X}.

  • [deleted] replied

    Hi James

    Since you are creating a report from the related table, the information sent to the variables is defined by you and the report will only pull what you tell him to pull. You won't be able to put an unrelated variable into the report and expect results.

    Please have a look at our documentation on how to prepare templates for more detailed information on how to prepare variables as well

    https://wpreportbuilder.com/documentation/create-template-for-wordpress-report-builder/

    Do let us know if you need further assistance. 

  • James Yang replied

    thank you.

    different question.

    I created a table.  it has two fields.  the first field is due date which is a date.  origin header is duedate.  The second field is title of invention which is a string.  origin header is titleofinvention.

    I created the attached template.  

    for the duedate, I could get it to pull the data from the table if I used ${duedate.total}.  

    I could not get it to pull the data from the table if I used ${duedate.all}.  Actually, it sent back an error code.  I also could not get it to pull the data from the table if I used ${duedate}.  The downloaded template just inserted ${duedate}.  

    For the title of invention, I was unable to get it to pull the date.  I tried all three variants.  ${titleofinvention}, ${titleofinvention.all}, ${titleofinvention.total}.

    Please help.

  • [deleted] replied

    Hi James

    Since both of these are string columns you wouldn't be able to use variables for float and integer columns .total

    Can you please tell us more about the error you get when you use this variable ${duedate.all} can you provide us with a screenshot?

    Can you share the source file used to create the table so we can try and recreate the issue on our end? Do you have a link to the front end where we can test the described behavior?