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

  1. ZohoDesk & ZohoAnalytics: Display Ticket Attachments in Analytics Reporthttps://joellipman.com/articles/crm/zoho/zohodesk-zohoanalytics-display-ticket-attachments-in-analytics-report.html

    You can now specify the size of the image as well (16x16 is a tad small). Caveat(s): A bit work needs to be done to the code above to prevent attachments from going in twice. You would need to record the attachment ID and only push it to Analytics if...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  2. Zoho People: Get Performance Records over APIhttps://joellipman.com/articles/crm/zoho/zoho-people-get-performance-records-over-api.html

    after the slash /org-details/###### (eg. "123456789") Note this down for later use Create a connection to Zoho Analytics: Above the function in Zoho People > Connections > Create Connection Select Zoho Analytics and give the required scopes (I've...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  3. Zoho Survey & Zoho Analytics: Query to generate individual responses and grouped pageshttps://joellipman.com/articles/crm/zoho/zoho-survey-zoho-analytics-query-to-generate-individual-responses-and-grouped-pages.html

    a go: The page responses query showing only the last survey attempt per respondent I'm going to modify the analytics query above to only return the latest responses that a respondent has completed; this means that if they have completed the same survey...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  4. GDPR Privacy Policyhttps://joellipman.com/static-items/gdpr-privacy-policy.html

    on implied warranties or the exclusion or limitation of certain damages. If these laws apply to you, some or all of the above disclaimers, exclusions, or limitations may not apply to you, and you might have additional rights. Applicable Law By visiting...

    • Type: Article
    • Author: Joel Lipman
    • Category: Static Items
    • Language: *
  5. Installing phpBB3 for Joomla with a RocketTheme templatehttps://joellipman.com/articles/cms/joomla/installing-phpbb3-for-joomla-with-a-rockettheme-template.html

    Log into the phpBB3 Administration Control Panel. Based on the phpBB3 installation instructions above, this should be something like http://www.mysite.com/phpBB3/adm/. Click on the 'General' tab, look at the "Server Configuration" section and click the...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *
  6. Change default order of weblinkshttps://joellipman.com/articles/cms/joomla/change-default-order-of-weblinks.html

    .', ordering':' ORDER BY title ASC'; To sort by another value on page load To do this, change the word 'title' in the above code to one of the following values: id => sort by ID catid => sort by Category ID sid => ? dunno title => by web link title...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *
  7. Creating a Top 10 chart with less codehttps://joellipman.com/articles/web-development/php/creating-a-top-10-chart-with-less-code.html

    in a row My old method was to: Select distinct column1.table1 FROM table1 PHP script would loop through all rows of the above mysql query Count for each row how many times the column1.table1 value appears in table1 Format this count result by prefixing...

    • Type: Article
    • Author: Joel Lipman
    • Category: Personal Home Page
    • Language: *
  8. Report Builder 2.0 - Hide Series1https://joellipman.com/articles/microsoft/ssrs/report-builder-20-hide-series1.html

    to the WHERE clause Specify that the field name in the series fields is not blank So I've added the AND line to the above statement yielding: SELECT _SMDBA_.Incident.[Incident #] ,_SMDBA_.Incident.[Group Name] ,_SMDBA_.Incident.[Close Date & Time]...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  9. Accessing a MySQL Database with Business Intelligence Development Studiohttps://joellipman.com/articles/database/mysql/accessing-a-mysql-database-with-business-intelligence-development-studio.html

    through the same rubbish. I just took a step back and thought this through and this is what I came up with! Additional The above will all work if you're working on a local report within BIDS connecting to remote servers. If you want the report to be...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: en-GB
  10. Formatting a date in an MDX queryhttps://joellipman.com/articles/database/t-sql/formatting-a-date-in-an-mdx-query.html

    to use a specific European date format and you spend as long as I did searching the web for a solution, then ignore all the above. Another built-in function is the text-formatter =Format(Fields!myDateTime.Value, "M/d/yy")... 6/15/09...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: *
  11. SSRS Hide results table if emptyhttps://joellipman.com/articles/microsoft/ssrs/ssrs-hide-results-table-if-empty.html

    do with this. We could add a row with a SELECT UNION statement but I found this can be resolved by adding a counter, so the above becomes: SELECT DISTINCT re.[RoomId] ,re.[SiteId] ,re.[EquipId] ,eq.[Description] ,1 Counter FROM [ROOMEQUIPMENT] re INNER...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  12. Developer's Checklist: Taking over a projecthttps://joellipman.com/articles/web-development/developers-checklist-taking-over-a-project.html

    (formats, defaults and vulnerability) Check ALL server-side errors EventViewer (if Windows) errors.log (if Linux) Above and beyond Product Handover (branded pack with contact details - make it simple and friendly!!!) Warranty / Grace Period (agreed...

    • Type: Article
    • Author: Joel Lipman
    • Category: Web-Development
    • Language: *
  13. Win32 Constantshttps://joellipman.com/articles/automation/autohotkey/win32-constants.html

    Flags Const HHT_NOWHERE = $0001 Const HHT_ONHEADER = $0002 Const HHT_ONDIVIDER = $0004 Const HHT_ONDIVOPEN = $0008 Const HHT_ABOVE = $0100 Const HHT_BELOW = $0200 Const HHT_TORIGHT = $0400 Const HHT_TOLEFT = $0800 ;#End Region ;#Region List View sub...

    • Type: Article
    • Author: Joel Lipman
    • Category: AutoHotkey
    • Language: *
  14. SSRS Querying on either of 2 Parametershttps://joellipman.com/articles/microsoft/ssrs/ssrs-querying-on-either-of-2-parameters.html

    student always has a "Student Reference" but not necessarily a student AD account (enquired/applied only). So following the above, I end up with: Then I want the ID parameter ("@StudentReference") to populate itself if it is left blank when the report...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  15. Excel PivotTable Filter List Orderinghttps://joellipman.com/articles/microsoft/excel/excel-pivottable-filter-list-ordering.html

    Move this added field to the Report Filter section (click on it and select "Move to Report Filter") Advanced Sorting So the above works which is great but what if you have a list of month names? January comes before February but not alphabetically, so...

    • Type: Article
    • Author: Joel Lipman
    • Category: Excel
    • Language: en-GB
  16. Alternative method of displaying Unicode in Autohotkey GUIhttps://joellipman.com/articles/automation/autohotkey/alternative-method-of-displaying-unicode-in-autohotkey-gui.html

    small letter a with diaeresis 133 85 U+00E0 à latin small letter a with grave 134 86 U+00E5 å latin small letter a with ring above 135 87 U+00E7 ç latin small letter c with cedilla 136 88 U+00EA ê latin small letter e with circumflex 137 89 U+00EB ë...

    • Type: Article
    • Author: Joel Lipman
    • Category: AutoHotkey
    • Language: en-GB
  17. T-SQL Record Separatorhttps://joellipman.com/articles/database/t-sql/t-sql-record-separator.html

    A009 08:00 17:00 Separator Marker */ As I mentioned at the beginning of this article, I am comparing on Day names. The above query generates a last column which is either empty or says "Separator Marker". Based on the CTE above, I now need to add an...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: en-GB
  18. Prefix Line Numbers in a Text Filehttps://joellipman.com/articles/automation/ms-dos/prefix-line-numbers-to-a-text-file.html

    should be empty for clarity results_file.txt is the resulting file, it will be created in the current working directory. Above and Beyond: Add to your Context Menu My absolute laziness drives me to write the instructions on adding this to the context...

    • Type: Article
    • Author: Joel Lipman
    • Category: MS-DOS
    • Language: *
  19. T-SQL Conversion failed when converting the varchar to data type inthttps://joellipman.com/articles/database/t-sql/t-sql-conversion-failed-when-converting-the-varchar-to-data-type-int.html

    LEFT JOIN DMExtractReferenceTable r1 ON e1.CodeType=r1.MapIn So simply change the "=" to a "LIKE". Scenario #2 So when the above has been addressed or we've tried casting as varchars all over the place, check the value that gets outputted is also a...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: en-GB
  20. T-SQL concatenate an incremental row numberhttps://joellipman.com/articles/database/t-sql/t-sql-concatenate-an-incremental-row-number.html

    the -- Employee Number concatenated with a 2 digit sequence -- number (padded with zeros) How? So how do we do it? In the above example, Joel Lipman has two qualification records. So let's start with a simple query: SELECT RIGHT('000' + CAST(e.ID AS...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: en-GB
Results 21 - 40 of 179

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.