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

  1. ZohoCRM: Using Criteria with Module Record Counthttps://www.joellipman.com/articles/crm/zoho/zohocrm-using-criteria-with-module-record-count.html

    value: (Last_Name:equals:K\\) After encoding the value: (Last_Name:equals:K%5C%5C) To search for Date, DateTime, Lookup, Number, Currency, Boolean fields, you need comparators other than starts_with and equals. Source(s): Zoho CRM Documentation - Record...

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

  2. Zoho Creator: Render to PDF with margins and page numbershttps://www.joellipman.com/articles/crm/zoho/zoho-creator-render-to-pdf-with-margins-and-page-numbers.html

    footer on every page. The key point is the HTML attribute zcpage-footerhtml; but note the 3 other CSS classes zcpage-pagenumber, currentPageNumber, and totalPageNumber which will output the current page number and total count of pages respectively: Page...

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

  3. 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

    this is also referred to as the pricelist... and vice-versa. And in this use-case, my client has added an incredible number of price books/ price lists and then has in excess of 20k items. Previously, the function that would need to get the price book...

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

  4. ZohoAnalytics & ZohoBooks: Custom Related List from Analyticshttps://www.joellipman.com/articles/crm/zoho/zohoanalytics-zohobooks-custom-related-list-from-analytics.html

    with the sales order items based on the custom lookup field: SELECT po."Purchase Order ID" AS "PO ID", po."Purchase Order Number" AS "PO Ref", po."Purchase Order Date" AS "PO Date", po."Purchase Order Status" AS "PO Status", poi."Item Name" AS "PO...

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

  5. Setting a rocket theme background to fixedhttps://www.joellipman.com/articles/cms/joomla/setting-a-rocket-theme-background-to-fixed.html

    #main-background {background: url(../images/backgrounds/bgstyle1/bgimage.jpg) 50% 0 no-repeat;} where 1 is the number of the style of the template I am setting the background for and I add the "fixed" attribute to this id. This will yield the following:...

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

  6. Restoring your WYSIWYG editor after upgrading Joomlahttps://www.joellipman.com/articles/cms/joomla/restoring-your-wysiwyg-editor-after-upgrading-joomla.html

    The Issue Basically that after upgrading Joomla, my TinyMCE WYSIWYG (What-you-see-is-what-you-get) editor halved its number of buttons and I couldn't add code snippets... The Fix Just installed JoomlaFCK WYSIWYG Editor, an editor I use with my day...

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

  7. MySQL Oracle equivalentshttps://www.joellipman.com/articles/database/mysql-oracle-equivalents.html

    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. Set default parameter dates to start and end of monthhttps://www.joellipman.com/articles/microsoft/ssrs/set-default-parameter-dates-to-start-and-end-of-month.html

    post on SQL Server Central.com forums where he subtracts 1 day from the first day of next month to get the last date/number of days in this month.

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

  9. About 5 seconds worth of funhttps://www.joellipman.com/articles/microsoft/sharepoint/about-5-seconds-worth-of-fun.html

    and MY_SHAREPOINT_SITE accordingly). The moon to play with /_layouts/people.aspx?MembershipGroupId=# where # is the ID number of the group (will error on invalid IDs).

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

  10. Ordered List of over 1000 Itemshttps://www.joellipman.com/articles/web-development/css/ordered-list-of-over-1000-items.html

    What? So many people asking this when the solution is a bit of aesthetic styling. ol{margin:4px} -- yields 995. 996. 997. 998. 999. 000. 1000 Ordered list resets to zero after the ninth item Ordered List Maximum

    • Type: Article
    • Author: Joel Lipman
    • Category: Cascading Stylesheets
    • Language: *

  11. Oracle: order by subquery missing right parenthesishttps://www.joellipman.com/articles/database/pl-sql/oracle-order-by-subquery-missing-right-parenthesis.html

    SELECT ps.person_id, ps.person_name, ( select txt from ( select pa.person_text as txt, pa.person_reference as personid, row_number() over (order by pa.last_modified_date desc) r from Person_Academia pa where pa.type = 'USER' AND pa.code = 'SPECIAL1' )...

    • Type: Article
    • Author: Joel Lipman
    • Category: Oracle PL/SQL
    • Language: *

  12. Regular Expressions in SQLhttps://www.joellipman.com/articles/database/regular-expressions-in-sql.html

    WHERE [S_SURNAME] NOT LIKE '%[a-zA-Z0-9]%' -- returns all rows where the student surname does NOT contain a letter or number -- eg. O'Brien will NOT be returned as it contains letters MySQL And my favorite. Note the circumflex as we are still excluding...

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

  13. VBScript to retrieve Windows Product Keyhttps://www.joellipman.com/articles/microsoft/windows-os/vbscript-to-retrieve-windows-product-key.html

    the Windows 10 operating system offered as a free upgrade (for Windows 7 or later at time of print), I needed the serial number / product key from my Windows 7 Professional 32-bit operating system. I didn't want to dig through my CD/DVDs to find my...

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

  14. SELECT COUNT(DISTINCT name) FROM tablehttps://www.joellipman.com/articles/cms/joomla/select-count-distinct-name-from-table.html

    why method 3 is an accepted answer over the web because as soon as I put a WHERE clause in the statements and check the numbers, only method 1 and 2 return the correct number. I'm still unsure as to why WHERE...GROUP BY... doesn't return the same totals...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *
Results 141 - 154 of 154

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

Joes Word Cloud

Please publish modules in offcanvas position.