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

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

    for each m_GoalRecord in l_GoalResults { // // check this is a valid record and not an error from the search if(!isNull(m_GoalRecord.get("Progress"))) { m_OutputRecord = Map(); // // obtain each field in this record and create our own map......

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho People
    • Language: *
  2. ZohoCRM & Xero: Function to pull most recent invoiceshttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zohocrm-xero-function-to-pull-most-recent-invoices.html

    = m_ThisInvoice.get("Contact").get("ContactID"); v_XeroContactName = m_ThisInvoice.get("Contact").get("Name"); // // search CRM for this account/customer l_SearchAccounts = zoho.crm.searchRecords("Accounts","Xero_Ref_ID:equals:" +...

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

    It took a few google searches until I could find out how to change the default weblinks order. A lot of websites showed how to do this via the admin back-end panel in the advanced configuration... I can't see this panel, there is no advanced parameters...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *
  4. Things to Check if Joomla Password Reminder email not being senthttps://www.joellipman.com/articles/cms/joomla/things-to-check-if-joomla-password-reminder-email-not-being-sent.html

    pane, type “COM_USERS_EMAIL_PASSWORD_RESET_BODY” without the quotes and tick the “Constant” radio box and click on the “Search” button. What displays in the search results should be the text that the system emails out on password change. The default if...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
  5. Warning: Save failed. Another menu item has the same aliashttps://www.joellipman.com/articles/cms/joomla/warning-save-failed-another-menu-item-has-the-same-alias.html

    it a temporary alias (eg. for "about" give it the alias "about_new") Login to your database and browse to the #__menu table Search for any values in the `alias` column that match the term (eg. for "about" do SELECT * FROM #__menu WHERE alias LIKE...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *
  6. Copy a Wordpress Site for Developmenthttps://www.joellipman.com/articles/cms/wordpress/copy-a-wordpress-site-for-development.html

    to dev1.myexample.com where `option_name`='home' change `option_value` // from www.myexample.com to dev1.myexample.com Search and replace any other occurrences in the `wp_options` database table (note: include `wp_postmeta` and `wp_posts` if you want...

    • Type: Article
    • Author: Joel Lipman
    • Category: Wordpress
    • Language: en-GB
  7. URL passed settings in Reporting Serviceshttps://www.joellipman.com/component/content/article/url-passed-settings-in-reporting-services.html?catid=75&Itemid=165

    &rc:BookMarkID=1 Provide search criteria and find the first instance http:///ReportServer/Pages/ReportViewer.aspx?%2fMYREPORTS%2fDemos%2fRB+Report+for+Me&rs:Command=Render &rc:FindString=foo Note: I have no idea what this is for. Render a snapshot...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  8. SSRS Redirect after a report is runhttps://www.joellipman.com/component/content/article/ssrs-redirect-after-a-report-is-run.html?catid=75&Itemid=165

    This article serves to describe several workarounds or proofs of concept. Why? We have a first report which acts like a search page. You enter the student you are looking for by reference or name and if there is only 1 result in the results page, then...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  9. How to Display Report Execution Time in SSRS (milliseconds)https://www.joellipman.com/component/content/article/how-to-display-report-execution-time-in-ssrs.html?catid=75&Itemid=165

    articles out there but I was looking to display in milliseconds the execution time it took for a particular report (which searches for results matching the submitted parameter) to run. Lifted from Dattatray Sindol's blog Other sites have this solution...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  10. Include a carriage return in a column headinghttps://www.joellipman.com/component/content/article/include-a-carriage-return-in-a-column-heading.html?catid=78&Itemid=165

    and "Week" otherwise the system will only understand the carriage return and often return it as "AcademicWeek"). Other Search(es) Format a column alias with new line Using carriage return in column names New line Character in column alias

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server
    • Language: *
  11. Windows 7: System Clock is constantly going out of synchttps://www.joellipman.com/component/content/article/windows-7-system-clock-is-constantly-going-out-of-sync.html?catid=80&Itemid=165

    following process requires administrator (installation) rights on your computer. Open regedit.exe through the start menu search box, and then find this registry key: HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\w32time\TimeProviders\NtpClient...

    • Type: Article
    • Author: Joel Lipman
    • Category: Windows OS
    • Language: *
  12. Remove write-protect from USB pen in Windowshttps://www.joellipman.com/component/content/article/remove-write-protect-from-pen-in-windows.html?catid=80&Itemid=165

    need to use it as little as possible, i.e. once)!!! To find it go to http://emea.apacer.com/en/support/downloads.asp then search for “AH128 Handy Steno Repair Tool” released in 2010 and should be about 3.57Mb). I have tried other rescue programs which...

    • Type: Article
    • Author: Joel Lipman
    • Category: Windows OS
    • Language: en-GB
  13. Running Internet Explorer 6, 7, 8 as standaloneshttps://www.joellipman.com/component/content/article/running-internet-explorer-6-7-8-as-standalones.html?catid=80&Itemid=165

    details (see below - Additional Info) The Free Virtual PC solution (Requires ISO or WinXP disk) Go to Microsoft.com and search for Microsoft Virtual PC 2007 SP1...

    • Type: Article
    • Author: Joel Lipman
    • Category: Windows OS
    • Language: *
  14. Hide a Drive per User in Windows 7https://www.joellipman.com/component/content/article/hide-a-drive-per-user-in-windows-7.html?catid=80&Itemid=165

    logged-in user. To restrict other users, see the example after this one: Open the Start Menu, then type regedit in the search box and press Enter. In regedit, expand to the following key...

    • Type: Article
    • Author: Joel Lipman
    • Category: Windows OS
    • Language: *
  15. T-SQL: Parse an XML valuehttps://www.joellipman.com/articles/else/database/t-sql/t-sql-parse-an-xml-value.html

    AS r(c) -- added [1] to only get 1 result returned ) AS Node_Surname FROM [dbo].[XML_EVENTS] Search if Node or value contains string: -- exist() returns 1 or 0 if a node name exists containing "NAME" or not respectively SELECT...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: en-GB
  16. Convert to Proper Case in T-SQLhttps://www.joellipman.com/articles/else/database/t-sql/convert-to-proper-case-in-t-sql.html

    Why? We wanted a T-SQL version despite having successfully built a custom script component for SSIS. How? You can search my site for how to do this in VB or C#. This version is entirely using T-SQL and we're going to use a function so no dynamic SQL...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: en-GB
  17. MySQL parameters in Excel 2007 PivotTableshttps://www.joellipman.com/articles/else/database/mysql/mysql-parameters-in-excel-2007-pivottables.html

    much Googling and Bing-ing, I still couldn't figure out how to do this. Hopefully this article will help you more than my search engine skills do. My Setup Windows XP Workstation...needs to open... Excel 2007 SP2...with ODBC to... MySQL v5+...hosting...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: en-GB
  18. Quickly update all content in mySQL database replacing a stringhttps://www.joellipman.com/articles/else/database/mysql/quickly-update-all-content-replacing-a-string.html

    a third-party plugin that would replace my HTML tags with . Not I want to switch these back. How? For demo purposes, I'm searching a column called introtext in a database table called MYTABLE_content. First let me find all the articles that need this...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: en-GB
  19. Project Plan for Freelance Websitehttps://www.joellipman.com/articles/cms/website-development/project-plan-for-freelance-website.html

    schemes Will the website be the primary medium for the Client? Affiliates / Associate Websites? Any relevant market research notes. eg. a website is not just a marketing brochure. For JoelLipman.Com to discuss: Target Audience implications (Internally...

    • Type: Article
    • Author: Joel Lipman
    • Category: Web-Development
    • Language: *
  20. Difference between two dates - the midnight hourhttps://www.joellipman.com/articles/cms/website-development/difference-between-two-dates-the-midnight-hour.html

    might already have something similar to this but this deserves its own article. Why? Well try to search the web for a PHP/MySQL solution which suggests on how to count the hours between two times on the same date, when one of the hours is on the other...

    • Type: Article
    • Author: Joel Lipman
    • Category: Web-Development
    • Language: *
Results 61 - 80 of 87