Cannot get conditional statement to work

Question

Hello, I'm having trouble getting my CC to pull data from the db. Here you can see my config.

[attachment=0]ccv5.jpg[/attachment]

ckstatus is an integer and will either be a 1 or 0. When I click on the "Staff on Site" menu option I only get this:

[attachment=1]ccv5b.jpg[/attachment]

What am I doing wrong?

Thanks for your assistance.

chriso0258 · Accepted Answer

I figured it out. I needed to add the model to the column list. For example, I had put lname:Last Name when I should have put staffonsite.lname:Last Name.

Forums

Cannot get conditional statement to work