Quota getQuotasByNameLike - Revision history

Hovietluu at 09:28, 11 November 2016

2016-11-11T09:28:37Z

← Older revision		Revision as of 09:28, 11 November 2016
Line 21:		Line 21:

	'''Example'''		'''Example'''
			<source lang="javascript">
			array a = Quota_getQuotasByNameLike("[Week 201621]",15530909);
			for(number i = 0; i< a.Count; i++) print(a[i]);

	~~<div>array a = Quota_getQuotasByNameLike("[Week 201621]",15530909);</div><div>for(number i = 0; i< a.Count; i++)  print(a[i]);</div><div><br/></div><div>~~Result:~~</div><div>~~//{26,62550,[Week 201621] - A. Age 18-34,68,Age == [18-34] && D_Week == [201621],15530909,Original target: 68,False,False,17,4}~~</div><div>~~//{26,62551,[Week 201621] - B. Age 35-49,69,Age == [35-49] && D_Week == [201621],15530909,Original target: 69,False,False,43,9}~~</div><div>~~//{26,62552,[Week 201621] - C. Age 50-64,67,Age == [50-64] && D_Week == [201621],15530909,Original target: 67,False,False,97,25}~~</div><div>~~//{26,62553,[Week 201621] - D. Age 65+,47,Age == [65-99] && D_Week == [201621],15530909,Original target: 47,False,False,93,40}~~</div><div>~~//{26,62554,[Week 201621] - E. Region Hovedstaden,79,Region == [200] && D_Week == [201621],15530909,Original target: 79,False,False,74,23}~~</div><div>~~//{26,62555,[Week 201621] - F. Region Sjælland,37,Region == [201] && D_Week == [201621],15530909,Original target: 37,False,False,35,14}~~</div><div>~~//{26,62556,[Week 201621] - G. Region Syddanmark,54,Region == [202] && D_Week == [201621],15530909,Original target: 54,False,False,61,11}~~</div><div>~~//{26,62557,[Week 201621] - H. Region Midtjylland,57,Region == [203] && D_Week == [201621],15530909,Original target: 57,False,False,54,20}~~</div><div>~~//{26,62558,[Week 201621] - I. Region Nordjylland,26,Region == [204] && D_Week == [201621],15530909,Original target: 26,False,False,25,10}~~</div><div>~~//{26,62559,[Week 201621] - K. Gender - Mand,126,D_Week == [201621] && ~~ ~~Sex == [1],15530909,Original target: 126,False,False,135,36}~~</div><div>~~//{26,62560,[Week 201621] - L. Gender - Kvinde,127,D_Week == [201621] && ~~ ~~Sex == [2],15530909,Original target: 127,False,False,115,42}~~</div><div>~~//{26,62561,[Week 201621] - M. Total,250,D_Week == [201621],15530909,Original target: 250,False,False,250,78}</~~div~~>		Result:
			//{26,62550,[Week 201621] - A. Age 18-34,68,Age == [18-34] && D_Week == [201621],15530909,Original target: 68,False,False,17,4}
			//{26,62551,[Week 201621] - B. Age 35-49,69,Age == [35-49] && D_Week == [201621],15530909,Original target: 69,False,False,43,9}
			//{26,62552,[Week 201621] - C. Age 50-64,67,Age == [50-64] && D_Week == [201621],15530909,Original target: 67,False,False,97,25}
			//{26,62553,[Week 201621] - D. Age 65+,47,Age == [65-99] && D_Week == [201621],15530909,Original target: 47,False,False,93,40}
			//{26,62554,[Week 201621] - E. Region Hovedstaden,79,Region == [200] && D_Week == [201621],15530909,Original target: 79,False,False,74,23}
			//{26,62555,[Week 201621] - F. Region Sjælland,37,Region == [201] && D_Week == [201621],15530909,Original target: 37,False,False,35,14}
			//{26,62556,[Week 201621] - G. Region Syddanmark,54,Region == [202] && D_Week == [201621],15530909,Original target: 54,False,False,61,11}
			//{26,62557,[Week 201621] - H. Region Midtjylland,57,Region == [203] && D_Week == [201621],15530909,Original target: 57,False,False,54,20}
			//{26,62558,[Week 201621] - I. Region Nordjylland,26,Region == [204] && D_Week == [201621],15530909,Original target: 26,False,False,25,10}
			//{26,62559,[Week 201621] - K. Gender - Mand,126,D_Week == [201621] && Sex == [1],15530909,Original target: 126,False,False,135,36}
			//{26,62560,[Week 201621] - L. Gender - Kvinde,127,D_Week == [201621] && Sex == [2],15530909,Original target: 127,False,False,115,42}
			//{26,62561,[Week 201621] - M. Total,250,D_Week == [201621],15530909,Original target: 250,False,False,250,78}
			</source>
	<br/>'''Availability'''		<br/>'''Availability'''

	Version 5.8 __NOTOC__		Version 5.8 __NOTOC__
	<!-- imported from file: 8021.htm-->		<!-- imported from file: 8021.htm-->

