Conditional substitutions

I am having a problem getting a conditional substitution to work despite spending some time trying to unravel the tutorial .

In the CBS Invoice I am using

NOTE: The current status of this payment is <[PAYMENT_STATUS]>[cb:if [DATE_PAID]!=""] and the payment date was <[DATE_PAID]>[/cb:if].

and wanting the second part to only appear if there is a value in the DATE_PAID field. Currently it fails to appear even when the payment has been completed. (Without the if code it appears all the time.)

I have tried a number of combinations without success. I have looked at the database Baskets table and am guessing that the underlying field is the payment_date field which can be null.

Guidance sought.

J2.5.14, CB1.9, CBS 3.0.0

If it worked it'd be as follows, but I don't think you can use the CBSubs substitutions in an IF statement. They're for information display.

[cb:if DATE_PAID!=""]Content here.[/cb:if]

Please see the below tutorial for further substitution usage information. There are IF usage examples at the bottom.

www.joomlapolis.com/support/tutorials/107-use-cases/18353-using-substitutions-throughout-cb

Thanks Kyle, but can confirm this did not work in the IF statement.

Yup, they're for display purposes only. If you want to condition such information you'll need to first query for it using a CB Query Field then try and condition the query field. We've plans to improve the substitution API so it'll be easier to add new values to it so things like this can be possible, but for now CB Query Field is probably the only way to do it for now.

Thanks Kyle.

I think in my case the Query field option gets very messy given that each user might have many payments (each with a different DATE_PAID) so an open-ended number of Query fields would need to be created. And then there would need to be a conditional choice of the correct Query field to display in each Invoice.

I look forward to the next version of the substitution API.

I think in my case the Query field option gets very messy given that each user might have many payments (each with a different DATE_PAID) so an open-ended number of Query fields would need to be created. And then there would need to be a conditional choice of the correct Query field to display in each Invoice.

You only need the latest payment date so you won't need to grab every payment, but you probably would need a field per plan.

I look forward to the next version of the substitution API.

This isn't happening until way later. Like CB 2.0 later. So I would not wait for it and simply implement a workaround if this is needed now. Improved substitutions will not be in 1.10.0.