Advanced SQL Filtering
Advanced SQL Filtering
By Paul
03/22/04 (Edited 01/30/14)
Warning: This is an advanced topic and you should probably consult WSN support about it first if you're not a programmer.
At Admin Panel -> Articles -> Article Settings, there's an option "Only Show Articles Where." This is an advanced option intended for use in rare cases by people somewhat familiar with MySQL.
In this field you can supply any MySQL condition, and it will be used inside the "where" clause of the queries which select links. Thus for example if you put recipurl != ''
in the field, it would effectively prevent any links which lack a reciprocal URL from being shown on your site.
This sort of method can on occasion be useful when you're doing multiple installs and want to share most of the content. You could set up a custom field to mark which installations a article should be displayed on, and then use the filtering condition whichsite='applicable' OR whichsite='' to filter.
By Paul
03/22/04 (Edited 01/30/14)
At Admin Panel -> Articles -> Article Settings, there's an option "Only Show Articles Where." This is an advanced option intended for use in rare cases by people somewhat familiar with MySQL.
In this field you can supply any MySQL condition, and it will be used inside the "where" clause of the queries which select links. Thus for example if you put recipurl != ''
in the field, it would effectively prevent any links which lack a reciprocal URL from being shown on your site.
This sort of method can on occasion be useful when you're doing multiple installs and want to share most of the content. You could set up a custom field to mark which installations a article should be displayed on, and then use the filtering condition whichsite='applicable' OR whichsite='' to filter.
Description | Making use of the 'only show links where' setting. |
Rating | |
Views | 2035 views. Averaging 0 views per day. |