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

  1. ZohoCreator: Basic Widget with Zoho Datahttps://www.joellipman.com/articles/crm/zoho/zoho-creator/zohocreator-basic-widget-with-zoho-data.html

    = new Date(); var currentYear = today.getFullYear(); $('footer span.year').text(currentYear); Error(s) Encountered: Error Status 401 Code 1030: Authorization Failure. The access token is either invalid or has expired. Please check your Zoho Account for...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *

  2. Zoho Analytics & Zoho People: Monitor DataSource Sync https://www.joellipman.com/articles/crm/zoho/zoho-analytics/zoho-analytics-zoho-people-monitor-datasource-sync.html

    */ // // initialize v_LastSyncTime = null; v_LastSyncStatus = "?"; m_DataSourceInfo = Map(); // // read the TLD (eu or com or com.in) from the URL when logged into Zoho Analytics v_BaseURL = "https://analyticsapi.zoho.com"; // // to get workspace ID,...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Analytics
    • Language: *

  3. Zoho People: Get Performance Records over APIhttps://www.joellipman.com/articles/crm/zoho/zoho-people/zoho-people-get-performance-records-over-api.html

    m_OutputRecord.put("Priority.id",m_GoalRecord.get("Priority.id")); m_OutputRecord.put("ApprovalStatus",m_GoalRecord.get("ApprovalStatus")); m_OutputRecord.put("AssignedBy.ID",m_GoalRecord.get("AssignedBy.ID"));...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho People
    • Language: *

  4. Zoho Survey: Zoho CRM Webhookhttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zoho-survey-zoho-crm-webhook.html

    :crmAPIRequest ] */ // // build response to Zoho Survey (hard-coded a ok) m_ResponseHeader = Map(); m_ResponseHeader.put("status_code",200); return {"crmAPIResponse":m_ResponseHeader}; } Save the function, hover over it and select "REST API", enable...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *

  5. Zoho CRM Client Script: Map Quote to Invoicehttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zoho-crm-client-script-map-quote-to-invoice.html

    = null; // loop through related sales orders for (var i = 0; i...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *

  6. ZohoCRM & Xero: Function to pull most recent quoteshttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zohocrm-xero-function-to-pull-most-recent-quotes.html

    Zone v_XeroTimeZone = "Europe/London"; // // hard-code Zoho timezone v_ZohoTimeZone = "Europe/London"; // // Xero Quote Statuses vs your CRM Quote Statuses m_TranslateStatuses = Map(); m_TranslateStatuses.put("DRAFT","Draft");...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *

  7. Change default order of weblinkshttps://www.joellipman.com/articles/cms/joomla/change-default-order-of-weblinks.html

    a date formatted field hits - number of times that weblink has been visited state - this is the J16 published/unpublished status ordering featured To switch the default ordering (ascending / descending), change the ASC to DESC on line 187: $listOrder =...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *

  8. Registered Users Cannot Login - Super Users Canhttps://www.joellipman.com/articles/cms/joomla/registered-users-cannot-login-super-users-can.html

    users but only "Super Users" could actually login. "Registered" users would not be able to login, despite their status in the admin panel saying "enabled" and "activated" (not blocked). If I used a test account, none of the Joomla groups, not even...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB

  9. Migrating from Joomla 2.5.x to 3.4.xhttps://www.joellipman.com/articles/cms/joomla/migrating-from-joomla-2-5-x-to-3-4-x.html

    usergroups are the same in both systems. Import new ones. Copy all users except the v25 admin to your v34 database (with status=blocked) Copy over user group mappings Update new system admin details with old (name, registration date, etc). Copy over...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB

  10. Upgrading Joomla CMS version 3.x to Joomla CMS 5.xhttps://www.joellipman.com/articles/cms/joomla/upgrading-joomla-cms-version-3-x-to-joomla-cms-5-x.html

    account is 333), remove other super admins (optional) I also noted the previous admin's ID and returned their super admin status. Sorted by group_id desc and changed 8 to 2. SELECT m.`user_id`, m.`group_id`, u.`username`, u.`email` FROM...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *

  11. Migrate Joomla Users to WordPresshttps://www.joellipman.com/articles/cms/wordpress/migrate-joomla-users-to-wordpress.html

    my_wordpress_db.wp_users (ID, user_login, user_nicename, user_email, user_url, user_registered, user_activation_key, user_status, display_name ) SELECT a.id 'ID', a.username 'user_login', REPLACE(TRIM(LOWER(a.username)), ' ', '_') AS 'user_nicename',...

    • Type: Article
    • Author: Joel Lipman
    • Category: Wordpress
    • Language: en-GB

  12. SSRS Parameters in Oracle Stored Procedurehttps://www.joellipman.com/component/content/article/ssrs-parameters-in-oracle-stored-procedure.html?catid=75&Itemid=165

    in Variables I've been told that SSRS does not understand OUT variables. For a success message to be returned based on the status of the stored procedure, please view my article SSRS Retrieving Oracle Stored Procedure Success or ErrorLevel EXECUTE...

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

  13. SSRS External Images don't displayhttps://www.joellipman.com/component/content/article/ssrs-external-images-dont-display.html?catid=75&Itemid=165

    the previous version (using 3rd-party components other than Microsoft SSRS) that the existence of a photo depended on the status of a student in any case. This meant that I could use the same Oracle PL/SQL query they used to determine whether to display...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: *

  14. Windows 10: Shortcut Apps to Settingshttps://www.joellipman.com/component/content/article/windows-10-shortcut-apps-to-settings.html?catid=80&Itemid=165

    Mobile hotspot ms-settings:network-mobilehotspot NFC ms-settings:nfctransactions Proxy ms-settings:network-proxy Status ms-settings:network-status ms-settings:network VPN ms-settings:network-vpn Wi-Fi ms-settings:network-wifi Wi-Fi Calling...

    • Type: Article
    • Author: Joel Lipman
    • Category: Windows OS
    • Language: *

  15. Apple Magic Trackpad with Windows 11 Intelhttps://www.joellipman.com/component/content/article/apple-magic-trackpad-with-windows-11-intel.html?catid=80&Itemid=165

    the preivous step of installing the driver and wait a few seconds for the settings page to show the green light / connected status. Done

    • Type: Article
    • Author: Joel Lipman
    • Category: Windows OS
    • Language: *

  16. Search a database for a string (MySQL, T-SQL)https://www.joellipman.com/articles/else/database/search-a-database-for-a-string-mysql-t-sql.html

    ORDER BY TABLE_SCHEMA, TABLE_NAME, COLUMN_NAME; OPEN MyCursor FETCH NEXT FROM MyCursor INTO @SqlToExecute WHILE @@FETCH_STATUS = 0 BEGIN PRINT ' union all ' + @SqlToExecute; FETCH NEXT FROM MyCursor INTO @SqlToExecute END CLOSE MyCursor DEALLOCATE...

    • Type: Article
    • Author: Joel Lipman
    • Category: Databases
    • Language: en-GB

  17. Search a database with SOUNDEXhttps://www.joellipman.com/articles/else/database/search-a-database-with-soundex.html

    AS Count FROM ( '; -- Iterate through cursor1 OPEN Cursor1 FETCH NEXT FROM Cursor1 INTO @SqlToExecute WHILE @@FETCH_STATUS = 0 BEGIN IF @myCounter=0 PRINT @SqlToExecute; ELSE PRINT ' union all ' + @SqlToExecute; SET @myCounter = @myCounter + 1; FETCH...

    • Type: Article
    • Author: Joel Lipman
    • Category: Databases
    • Language: en-GB

  18. Search a database for a value and count matching rowshttps://www.joellipman.com/articles/else/database/search-a-database-for-a-value-and-count-matching-rows.html

    myCount int); -- Iterate through cursor1 OPEN Cursor1 FETCH NEXT FROM Cursor1 INTO @TableToProcess WHILE @@FETCH_STATUS = 0 BEGIN SET @SqlToExecute = ' SELECT DISTINCT ' + CAST(@p_Value AS VARCHAR) + ', ''' + @TableToProcess + ''', COUNT(*) AS Count...

    • Type: Article
    • Author: Joel Lipman
    • Category: Databases
    • Language: en-GB

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

    WHERE StartDate BETWEEN DATEADD(day, -6, GETDATE()) AND DATEADD(day, 6, GETDATE())) AND tt.[Status] 3 AND ( wm.[WeekNumber] = (SELECT TOP 1 WeekNumber FROM [pretendDatabase].[pretendSchema].[WEEKSTRUCTURE] WHERE StartDate BETWEEN DATEADD(day, -6,...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: en-GB

  20. Stored Procedure to List Distinct Values and Countshttps://www.joellipman.com/articles/else/database/t-sql/stored-procedure-to-list-distinct-values-and-counts.html

    myCount int); -- Iterate through cursor1 OPEN Cursor1 FETCH NEXT FROM Cursor1 INTO @ColToProcess WHILE @@FETCH_STATUS = 0 BEGIN SET @SqlToExecute = ' SELECT DISTINCT ' + LTRIM(@ColToProcess) + ' COLLATE ' + @p_UseCollation + ', ''' +...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: *
Results 61 - 80 of 83