Hovietluu at 09:27, 11 November 2016

2016-11-11T09:27:58Z

← Older revision		Revision as of 09:27, 11 November 2016
Line 21:		Line 21:

	'''Example'''		'''Example'''
	~~<source lang="javascript">~~
	<div>array a = Quota_getQuotasByNameLike("[Week 201621]",15530909);</div><div>for(number i = 0; i< a.Count; i++)  print(a[i]);</div><div><br/></div><div>Result:</div><div>//{26,62550,[Week 201621] - A. Age 18-34,68,Age == [18-34] && D_Week == [201621],15530909,Original target: 68,False,False,17,4}</div><div>//{26,62551,[Week 201621] - B. Age 35-49,69,Age == [35-49] && D_Week == [201621],15530909,Original target: 69,False,False,43,9}</div><div>//{26,62552,[Week 201621] - C. Age 50-64,67,Age == [50-64] && D_Week == [201621],15530909,Original target: 67,False,False,97,25}</div><div>//{26,62553,[Week 201621] - D. Age 65+,47,Age == [65-99] && D_Week == [201621],15530909,Original target: 47,False,False,93,40}</div><div>//{26,62554,[Week 201621] - E. Region Hovedstaden,79,Region == [200] && D_Week == [201621],15530909,Original target: 79,False,False,74,23}</div><div>//{26,62555,[Week 201621] - F. Region Sjælland,37,Region == [201] && D_Week == [201621],15530909,Original target: 37,False,False,35,14}</div><div>//{26,62556,[Week 201621] - G. Region Syddanmark,54,Region == [202] && D_Week == [201621],15530909,Original target: 54,False,False,61,11}</div><div>//{26,62557,[Week 201621] - H. Region Midtjylland,57,Region == [203] && D_Week == [201621],15530909,Original target: 57,False,False,54,20}</div><div>//{26,62558,[Week 201621] - I. Region Nordjylland,26,Region == [204] && D_Week == [201621],15530909,Original target: 26,False,False,25,10}</div><div>//{26,62559,[Week 201621] - K. Gender - Mand,126,D_Week == [201621] &&  Sex == [1],15530909,Original target: 126,False,False,135,36}</div><div>//{26,62560,[Week 201621] - L. Gender - Kvinde,127,D_Week == [201621] &&  Sex == [2],15530909,Original target: 127,False,False,115,42}</div><div>//{26,62561,[Week 201621] - M. Total,250,D_Week == [201621],15530909,Original target: 250,False,False,250,78}</div>		<div>array a = Quota_getQuotasByNameLike("[Week 201621]",15530909);</div><div>for(number i = 0; i< a.Count; i++)  print(a[i]);</div><div><br/></div><div>Result:</div><div>//{26,62550,[Week 201621] - A. Age 18-34,68,Age == [18-34] && D_Week == [201621],15530909,Original target: 68,False,False,17,4}</div><div>//{26,62551,[Week 201621] - B. Age 35-49,69,Age == [35-49] && D_Week == [201621],15530909,Original target: 69,False,False,43,9}</div><div>//{26,62552,[Week 201621] - C. Age 50-64,67,Age == [50-64] && D_Week == [201621],15530909,Original target: 67,False,False,97,25}</div><div>//{26,62553,[Week 201621] - D. Age 65+,47,Age == [65-99] && D_Week == [201621],15530909,Original target: 47,False,False,93,40}</div><div>//{26,62554,[Week 201621] - E. Region Hovedstaden,79,Region == [200] && D_Week == [201621],15530909,Original target: 79,False,False,74,23}</div><div>//{26,62555,[Week 201621] - F. Region Sjælland,37,Region == [201] && D_Week == [201621],15530909,Original target: 37,False,False,35,14}</div><div>//{26,62556,[Week 201621] - G. Region Syddanmark,54,Region == [202] && D_Week == [201621],15530909,Original target: 54,False,False,61,11}</div><div>//{26,62557,[Week 201621] - H. Region Midtjylland,57,Region == [203] && D_Week == [201621],15530909,Original target: 57,False,False,54,20}</div><div>//{26,62558,[Week 201621] - I. Region Nordjylland,26,Region == [204] && D_Week == [201621],15530909,Original target: 26,False,False,25,10}</div><div>//{26,62559,[Week 201621] - K. Gender - Mand,126,D_Week == [201621] &&  Sex == [1],15530909,Original target: 126,False,False,135,36}</div><div>//{26,62560,[Week 201621] - L. Gender - Kvinde,127,D_Week == [201621] &&  Sex == [2],15530909,Original target: 127,False,False,115,42}</div><div>//{26,62561,[Week 201621] - M. Total,250,D_Week == [201621],15530909,Original target: 250,False,False,250,78}</div>
	~~</source>~~
	<br/>'''Availability'''		<br/>'''Availability'''

	Version 5.8 __NOTOC__		Version 5.8 __NOTOC__
	<!-- imported from file: 8021.htm-->		<!-- imported from file: 8021.htm-->

