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 change is required, the following 170 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

    "Organization Reports" but would like some additional fields/columns added to it. Turns out, it's a system report you can't change. Enter Zoho Analytics... well almost, Analytics will sync with Zoho People but I wasn't able to select the performance...

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

    = r_ContactDetails.get("Email"); info v_ContactEmail; // // the following related list couldn't be found hence the change to the summary query in analytics // l_ContactSurveys = zoho.crm.getRelatedRecords("Zoho_Survey", "Contacts", p_ContactID); // info...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Analytics
    • Language: *
  3. 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

    } m_UpsertCrmQuote.put("Currency",m_ThisQuote.get("CurrencyCode")); m_UpsertCrmQuote.put("Exchange_Rate",m_ThisQuote.get("CurrencyRate")); // // some custom fields I created in CRM to store the data...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  4. Uninstalling AEC Central and installing Community Builderhttps://www.joellipman.com/articles/cms/joomla/uninstalling-aec-central-and-installing-community-builder.html

    instructions backwards. 1. Go to your admin panel (back-end) 2. Extensions > Plugin Manager 3. Go to the bottom and change the display # dropdown to ALL 4. Disable Authentication - AEC Access 5. Enable Authentication - Joomla 6. Re-enable any other...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *
  5. Improve Default Joomla Search https://www.joellipman.com/articles/cms/joomla/improve-default-joomla-search-heuristics.html

    Stage] We want to order by more than just popularity and/or date, but also by our own relevance heuristics. The following change would give radically high relevance to articles where the search term is found in the title....

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
  6. Registered Users Cannot Login - Super Users Canhttps://www.joellipman.com/articles/cms/joomla/registered-users-cannot-login-super-users-can.html

    data (clicking on the heading of the column) by their parent_id. If you see more than one record with a value of 0, then change it to 1. If it's name is "root..." and title is "Root Asset" then leave this as having a parent_id of 0. The fix is immediate...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
  7. Importing Joomla articles to WordPress postshttps://www.joellipman.com/articles/cms/wordpress/importing-joomla-articles-to-wordpress-posts.html

    the articles: Change database name my_joomla_db to your joomla database and my_wordpress_db to your Wordpress database Change http://demo.joellipman.com/wordpress/ to the full URL of your WordPress site. If post_type is to be post then append with ?p=...

    • Type: Article
    • Author: Joel Lipman
    • Category: Wordpress
    • Language: en-GB
  8. Android OS: Add GoogleMap as fragmenthttps://www.joellipman.com/articles/else/app-dev/android-os/android-os-add-googlemap-as-fragment.html

    returning to the map activity would restart the app as a menu item, it would need to launch a new intent... I wanted to change my previous example so that the homepage of the app (the starting page) will simply display a button to the map (in case of...

    • Type: Article
    • Author: Joel Lipman
    • Category: AndroidOS
    • Language: *
  9. Room Availability Calendar in Business Intelligence Development Studiohttps://www.joellipman.com/component/content/article/room-availability-calendar-in-business-intelligence-development-studio.html?catid=75&Itemid=165

    hour in range SELECT CONVERT(DATETIME,@StartTime) AS [Time] UNION ALL --Add a record for every half-hour in the range (change based on slot times) SELECT DATEADD(MI, 30, [Time]) FROM Times WHERE Time...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: *
  10. SSRS Querying on either of 2 Parametershttps://www.joellipman.com/component/content/article/ssrs-querying-on-either-of-2-parameters.html?catid=75&Itemid=165

    OR StudentName=@StudentADAccount). And according to other web articles on this matter, I have to change the order of my parameters (I will be checking "Student Username" first as "Student Reference" must be calculated and not blank/null): So I tried...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  11. SSRS AlphaNumeric Parameter Validationhttps://www.joellipman.com/component/content/article/ssrs-alphanumeric-validation.html?catid=75&Itemid=165

    gets formatted by the database Report retrieves (select) formatted parameter as a field value to use Report loads with changes based on returned value. The Gist Add database level parameter check Add IIF in SSRS to confirm Database Level AlphaNumeric...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  12. Windows Live Messenger: Error 80048820https://www.joellipman.com/component/content/article/windows-live-messenger-error-80048820.html?catid=80&Itemid=165

    analogue clock. Make sure your computer is connected to the Internet Left-Click once on the clock on your taskbar Click on Change date and time settings link Click on the tab Internet Time Click on the Change Settings button Check the box next to...

    • Type: Article
    • Author: Joel Lipman
    • Category: Windows OS
    • Language: en-GB
  13. Set up Desktop SlideShow in Windows 7https://www.joellipman.com/component/content/article/set-up-desktop-slideshow-in-windows-7.html?catid=80&Itemid=165

    we have elevated privileges but not absolute rights to configuring our computer. And we still need to re-login for every change. About a zillion group policies control our every deviation from the standard staff image and so we spend more time on "how...

    • Type: Article
    • Author: Joel Lipman
    • Category: Windows OS
    • Language: en-GB
  14. Restore MSSQL Error: Database is in usehttps://www.joellipman.com/articles/else/database/restore-mssql-error-database-is-in-use.html

    SSMS, connect to an instance of the SQL Server Database Engine, and then expand that instance. Right-click the database to change, and then click Properties. In the Database Properties dialog box, click the Options page. From the Restrict Access option,...

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

    END RETURN @Ret END Examples of what this script does: Reminder: The script only affects data already in UPPERCASE. Change the IF (UPPER(@Text)=@Text COLLATE Latin1_General_CS_AI) line if you want to change this. Original Proper-Cased JOHN SMITH-JONES...

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

    Studio (BIDS) Click on "View" > "Server Explorer" Right-click on "Data Connections" > select "Add Connection" Click on "Change..." Select "Microsoft ODBC Data Source" > OK Select the data source from the dropdown (the one you just created earlier should...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: en-GB
  17. A quick run through of setting up an export process in SITShttps://www.joellipman.com/articles/cms/website-development/xml/a-quick-run-through-of-setting-up-an-export-process-in-sits.html

    using SITS:Vision again. How? For demonstration purposes, I'm going to create a table update process (TUP) based around a change in the course application details. Some of the screenshots are censored for confidentiality but nothing relating to the...

    • Type: Article
    • Author: Joel Lipman
    • Category: Extensible Markup Language
    • Language: *
  18. Stop Excel Row Height Self-Adjust on Refreshhttps://www.joellipman.com/component/content/article/stop-excel-row-height-self-adjust-on-refresh.html?catid=110&Itemid=165

    customers were complaining it became too convoluted and cramped when refreshing data and preferred the end result with this change. Note on "row height": We did not want the customer having to format the report after they've already gone through the...

    • Type: Article
    • Author: Joel Lipman
    • Category: Excel
    • Language: en-GB
  19. Zoho Inventory Template Issue: First Page is Blankhttps://www.joellipman.com/articles/crm/zoho/zoho-inventory/zoho-inventory-template-issue-first-page-is-blank.html

    particular case CSS... so maybe this will help others: The culprit is the following CSS line: page-break-inside:avoid // change to page-break-inside:auto Resolution Find the CSS attribute "page-break-inside" If this is set to "avoid", then change it to...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Inventory
    • Language: *
  20. List last modified files using FTP Command-linehttps://www.joellipman.com/articles/cms/website-development/ftp/list-last-modified-files-using-ftp-command-line.html

    login credentials Type dir (lists files & folders in the current remote working directory) Type cd /path/to/my/website to change directory to the root folder containing your website. Type pwd to confirm the remote working directory is the current...

    • Type: Article
    • Author: Joel Lipman
    • Category: File Transfer Protocol
    • Language: *
Results 61 - 80 of 170