Export Merge Data - Revision history

WikiSysop at 05:03, 3 February 2012

2012-02-03T05:03:28Z

WikiSysop: /* Student Information Functions */

2011-06-08T03:16:24Z

‎Student Information Functions

WikiSysop: /* Date Manipulation Functions */

2011-06-08T03:15:14Z

‎Date Manipulation Functions

WikiSysop: /* Text Manipulation Functions */

2011-06-08T03:14:32Z

‎Text Manipulation Functions

WikiSysop: /* Numeric Manipulation Functions */

2011-06-08T03:13:10Z

‎Numeric Manipulation Functions

WikiSysop: /* Numeric Manipulation Functions */

2011-06-08T03:09:30Z

‎Numeric Manipulation Functions

WikiSysop: /* Date Manipulation Functions */

2011-06-08T03:08:15Z

‎Date Manipulation Functions

WikiSysop: /* Text Manipulation Functions */

2011-06-08T03:06:28Z

‎Text Manipulation Functions

WikiSysop: /* Integer( nValue ) */

2011-06-08T02:27:53Z

‎Integer( nValue )

WikiSysop: /* INT( nValue ) */

2011-06-08T02:27:19Z

‎INT( nValue )

← Older revision		Revision as of 05:03, 3 February 2012
Line 30:		Line 30:

	Two operators at the same level are resolved from left to right.		Two operators at the same level are resolved from left to right.
		+
		+	Replaceable parameters are available. Anything entered between square brackets [ ] will generate a query for those values when the criteria is first evaluated. The text in the square brackets will be used as a prompt.
		+
		+	Three specialized parameters exist and are marked by special characters at the beginning of the string inside the square brackets. AY: will ask for an academic year, AT: for an academic term, and D: for a date. Anything appearing after the colon will be used as text for the prompt.

	=Criteria Editing Screen=		=Criteria Editing Screen=

← Older revision		Revision as of 03:16, 8 June 2011
Line 426:		Line 426:

	<code>HasFinApp(master.entcode,"2010/11",141)		<code>HasFinApp(master.entcode,"2010/11",141)
		+
		+	=== HasCommLog(nFileNumber, lIncludeOperators, cOperators, lIncludeContacts, cContacts, lIncludeMessage, cWords, lIncludeDates, dStart, dEnd, cDateType, lIncludeCategory, cCategories, lIncludeBalance, nBalance ) ===
		+
		+	Returns true if the individual has a communication log entry matching the specified parameters.
		+
		+	=== HasLoan( nEntcode, cYear, cTerm ) ===
		+
		+	Returns true if the individual has a loan for the specified year and term.
		+
		+	=== iif( lCondition , expTrue , expFalse ) ===
		+
		+	Returns the value of the true or false expression based on the condition.
		+
		+	=== MissingTags( cYear, cTerm ) ===
		+
		+	Returns true if the student's course records for the specified year and term are missing tags.
		+
		+	=== SetGlobal( cKeyItem ) ===
		+
		+	Returns the global setting for the item in CrossRoad.
		+
		+	=== TermEntRez( cYear ) ===
		+
		+	Returns the term in which a student entered residence in the specified year.
		+
		+	=== HasCableTV( cYear ) ===
		+
		+	Returns true if the student has cable selected in the year's residence record.
		+
		+	=== HasNetwork( cYear ) ===
		+
		+	Returns true if the student has network selected in the year's residence record.
		+
		+	=== PreviousExport( nIDCent, nStudentID, cYearTerm, cTestFee ) ===
		+
		+	Returns true if the student has previously confirmed registration.
		+
		+	=== HasAppliedBetween( cYear, cTerm, dStart, dEnd ) ===
		+
		+	Returns true if the student applied between the two dates.
		+
		+	=== HasAppliedBefore( cYear, cTerm, dDate) ===
		+
		+	Returns true if the student applied before the specified date.
		+
		+	=== HasAppliedSince( cYear, cTerm, dDate ) ===
		+
		+	Returns true if the student applied after the specified date.
		+
		+	=== TermCredits( cYear, cTerm, lIncludeWD ) ===
		+
		+	Returns a floating point number of credits for the specified year and term. Withdrawn are counted only if the last parameter is true.
		+
		+	=== RezAuthCd( nFileNumber, cYear, cTerm ) ===
		+
		+	Returns the long distance code for the residence record for the year and term.
		+
		+	=== RezExtn( nFileNumber, cYear, cTerm ) ===
		+
		+	Returns the extension for the residence record for the year and term.
		+
		+	=== RezMAC( nFileNumber, cYear, cTerm ) ===
		+
		+	Returns the MAC address for the residence record for the year and term.
		+
		+	=== RezRoom( nFileNumber, cYear, cTerm ) ===
		+
		+	Returns the room number for the residence record for the year and term.
		+
		+	=== FsaRegion( cPostalCode ) ===
		+
		+	Returns the name of the region for the passed postal code.
		+
		+	=== AppliedFor( cYear, cTerm ) ===
		+
		+	Returns true if the student has applied for the specified year and term.
		+
		+	=== AdmittedFor( cYear, cTerm ) ===
		+
		+	Returns true if the student has been admitted for the specified year and term.

	== Functions working with multiple data types ==		== Functions working with multiple data types ==