Hovietluu at 09:27, 11 November 2016

2016-11-11T09:27:15Z

← Older revision		Revision as of 09:27, 11 November 2016
Line 21:		Line 21:

	'''Example'''		'''Example'''
			<source lang="javascript">
	<div>array a = Quota_getQuotasByNameLike("[Week 201621]",15530909);</div><div>for(number i = 0; i< a.Count; i++)  print(a[i]);</div><div><br/></div><div>Result:</div><div>//{26,62550,[Week 201621] - A. Age 18-34,68,Age == [18-34] && D_Week == [201621],15530909,Original target: 68,False,False,17,4}</div><div>//{26,62551,[Week 201621] - B. Age 35-49,69,Age == [35-49] && D_Week == [201621],15530909,Original target: 69,False,False,43,9}</div><div>//{26,62552,[Week 201621] - C. Age 50-64,67,Age == [50-64] && D_Week == [201621],15530909,Original target: 67,False,False,97,25}</div><div>//{26,62553,[Week 201621] - D. Age 65+,47,Age == [65-99] && D_Week == [201621],15530909,Original target: 47,False,False,93,40}</div><div>//{26,62554,[Week 201621] - E. Region Hovedstaden,79,Region == [200] && D_Week == [201621],15530909,Original target: 79,False,False,74,23}</div><div>//{26,62555,[Week 201621] - F. Region Sjælland,37,Region == [201] && D_Week == [201621],15530909,Original target: 37,False,False,35,14}</div><div>//{26,62556,[Week 201621] - G. Region Syddanmark,54,Region == [202] && D_Week == [201621],15530909,Original target: 54,False,False,61,11}</div><div>//{26,62557,[Week 201621] - H. Region Midtjylland,57,Region == [203] && D_Week == [201621],15530909,Original target: 57,False,False,54,20}</div><div>//{26,62558,[Week 201621] - I. Region Nordjylland,26,Region == [204] && D_Week == [201621],15530909,Original target: 26,False,False,25,10}</div><div>//{26,62559,[Week 201621] - K. Gender - Mand,126,D_Week == [201621] &&  Sex == [1],15530909,Original target: 126,False,False,135,36}</div><div>//{26,62560,[Week 201621] - L. Gender - Kvinde,127,D_Week == [201621] &&  Sex == [2],15530909,Original target: 127,False,False,115,42}</div><div>//{26,62561,[Week 201621] - M. Total,250,D_Week == [201621],15530909,Original target: 250,False,False,250,78}</div>		<div>array a = Quota_getQuotasByNameLike("[Week 201621]",15530909);</div><div>for(number i = 0; i< a.Count; i++)  print(a[i]);</div><div><br/></div><div>Result:</div><div>//{26,62550,[Week 201621] - A. Age 18-34,68,Age == [18-34] && D_Week == [201621],15530909,Original target: 68,False,False,17,4}</div><div>//{26,62551,[Week 201621] - B. Age 35-49,69,Age == [35-49] && D_Week == [201621],15530909,Original target: 69,False,False,43,9}</div><div>//{26,62552,[Week 201621] - C. Age 50-64,67,Age == [50-64] && D_Week == [201621],15530909,Original target: 67,False,False,97,25}</div><div>//{26,62553,[Week 201621] - D. Age 65+,47,Age == [65-99] && D_Week == [201621],15530909,Original target: 47,False,False,93,40}</div><div>//{26,62554,[Week 201621] - E. Region Hovedstaden,79,Region == [200] && D_Week == [201621],15530909,Original target: 79,False,False,74,23}</div><div>//{26,62555,[Week 201621] - F. Region Sjælland,37,Region == [201] && D_Week == [201621],15530909,Original target: 37,False,False,35,14}</div><div>//{26,62556,[Week 201621] - G. Region Syddanmark,54,Region == [202] && D_Week == [201621],15530909,Original target: 54,False,False,61,11}</div><div>//{26,62557,[Week 201621] - H. Region Midtjylland,57,Region == [203] && D_Week == [201621],15530909,Original target: 57,False,False,54,20}</div><div>//{26,62558,[Week 201621] - I. Region Nordjylland,26,Region == [204] && D_Week == [201621],15530909,Original target: 26,False,False,25,10}</div><div>//{26,62559,[Week 201621] - K. Gender - Mand,126,D_Week == [201621] &&  Sex == [1],15530909,Original target: 126,False,False,135,36}</div><div>//{26,62560,[Week 201621] - L. Gender - Kvinde,127,D_Week == [201621] &&  Sex == [2],15530909,Original target: 127,False,False,115,42}</div><div>//{26,62561,[Week 201621] - M. Total,250,D_Week == [201621],15530909,Original target: 250,False,False,250,78}</div>
			</source>
	<br/>'''Availability'''		<br/>'''Availability'''

	Version 5.8 __NOTOC__		Version 5.8 __NOTOC__
	<!-- imported from file: 8021.htm-->		<!-- imported from file: 8021.htm-->

