Zoho Analytics: Set Up a Widget Displaying Sales Personhttp://mail.joellipman.com/articles/crm/zoho/zoho-analytics-set-up-widget-displaying-sales-person.html

24 October 2022 a sales person. It adds to the effect on loading the page that a widget has clearly defined values based on the filters I select on a dashboard. First you will need a table or query that has a bunch of columns and rows with one of the columns containing...

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

Zoho CRM: Remove Duplicate Product Recordshttp://mail.joellipman.com/articles/crm/zoho/zoho-crm-remove-duplicate-product-records.html

07 March 2025 = v_PageFactor * v_PerPage; // // get unique product names (v2 up to 200, v6 up to 10k, v7 up to 100k) m_Params = {"select_query":"select Product_Name, COUNT(id) 'Frequency' from Products where Product_Name is not null group by Product_Name limit " +...

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

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

18 September 2025 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 modules (Client Review and Placement Tech Survey having been disabled)... How? So this might seem obvious but...

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

MySQL Commands to display all columnshttp://mail.joellipman.com/articles/database/mysql/mysql-commands-to-display-all-columns.html

28 October 2010 from. The following is a MYSQL query that displays the structure of all the columns in all the databases of the localhost: SELECT * FROM information_schema.COLUMNS ORDER BY TABLE_NAME, COLUMN_NAME The following is a MYSQL query that finds all columns...

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

Trim in T-SQL and SSIShttp://mail.joellipman.com/articles/microsoft/ssis/trim-in-t-sql-and-ssis.html

14 May 2013 Some methods of removing trailing spaces, tabs, carriage returns and line feeds (new lines). How? First in Transact-SQL: SELECT RTRIM( REPLACE( REPLACE( REPLACE( @myString, CHAR(9), ''), CHAR(10), ''), CHAR(13), '') ) -- CHAR(9) = Tab -- CHAR(10) = Line...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Integration Services
• Language: en-GB

Zoho CRM: ZDK Client Script: Auto-Select Pipeline based on User Departmenthttp://mail.joellipman.com/articles/crm/zoho/zoho-crm-zdk-client-script-auto-select-pipeline-based-on-user-department.html

16 October 2023 A super quick article on how to pre-select the pipeline on deal creation within CRM based on the department specified on a user's profile. Why? A client asked that when staff create a deal/opportunity record in CRM, the pipeline is automatically...

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

Installing phpBB3 for Joomla with a RocketTheme templatehttp://mail.joellipman.com/articles/cms/joomla/installing-phpbb3-for-joomla-with-a-rockettheme-template.html

28 September 2009 phpBB3 Administration Control Panel (ACP), which should be located at something like http://www.mysite.com/phpBB3/adm/. Select the "Styles" tab. You should see a row with "Affinity" at the bottom. Click on "Install", set as default and that's it.......

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

Win32 Constantshttp://mail.joellipman.com/articles/automation/autohotkey/win32-constants.html

05 July 2011 Const WM_HSCROLL = $0114 Const WM_VSCROLL = $0115 Const WM_INITMENU = $0116 Const WM_INITMENUPOPUP = $0117 Const WM_MENUSELECT = $011F Const WM_MENUCHAR = $0120 Const WM_ENTERIDLE = $0121 Const WM_MENURBUTTONUP = $0122 Const WM_MENUDRAG = $0123 Const...

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

Before and After, Highs and Lowshttp://mail.joellipman.com/articles/microsoft/ssrs/before-and-after-highs-and-lows.html

03 August 2011 let's say I have one RDL or SSRS Solution. I could do a dataset per SQL query but it doesn't seem that ideal. In Theory: SELECT ItemName, DATEPART(dayofyear, ItemDate) as DayOfYear, DATEPART(year, ItemYear) AS YearRun, COUNT(ItemName) AS Counter FROM...

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

The ReportServer Databasehttp://mail.joellipman.com/articles/database/the-reportserver-database.html

08 August 2011 Show me the Name! A quick query to show the execution log with at least the report name for us human users: SELECT a.[InstanceName] ,b.[Name] ,a.[UserName] ,a.[RequestType] ,a.[Format] ,a.[Parameters] ,a.[TimeStart] ,a.[TimeEnd] ,a.[TimeDataRetrieval]...

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