← Older revision		Revision as of 03:15, 8 June 2011
Line 330:		Line 330:

	Returns a string of the specified month number.		Returns a string of the specified month number.
		+
		+	=== Sec2Days( nSeconds ) ===
		+
		+	Returns an integer of the number of days represented by the specified seconds.
		+
		+	=== Time() ===
		+
		+	Returns the current time as a string.

	== Academic Session Functions ==		== Academic Session Functions ==

← Older revision		Revision as of 03:14, 8 June 2011
Line 214:		Line 214:

	Returns an integer of the number of lines in the passed memo.		Returns an integer of the number of lines in the passed memo.
		+
		+	=== NumTrim( nNumber ) ===
		+
		+	Returns a string of the passed number.
		+
		+	=== OccursIn( cSearchFor, cSearchIn ) ===
		+
		+	Returns true if the sought value is found in the passed string.
		+
		+	=== Replicate( cString, nTimes ) ===
		+
		+	Returns a string of the character(s) repeated the specified number of times.
		+
		+	=== StrTran( cSearchFor , cSearchIn , cReplaceWith , nStart , nCount ) ===
		+
		+	Returns a string with the specified replacement made.
		+
		+	=== Stuff( cString , nStart , nDelete , cInsert ) ===
		+
		+	Returns a string with the inserted and/or deleted characters.

	== Date Manipulation Functions ==		== Date Manipulation Functions ==

@@ Line 447: / Line 447: @@
 === VAL(&nbsp;cString&nbsp;) ===
-Convert a character number to numeric type
+ Convert a character number to numeric type
-<code>val(master.yrstdy) >= 2</code> selects students in year two or greater of their program.
+ <code>val(master.yrstdy) >= 2</code> selects students in year two or greater of their program.
 === Ceiling( nNumber ) ===
@@ Line 466: / Line 466: @@
   Returns the log of the passed number.
 =Comparison Operators=

← Older revision		Revision as of 03:09, 8 June 2011
Line 450:		Line 450:

	<code>val(master.yrstdy) >= 2</code> selects students in year two or greater of their program.		<code>val(master.yrstdy) >= 2</code> selects students in year two or greater of their program.
		+
		+	=== Ceiling( nNumber ) ===
		+
		+	Returns the next highest integer from the floating point number.
		+
		+	=== Cosine( nAngle ) ===
		+
		+	Returns the floating point cosine of the angle.
		+
		+	=== Cotangent( nAngle ) ===
		+
		+	Returns the cotangent of the angle.
		+
		+	=== Log( nNumber ) ===
		+
		+	Returns the log of the passed number.

	=Comparison Operators=		=Comparison Operators=

