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

  1. Zoho CRM: Remove Duplicate Product Recordshttps://joellipman.com/articles/crm/zoho/zoho-crm/zoho-crm-remove-duplicate-product-records.html

    + " offset " + v_Offset}; r_CoqlUniqueProducts = invokeurl [ url :"https://www.zohoapis.eu/crm/v7/coql" type :POST parameters:m_Params.toString() connection:"zcrm" ]; l_UniqueProducts = ifnull(r_CoqlUniqueProducts.get("data"),List()); for each m_Product...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  2. Zoho CRM: JS Widget: Generic Script to pass the Record ID to a CRM functionhttps://joellipman.com/articles/crm/zoho/zoho-crm/zoho-crm-js-widget-generic-script-to-pass-the-record-id-to-a-crm-function.html

    the function name to be called (don't include the namespace) var v_FuncName = "fn_Accounts_GetCreditSafe"; // Prepare the parameters for the function call var m_Params = { "arguments": JSON.stringify({ "p_AccountID": v_EntityID }) };...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  3. Using MetaMod to hide buttons from logged in usershttps://joellipman.com/articles/cms/joomla/using-metamod-to-hide-buttons-from-logged-in-users.html

    and rename it to metamod_pubmenu, set "Access Level" to 'public' and "Menu Items" to 'All'. 5. On right side in "Module Parameters" "Show Quick Modules To" choose - 'non-logged in users only' then scroll down to the list of available modules and find...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *
  4. URL passed settings in Reporting Serviceshttps://joellipman.com/component/content/article/url-passed-settings-in-reporting-services.html?catid=75&Itemid=165

    &rc:Toolbar=False To hide just the parameters (default is True) http:///ReportServer/Pages/ReportViewer.aspx?%2fMYREPORTS%2fDemos%2fRB+Report+for+Me&rs:Command=Render &rc:Parameters=False To change the Rendering modes (defaults to HTML4.0)...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  5. SSRS Retrieving Oracle Stored Procedure Success or ErrorLevelhttps://joellipman.com/component/content/article/ssrs-retrieving-oracle-stored-procedure-success-or-errorlevel.html?catid=75&Itemid=165

    to run the stored procedure. This requires using 2 data sources in SSRS. A user will specify the student reference in the parameters of the first report (the one with all the main details), as well as a job reference (for audit purposes) and click "View...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  6. SSRS: Performance Improvements: SELECT TOPhttps://joellipman.com/component/content/article/ssrs-performance-improvements-select-top.html?catid=75&Itemid=165

    this person... Refine your search. -- This "where" clause returns zero rows if dob, reference, -- forename and surname parameters are not populated. In addition, we also need a second dataset in our report which gets the total count of all the rows...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  7. Search a database for a value and count matching rowshttps://joellipman.com/articles/else/database/search-a-database-for-a-value-and-count-matching-rows.html

    3rd incremental load). How? The below stored procedure can be reduced to just a script as long as you declare and set the parameters after the BEGIN and extract the script from BEGIN to END (excluding the words BEGIN and END - avoids the need to create...

    • Type: Article
    • Author: Joel Lipman
    • Category: Databases
    • Language: en-GB
  8. SQL Calendar in Business Intelligence Development Studiohttps://joellipman.com/articles/else/database/t-sql/sql-calendar-in-business-intelligence-development-studio.html

    you should get the below: Formatting In other words, making it look pretty. I'm doing this now because you may not need parameters or events. The above should create your calendar, the steps that follow are to display it in a recognizable calendar...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: en-GB
  9. Data Randomization Function in Oracle PL/SQLhttps://joellipman.com/articles/else/database/oracle-pl-sql/data-randomization-function-in-oracle-plsql.html

    be returned BEGIN IF p_original_value IS NULL THEN v_returnedval := NULL; ELSIF p_original_datatype='INT' THEN -- Check Parameters and assign proper default values IF p_original_range_1 IS NULL THEN v_rand_param1 := POWER(10,...

    • Type: Article
    • Author: Joel Lipman
    • Category: Oracle PL/SQL
    • Language: en-GB
  10. Joes Word Cloud (JWC) Downloadhttps://joellipman.com/component/content/article/joes-word-cloud-jwc-downloads.html?catid=105&Itemid=165

    if only one exclusion category selected - Date Uploaded: Thu, 27th Mar 2014 3.2.1 JoomlaGate - Enhancement: Label parameters in XML and language file review - Date Uploaded: Tue, 18th Mar 2014 3.2 - Fixed Bug: Redeclare function issue when used multiple...

    • Type: Article
    • Author: Joel Lipman
    • Category: Downloads
    • Language: *
  11. Frontpage Item Orderinghttps://joellipman.com/articles/cms/joomla/frontpage-item-ordering.html

    is that it is within the menu manager > main menu > menu item section of your Joomla! Admin Panel. Certain Advanced Parameters in your Menu Item called "Home" must be set correctly for the article ordering you set in your Front Page Manager to take...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *
  12. SSRS Subscriptions cannot be createdhttps://joellipman.com/component/content/article/ssrs-subscriptions-cannot-be-created.html?catid=75&Itemid=165

    shared data source which stores the credentials, ie. A sql authenticated user with read-only privileges. The report has 4 parameters, two of them use the default values (from and to date range) and two use specified values (setup in the subscription...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  13. Autohotkey Count Number of Files/Folders in a Directoryhttps://joellipman.com/component/content/article/autohotkey-count-number-of-files-folders-in-a-directory.html?catid=48&Itemid=165

    - FileCount TotalFileCount += FileCount TotalFolderCount += FolderCount } Method #3: Standard Function with Loop -- input parameters: -- -- Folder=folder/file pattern. -- -- Subfolders=1 or 0 (recurse into subfolders or not) SC_Load(Folder, Subfolders){...

    • Type: Article
    • Author: Joel Lipman
    • Category: AutoHotkey
    • Language: en-GB
  14. AutoHotkey - MS Windows 10 - Open Apps on Multiple Monitors and Desktopshttps://joellipman.com/component/content/article/autohotkey-ms-windows-10-open-apps-on-multiple-monitors-and-desktops.html?catid=48&Itemid=165

    central screen starting at coordinates 0,0 (might be different on your setup)... Note that removing the width and height parameters should simply load the app without resizing it to the maximum width/height of the screen. Windows 10 Mail Lastly: Want to...

    • Type: Article
    • Author: Joel Lipman
    • Category: AutoHotkey
    • Language: en-GB
  15. Joes Word Cloud (JWC)https://joellipman.com/component/content/article/module-joes-word-cloud-jwc.html?catid=53&Itemid=165

    Panel > Extension Manager View the module on your front-end to see if it does what you want it to do. Modify the module parameters as necessary. Setup First of all, you need to make it visible. These 3 steps will have your module ready: The further...

    • Type: Article
    • Author: Joel Lipman
    • Category: Product Documentation
    • Language: *
  16. Zoho Deluge: Duplicate/Clone a Recordhttps://joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-duplicate-clone-a-record.html

    module. In our case, for "Invoices": /* Function: fn_Button_CloneInvoice Purpose: This function duplicates a CRM invoice Parameters: p_InvoiceID (CRM ID of the invoice) Returns: Nothing Author: Joel Lipman Date Created: 2020-03-17 */ // get all field...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  17. Zoho Creator: Download uploaded file and attach to Sales Order in Zoho Bookshttps://joellipman.com/articles/crm/zoho/zoho-books/zoho-creator-download-uploaded-file-and-attach-to-sales-order-in-zoho-books.html

    USA] so books.zoho.eu for Europe and books.zoho.com for US. {"code":2,"message":"The request passed is not valid."}: The parameters you are sending are not in the right format. {"code":15,"message":"Please ensure that the attachment has less than 100...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Books
    • Language: *
  18. Zoho Creator: info/alert/modal/popup notification for any userhttps://joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-info-alert-modal-popup-notification-for-any-user.html

    modal would. 1. Create a page This will be the page containing the styled modal. I'm going to call it "Notify". Add the 2 parameters p_NotifyTitle and p_NotifyContent to the page: Then drag a HTML snippet onto the page with the following: /* optional:...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
  19. Zoho Deluge: Post a multi-dimensional or nested array to a 3rd-party APIhttps://joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-post-a-multi-dimensional-or-nested-array-to-a-3rd-party-api.html

    r_PostResponse = invokeurl [ url :"https://api.joellipman.com/my_test_api.php" type :POST parameters:m_NestedRequest ]; The receiving PHP script did however understand this hack as: $v_Key = "aaabbbbccccddddeeeeffff11112222"; $v_Secret =...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  20. Zoho Deluge: Zoho Bookings Get Available Slotshttps://joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-zoho-bookings-get-available-slots.html

    based on the configuration and appointments in a ZohoBookings instance. How? The getAvailableSlots function requires as parameters according to documentation = zoho.bookings.getAvailableSlots(, , , ); Set up your connector with the following scope:...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
Results 61 - 80 of 108