Assuming refer is required, the following 41 results were found.
-
t0 WHERE [pretendField]='elephantastic' -- end your original SQL query here (note no "order by" allowed -- refer to 6th line of this query for order by) ) AS t1 ) -- Query that will display extracted data SELECT t2.*, CASE WHEN t2.Day=t3.Day THEN NULL...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
a time against a project Task but this article is focused on getting this working against Project Issues. Also note, we will refer to Project Issues in this article, but in the backend code, Zoho refer to Issues as "Bugs". Why? At time of this article...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Projects
- Language: *
-
another article on how to access the Joomla Database using the Joomla classes but this is just a quick note for myself as a reference sheet. Plus the official documentation don't have enough examples in my view. Source: http://docs.joomla.org/ for...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
with upgrading a Joomla! CMS and running MySQL statements against your database. For the purposes of this article, we will refer to the live/current/production website running Joomla v2.5 as "v25" and the new Joomla instance as "v34". Their respective...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
existence of those rows is stored in another table, how do we delete from all the related tables as well? How? You need to refer to the tables just after the DELETE clause (so instead of DELETE FROM myTable WHERE myValue=givenValue): DELETE s, ssf, sst...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: *
-
with programming languages, I often need to write the accompanying documentation. Within the documentation, I may want to refer to a line of code within a text file. I also find myself copying amounts of code into the same document and then needing...
- Type: Article
- Author: Joel Lipman
- Category: MS-DOS
- Language: *
-
code snippet took me a while to do and the documentation is flaky so I thought I'd make a note here just in case I need to refer to it again. Why? I want to modify a picklist and fill it with options from a certain time of the day to the closing time of...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
- 1; } l_Output = l_OutputShuffled.subList(0,v_StrLength); v_Output= l_Output.toString(""); return v_Output; } This is my preferred method and it will return a string of 5 random uppercase letters. Method #2: Convert time to letters I've previously used...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
to put the customer portal on a subdomain (eg. "customerportal.joellipman.com" instead of "www.joellipman.com"), then please refer to your domain registrar's website on how to setup a subdomain. Here is the gist of what you need to do in your respective...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
was written. One is that there are 2 sets of documentation and the other is that the majority of the documentation doesn't refer to OAuth 2.0/json and instead uses the deprecated authtoken v1 and XML. How? The trick in this solution was more about the...
- Type: Article
- Author: Joel Lipman
- Category: Zoho People
- Language: *
-
},... AND .. "userlookup221_2":{ "name":"Another Joel", "id":"12345600000987653" },... So I'll just refer to https://www.zoho.com/crm/developer/docs/api/v8/insert-records.html and here's the code to associate 1 user in the multi-user lookup:...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
v_Output = r_Api.Access_Token; } } else { //info "Re-using Token"; } } return v_Output; } Get Notification Preferences [Optional] Here's a function to run just to see what the current notification preferences are setup. This one didn't tell me much...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
supported in additional parameters, I find the below works in CRM just fine: As of 2025, this method no longer works. Please refer to method 2 using a search API or a COQL query (see below). // ****************** CODE USING SEARCHRECORDS...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
dataset should be just the profit per item based on what was purchased. I'm including the Purchase Order ID so that I can refer to it later for shipping charges and other discrepancies. I'm calling this dataset "My Purchase Order Items" SELECT DISTINCT...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Analytics
- Language: *
-
= r_DealLookup.id; let r_DealDetails = ZDK.Apps.CRM.Deals.fetchById(v_DealID); // get Deal/Opportunity fields we need to refer to var v_OppType = r_DealDetails.Type_of_Opportunity; var v_DealRate0 = r_DealDetails.Rate_Year_1_0; var v_DealRate1 =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
month" } ] } } Usage: This is just a snippet of usage and obviously not the whole function to generate an invoice. Please refer to the Zoho Books API documentation for what fields are required to complete a request within your system. m_InvoiceDetails =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
will push some of the details of the ticket and all/any attachments to a Zoho Creator form. The ticket form has the ticket reference, product information, factory/supplier, the fault/description, and a subform to a form called "Documents" linked by a...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
post a new quote to the system as well as show previous orders. How? We're going to use the Zoho Extension SDK. You should refer to my previous linked article but the revised instructions here should also help. Then lastly, I'll post the snippet of code...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
if a pricebook is specified and the item exists within it, then it takes the rate from the pricelist. Note that when I refer to pricebook, this is also referred to as the pricelist... and vice-versa. And in this use-case, my client has added an...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
to simply install a JS widget hosted by Zoho and pass the record ID via a button to it, I'm adding it here in case I need to refer to it in future. Why? We have an Accounts module which holds all the companies we deal with in our Zoho CRM. I want our...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *