Queries: General - Revision history

Ngordon7000: Ngordon7000 moved page Code Scratchpad: Queries: General to Queries: General

2021-07-28T05:56:29Z

Ngordon7000 moved page Code Scratchpad: Queries: General to Queries: General

Thomas Thießen: Add category

2015-08-31T18:00:51Z

Add category

Ngordon7000: /* Invoices grouped by document type name */

2015-05-07T10:10:08Z

Invoices grouped by document type name

Ngordon7000 at 10:09, 7 May 2015

2015-05-07T10:09:50Z

Ngordon7000: /* Statistics: number of records */

2015-05-07T08:24:14Z

Statistics: number of records

Ngordon7000 at 08:23, 7 May 2015

2015-05-07T08:23:54Z

Ngordon7000: /* Credits */

2015-05-07T07:42:43Z

Credits

Ngordon7000: Created page with "Category:Code Scratchpad = Credits = Initial contribution by: nTier Software Services http://www.ntier.co.za ngordon7000 Add your credit here."

2015-05-07T07:42:27Z

Created page with "Category:Code Scratchpad = Credits = Initial contribution by: nTier Software Services http://www.ntier.co.za ngordon7000 Add your credit here."

New page

[[Category:Code Scratchpad]]

= Credits =

Initial contribution by: nTier Software Services http://www.ntier.co.za ngordon7000
Add your credit here.

← Older revision		Revision as of 18:00, 31 August 2015
Line 1:		Line 1:
	[[Category:Code Scratchpad]]		[[Category:Code Scratchpad]]
		+	[[Category:Development‏‎]]
		+	[[Category:Developer documentation‏‎]]

	= Statistics =		= Statistics =

@@ Line 38: / Line 38: @@
 == Invoices grouped by document type name ==
-select dt.name as DocumentType, cast('1900/01/01' as text) as since, count(*) from c_invoice a join c_doctype dt on a.c_doctype_id = dt.c_doctype_id where a.ad_client_id = 1000000 and a.created>='1900/01/01' group by dt.name;
+ <nowiki>select dt.name as DocumentType, cast('1900/01/01' as text) as since, count(*) from c_invoice a join c_doctype dt on a.c_doctype_id = dt.c_doctype_id where a.ad_client_id = 1000000 and a.created>='1900/01/01' group by dt.name;</nowiki>
 = Credits =

@@ Line 1: / Line 1: @@
 [[Category:Code Scratchpad]]
-= Statistics: number of records =
+= Statistics =
   <nowiki>select cast('Business partners: Count' as text) as heading, cast('1900/01/01' as text) as since, count(*) from c_bpartner a where a.ad_client_id = 1000000 and created>='1900/01/01'
@@ Line 33: / Line 35: @@
 select cast('Assets: Inactive' as text) as heading, cast('1900/01/01' as text) as since, count(*) from a_asset a where a.ad_client_id = 1000000 and created>='1900/01/01' and isactive = 'N'
 ;</nowiki>
 = Credits =

@@ Line 3: / Line 3: @@
 = Statistics: number of records =
-<nowiki>select cast('Business partners: Count' as text) as heading, cast('1900/01/01' as text) as since, count(*) from c_bpartner a where a.ad_client_id = 1000000 and created>='1900/01/01'
+ <nowiki>select cast('Business partners: Count' as text) as heading, cast('1900/01/01' as text) as since, count(*) from c_bpartner a where a.ad_client_id = 1000000 and created>='1900/01/01'
 union all
 select cast('Business partners: Inactive' as text) as heading, cast('1900/01/01' as text) as since, count(*) from c_bpartner a where a.ad_client_id = 1000000 and created>='1900/01/01' and isactive = 'N'

