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

  1. Zoho Books / Inventory: Get Item Rate from a Price Book/Listhttps://www.joellipman.com/articles/crm/zoho/zoho-books-inventory-get-item-rate-from-a-price-book-list.html

    A quick article on how to get the pricebook entry using Zoho Deluge for a specific product in your ZohoBooks or ZohoInventory instance. Why? This took me the best part of an hour to determine by going through forum posts from 7 years to 2 years ago. The...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  2. Zoho Analytics & Zoho People: Monitor DataSource Sync https://www.joellipman.com/articles/crm/zoho/zoho-analytics-zoho-people-monitor-datasource-sync.html

    Why? We're assisting a client implement Zoho People as their new HR solution. Zoho Analytics is used to generate specific spreadsheets for a feed into their third-party payroll system. If the data is incorrect in Zoho Analytics, and payroll gets run...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  3. ZohoAnalytics & ZohoBooks: Custom Related List from Analyticshttps://www.joellipman.com/articles/crm/zoho/zohoanalytics-zohobooks-custom-related-list-from-analytics.html

    v_BooksOrgID = organization.get("organization_id"); v_SalesOrderID = salesorder.get("salesorder_id"); // // analytics specific table to read data from (enter your own here) v_ZA_WorkspaceID = "123456000000789012"; v_ZA_ViewID = "123467000009876543";...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  4. ZohoDeluge: eBay marketplace account deletion/closure notificationshttps://www.joellipman.com/articles/crm/zoho/zohodeluge-ebay-marketplace-account-deletion-closure-notifications.html

    was sent notification.publishAttemptCount integer indicating how many times the notification has been sent to this specific callback URL notification.data.username this string is the publicly known eBay user ID notification.data.userId this string is...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  5. ZohoCRM / Client Script / Canvas: Hide Tab based on Pipelinehttps://www.joellipman.com/articles/crm/zoho/zohocrm-client-script-canvas-hide-tab-based-on-pipeline.html

    code to hide and show certain tabs on a deal record based on the pipeline. Why? A request from a customer asked if a tab specific to the pipeline selected can be shown while others hidden. Standard tabs such as Notes, Attachments, Emails, and Timeline...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  6. Zoho Deluge: Connect to Shopifyhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-connect-to-shopify.html

    headers and payload. Previously on... m_Header = Map(); m_Header.put("Content-Type","application/json"); // // app specific (retrieving from a ZohoCreator record that stores all these credentials) r_ShopifyAPI = API_Integration[Connection_Name ==...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  7. MySQL Oracle equivalentshttps://www.joellipman.com/articles/database/mysql-oracle-equivalents.html

    in Oracle: Objective MySQL Oracle - See if a table exists SHOW TABLES Select table_name from sys.dba_tables - Return a specific number of rows SELECT * FROM table1 LIMIT 0, 10 SELECT * FROM table1 WHERE ROWNUM

    • Type: Article
    • Author: Joel Lipman
    • Category: Databases
    • Language: en-GB
  8. Drop If Object Existshttps://www.joellipman.com/articles/database/t-sql/drop-if-object-exists.html

    go go Note that in the following examples, I'm checking under the [Common] schema, this might be [dbo] for you or a more specific one. -- drop a stored procedure if it exists IF OBJECT_ID ( '[Common].[usp_MyStoredProcedure]', 'P' ) IS NOT NULL DROP...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: *
  9. SSRS Border Problemhttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-border-problem.html

    "None" next to it (as its value). Press the "Enter" key if you need to. You are now free to apply normal borders to each specific cell.

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  10. SELECT COUNT(DISTINCT name) FROM tablehttps://www.joellipman.com/articles/cms/joomla/select-count-distinct-name-from-table.html

    A quick article to remind me about this issue. Not sure whether it is specific to the Joomla Content Management System, but within the Joomla! CMS, an error 1054 comes up if you use the above statement. Why? The MySQL statement SELECT COUNT(DISTINCT...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *
Results 61 - 70 of 70

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.