Destination data gathering and updating
Greetings,
I was approached with these questions and was hoping to hear some welcome input.
-
Is there a way to create a select query to see if "Publish to this Destination by default" is enabled throughout the sites model against a standardized name publish target?
-
In the KB documentation there is a way to disable all publish targets via the following line:
UPDATE cxml_destination SET isEnabled=0;
Is there a way to disable a single publish target with a standardized name throughout the sites model?
Discussions are closed to public comments.
If you need help with Cascade CMS please
start a new discussion.
Keyboard shortcuts
Generic
? | Show this help |
---|---|
ESC | Blurs the current field |
Comment Form
r | Focus the comment reply box |
---|---|
^ + ↩ | Submit the comment |
You can use Command ⌘
instead of Control ^
on Mac
Support Staff 1 Posted by Tim on 07 Jul, 2016 05:24 PM
Hi,
I imagine you could do something like this if you're just looking for a list of Destinations in each Site and whether or not they have that option checked:
If you're looking to disable all Destinations having a similar name, you would probably want to do something like this:
For example, if you had a Destination in Site A namedWeb Server - PROD - SiteA
and then a Destination in Site B namedWeb Server - PROD - SiteB
, disabling both of those would look like:NOTE: Performing
select
queries on the database is fine, but you should always backup the database prior to anyupdate
commands just in case you need to restore. You'll also want to check in with us first (as you've done here) before updating any of the raw database data.Let me know if this helps.
Thanks
2 Posted by rreynolds on 07 Jul, 2016 07:03 PM
I think that about covers it. Thanks again Tim.
Support Staff 3 Posted by Tim on 07 Jul, 2016 07:04 PM
You bet! Just let us know if anything else comes up!
Thanks
Tim closed this discussion on 07 Jul, 2016 07:04 PM.