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

  1. JDatabase: using the Joomla database with exampleshttps://www.joellipman.com/articles/cms/joomla/jdatabase-using-the-joomla-database.html

    JFactory::getDbo(); // Create a new query object. $query = $db->getQuery(true); // build the SQL query $query->select($db->quoteName(array('p.user_id', 'u.username', 'u.real_name'))); $query->from($db->quoteName('#__user_profiles p'));...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
  2. Joomla Component: Set default params on installationhttps://www.joellipman.com/articles/cms/joomla/joomla-component-set-default-params-on-installation.html

    or discover_install) if ($type == 'install') { $db = JFactory::getDBO(); $query = $db->getQuery(true); $query->update($db->quoteName('#__extensions')); $defaults = '{"param1":"value1","param2":"value2"}'; // JSON format for the parameters...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
  3. Joomla WHERE clause with ORhttps://www.joellipman.com/articles/cms/joomla/joomla-where-clause-with-or.html

    $db->query('SELECT * FROM #__myTable WHERE condition1=true or condition2=true') Method #1 - chain: $query ->where($db->quoteName('condition1') . ' = '. $db->quote('true'),'OR') ->where($db->quoteName('condition2') . ' = '. $db->quote('true')) Method #2...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
  4. Zoho Creator: Add a subform while creating a recordhttps://www.joellipman.com/articles/crm/zoho/zoho-creator-add-a-subform-while-creating-a-record.html

    data r_QuoteDetails = zoho.crm.getRecordById("Quotes", 123456789012345678); // // transform variables for main record v_QuoteName = ifnull(r_QuoteDetails.get("Name"),"Test Quote"); if(!isNull(r_QuoteDetails.get("Contact_Name"))) { r_ContactDetails =...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  5. Zoho CRM & Zoho Books: Custom Related Lists Delugehttps://www.joellipman.com/articles/crm/zoho/zoho-crm-zoho-books-custom-related-lists-deluge.html

    + "/" + v_AppLinkName + "/#Page:OpenQuote?ID=" + v_CreatorQuoteID; 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 =...

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

Please publish modules in offcanvas position.