Assuming staff is required, the following 46 results were found.
-
the value in between the opening and closing XML tags: -- Using .query() SELECT CAST(CAST(Event_XML AS XML).query('data(/STAFF/GENDER)') AS VARCHAR(10)) AS Gender FROM [dbo].[XML_EVENTS] -- Returns column GENDER for every record/row (eg. "Male") Or --...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
for each r_Service in l_Services { if(!isnull(r_Service.get("id"))) { v_ServiceName = r_Service.get("name"); } } Get the staff: // // get staff r_StaffResults = zoho.bookings.getRelatedRecords("Staffs","Services",v_ServiceID,"joels_connector"); l_Staff...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
but that of the normal week (in other words, not alphabetical, numerical, or completely random order): void JoelLipman.fn_SetStaffUsualShift() { // // build a standard usual shift subform from CRM r_OrgDetails = invokeUrl [ url:...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
is a page of some MySQL queries I can do based on just those 5 columns: MediaWiki: number of unique guests, students and staff by month. Also associates a UserID to the wikimedia_user table to identify a user. SELECT CONCAT(MONTHNAME(t2.Date), ' ',...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: *
-
be a breeze, but that's because I don't implement group policies at home. Why? We get problems with this because none of our staff are full administrators of their local workstation. As IT staff we have elevated privileges but not absolute rights to...
- Type: Article
- Author: Joel Lipman
- Category: Windows OS
- Language: en-GB
-
we created a button off a Bill record in ZohoBooks which generates a text file to be sent to a bank and downloads it to the staff member's workstation. Why? Why is this a challenge? The file contains bank details and should not be stored anywhere....
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
// delete any tasks that were transferred from the lead record relating to reminding staff to convert the lead. // l_RelatedTasks = zoho.crm.getRelatedRecords("Tasks", "Contacts", p_ContactID); for each m_RelatedTask in l_RelatedTasks {...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
is a fair bit of coding, you may want to ask us to build this solution for you. It can take a few days but it will save your staff a ton of time per week! What your staff see: How? So we're going to create a button. Let's use the example of a credit...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
numbers with more than 6 decimal places. As this is more than specified on the ZohoCRM field properties, as soon as the staff user tries to save the record, they will get a validation error on the decimal field even if that's not the field that is being...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
Forum Ruleshttps://www.joellipman.com/static-items/forum-rules.html
it does the same damage, regardless of your reasons for breaking it, and you will be punished all the same. Amendment 2 - Staff abuse will not be tolerated. As a staff member, your job is to help the people, not harm them. You may only use your powers...
- Type: Article
- Author: Joel Lipman
- Category: Static Items
- Language: *
-
who graduated and left the institution. It was a custom-built site written from scratch, and it's purpose was to manage Staff and Students within the Additional Learning Needs group. These are staff who take lecture notes for people of all disabilities...
- Type: Article
- Author: Joel Lipman
- Category: Web-Development
- Language: *
-
third was using Mozilla Firefox. We told them to go back to the template providers and report the same problem to them...??? Staff member requiring access to a secure application "So that's all installed for you. I just need you to restart your computer...
- Type: Article
- Author: Joel Lipman
- Category: Web-Development
- Language: *
-
We have a specific timetabling system for academic institutions and all our staff/students follow academic week numbers as opposed to calendar week numbers. Why? The aim of this article is to quickly generate a calendar for a full academic year for...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
"00" ; Background image to change to during the running of this program DesktopBackgroundImage1:="\\bournemouth.ac.uk\data\Staff\Home\jlipman\My Pictures\byeBU\byeBU_byPChristopher.bmp" ; Background image to revert to once program ends...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: *
-
custom app. Why? My use-case scenario here is that we have a Zoho Creator app which comprises of a custom quote builder that staff use to store details about a product, and then to push that product out to their Shopify store with a pre-built...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
it. When are colors used? Well in this use-case, we are using it to color events in a calendar associated with specific staff. Probably not the most essential part of a system but important to some staff... How? In an earlier article, I've shown how to...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
'USER' AND pa.code = 'SPECIAL1' pa.person_reference = ps.person_reference order by pa.last_modified_date desc ) FROM Person_Staff ps -- In oracle, yields "missing parenthesis" error. So you can see my parentheses are fine. Working Solution: SELECT...
- Type: Article
- Author: Joel Lipman
- Category: Oracle PL/SQL
- Language: *
-
the list with the selected item and filtering the options available for selection. Why? This was for a multi lookup with staff as the list entries. The lookup needed to filter against various forms such as Staff Rotas, Leave Requests, Qualifications and...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: en-GB
-
sure about, it will return as shockwave files. This could be a security concern but as our MediaWiki is on our Intranet for Staff use only, it isn't.
- Type: Article
- Author: Joel Lipman
- Category: Hypertext Markup Language
- Language: en-GB
-
an internal wiki knowledge base using MediaWiki version 1.14. Some articles are available for public, some are restricted to staff and different localgroups. When users click on the 'Login' link, we want the system to automatically prompt them for their...
- Type: Article
- Author: Joel Lipman
- Category: MediaWiki
- Language: en-GB
Donate & Support
bc1qf6elrdxc968h0k673l2djc9wrpazhqtxw8qqp4
0xb038962F3809b425D661EF5D22294Cf45E02FebF