Assuming group is required, the following 56 results were found.
-
the drama across the web, the system introduces only a few new fundamental improvements (particularly Access Control and Groups) which actually only means some minor database alterations. I've googled, yahood and binged, but still can't find a good way...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
including shipping and tax. The second is to associate these to the invoiced items and work out the profit. The third is to group by the sales person, date, and customer so as to generate meaningful reports. The first dataset should be just the profit...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
This is an article to serve as a guide in terms of styling a radio group into a group of Tabs. This is only a guide or reference which was applied for one client but would need adapting to match the colors or style the next client wants. Why? The...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
at the time of install. Also note, this module will NOT generate thumbnails if you select "Public" as the authorized service group. I know it's the default option but you need to select an user group with higher privileges like "Super User"....
- Type: Article
- Author: Joel Lipman
- Category: Product Documentation
- Language: *
-
MAX(a.VisitorID) ID, a.VisitorIP IP, a.DateTimeStamp Date FROM custombu_stats_visits a WHERE YEAR(a.DateTimeStamp)='2010' GROUP BY a.VisitorIP ORDER BY MAX(a.VisitorID) DESC ) t1 LEFT OUTER JOIN wikimedia_user b ON t1.ID=b.user_id GROUP BY t1.IP ORDER...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: *
-
to the template. Copy over Users: Rename the Admin ID in the new v34 system to match your v25 system. Check your usergroups are the same in both systems. Import new ones. Copy all users except the v25 admin to your v34 database (with status=blocked)...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
Another article on styling a radio group to become a weekly calendar carousel. In that a radio group displays the days of the week with arrows allowing the user to select the next or previous week. This is a follow on from my other articles on restyling...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
and environment. Our setup is: SQL Server 2008 Report Builder 2.0 BMC Service Desk Express 9.8 DataSet1: Incident # Group Name Close Date & Time Assigned to Full Name Incident Type The objective of this article is to explain how to hide "Series1" from...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
the new table `#_content` Import Users: export SQL file and amend the insert(s) into the new table `#_users` Import User Group Maps: export SQL file and amend the insert(s) into the new table `#_user_usergroup_map` Viewing Articles in the Administrator...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
this you should be on the following screen: Select the Report Type: For this calendar we want matrix because we're going to group based on the rows: Design the Matrix: Ok so we want weekday in the columns (to have mon-sun along the top), "Order" in rows...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
to select the exchange fields. Check/ensure the "In Use?" is ticked. Store/save your XET Setting up the Stu-Talk Message Group (SMG) This should be done before continuing as the remaining screens will refer to this and allow you to specify the related...
- Type: Article
- Author: Joel Lipman
- Category: Extensible Markup Language
- Language: *
-
// // reset and set radio group options clear input.Color_Picker; for each l_ColorRow in l_ColorPalette { for each v_ThisColor in l_ColorRow { input.Color_Picker:ui.add(v_ThisColor); } } Step 2: Replace the text with colored boxes //... // // reset and...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
1 Me,Myself,I Note that the following queries include the nested version because I find myself needing to group concatenate more often from another table then using data from the same table. MySQL SELECT ( SELECT GROUP_CONCAT(column_to_return_as_string)...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: en-GB
-
INSERT INTO mydb_upgrade_j25.myprefix_jcomments ( id, parent, thread_id, path, level, object_id, object_group, object_params, lang, userid, name, username, email, homepage, title, comment, ip, date, isgood, ispoor, published, subscribe, source,...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
line items, alongside the product name, list price, quantity, tax, etc. In the example below, we have added a column called "Group Name" in the CRM Quote module as per the following screenshot: How? Again at the time of this article, this is only...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
solution and can follow these quick steps: Right-click the grey header of the tablix row (left-most grey part) Select "Add Group" then "Parent Group..." Specify the "Group by" (in my case "Day"), the grey part will display a grouping icon Now select the...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
to a Month name. An error occurred during local report processing. An error has occurred during report processing. The Group expression used in grouping 'table1_month' returned a data type that is not valid. My DataSet Query was as follows: SELECT...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
Win32 Constantshttps://joellipman.com/articles/automation/autohotkey/win32-constants.html
WS_VSCROLL = $00200000 Const WS_HSCROLL = $00100000 Const WS_SYSMENU = $00080000 Const WS_THICKFRAME = $00040000 Const WS_GROUP = $00020000 Const WS_TABSTOP = $00010000 Const WS_MINIMIZEBOX = $00020000 Const WS_MAXIMIZEBOX = $00010000 Const WS_TILED =...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: *
-
ItemYear) AS YearRun, COUNT(ItemName) AS Counter FROM TableName WHERE ItemDate BETWEEN '01/01/2010' AND '08/01/2011' GROUP BY DATEPART(dayofyear, ItemDate), DATEPART(year, ItemYear), ItemName // yields something like ItemName DayOfYear YearRun Counter...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: *
-
List MediaWiki Articleshttps://joellipman.com/articles/cms/mediawiki/list-mediawiki-articles.html
AS PageID, CONVERT(p.page_title USING latin1) AS PageTitle, CONVERT(t.old_text USING latin1) AS PageContent, (SELECT GROUP_CONCAT(CONVERT(wikimedia_categorylinks.cl_to USING latin1)) FROM wikimedia_categorylinks WHERE...
- Type: Article
- Author: Joel Lipman
- Category: MediaWiki
- Language: en-GB
Donate & Support
bc1qf6elrdxc968h0k673l2djc9wrpazhqtxw8qqp4
0xb038962F3809b425D661EF5D22294Cf45E02FebF