PowerSchool Customization

• PS HTML is PowerSchool's special brand of HTML which allows you to add special codes and commands to interact with your server and the data in your PowerSchool database.
• PS HTML elements begin with a tilde character (~) and contain commands enclosed in parenthesis or square brackets.
• Prior to delivering content to a browser, the PowerSchool server replaces PS HTML with the appropriate traditional HTML content.

FRN and RN

• FRNs are used to indicate to PowerSchool the current record which must be accessed from the database.
• FRNs are numeric and always consists of at least four digits.
• The first three digits of an FRN indicate the table number (i.e. 001 for the students table)
• The digits following the table number indicate the unique id (dcid) of a record in a given table.
• ~(frn) is the PS HTML tag used to retrieve or set the current record.
• ~(rn) is the PS HTML tag used to retrieve the current unique id (dcid).
FRNs are often found in HTML links. <a href="/admin/students/generaldemographics.html?frn=001332">Demographics</a> The above link will navigate the user to the demographics page and retrieve data for a student in the database with a dcid of 332.
Once on this page, the use of the ~(frn) tag would result in a return of the value 001332.
The use of the ~(rn) tag would result in a return of the value 332.

GPV - Get Posted/Parameter Value

Wildcards

Insert File

Text Tags

Tlist SQL

• Tlist_sql Tags
• Query
• Row Template

		~[tlist_sql;
			SQL Query goes here;]
			Row Template goes here
		[/tlist_sql]
		

<table class="linkDescList">
	<thead>
		<tr>
			<th>Name</th>
			<th>School Number</th>
			<th>Principal</th>
			<th>Address</th>
		</tr>
	</thead>
	<tbody>
		~[tlist_sql;
			SELECT name, school_number, principal, address
			FROM schools
			ORDER BY sortorder
		;]
			<tr>
				<td>~(name)</td>
				<td>~(school_number)</td>
				<td>~(principal)</td>
				<td>~(address)</td>
			</tr>
		[/tlist_sql]
	</tbody>
</table>

• Develop and test queries in a querying tool such as SQL Developer. Then paste the query into your tlist_sql tags. PowerSchool will not respond with an error message if the query has an error; there simply won't be any data rendered. However, tlist_sql errors will appear in the PowerSchool log (System > System Logs > System Log > View Current System Log File).
• Tlist_sql is not limited to generating table rows. It can also be used to create options for <select> inputs, or any solution that would require repeated code for each result from a query.
• When working with the Students table, you can query the current selection of students by adding the following WHERE clause: WHERE dcid IN (SELECT dcid FROM ~[temp.table.current.selection:students])

Conditional Logic (IF tag)

		~[if{#identifier}.{expression}]
			{true_render}
		[else]
			{false_render}
		[/if]
		

• {#identifier} - Optional. This portion of the tag is used when nesting multiple IF tags. The identifier must be prefixed with a number sign(#).
• {expression} - Required. A comparison expression to test for a true/false result.
• {true_render} - Optional. Rendered by PowerSchool if the if statement expression returns true.
• {false_render} - Optional. Rendered by PowerSchool if the if statement expression returns false.

~[if.~(gpv.gender;onlyalpha)=M]
	Male
[else]
	Female
[/if]

• ~[if.district.office]
• ~[if.is.a.school]
• ~[if.mac]
• ~[if.win]
• ~[if.isstudent]
• ~[if.isguardian]

~[if#distCheck.district.office]
	~[if#winCheck.win]
		District office on Windows
	[else#winCheck]
		District office on Mac
	[/if#winCheck]
[else#distCheck]
	~[if#winCheck2.win]
		~(schoolname) on Windows
	[else#winCheck2]
		~(schoolname) on Mac
	[/if#winCheck2]
[/if#distCheck]