Loading Profile...
Alex has just written us an excellent query to check what our records are tagged to.
Alex has written us a query that reports back what we have tagged records to and the zones/categories that they are in. We hope to use this to check back our paper tagging and also monitor our coverage of s12 topics.
He did it super quick and I am so impressed I wanted everyone to know. If you want it I'm sure Alex would do it for you too (just don't all ring at once).
Cheers Alex
He did it super quick and I am so impressed I wanted everyone to know. If you want it I'm sure Alex would do it for you too (just don't all ring at once).
Cheers Alex
I’m over the moon.
Follow this praise to get notifications on your dashboard.
-
Inappropriate?Or even better i'll paste the two queries below and all you need to do is copy them into new queries :)
Bulletin board related records : -
Select BulletinBoard.BulletinBoardID,
BulletinBoard.ProjectVacancy,
BBZone.BBZoneName,
BBMainCategory.CategoryTitle,
BBSubCategory.SubCategoryTitle,
BBZone.BBZoneID
From BBSubCategory left join BBMainCategory On BBMainCategory.MainCategoryCode = BBSubCategory.MainCategoryCode left join BBZone On BBZone.BBZoneID = BBMainCategory.BBZoneID inner join BulletinBoard On BBSubCategory.SubCategoryID = BulletinBoard.SubCategoryID
Where bulletinboard.bulletinboardid in (<%bulletinboardid%>)
Order by bulletinboard.projectvacancy,
bbzone.bbzonename,
bbmaincategory.categorytitle,
bbsubcategory.subcategorytitle
Organisation records :-
Select Organisation.OrganisationID,
Organisation.Name,
BBZone.BBZoneName,
BBMainCategory.CategoryTitle,
BBSubCategory.SubCategoryTitle,
BBZone.BBZoneID
From Organisation left join OrganisationCategorisation On Organisation.OrganisationID = OrganisationCategorisation.OrganisationID left join BBSubCategory On BBSubCategory.SubCategoryID = OrganisationCategorisation.SubCategoryID left join BBMainCategory On BBMainCategory.MainCategoryCode = BBSubCategory.MainCategoryCode left join BBZone On BBZone.BBZoneID = BBMainCategory.BBZoneID
Where organisation.organisationid in (<%organisationids%>)
Order by organisation.name,
bbzone.bbzonename,
bbmaincategory.categorytitle,
bbsubcategory.subcategorytitle
EMPLOYEE