Stop Excel Row Height Self-Adjust on Refreshhttp://mail.joellipman.com/articles/microsoft/excel/stop-excel-row-height-self-adjust-on-refresh.html

30 September 2011 database. The Excel file pulls data using lookup tables and displays the data in an Excel Spreadsheet. The Problem We can select all cells and set row height to be 30 for example, but everytime we refresh the data in the Excel spreadsheet, all the rows...

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

MySQL last year week month day trend periodshttp://mail.joellipman.com/articles/database/mysql/mysql-last-year-week-month-day-trend.html

31 October 2011 level now. What follows should be usable mySQL statements to get all the numbers: Yesterdays -- CURRENT: count todays SELECT COUNT(id) FROM Table1 WHERE DATE(registerDate)=DATE(NOW()); -- BEFORE: count yesterdays total SELECT COUNT(id) FROM Table1 WHERE...

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

How to Display Report Execution Time in SSRS (milliseconds)http://mail.joellipman.com/articles/microsoft/ssrs/how-to-display-report-execution-time-in-ssrs.html

17 November 2011 calculation using two datasets: -- Oracle 10g: DataSet1 -- your normal dataset query with an added field (ReportStartTime) SELECT field1, field2, TO_CHAR(systimestamp, 'HH24:MI:SS.FF6') AS ReportStartTime FROM... Then add another dataset (using the...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Reporting Services
• Language: en-GB

Getting the mysql where in delimited string to workhttp://mail.joellipman.com/articles/database/mysql/getting-the-mysql-where-in-delimited-string-to-work.html

02 January 2012 table of room assets that has a field containing the ID numbers of images relevant to this room. The Problem? When I select specifying the statement "WHERE IN (c.RoomImages)", this is interpreted as a string and when converted to a number only retrieves...

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

T-SQL example of Case-Sensitive Soundexhttp://mail.joellipman.com/articles/database/t-sql/t-sql-example-of-case-sensitive-soundex.html

10 October 2012 This article is for demonstrating how to use a SOUNDEX in a select and then listing all the variations based on case-sensitivity. Why? We have a database with data in it. For a particular column we have setup default values, let's use the example "Data...

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

Search a database with SOUNDEXhttp://mail.joellipman.com/articles/database/search-a-database-with-soundex.html

11 October 2012 = LEN(@p_SearchString) + 1; -- Populate Cursor1 (used to generate final SQL query to run) DECLARE Cursor1 CURSOR FOR SELECT 'SELECT ' + COLUMN_NAME + ' COLLATE Latin1_General_CS_AS AS column_value, ''' + TABLE_SCHEMA + '.' + TABLE_NAME + '.' +...

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

Search a database for a value and count matching rowshttp://mail.joellipman.com/articles/database/search-a-database-for-a-value-and-count-matching-rows.html

05 November 2012 varchar(max), @TableToProcess varchar(max); -- Populate Cursor1 (Used to hold valid table names) DECLARE Cursor1 CURSOR FOR SELECT TABLE_CATALOG + '.' + TABLE_SCHEMA + '.' + TABLE_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE COLUMN_NAME = @p_Column ORDER...

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

Adding a selectable background to a Yootheme templatehttp://mail.joellipman.com/articles/cms/joomla/adding-a-selectable-background-to-a-yootheme-template.html

19 November 2012 Turquoise". Yootheme uses CSS files to do this so we'll need to modify the XML file and add some files that this will select. Modify \templates\\config.xml add the select option "Ambient Turquoise" to the end of the list: Grey Dots Tartan Lines Dark...

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

T-SQL concatenate an incremental row numberhttp://mail.joellipman.com/articles/database/t-sql/t-sql-concatenate-an-incremental-row-number.html

24 May 2013 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 VARCHAR), 3) AS EmployeeNo, RIGHT('000' + CAST(q.Employee AS VARCHAR), 3) + '01' AS...

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

Convert to Proper Case in T-SQLhttp://mail.joellipman.com/articles/database/t-sql/convert-to-proper-case-in-t-sql.html

04 June 2014 some variables DECLARE @Reset BIT; DECLARE @Ret VARCHAR(8000); DECLARE @i INT; DECLARE @c VARCHAR(2); -- specify reset SELECT @Reset = 1, @i=1, @Ret = ''; IF (UPPER(@Text)=@Text Collate Latin1_General_CS_AI) BEGIN -- cycle through each character, -- if...

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