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 pages is required, the following 41 results were found.

  1. URL passed settings in Reporting Serviceshttps://joellipman.com/component/content/article/url-passed-settings-in-reporting-services.html?catid=75&Itemid=165

    to the name and folder of your report. To hide all except the report (default is True) http:///ReportServer/Pages/ReportViewer.aspx?%2fMYREPORTS%2fDemos%2fRB+Report+for+Me&rs:Command=Render &rc:Toolbar=False To hide just the parameters (default is True)...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  2. ZohoCRM: Using Criteria with Module Record Counthttps://joellipman.com/articles/crm/zoho/zoho-crm/zohocrm-using-criteria-with-module-record-count.html

    Not sure about the rest of you, but I've been using this for pagination purposes and for the system to work out how many pages or loops in total it would need to do. How? Here's a couple of working examples I use in production systems: Pre-amble: I'm...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  3. Zoho Survey & Zoho Analytics: Query to generate individual responses and grouped pageshttps://joellipman.com/articles/crm/zoho/zoho-analytics/zoho-survey-zoho-analytics-query-to-generate-individual-responses-and-grouped-pages.html

    r2 ON r."Respondent ID" = r2."ID" LEFT JOIN "Response Variables (Zoho Survey)" r3 ON r2."ID" = r3."Respondent ID" LEFT JOIN "Pages (Zoho Survey)" p ON r."Page ID" = p."ID" WHERE p."Title" 'GENERAL' ORDER BY "Response Date" DESC, "Attempt ID", "Page...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Analytics
    • Language: *
  4. Background Gradient Disappears on Long Pageshttps://joellipman.com/articles/cms/website-development/css/background-disappears-on-long-pages.html

    background (blue) making the text very hard to read. Why? Took me a while to figure out what was the problem, I'd visit some pages and they'd be fine, but when visiting a long page, it would initially display properly but then the white background would...

    • Type: Article
    • Author: Joel Lipman
    • Category: Cascading Stylesheets
    • Language: *
  5. Zoho CRM: searchRecords with sorted resultshttps://joellipman.com/articles/crm/zoho/zoho-crm/zoho-crm-searchrecords-with-sorted-results.html

    the standard searchRecords() and then the getRecords() functions: Set the record ID to your own record ID. Set the list of pages to the number of pages you want to search. Keep in mind script execution limits set by Zoho. Set the search criteria string...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  6. Zoho Deluge: Shopify API: Get all active products with GraphQL and Paginationhttps://joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-shopify-api-get-all-active-products-with-graphql-and-pagination.html

    this, I'm building on top of my initial GraphQL query which will now retrieve 10 products per page and loop through 3 pages for use in Zoho Deluge. If this works, we can increase the number of pages as well as the number of products per page: The...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  7. ZohoCRM: Get All eBay Active Listingshttps://joellipman.com/articles/crm/zoho/zoho-crm/zohocrm-get-all-ebay-active-listings.html

    is that it asks you to set an estimated number of products that are in your listing, it will then generate the number of pages it thinks it has to loop, so try and give a number higher than the actual number of products you have in your shop, it will...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  8. Zoho Deluge: Get All Orders from eBayhttps://joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-get-all-orders-from-ebay.html

    */ // // declare v_Page = 1; v_PerPage = 100; l_Pages = List(); // // specify the maximum number of orders you think you have on eBay (check eBay homepage and see number of sales [ will be rounded to nearest 1000 ]) // the actual number may be less than...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  9. Zoho Creator / Shopify: Get all Active Productshttps://joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-shopify-get-all-active-products.html

    + "@" + v_ShopID; v_ShopifyApiVersion = "2020-01"; // // loop through 2500 records v_LastID = 0; l_ProductIDs = List(); l_Pages = {1,2,3,4,5,6,7,8,9,10}; for each v_Page in l_Pages { v_Endpoint = v_ShopifyURL + "/admin/api/" +...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
  10. ZohoRecruit: Create Linking Table for Candidates and Associated Job Openingshttps://joellipman.com/articles/crm/zoho/zoho-recruit/zohorecruit-create-linking-table-for-candidates-and-associated-job-openings.html

    ????-??-?? (??? - ???) - ******************************************************************************* */ // // list of pages to loop through (note: issues with multiple pages, do 1 at a time) l_Pages = {1}; v_PerPage = 200; for each v_Page in l_Pages...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Recruit
    • Language: *
  11. ZohoCRM GetRelatedRecords INVALID_DATAhttps://joellipman.com/articles/crm/zoho/zoho-crm/zohocrm-getrelatedrecords-invalid_data.html

    */ // // initialize v_CountTotal = 0; v_CountUpdated = 0; l_Pages = {1}; v_PerPage = 1; // for each v_Page in l_Pages { l_Deals = zoho.crm.getRecords("Deals", v_Page, v_PerPage, {"cvid":123456000012345678}); for each m_Deal in l_Deals {...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  12. Project Plan for Freelance Websitehttps://joellipman.com/articles/cms/website-development/project-plan-for-freelance-website.html

    It may look clean, clear, obvious... it's just an outline of what I picture as a perfect project; unfortunately the first 2 pages tend to be completed in just over a day and the rest of the time is spent faffing around with design and functionality. We...

    • Type: Article
    • Author: Joel Lipman
    • Category: Web-Development
    • Language: *
  13. ZohoCRM: Process all records of a modulehttps://joellipman.com/articles/crm/zoho/zoho-crm/zohocrm-process-all-records-of-a-module.html

    are at least 10 thousand if not 100 thousand records. The code I use is a for loop within a for loop or in other words 5 pages (as each page is limited to 200) and 1000 records is the sweet spot in which case the loading bar disappears but the function...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  14. Zoho Deluge and Wordpress/WooCommerce API: Get All Productshttps://joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-and-wordpress-woocommerce-api-get-all-products.html

    then we'll include the code to count the total number of products, and then finallly show the code to loop through all the pages to retrieve every product from the WooCommerce system. API connection in WooCommerce So we need to get an API connection to...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  15. GDPR Privacy Policyhttps://joellipman.com/component/content/article/gdpr-privacy-policy.html?catid=50&Itemid=165

    • Type: Article
    • Category: Static Items
    • Language: *
  16. Privacy Policyhttps://joellipman.com/component/content/article/privacy-policy.html?catid=50&Itemid=165

    and dislikes by gathering and remembering information about your preferences. We use traffic log cookies to identify which pages are being used. This helps us analyse data about webpage traffic and improve our website in order to tailor it to customer...

    • Type: Article
    • Author: Joel Lipman
    • Category: Static Items
    • Language: en-GB
  17. Zoho Creator: Render to PDF with margins and page numbershttps://joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-render-to-pdf-with-margins-and-page-numbers.html

    going to use ZohoCreator and its PDF rendering options. What's wrong with just using CSS? It looks beautiful on ZohoCreator pages but then you hit the PDF button and it pretty much vomits your output back to the 90s. The code snippet below is just for a...

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

    or Tenant Connection specified."; v_Count_FoundInXero = 0; v_Count_Created = 0; v_Count_Updated = 0; v_AccessToken = ""; l_Pages = {1}; v_PageSize = 20; b_Debug = false; // // Xero Invoice Statuses vs your CRM Invoice Statuses m_TranslateStatuses =...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  19. ZohoCRM & Xero: Function to pull most recent quoteshttps://joellipman.com/articles/crm/zoho/zoho-crm/zohocrm-xero-function-to-pull-most-recent-quotes.html

    or Tenant Connection specified."; v_Count_FoundInXero = 0; v_Count_Created = 0; v_Count_Updated = 0; v_AccessToken = ""; l_Pages = {1}; v_PageSize = 1; b_Debug = false; // // Login to Xero > Accounting > Accounting Settings > Financial Settings > Time...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  20. MacOs: Transcribe Training Video using OpenAI Whisperhttps://joellipman.com/component/content/article/macos-transcribe-training-video-using-openai-whisper.html?catid=60&Itemid=165

    it. [Score: 1/10 for effort] I gave the transcript.txt file (all lowercase no punctuation) to ChatGPT as an attachment (~100 pages) and gave it the following prompt: rephrase the following so that it makes sense to a trainee: "" // wait for completion...

    • Type: Article
    • Author: Joel Lipman
    • Category: Apple
    • Language: *
Results 1 - 20 of 41