Hovietluu at 09:20, 11 November 2016

2016-11-11T09:20:04Z

← Older revision		Revision as of 09:20, 11 November 2016
Line 12:		Line 12:
	'''Arguments'''		'''Arguments'''

	- quotaName : ~~the~~ name of ~~new~~ quota.		- quotaName : a part or full name of quota.

	- PQResourceId : Resource Id of questionnaire to which quota belongs. If it is empty, the project questionnaire context is needed		- PQResourceId : Resource Id of questionnaire to which quota belongs. If it is empty, the project questionnaire context is needed

Hovietluu at 09:19, 11 November 2016

2016-11-11T09:19:02Z

← Older revision		Revision as of 09:19, 11 November 2016
Line 1:		Line 1:
	{{HelpFiles}}		[[Category:Questionnaire_Functions]]
			{{HelpFiles}}

	==== Quota_getQuotasByNameLike ====		==== Quota_getQuotasByNameLike ====

Hovietluu at 09:18, 11 November 2016

2016-11-11T09:18:00Z

← Older revision		Revision as of 09:18, 11 November 2016
Line 1:		Line 1:
	~~[[Category:Questionnaire_Functions]]~~		{{HelpFiles}}
	{{HelpFiles}}

	==== ~~Quota_getQuotaByName~~ ====		==== Quota_getQuotasByNameLike ====

	To get information of ~~quota~~ by name.		To get information of quotas by similar name.

	'''Syntax'''		'''Syntax'''

	~~array Quota_getQuotaByName~~(string quotaName[, number PQResourceId])		Quota_getQuotasByNameLike(string quotaName[, number PQResourceId])

	'''Arguments'''		'''Arguments'''