← Older revision		Revision as of 08:23, 7 May 2015
Line 1:		Line 1:
	[[Category:Code Scratchpad]]		[[Category:Code Scratchpad]]
		+
		+	= Statistics: number of records =
		+
		+	<nowiki>select cast('Business partners: Count' as text) as heading, cast('1900/01/01' as text) as since, count(*) from c_bpartner a where a.ad_client_id = 1000000 and created>='1900/01/01'
		+	union all
		+	select cast('Business partners: Inactive' as text) as heading, cast('1900/01/01' as text) as since, count(*) from c_bpartner a where a.ad_client_id = 1000000 and created>='1900/01/01' and isactive = 'N'
		+	union all
		+	select cast('Business partners: Suppliers' as text) as heading, cast('1900/01/01' as text) as since, count(*) from c_bpartner a where a.ad_client_id = 1000000 and a.isvendor = 'Y' and created>='1900/01/01'
		+	union all
		+	select cast('Business partners: Customers' as text) as heading, cast('1900/01/01' as text) as since, count(*) from c_bpartner a where a.ad_client_id = 1000000 and a.iscustomer = 'Y' and created>='1900/01/01'
		+	union all
		+	select cast('Business partners: Count' as text) as heading, cast('1900/01/01' as text) as since, count(*) from c_bpartner a where a.ad_client_id = 1000000 and created>='1900/01/01'
		+	union all
		+	select cast('Invoices: Count' as text) as heading, cast('1900/01/01' as text) as since, count(*) from c_invoice a where a.ad_client_id = 1000000 and created>='1900/01/01'
		+	union all
		+	select cast('Invoices: Reversed or voided' as text) as heading, cast('1900/01/01' as text) as since, count(*) from c_invoice a where a.ad_client_id = 1000000 and created>='1900/01/01' and docstatus in ('RE','VO')
		+	union all
		+	select cast('Invoices: Suppliers' as text) as heading, cast('1900/01/01' as text) as since, count(*) from c_invoice a where a.ad_client_id = 1000000 and a.issotrx = 'N' and created>='1900/01/01'
		+	union all
		+	select cast('Invoices: Customers' as text) as heading, cast('1900/01/01' as text) as since, count(*) from c_invoice a where a.ad_client_id = 1000000 and a.issotrx = 'Y' and created>='1900/01/01'
		+	union all
		+	select cast('Payments: Count' as text) as heading, cast('1900/01/01' as text) as since, count(*) from c_payment a where a.ad_client_id = 1000000 and created>='1900/01/01'
		+	union all
		+	select cast('Payments: Reversed or voided' as text) as heading, cast('1900/01/01' as text) as since, count(*) from c_payment a where a.ad_client_id = 1000000 and created>='1900/01/01' and docstatus in ('RE','VO')
		+	union all
		+	select cast('Payments: Suppliers' as text) as heading, cast('1900/01/01' as text) as since, count(*) from c_payment a where a.ad_client_id = 1000000 and a.isreceipt = 'N' and created>='1900/01/01'
		+	union all
		+	select cast('Payments: Customers' as text) as heading, cast('1900/01/01' as text) as since, count(*) from c_payment a where a.ad_client_id = 1000000 and a.isreceipt = 'Y' and created>='1900/01/01'
		+	union all
		+	select cast('Assets: Count' as text) as heading, cast('1900/01/01' as text) as since, count(*) from a_asset a where a.ad_client_id = 1000000 and created>='1900/01/01'
		+	union all
		+	select cast('Assets: Inactive' as text) as heading, cast('1900/01/01' as text) as since, count(*) from a_asset a where a.ad_client_id = 1000000 and created>='1900/01/01' and isactive = 'N'
		+	;</nowiki>

	= Credits =		= Credits =

← Older revision		Revision as of 07:42, 7 May 2015
Line 4:		Line 4:

	Initial contribution by: nTier Software Services http://www.ntier.co.za ngordon7000		Initial contribution by: nTier Software Services http://www.ntier.co.za ngordon7000
		+
	Add your credit here.		Add your credit here.