LIST_TABLE syntax when displaying query results

If you have questions or if you want to share your opinion about Aware IM post your message on this forum
Post Reply
tford
Posts: 4238
Joined: Sat Mar 10, 2007 6:44 pm

LIST_TABLE syntax when displaying query results

Post by tford »

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.
Tom - V8.8 build 3137 - MySql / PostGres
4xjbh
Posts: 177
Joined: Thu Dec 22, 2005 10:01 pm
Location: Brisbane

Re: LIST_TABLE syntax when displaying query results

Post by 4xjbh »

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.
tford
Posts: 4238
Joined: Sat Mar 10, 2007 6:44 pm

Re: LIST_TABLE syntax when displaying query results

Post by tford »

This is a wild guess but could it be the minus '-' sign in the name. Can you change it to an underscore?
I simplified the syntax to narrow down the issue. This still has a problem:
<<LIST_TABLE(`TicketBuyersNotPaid`,`Amount`)>>

where:
- query name = TicketBuyersNotPaid
- one attribute in the TicketBuyersNotPaid query: Amount
Tom - V8.8 build 3137 - MySql / PostGres
aware_support
Posts: 7525
Joined: Sun Apr 24, 2005 12:36 am
Contact:

Re: LIST_TABLE syntax when displaying query results

Post by aware_support »

Why are you using ` symbol for apostrophe? Can you try using a standard one '
Aware IM Support Team
tford
Posts: 4238
Joined: Sat Mar 10, 2007 6:44 pm

Re: LIST_TABLE syntax when displaying query results

Post by tford »

This was a V6 BSV. Turns out the query does not work with LIST_TABLE in V6.
Tom - V8.8 build 3137 - MySql / PostGres
Post Reply