Forums

Solved: Where SQL toggle

abasel 01 Jan, 2013
My listing is set using (`archive`!='archived') not to list entries that I consider archived. Is there an easy way to add a checkbox so that I can toggle this option i.e. change it to (`archive`='archived')?
abasel 01 Jan, 2013
TO add some more detail,

My ChronoConnectivity listing looks as follows:
[attachment=1]ScreenShot002.jpg[/attachment]
And my Chronofrom Actions look as follows with the download link being created in the "Show Thanks Message" of the "On Listing" section.
[attachment=0]ScreenShot001.jpg[/attachment]
I am looking for some code that I could add to the "Show Thanks Message" section that would allow me to set the "Where SQL" field.
abasel 02 Jan, 2013
I think that I got it working. I added another event called ListingArchives
[attachment=0]ScreenShot003.jpg[/attachment]

"Show Thanks Message (6)" contains
<p><a href="/index.php/bookings-download">Download Enrollment List</a><p>
<p><a href="/index.php?option=com_chronoconnectivity&chronoconnection=Bookings_Update_Archives">Manage Archives</a><p>


And Show Thanks Message (10) contains
<p><a href="/index.php/bookings-download">Download Enrollment List</a><p>
<p><a href="/index.php?option=com_chronoconnectivity&chronoconnection=Bookings_Update">Manage Current Entries</a><p>
This topic is locked and no more replies can be posted.