Advanced Search

Here are a few examples of how you can use the search feature:

Entering this and that into the search form will return results containing both "this" and "that".

Entering this not that into the search form will return results containing "this" and not "that".

Entering this or that into the search form will return results containing either "this" or "that".

Search results can also be filtered using a variety of criteria. Select one or more filters below to get started.

Assuming both is required, the following 107 results were found.

  1. ZohoCRM & Xero: Function to pull most recent quoteshttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zohocrm-xero-function-to-pull-most-recent-quotes.html

    l_SearchAccounts = zoho.crm.searchRecords("Accounts","Xero_Ref_ID:equals:" + v_XeroContactID,1,2,{"approved":"both","converted":"both"}); for each m_SearchAccount in l_SearchAccounts { if(!isNull(m_SearchAccount.get("id"))) { b_CreateAccount = false;...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  2. Migrate Joomla! 1.5.x to 2.5.x+https://www.joellipman.com/articles/cms/joomla/migrating-from-joomla-15-to-16.html

    database management tool (phpMyAdmin, workBench, navicat, sqlyog?) and connect to the new database. This script will use both databases, reading from the old Joomla database and writing to the new one. To run this script, your user needs SELECT, INSERT...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *
  3. Migrating from Joomla 2.5.x to 3.4.xhttps://www.joellipman.com/articles/cms/joomla/migrating-from-joomla-2-5-x-to-3-4-x.html

    Copy over Users: Rename the Admin ID in the new v34 system to match your v25 system. Check your usergroups are the same in both systems. Import new ones. Copy all users except the v25 admin to your v34 database (with status=blocked) Copy over user group...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
  4. ZohoFlow & ZohoSign: Retrieve a Zoho Sign document request and add attachments to CRM recordhttps://www.joellipman.com/component/content/article/zohoflow-zohosign-retrieve-a-zoho-sign-document-request-and-add-attachments-to-crm-record.html?catid=138&Itemid=165

    != "") { l_SearchResults = zoho.crm.searchRecords("Deals","(Reference_ID:equals:" + v_DealRef + ")",1,200,{"converted":"both","approved":"both"}); for each r_Result in l_SearchResults { if(!isnull(r_Result.get("id"))) { v_DealID =...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Sign
    • Language: *
  5. SSRS Querying on either of 2 Parametershttps://www.joellipman.com/component/content/article/ssrs-querying-on-either-of-2-parameters.html?catid=75&Itemid=165

    added the OR part to all my datasets (so where each one says if studentreference is blank then compare to studentadaccount)… Both solutions have the issue where they will return all rows where studentadaccount is blank (this field can be null in the...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  6. Joes Quicklist Weblinks (JQW) Downloadshttps://www.joellipman.com/component/content/article/joes-quicklist-weblinks-jqw-downloads.html?catid=105&Itemid=165

    Mon, 1st Aug 2011 1.4.3 - Parameter: Enable MouseOver Popups - Parameter: Display Descriptions: no, alongside, popup, both - Parameter: Display Images: no, alongside, popup, both - Parameter: Display Date: no, alongside, popup, both - Parameter: Display...

    • Type: Article
    • Author: Joel Lipman
    • Category: Downloads
    • Language: *
  7. Win32 Constantshttps://www.joellipman.com/component/content/article/win32-constants.html?catid=48&Itemid=165

    81 Const SM_CMETRICS = 83 ;#End Region ;#Region ScrollBarTypes Const SB_HORZ = 0 Const SB_VERT = 1 Const SB_CTL = 2 Const SB_BOTH = 3 ;#End Region ;#Region SrollBarInfoFlags Const SIF_RANGE = $0001 Const SIF_PAGE = $0002 Const SIF_POS = $0004 Const...

    • Type: Article
    • Author: Joel Lipman
    • Category: AutoHotkey
    • Language: *
  8. ZohoCRM: zoho.crm.searchRecords only returns certain recordshttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zohocrm-search-records-only-returns-certain-records.html

    is getting a JSON response with a zoho.crm.getRecordByID() with a quote that works and a quote that doesn't Comparing both records JSON and finding the $converted system field is different. Checking the Zoho documentation for an example showing how you...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  9. PHP Script: Make your own Thumbnail Generator via APIhttps://www.joellipman.com/articles/cms/website-development/php/php-script-make-your-own-thumbnail-generator-via-api.html

    thumbnail copy? This article is for me if I ever want to recreate an online tool capable of receiving an image URL and which both generates and outputs a thumbnail image and makes it downloadable via URL. Why? Performance. I have a client with about 10k...

    • Type: Article
    • Author: Joel Lipman
    • Category: Personal Home Page
    • Language: *
  10. ZohoCRM & Xero: Function to pull most recent invoiceshttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zohocrm-xero-function-to-pull-most-recent-invoices.html

    l_SearchAccounts = zoho.crm.searchRecords("Accounts","Xero_Ref_ID:equals:" + v_XeroContactID,1,2,{"approved":"both","converted":"both"}); for each m_SearchAccount in l_SearchAccounts { if(!isNull(m_SearchAccount.get("id"))) { b_CreateAccount = false;...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  11. CSS keeping the footer at the bottomhttps://www.joellipman.com/articles/cms/website-development/css/css-keeping-the-footer-at-the-bottom.html

    had a semi-transparent layer that overlapped it half-way. I managed to fix this by including a div push layer which clears both (even though i had clear:both on the css for my #right div layer). For some reason, it has a more forceful effect in its own...

    • Type: Article
    • Author: Joel Lipman
    • Category: Cascading Stylesheets
    • Language: en-GB
  12. SITS: Export field code and namehttps://www.joellipman.com/articles/cms/website-development/xml/sits-export-field-code-and-name.html

    (v8.7.0) What? You might be able to work it out from the online manuals but it took me a while, we wanted to bring back both the code and the lookup value in our XML to our Staging environment. Why? Let's take the country of birth of a person as an...

    • Type: Article
    • Author: Joel Lipman
    • Category: Extensible Markup Language
    • Language: *
  13. PC Build 2022: 5 Monitors connected to 1 PC using 1 GPUhttps://www.joellipman.com/component/content/article/pc-build-2022-5-monitors-connected-to-1-pc-using-1-gpu.html?catid=45&Itemid=165

    Diagram: Home PC has a graphics card with 1x HDMI, 1x DVI, and 1x VGA output ports: I connected the 2 acer monitors which both accepted DVI. Work PC has a graphics card with 1x Display Port output port: I connected 1 DP to miniDP cable to the 1st...

    • Type: Article
    • Author: Joel Lipman
    • Category: Articles
    • Language: *
  14. Add Image Mouseover effect in AutoHotkey GUIhttps://www.joellipman.com/component/content/article/add-image-mouseover-effect-in-autohotkey-gui.html?catid=48&Itemid=165

    x45 y40 w520 r1 vSearchTextInput Limit70, Search... Gui, Show OnMessage(0x200, "WM_MOUSEMOVE") Return ; FUNCTION TO HANDLE BOTH TOOLTIP AND MOUSEOVER EVENT WM_MOUSEMOVE() { static CurrControl, PrevControl, _TT ; _TT is kept blank for use by the ToolTip...

    • Type: Article
    • Author: Joel Lipman
    • Category: AutoHotkey
    • Language: en-GB
  15. Licence GNU/GPLhttps://www.joellipman.com/component/content/article/licence-gnugpl.html?catid=50&Itemid=165

    For the developers' and authors' protection, the GPL clearly explains that there is no warranty for this free software. For both users' and authors' sake, the GPL requires that modified versions be marked as changed, so that their problems will not be...

    • Type: Article
    • Author: Joel Lipman
    • Category: Static Items
    • Language: *
  16. Client Services: Website Development Agreementhttps://www.joellipman.com/component/content/article/client-services-website-development-agreement.html?catid=50&Itemid=165

    website is finalised, the following need to be agreed: Parallel running with legacy systems – testing and confirmation that both systems are operational, data needs to be entered in both systems. (this is only necessary if this is an upgrade or...

    • Type: Article
    • Author: Joel Lipman
    • Category: Static Items
    • Language: *
  17. Joes FREE Website Thumbnailer (JWT)https://www.joellipman.com/component/content/article/joes-free-website-thumbnailer.html?catid=53&Itemid=165

    Tested on: Windows XP SP3, Windows 7 (both 32-bit) Tested with: MS Internet Explorer 7 libraries System Requirements: Used ~55Mb RAM on 1.6Ghz PC Free Disk space to store your pictures Installed MS Internet Explorer (only uses libraries) Program Size:...

    • Type: Article
    • Author: Joel Lipman
    • Category: Product Documentation
    • Language: *
  18. Joes Quicklist Weblinks (JQW)https://www.joellipman.com/component/content/article/joes-quicklist-weblinks-jqw.html?catid=53&Itemid=165

    up your entitlement to FREE prints extremely quickly. The "STOP Thumbnail Service" parameter was created to be economical to both your server and the free service. Use this wisely and you could get away with generating a million images for FREE! Error...

    • Type: Article
    • Author: Joel Lipman
    • Category: Product Documentation
    • Language: *
  19. Zoho Creator: Set Up Custom Domain for Customer Portalhttps://www.joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-set-up-custom-domain-for-customer-portal.html

    effects have been propagated. A test I like to do is open the command-line in MS-Windows or the terminal on MacOS, and ping both creator.cs.zohohost.com and the subdomain example.joellipman.com. These should both respond with the same IP address. 3. Get...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
  20. Zoho CRM: Update a custom field in line items / product details using REST API v2.1https://www.joellipman.com/articles/crm/zoho/zoho-crm/zoho-crm-update-a-custom-field-in-line-items-product-details.html

    to ensure we get CRM records that are also pending approval or being converted. m_Params = Map(); m_Params.put("approved","both"); m_Params.put("converted","both"); r_InvoiceDetails = invokeurl [ url :"https://www.zohoapis.eu/crm/v2.1/Invoices/" +...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
Results 1 - 20 of 107