← Older revision		Revision as of 03:08, 8 June 2011
Line 282:		Line 282:

	<code>year( applics.admdate) = 1998</code> selects students admitted in 1998		<code>year( applics.admdate) = 1998</code> selects students admitted in 1998
		+
		+	=== ElapsedTime( cTime1, cTime2 ) ===
		+
		+	Returns a string of the difference between the two specified times.
		+
		+	=== HoursBetween( dDate1, cTime1, dDate2, cTime2, lWeekEnds ) ===
		+
		+	Returns the number of hours between the specified dates and times.
		+
		+	=== MakeDate( nYear , nMonth , nDay ) ===
		+
		+	Returns a date based on the passed integers.
		+
		+	=== MakeTime( nHours , nMinutes , nSeconds ) ===
		+
		+	Returns a time string based on the passed values.
		+
		+	=== MinutesBetween( dDate1, cTime1, dDate2, cTime2, lWeekEnds ) ===
		+
		+	Returns the minutes between the specified dates and times.
		+
		+	=== Num2CDOW( nDay ) ===
		+
		+	Returns a string of the specified day number.
		+
		+	=== Num2CMonth( nMonth ) ===
		+
		+	Returns a string of the specified month number.

	== Academic Session Functions ==		== Academic Session Functions ==

← Older revision		Revision as of 03:06, 8 June 2011
Line 155:		Line 155:
	<code>Upper(master.surname) = "SMITH"</code> Selects all SMITHs regardless of case.		<code>Upper(master.surname) = "SMITH"</code> Selects all SMITHs regardless of case.

		+	=== AddressBlk( cName, cAddress1, cAddress2, cCity, cState, cZip ) ===
		+
		+	Returns a string of a formatted address block.
		+
		+	=== Asc( cCharacter ) ===
		+
		+	Returns the integer ASCII value for the character.
		+
		+	=== AtNoCase( cSearchFor, cSearchIn ) ===
		+
		+	Returns the integer position of the character in the string regardless of case.
		+
		+	=== AtLineNum( cSearchFor, cSearchIn ) ===
		+
		+	Returns the integer line position of the character in the multiline string.
		+
		+	=== AtLineNoCase( cSearchFor, cSearchIn ) ===
		+
		+	Returns the integer line position of the character in the multiline string regardless of case.
		+
		+	=== Chr( nNumber ) ===
		+
		+	Returns the character corresponding to the ASCII value specified.
		+
		+	=== Descend( cString ) ===
		+
		+	Returns a descending order key string for the passed string.
		+
		+	=== HardCR( cString ) ===
		+
		+	Replaces soft returns with hard returns in the passed string.
		+
		+	=== IsAlpha( cString ) ===
		+
		+	Returns true if the string begins with an alphabetic character.
		+
		+	=== IsDigit( cString ) ===
		+
		+	Returns true if the string starts with a digit.
		+
		+	=== IsLower( cString ) ===
		+
		+	Returns true if the string starts with a lower case character.
		+
		+	=== IsUpper( cString ) ===
		+
		+	Returns true if the string starts with an upper case character.
		+
		+	=== MemoLine( cString , nLineLength , nLineNumber , nTabSize , lWrap ) ===
		+
		+	Returns the specified line from the passed memo.
		+
		+	=== MemoTran( cString , cHardCR , cSoftCR ) ===
		+
		+	Returns the memo with hard and soft carriage returns replaced as specified.
		+
		+	=== MLCount( cString , nLineLength , nTabSize , lWrap ) ===
		+
		+	Returns an integer of the number of lines in the passed memo.

	== Date Manipulation Functions ==		== Date Manipulation Functions ==

@@ Line 350: / Line 350: @@
 Convert a numeric value to an integer. Note that this does NOT round, but truncates the number
-<code>Integer( register.advcred) = 12</code> selects students with 12.00 - 12.99 credits of advance credit.
+<code>Integer( register.advcred ) = 12</code> selects students with 12.00 - 12.99 credits of advance credit.
 === ROUND(&nbsp;nValue,&nbsp;nDecimals&nbsp;) ===

@@ Line 346: / Line 346: @@
 <code>
-=== INT(&nbsp;nValue&nbsp;) ===
+=== Integer(&nbsp;nValue&nbsp;) ===
 Convert a numeric value to an integer. Note that this does NOT round, but truncates the number
-<code>int( register.advcred) = 12</code> selects students with 12.00 - 12.99 credits of advance credit.
+<code>Integer( register.advcred) = 12</code> selects students with 12.00 - 12.99 credits of advance credit.
 === ROUND(&nbsp;nValue,&nbsp;nDecimals&nbsp;) ===