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

  1. Zoho People Analytics Regional Configurationhttps://joellipman.com/articles/crm/zoho/zoho-people/zoho-people-analytics-regional-configuration.html

    e."ID" INNER JOIN "Legal Entity" le ON e."Legal Entity (Company)" = le."ID" WHERE le."Description" LIKE '%APAC%' Employee_Dependent Details -- Custom Query -- SELECT ed.* FROM "Employee_Dependent Details" ed INNER JOIN "Employee" e ON ed."PARENT_ID" =...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho People
    • Language: *
  2. Basic Webpage Controls with JavaScript / COMhttps://joellipman.com/component/content/article/basic-webpage-controls-with-javascript-com.html?catid=48&Itemid=165

    webpages. This is because it's a "map" or "heirarchy" for accessing parts of the webpage. The HTML DOM is not language dependent, but rather the model for how the webpage document is constructed. JavaScript - We will cover some basic JavaScript because...

    • Type: Article
    • Author: Joel Lipman
    • Category: AutoHotkey
    • Language: *
  3. Zoho Creator: Set Up Custom Domain for Customer Portalhttps://joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-set-up-custom-domain-for-customer-portal.html

    or creator.cs.zohohost.com depending on your datacenter: 2. Setup your Domain/Subdomain The process here is dependent on your service provider or domain registrar (website where you registered your domain). I've listed some third-party providers'...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
  4. Zoho Deluge: Date from a String (dd/MM/yyyy to yyyy-MM-dd)https://joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-date-from-a-string-dd-mm-yyyy-to-yyyy-mm-dd.html

    the date correctly? How? It may be that when obtaining a date string and applying the method .toString("dd/MM/yyyy") is dependent on the settings. But making a date into a SQL format or from largest denominator to smallest in "yyyy-MM-dd" will usually...

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

    icon or the eye icon to copy & paste) into the "Client Secret" field. Click on "Configure Admin API scopes": This will be dependent on what your app needs to do. In this example, mine needs to sync orders, products, customers, and some reports; the...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
  6. Creating a custom form field type for Joomla XML fieldsethttps://joellipman.com/articles/cms/joomla/creating-a-custom-form-field-type-for-joomla-xml-fieldset.html

    restricted to the logged-in user. This is specified in the XML file of the custom Joomla component and needs some SQL dependent on some dynamic variables. Why? In Joomla, the XML type of "sql" is extremely limited. The component I'm making has to ensure...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
  7. SSRS AlphaNumeric Parameter Validationhttps://joellipman.com/component/content/article/ssrs-alphanumeric-validation.html?catid=75&Itemid=165

    AND Fields!NOTALPHANUMERIC.Value=0, "Valid", "Not Valid" ) Additional If like us, you've made a report containing a link dependent on parameters submitted, we had to apply a similar IIF statement block to the Font color and the Action target as well...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  8. Zoho Deluge - Get User Timezone, Country and Locationhttps://joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-get-user-timezone-country-and-location.html

    third-party API based on the given IP address. How? Well this is just a list of free 3rd-party APIs and the below code is dependent on these being online and working... The quickest I found [limit 1000 per day | Incorrect Location]: v_Url =...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: en-GB
  9. Change Regional Settings for your Reporthttps://joellipman.com/component/content/article/change-regional-settings-for-your-report.html?catid=75&Itemid=165

    I thought that the regional settings of a report generated using Report Builder 2.0 on a MS SQL Server 2008 instance were dependent on either the server or the client machine. Realised that this was actually specified in the report. Here's a quick note...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
Results 1 - 9 of 9