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

  1. Improve Default Joomla Search https://joellipman.com/articles/cms/joomla/improve-default-joomla-search-heuristics.html

    - Applies to Joomla 2.5.x +, 3.4.x What? So I can't stand the way the default "Search" component in Joomla works. The default is to sort the results by popularity (hits) or by most recently added (depending on your version) which I have never seen in...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
  2. PHP & MySQL Search Enginehttps://joellipman.com/articles/web-development/php/php-a-mysql-search-engine.html

    you hate sites that do not have a search feature? I do. I think it defeats the purpose of cramming information endlessly in cyberspace. So we want to give a search engine to our users. This sounds really simple, we could try: $search_term_esc =...

    • Type: Article
    • Author: Joel Lipman
    • Category: Personal Home Page
    • Language: en-GB
  3. Joes Search Module (JSM)https://joellipman.com/component/content/article/joes-search-module-jsm.html?catid=40

    This article serves as documentation for a Joomla extension I have released which is a copy of the built-in Joomla Search module but with the parameters embedded (set in the administration section). Why? A client has a repository of PDF documents that...

    • Type: Article
    • Author: Joel Lipman
    • Category: Product Documentation
    • Language: *
  4. Search a database for a string (MySQL, T-SQL)https://joellipman.com/articles/database/search-a-database-for-a-string-mysql-t-sql.html

    to modify similar to an excel spreadsheet. Now without using PHP, I need standalone SQL scripts that can simply be used to search an entire database for a particular string of word(s). I've posted my own as well as some others I've lifted from...

    • Type: Article
    • Author: Joel Lipman
    • Category: Databases
    • Language: en-GB
  5. Basic Webpage Controls with JavaScript / COMhttps://joellipman.com/articles/automation/autohotkey/basic-webpage-controls-with-javascript-com.html

    javascript: - which you will feed through the URL Address bar. These examples will be based on (and can be used with) the Search Forum webPage. Our first example will use the alert() method to pop-up a message box that says Hello World! Simply put this...

    • Type: Article
    • Author: Joel Lipman
    • Category: AutoHotkey
    • Language: *
  6. Add Image Mouseover effect in AutoHotkey GUIhttps://joellipman.com/articles/automation/autohotkey/add-image-mouseover-effect-in-autohotkey-gui.html

    the whole code or a working program but should demonstrate how to include it in your own Autohotkey GUI: ; SET TOOLTIP TEXT SearchButton_TT:="Search" ; SHOW THE GUI Gui, Add, Button, x575 y40 w85 h85 +Default +gSearch +Hide, Search Gui, Add, Picture,...

    • Type: Article
    • Author: Joel Lipman
    • Category: AutoHotkey
    • Language: en-GB
  7. Regular Expression Basic Usage Exampleshttps://joellipman.com/articles/web-development/regular-expression-basic-usage-examples.html

    Exact Count The exact-count interval operator is specified with a single digit enclosed in braces. You use this operator to search for an exact number of occurrences of the preceding character or subexpression. For example, to find where 'a' occurs...

    • Type: Article
    • Author: Joel Lipman
    • Category: Web-Development
    • Language: *
  8. Keyboard and mouse shortcuts in Google Chromehttps://joellipman.com/articles/google/keyboard-and-mouse-shortcuts-in-google-chrome.html

    the Help Center in a new tab (our favorite). Address bar shortcuts Use the following shortcuts in the address bar: Type a search term, then press Enter. Performs a search using your default search engine. Type a search engine keyword, pressSpace, then...

    • Type: Article
    • Author: Joel Lipman
    • Category: Google
    • Language: en-GB
  9. Search a database with SOUNDEXhttps://joellipman.com/articles/database/search-a-database-with-soundex.html

    should go through the database and change all variations to be typed the same way in the same case. Wouldn't it be nice to search through your entire database for similar sounding values (so not just case), and in this example, find typos as well, eg....

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

    This is an article to remind me how to search for CRM records by a value that may contain an ampersand or parenthesis. Why? I wrote this article because some searches will work for me and sometimes it won't. Escaping the ampersand with a backslash or...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  11. SSRS: Performance Improvements: SELECT TOPhttps://joellipman.com/articles/microsoft/ssrs/ssrs-performance-improvements-select-top.html

    This article details a method we used on a search form in a SQL Server Reporting Services (SSRS) environment. The requirement (amongst others) was that the report ran in less than a few seconds. Analyzing the report through the ReportServer databases...

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

    a particular warehouse load. This is a column value where the column is called "WarehouseLoadKey" and the value we want to search on is "3" (the 3rd incremental load). How? The below stored procedure can be reduced to just a script as long as you...

    • Type: Article
    • Author: Joel Lipman
    • Category: Databases
    • Language: en-GB
  13. Quadcopter App with Flight Restrictions (JQA)https://joellipman.com/component/content/article/quadcopter-app.html?catid=40

    Model Aircraft Club (the only places you're supposed to be flying). Black: Earthquakes & Extreme Weather: To avoid, or search & rescue (note there are laws about getting involved). Regulations: Flight regulations are fed from api.joellipman.com and...

    • Type: Article
    • Author: Joel Lipman
    • Category: Product Documentation
    • Language: *
  14. Excel - Check a column for values found in another columnhttps://joellipman.com/articles/microsoft/excel/excel-check-a-column-for-values-found-in-another-column.html

    This is an article to remind me how to search a column in an Excel file for values found in another column (in this example, on another worksheet in the same workbook). How? So for demonstration purposes, I'm using a new Excel file with two worksheets...

    • Type: Article
    • Author: Joel Lipman
    • Category: Excel
    • Language: en-GB
  15. Zoho CRM: searchRecords with sorted resultshttps://joellipman.com/articles/crm/zoho/zoho-crm-searchrecords-with-sorted-results.html

    This is an article to document how to use the searchRecords function in CRM and to sort the results response. Why? This is unclear and not always working as coded below since each system (CRM, Creator, Books) seems to interpret this sorting feature...

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

    Record Count" with some criteria. Why? At time of print, I couldn't find an example of how to use this API call with search filters or criteria. Not sure about the rest of you, but I've been using this for pagination purposes and for the system to work...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  17. Zoho Creator: Shopify API Integration Oauth 2.0 - Update 2022 (Search by SKU GraphQL)https://joellipman.com/articles/crm/zoho/zoho-creator-shopify-api-integration-oauth-2-0-update-2022.html

    private apps created before February 2022 won't be deprecated? Because the previous version was limited by our ability to search by product SKU. The new version, taking advantage of GraphQL, will be able to search by SKU and retrieve the correct product...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  18. Zoho People: Reject an Application for Leave in Deluge based on Criteriahttps://joellipman.com/articles/crm/zoho/zoho-people-reject-an-application-for-leave-in-deluge.html

    80% of their team have already booked the same date off. My brief was: Check the department this employee belongs to Search for employees of the same department (team members) who have booked the same days off (ie count holiday clashes) Prevent an...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  19. Joomla CMS: Register to Read Morehttps://joellipman.com/articles/cms/joomla/joomla-cms-register-to-read-more.html

    read more content (full text) and just show intro texts to public but the default Joomla instructions do not include the search engine. I need the Joomla built-in search engine to also ignore permissions so that the article can still be indexed in...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *
  20. Search and Replace in a MySQL Databasehttps://joellipman.com/articles/database/mysql/search-and-replace-in-a-mysql-database.html

    Ok is it just me who does everything slowly and badly until someone comes along and says why are you doing it like that? My justification is that the job has to be done no matter what. If you've ever sat there with phpMyAdmin or a MySQL Administration...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: en-GB
Results 1 - 20 of 82

Please publish modules in offcanvas position.