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

  1. T-SQL Record Separatorhttps://joellipman.com/articles/database/t-sql/t-sql-record-separator.html

    Tuesday Wednesday Thursday Thursday Thursday Thursday Friday Friday The Official Gist Okay so the below article with the 3 stages can be a little confusing. When I wrote the support documentation which makes use of this little trick for my managers, I...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: en-GB
  2. Improve Default Joomla Search https://joellipman.com/articles/cms/joomla/improve-default-joomla-search-heuristics.html

    par with Google and Wikipedia (or near enough). How? I'd like to use various techniques, and the first part of this article (Stage 1) is the only part you need to modify as this will improve your Joomla search results by giving priority to articles...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
  3. Zoho Deluge: Search Records with Special Characters (COQL)https://joellipman.com/articles/crm/zoho/zoho-deluge-search-records-with-special-characters-coql.html

    for precedence. Pagination: LIMIT offset, limit: v_CoqlQuery = "select id, Deal_Name from Deals where ((Amount=0) and (Stage != 'Cancelled')) limit 400,2"; // returns 2 deals after the first 400 records // OR v_CoqlQuery = "select id, Deal_Name from...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  4. ZohoCRM: Using Criteria with Module Record Counthttps://joellipman.com/articles/crm/zoho/zohocrm-using-criteria-with-module-record-count.html

    v_Pages = ceil(v_MaxCount / v_PerPage); info v_Pages; Call with a criteria: v_PerPage = 200; v_CountCriteria = "Quote_Stage:equals:Draft"; v_Endpoint = "https://www.zohoapis.com/crm/v5/Quotes/actions/count?criteria=" + v_CountCriteria; r_MaximumCount =...

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

    for each m_Deal in l_Deals { if(!isNull(m_Deal.get("id"))) { v_CountTotal = v_CountTotal + 1; if(m_Deal.get("Stage").equalsIgnoreCase("Cancelled")) { // // cancel all related quotes // (...) // // cancel all related sales orders l_RelatedSOs =...

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

    projects but most people find this overwhelming. It's in business techno babble and I get asked what does this mean in stage 1? And this in stage 2? (There are over 100 stages)... Below is my template project initiation plan (project mandate?) for my...

    • Type: Article
    • Author: Joel Lipman
    • Category: Web-Development
    • Language: *
  7. Zoho CRM REST API: Stop Workflow from Triggeringhttps://joellipman.com/articles/crm/zoho/zoho-crm-rest-api-stop-workflow-from-triggering.html

    createRecord or updateRecord. Why? We had a Creator app updating a CRM record which in turn had a workflow to update the Stage in Creator (so a user can change the stage in CRM and it would reflect this in the equivalent Creator record). There was also...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  8. Upgrading Joomla CMS version 3.x to Joomla CMS 5.xhttps://joellipman.com/articles/cms/joomla/upgrading-joomla-cms-version-3-x-to-joomla-cms-5-x.html

    table `#_user_usergroup_map` Viewing Articles in the Administrator panel: INSERT INTO `#_workflow_associations` (`item_id`, `stage_id`, `extension`) SELECT `id`, 1, "com_content.article" FROM `#_content`; UPDATE `#_content` SET `checked_out`=NULL,...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *
  9. Joe's Unduplicater (JUD)https://joellipman.com/component/content/article/joes-unduplicater.html?catid=40

    REMOVE. - Changed code to loop through an array of files rather than the directory. - Added subtext to inform user at each stage of the process. - Added resize capabilities to the program. - Added more column details in the review list. v1.0...

    • Type: Article
    • Author: Joel Lipman
    • Category: Product Documentation
    • Language: *
  10. Room with a view E.M. Forsterhttps://joellipman.com/articles/_other-misc/room-with-a-view-em-forster.html

    it is impossible to rehearse life. A fault in the scenery, a face in the audience, an irruption of the audience on to the stage, and all our carefully planned gestures mean nothing, or mean too much."

    • Type: Article
    • Author: Joel Lipman
    • Category: Hobbies
    • Language: *
  11. MySQL: Find records in one table that are not in another.https://joellipman.com/articles/database/mysql/mysql-find-records-in-one-table-that-are-not-in-another.html

    The Why So I find myself writing increasingly complex SQL scripts and it's at the stage where we need to optimize the queries because some scripts are noticeably slow (as observed by the customer...) and then others not. The What I'm going to run these...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: en-GB
  12. Joes FREE Website Thumbnailer (JWT)https://joellipman.com/component/content/article/joes-free-website-thumbnailer.html?catid=40

    into an executable and interface (almost as quick as google's chrome :c). Version 0.6 beta is ready. I've left it in BETA stage without an official release because I'm the only one to have tested it and it works perfectly for me. And I guess I'll just...

    • Type: Article
    • Author: Joel Lipman
    • Category: Product Documentation
    • Language: *
  13. SSRS Parameters in Oracle Stored Procedurehttps://joellipman.com/articles/microsoft/ssrs/ssrs-parameters-in-oracle-stored-procedure.html

    or ErrorLevel EXECUTE MY_PRETEND_STORED_PROCEDURE('value1','value2','value3',:errorcode,:errormsg) Still discussing this stage... Not proceeding with this as there may be a better way. In addition, SSRS was complaining about assignment targets not being...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  14. Zoho CRM & Zoho Books: Custom Related Lists Delugehttps://joellipman.com/articles/crm/zoho/zoho-crm-zoho-books-custom-related-lists-deluge.html

    v_QuoteRef = ifnull(r_Result.get("Quote_Ref"),"-"); v_QuoteName = ifnull(r_Result.get("Quote_Name"),"-"); v_QuoteStage = ifnull(r_Result.get("Quote_Stage"),"-"); v_QuoteCurr = ifnull(r_Result.get("Quote_Currency"),"GBP"); v_QuoteTotal =...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  15. ZohoCRM & Xero Real-Time Invoices: Receive Webhookhttps://joellipman.com/articles/crm/zoho/zohocrm-xero-real-time-invoices-receive-webhook.html

    a third-party server (my example here is a LAMP server): Complete webhook setup by passing 'Intent to receive' required stage. Xero will test both a valid and invalid signed webhook. So I'm going to cheat, by setting up a PHP script on a server we own...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  16. Zoho CRM: Using a function for validation rules (or restricting specific picklist options by user profile)https://joellipman.com/articles/crm/zoho/zoho-crm-using-a-function-for-validation-rules.html

    means that the first-line agent would be referring to 2 status fields and not really knowing which one defines the stage the lead is at. How? Well this can be done through a validation rule. After working in Zoho CRM for over 3 years, this is the first...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  17. PC Build 2022: 5 Monitors connected to 1 PC using 1 GPUhttps://joellipman.com/pc-build-2022-5-monitors-connected-to-1-pc-using-1-gpu.html

    see all 5 screens flicker to life.... Finally! I say the dreaded "should" because it took so many reboots to get to this stage that I lost track of all the different configurations. The 2nd diagram is the working configuration I have now. Note that I've...

    • Type: Article
    • Author: Joel Lipman
    • Category: Articles
    • Language: *
  18. Zoho CRM: Manage a subform using Client Scripthttps://joellipman.com/articles/crm/zoho/zoho-crm-manage-a-subform-using-client-script.html

    if 3 different skills are not specified in the subform: // initialize var v_CalculatedNumberOfSkills = 0; // get the Opp stage var v_OppStage = ZDK.Page.getField('Stage').getValue(); // get the Skills subform var l_SkillsSubform =...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  19. ZohoCRM: Daily Follow Up and Remind Record Owner to Convert Leadhttps://joellipman.com/articles/crm/zoho/zohocrm-follow-up-and-remind-record-owner-to-convert-lead.html

    no avail. An assignment rule wouldn't work in this case as it had to be the lead owner (there is no owner at assignment rule stage). A workflow email notification doesn't do the popup on the CRM as well. A workflow notify by email didn't give the option...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  20. Zoho Analytics: Create a Monitoring System with Imageshttps://joellipman.com/articles/crm/zoho/zoho-analytics-create-a-monitoring-system-with-images.html

    my device: Now I can select the image(s) I want to upload (unfortunately only 1 at a time): Create an Image Table At this stage, I'm going to create a table that holds the URLs of the images I want to use but if the image is hosted elsewhere, then this...

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

Donate & Support

If you like my content, and would like to support this sharing site, feel free to donate using a method below:

Paypal:
Donate to Joel Lipman via PayPal

Bitcoin:
Donate to Joel Lipman with Bitcoin bc1qf6elrdxc968h0k673l2djc9wrpazhqtxw8qqp4

Ethereum:
Donate to Joel Lipman with Ethereum 0xb038962F3809b425D661EF5D22294Cf45E02FebF

Please publish modules in offcanvas position.