Line 18:		Line 17:
	'''Return type'''		'''Return type'''

	array		array of quota

	'''Example'''		'''Example'''
			<div>array a = Quota_getQuotasByNameLike("[Week 201621]",15530909);</div><div>for(number i = 0; i< a.Count; i++)  print(a[i]);</div><div><br/></div><div>Result:</div><div>//{26,62550,[Week 201621] - A. Age 18-34,68,Age == [18-34] && D_Week == [201621],15530909,Original target: 68,False,False,17,4}</div><div>//{26,62551,[Week 201621] - B. Age 35-49,69,Age == [35-49] && D_Week == [201621],15530909,Original target: 69,False,False,43,9}</div><div>//{26,62552,[Week 201621] - C. Age 50-64,67,Age == [50-64] && D_Week == [201621],15530909,Original target: 67,False,False,97,25}</div><div>//{26,62553,[Week 201621] - D. Age 65+,47,Age == [65-99] && D_Week == [201621],15530909,Original target: 47,False,False,93,40}</div><div>//{26,62554,[Week 201621] - E. Region Hovedstaden,79,Region == [200] && D_Week == [201621],15530909,Original target: 79,False,False,74,23}</div><div>//{26,62555,[Week 201621] - F. Region Sjælland,37,Region == [201] && D_Week == [201621],15530909,Original target: 37,False,False,35,14}</div><div>//{26,62556,[Week 201621] - G. Region Syddanmark,54,Region == [202] && D_Week == [201621],15530909,Original target: 54,False,False,61,11}</div><div>//{26,62557,[Week 201621] - H. Region Midtjylland,57,Region == [203] && D_Week == [201621],15530909,Original target: 57,False,False,54,20}</div><div>//{26,62558,[Week 201621] - I. Region Nordjylland,26,Region == [204] && D_Week == [201621],15530909,Original target: 26,False,False,25,10}</div><div>//{26,62559,[Week 201621] - K. Gender - Mand,126,D_Week == [201621] &&  Sex == [1],15530909,Original target: 126,False,False,135,36}</div><div>//{26,62560,[Week 201621] - L. Gender - Kvinde,127,D_Week == [201621] &&  Sex == [2],15530909,Original target: 127,False,False,115,42}</div><div>//{26,62561,[Week 201621] - M. Total,250,D_Week == [201621],15530909,Original target: 250,False,False,250,78}</div>
	array a = ~~Quota_getQuotaByName~~("~~Arkitekt, textilindustri~~",~~5310088~~);

	print(a);

	//{26,~~5915~~,~~Arkitekt~~, ~~textilindustri~~,~~1000~~,Q3 == [5] ,~~5310088~~,,False,False,9,1}

	<br/>'''Availability'''		<br/>'''Availability'''

	Version 5.8 __NOTOC__		Version 5.8 __NOTOC__
	<!-- imported from file: 8021.htm-->		<!-- imported from file: 8021.htm-->

Hovietluu at 09:10, 11 November 2016

2016-11-11T09:10:35Z

← Older revision		Revision as of 09:10, 11 November 2016
Line 1:		Line 1:
	{{HelpFiles}}		[[Category:Questionnaire_Functions]]
			{{HelpFiles}}

	==== Quota_getQuotaByName ====		==== Quota_getQuotaByName ====

Hovietluu at 09:08, 11 November 2016

2016-11-11T09:08:38Z

@@ Line 1: / Line 1: @@
-{{Function_Template|Name=Quota_getQuotasByNameLike|ReturnType=Array
+{{HelpFiles}}
-|Parameters=
-|Name=Quota name|ConstantType=String,
+==== Quota_getQuotaByName ====
-|Name=Quota questionnaire resource id|IsOptional=1|ConstantType=Number|IsInteger=1|IsPositive=1
-}}
+To get information of quota by name.

Hovietluu at 09:08, 11 November 2016

2016-11-11T09:08:24Z

← Older revision		Revision as of 09:08, 11 November 2016
Line 1:		Line 1:
	{{Function_Template\|Name=Quota_getQuotasByNameLike\|ReturnType=Array		{{Function_Template\|Name=Quota_getQuotasByNameLike\|ReturnType=Array
	\|Parameters=		\|Parameters=
	\|Name=~~<nowiki>~~Quota name~~</nowiki>~~\|ConstantType=String,		\|Name=Quota name\|ConstantType=String,
	\|Name=~~<nowiki>~~Quota questionnaire resource id~~</nowiki>~~\|IsOptional=1\|ConstantType=Number\|IsInteger=1\|IsPositive=1		\|Name=Quota questionnaire resource id\|IsOptional=1\|ConstantType=Number\|IsInteger=1\|IsPositive=1
	}}		}}

Hovietluu at 09:06, 11 November 2016

2016-11-11T09:06:42Z

← Older revision		Revision as of 09:06, 11 November 2016
Line 1:		Line 1:
	{{Function_Template\|Name=Quota_getQuotasByNameLike\|ReturnType=Array		{{Function_Template\|Name=Quota_getQuotasByNameLike\|ReturnType=Array
	\|Parameters=		\|Parameters=
	\|Name=Quota name\|ConstantType=String,		\|Name=<nowiki>Quota name</nowiki>\|ConstantType=String,
	\|Name=Quota questionnaire resource id\|IsOptional=1\|ConstantType=Number\|IsInteger=1\|IsPositive=1		\|Name=<nowiki>Quota questionnaire resource id</nowiki>\|IsOptional=1\|ConstantType=Number\|IsInteger=1\|IsPositive=1
	}}		}}