Assuming exists is required, the following 66 results were found.
-
is that the customer wants the item/product rate taken from the item record, 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...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
working in Zoho CRM. Why? To prove a point to ChatGPT who said this was not possible... and to deal with a scenario which exists for a client of mine. The use-case for my Cx is that they need documents converted from HTML to PDF — as in we send it a bit...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
Preceding is TRUE"; } If you're not expecting the user to enter any spaces at all and just want to check if the variable exists or is an empty string, then continue with: if(isNull(v_Test)) { info "isNull Preceding is TRUE"; } Additional Note(s): I've...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
a client and secret in the endpoint of a URL will no longer be supported in the Zoho Deluge invokeURL task... This article exists because I spent 2 hours going down the rabbit hole of trying to use OAuth2 and following the usual steps: Grant Code,...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
// m_CrmLineItem.put("Discount",v_DiscountAmount); l_CrmLineItems.add(m_CrmLineItem); } } // // if the CRM invoice already exists, we are going to upsert so we need to remove the current line items in the CRM invoice l_SearchInvoices =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
l_CrmLineItems.add(m_CrmLineItem); } } // // if the CRM Quote already exists, we are going to upsert so we need to remove the current line items in the CRM Quote l_SearchQuotes = zoho.crm.searchRecords("Quotes","Xero_Ref_ID:equals:" + v_XeroQuoteID);...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
(will either display or not on the front page so again not any use to sort by this) checked_out_time => just cos this value exists, don't know why you would order by this ordering => the setting it's on if you haven't made this modification. I don't...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
2.5.x) where it fails to email users who reset their password. How? A few things to check: Check the email message even exists: Login to your Joomla Admin Panel Navigate to Extensions > Language Manager Click on the “Overrides” label Click on “New” (but...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
the system-wide cron directory. cat "${CRONDIR}"/* | clean_cron_lines >>"${temp}" # */ # Add each user's crontab (if it exists). Insert the user's name between the # five time fields and the command. while read user ; do crontab -l -u "${user}"...
- Type: Article
- Author: Joel Lipman
- Category: Linux
- Language: *
-
myself but this displays an AlertDialog designed by an XML layout file ("res/layout/dialog_edititem_photo"). The ImageView exists in another XML with an identifier called @+id/hangar_aircraft_photo. The following is a full example of what can be added...
- Type: Article
- Author: Joel Lipman
- Category: AndroidOS
- Language: *
-
Items > Tick the "For Each Loop Container") Add the Data-Flow to the container (or drag into the container if it already exists) Edit the ForEach Loop Container (or double-click on it) Under General, give it a reasonable name of your choice Under...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB
-
in the dropdown menu Select "Data Sources" in the left menu Specify a "shared data source" and browse to it to ensure it exists. Ensure unattended system account scheduled to run and email the report can access the datasource (ask a DBA if you're...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
(apologies for the red censoring but this allows the images to be used in further demonstrations): Note that a footer exists (contains page number) because if printed, the page would end on a dataset row and continue the next page with the rest of the...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
permission to execute this function for whatever user/system account that will run it. -- Drop the function if it already exists IF OBJECT_ID ('ufn_DataJumble', 'FN') IS NOT NULL DROP FUNCTION ufn_DataJumble ; GO -- Create user defined function CREATE...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
Thinking outside of the box Hooray for you non-sheep! This is what I've come up with: -- Drop Stored Procedure if already exists IF OBJECT_ID ( 'dbo.usp_MakeTableTemp', 'P' ) IS NOT NULL DROP PROCEDURE dbo.usp_MakeTableTemp; GO -- Create Stored...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
plan on deploying the report to it. Scenario: We want to report on a MySQL database MySQL login information is a user who exists as a MySQL user and a server user. Reporting server is remote as well as the MySQL database. BIDS is on the client machine....
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
PageID NOT IN (SELECT ArticleID FROM MyTable2) -- STATEMENT3 SELECT PageID, PageTitle, PageContent FROM MyTable1 WHERE NOT EXISTS (SELECT ArticleID FROM MyTable2 WHERE MyTable2.ArticleID = MyTable1.PageID) -- STATEMENT4 SELECT PageID, PageTitle,...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
system. Create test space with same access details. Database Setup For JoelLipman.Com to do: Backup original database if exists already Assign unique database name Assign unique database username/password Add the user to the database Create test...
- Type: Article
- Author: Joel Lipman
- Category: Web-Development
- Language: *
-
(eg. movies, music, etc). My aim is to do the following: retrieve data from a table, count the number of times each data exists, sort it in reverse order so that the most frequent is at the top of the list print out each row with the number of times...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: *
-
DOT for records that will be output. Check that DRE contains the rules for the DOR code you are using. Check that an ERE exists relating to the EOR code you are using.
- Type: Article
- Author: Joel Lipman
- Category: Extensible Markup Language
- Language: *