I have successfully used LIST TABLE often when displaying a list of all instances of a BO or all items in a reference list of a BO.
Now I'm trying to display the result of a query and having a problem with the syntax. Here is what I have:
<<LIST_TABLE(`Ticket Buyers - Not Paid`,`Nbr_of_tickets`, `Amount` `Buyer_Name`, `Buyer_Email`, `TS_Payment_Initiated,M/d/yy h:mm a`)>>
The issue is somehow in the first element which is the query name.
LIST_TABLE syntax when displaying query results
LIST_TABLE syntax when displaying query results
Tom - V8.8 build 3137 - MySql / PostGres
Re: LIST_TABLE syntax when displaying query results
This is a wild guess but could it be the minus '-' sign in the name. Can you change it to an underscore?
Regards, James
AwareIM 7.1 on AWS - Beware I'm a AwareIM noob. Anything I help you with might make the hole your in deeper.
AwareIM 7.1 on AWS - Beware I'm a AwareIM noob. Anything I help you with might make the hole your in deeper.
Re: LIST_TABLE syntax when displaying query results
I simplified the syntax to narrow down the issue. This still has a problem:This is a wild guess but could it be the minus '-' sign in the name. Can you change it to an underscore?
<<LIST_TABLE(`TicketBuyersNotPaid`,`Amount`)>>
where:
- query name = TicketBuyersNotPaid
- one attribute in the TicketBuyersNotPaid query: Amount
Tom - V8.8 build 3137 - MySql / PostGres
-
- Posts: 7525
- Joined: Sun Apr 24, 2005 12:36 am
- Contact:
Re: LIST_TABLE syntax when displaying query results
Why are you using ` symbol for apostrophe? Can you try using a standard one '
Aware IM Support Team
Re: LIST_TABLE syntax when displaying query results
This was a V6 BSV. Turns out the query does not work with LIST_TABLE in V6.
Tom - V8.8 build 3137 - MySql / PostGres