Alex Pardy's dashboard

Alex Pardy set one of Alex Pardy's replies as an official response to "Is there a quick query I can run to get a list of the qualifications that no-one is attached to??" in Opportunity Links

Alex Pardy replied on December 03, 2009 10:51 to the question "Is there a quick query I can run to get a list of the qualifications that no-one is attached to??" in Opportunity Links:

Hello Lynne,

Made you up a quick query in your DB named Quals Unattached.

For everyone else the query is below

Select Qualification.QualificationID, Qualification.Name
From Qualification Left Join
PeopleQualification On Qualification.QualificationID = PeopleQualification.QualificationID Left Join
Course On Qualification.QualificationID = Course.QualificationID Left Join
RecruitmentRequiredQualification On Qualification.QualificationID = RecruitmentRequiredQualification.QualificationID Left Join
QualificationStaffRole On Qualification.QualificationID = QualificationStaffRole.QualificationID Left Join
RegistrationQualSummary On Qualification.QualificationID = RegistrationQualSummary.QualificationID
Where PeopleQualification.PeopleQualificationID Is Null And RecruitmentRequiredQualification.RecruitmentRequiredQualificationID Is Null And RegistrationQualSummary.RegistrationQualSummaryID Is Null And QualificationStaffRole.QualificationStaffRoleID Is Null And Course.QualificationID Is Null

Alex Pardy set one of Alex Pardy's replies as an official response to "Producing Reports from new quick search function." in Opportunity Links

Alex Pardy replied on December 03, 2009 10:25 to the question "Producing Reports from new quick search function." in Opportunity Links:

We need to make some changes to the reports webservice in order to allow you to run reports from the new quick search.

This will also involve a change to the reports that you would like to run on the new quick search. It will only be a very small change, as it stands at the moment you would just need to alter the line 'registration.registrationid in (<%registrationIDs%>)' to instead say 'Registration.registrationid in (<%registrationquickIDs%>)'

More information regarding this will be sent out with the next release of evince.

Alex Pardy replied on November 30, 2009 15:36 to the problem "Childcare searches" in Opportunity Links:

Hello Helen,

Would you be able to call the helpdesk and talk us through each step you are taking so we can re-create this.

Alex Pardy set one of Alex Pardy's replies as an official response to "Carescheme about box" in Opportunity Links

Alex Pardy set one of Alex Pardy's replies as an official response to "Carescheme about box" in Opportunity Links

Alex Pardy replied on November 25, 2009 15:24 to the question "Carescheme about box" in Opportunity Links:

no problem, would you be able to send us a quick email confirming this as we just need something in email format for our records.

Alex Pardy replied on November 25, 2009 12:38 to the question "Carescheme about box" in Opportunity Links:

Hi Craig,

Sure, I am happy to offer this out as a free datatask to all who request it. would you like the data deleted from any other information once it has been copied over to the carescheme about field?

Alex Pardy set one of Alex Pardy's replies as an official response to "Advanced Provider Search - Summary issues" in Opportunity Links

Alex Pardy replied on November 25, 2009 10:04 to the question "Advanced Provider Search - Summary issues" in Opportunity Links:

Hello Ruth,

We are aware of the issues with advanced provider search. We have more usability releases coming soon, I will try to get this looked at in these releases.

Regards,

Alex Pardy set one of Alex Pardy's replies as an official response to "Why is the accreditation field called different names depending on if it is in and organisation or service?" in Opportunity Links

Alex Pardy replied on November 25, 2009 09:57 to the question "Why is the accreditation field called different names depending on if it is in and organisation or service?" in Opportunity Links:

Hi James,

We will rename 'Quality awards' in organisation to be named 'Accreditation'.

Regards,

Alex Pardy set one of Alex Pardy's replies as an official response to "Why is there no 'awarding body' column when adding a qualification?!" in Opportunity Links

Alex Pardy replied on November 24, 2009 12:36 to the idea "Why is there no 'awarding body' column when adding a qualification?!" in Opportunity Links:

Hello Lynne,

I have added this as a change request, the ID is 5033.

Regards,

Alex Pardy set one of Alex Pardy's replies as an official response to "When was the last upload? When will be the next upload to PKHD?" in Opportunity Links

Alex Pardy replied on November 24, 2009 10:18 to the question "When was the last upload? When will be the next upload to PKHD?" in Opportunity Links:

Hi James, the last upload to PKHD was completed last friday. At the moment it is looking like the next update will be finished on monday (30th Nov). We need to wait until we have completed the evince release this week before we can begin a new upload.

Alex Pardy replied on November 23, 2009 16:34 to the problem "Lost training course delegate information" in Opportunity Links:

Thankyou Linda, I will try to see if i can replicate the problem.

Regards,

Alex Pardy set one of Alex Pardy's replies as an official response to "Two Active screens - Provider and childcare" in Opportunity Links

Alex Pardy replied on November 23, 2009 14:17 to the question "Two Active screens - Provider and childcare" in Opportunity Links:

Hello

This is possible but you need to be using Internet Explorer 7 or later in order to do it. if you wish to have multiple records open either 'right click' the link you wish to open and select 'Open in new tab' or alternatively simply open a new tab manually and then copy and past the address URL into the new tab.

regards,