Ændringer

Maintenance - Pooled Places with no Events (vis kilde)

Versionen fra 26. feb 2014, 11:05

729 bytes tilføjet , 26. feb 2014, 11:05

updated report

Linje 6: Linje 6:

== Purpose ==

−

This article shows you how you can create an Admin Report that lists all [[Pooling Places|pooled places]] not linked to any event.

+

This article shows you how you can create an Admin Report that lists all [[Pooling Places|pooled places]] not linked to any event.

== Creating the Report ==

Linje 56: Linje 56:

== Viewing and Using the Report ==

−

After saving the report changes, click the 'Test' button. The resulting report should look like this:

+

After saving the report changes, click the 'Test' button to run the report from the Admin screen. The resulting report should look like this:

−

[[File:Places-PooledReportResults.~~jpg~~]]

+

[[File:Places-PooledReportResults.png]]

+

Click on the link in the returned list to open the Place in another window or tab, where you can then verify that no events are associated with the place.

+

[[File:Places-PooledReportLinkedPlace.png]]

+

The verify will confirm that no Events are linked to this Place, but since the report does not check for Media linked to the place, it is possible that a Media record is linked to the place as shown below. In which case you will need to relink that Media record before deleting the Place record.

+

[[File:Places-PooledReportMediaLinkedPlace.png]]

+

You can then click the Delete icon to delete the place from your database.

+

[[File:Places-PooledReportDeletePlace.png]]

== Related Links ==

Linje 82: Linje 94:

* Original SQL - Luke Weerts

* Pooled Places SQL - Mark Wonson

−

* See TNG Forum: http://www.tngforum.us/index.php?showtopic=3273 for a variety of 'tweaks' to the original SQL and that provided here.

+

* See TNG Forum: http://www.tngforum.us/index.php?showtopic=3273 for a variety of 'tweaks' to the original SQL and that provided here.

[[Category:Reports]]

KenRoy

Bureaukrater, maintainer, Administratorer

17.946

redigeringer