Thai Localization - Power Query DATs
Thai Localization 25.3.0.0 - Power Query DATs
DATAccess Tag | Description | Portal Page | Optional Parameters | Available | Version |
---|---|---|---|---|---|
~(*powerquery;query=com.powerschool.th.dat.studentinfo;fields=stufullname) | This DAT is used to display the student's full name in Thai. |
| N/A | Object Report | 24.7.0 |
~(*powerquery;query=com.powerschool.th.dat.studentinfo;fields=stufullnameenglish) | This DAT is used to display Student’s Full Name in English |
| N/A | Object Report | 24.7.0 |
~(*powerquery;query=com.powerschool.th.dat.studentinfo;fields=mothername) | This DAT is used to show the full name of the student's mother in Thai. |
| N/A | Object Report | 24.7.0 |
~(*powerquery;query=com.powerschool.th.dat.studentinfo;fields=mothernameenglish) | This DAT is used to display the full name of the student's mother in English. |
| N/A | Object Report | 24.7.0 |
~(*powerquery;query=com.powerschool.th.dat.studentinfo;fields=fathername) | This DAT is used to show the full name of the student's father in Thai. |
| N/A | Object Report | 24.7.0 |
~(*powerquery;query=com.powerschool.th.dat.studentinfo;fields=fathernameenglish) | This DAT is used to display the full name of the student's father in English. |
| N/A | Object Report | 24.7.0 |
~(*powerquery;query=com.powerschool.th.dat.studentinfo;fields=madderine1) | This DAT is used to display the student's mailing address line 1 (house number, village/building, Moo). |
| N/A | Object Report | 24.7.0 |
~(*powerquery;query=com.powerschool.th.dat.studentinfo;fields=madderine2) | This DAT is used to display the student's mailing address, including Address Line 2 Alleyway, Soi, Road). |
| N/A | Object Report | 24.7.0 |
~(*powerquery;query=com.powerschool.th.dat.studentinfo;fields=madderine3) | This DAT is used to display the student's mailing address, including Line 3 (province, district, sub-district, zip code). |
|
To obtain the translation text for the specified fields, eg;arg.locale=th. |
| Object Report |
~(*powerquery;query=com.powerschool.th.dat.studentinfo;fields=addressline1) | This DAT is used to display Student Home Address Line1(House no, Village/Building, Moo) |
| N/A | Object Report | 24.7.0 |
~(*powerquery;query=com.powerschool.th.dat.studentinfo;fields=addressline2) | This DAT is used to display the student's home address line 2 (alleyway, soi, road). |
| N/A | Object Report | 24.7.0 |
~(*powerquery;query=com.powerschool.th.dat.studentinfo;fields=addressline3) | This DAT is used to display the student's home address Line 3 (Province, District, Sub-District, Zip). |
|
To obtain the translation text for the specified fields, eg;arg.locale=th. | Object Report | 24.7.0 |
~(*powerquery;query=com.powerschool.th.dat.studentinfo;fields=homeunit) | This DAT is used to display the student's home house number. |
|
| Object Report | 24.7.0 |
~(*powerquery;query=com.powerschool.th.dat.studentinfo;fields=homecustomstring1) | This DAT is used to display the student's home village or building. |
|
| Object Report | 24.7.0 |
~(*powerquery;query=com.powerschool.th.dat.studentinfo;fields=homecustomstring2) | This DAT is used to display Student’s Home Moo |
|
| Object Report | 24.7.0 |
~(*powerquery;query=com.powerschool.th.dat.studentinfo;fields=homestreet) | This DAT is used to display Student’s Home street |
|
| Object Report | 24.7.0 |
~(*powerquery;query=com.powerschool.th.dat.studentinfo;fields=homelinetwo) | This DAT is used to display the student's home road |
|
| Object Report | 24.7.0 |
~(*powerquery;query=com.powerschool.th.dat.studentinfo;fields=homeline3) | This DAT is used to display the student's home alleyway. |
|
| Object Report | 24.7.0 |
~(*powerquery;query=com.powerschool.th.dat.studentinfo;fields=homeaddress) | This DAT is used to display the student's full home address. |
|
| Object Report | 24.7.0 |
~(*powerquery;query=com.powerschool.th.dat.studentinfo;fields=hprov) | This DAT is used to display the student's home province. |
|
To obtain the translation text for the specified fields, eg;arg.locale=th. | Object Report | 24.7.0 |
~(*powerquery;query=com.powerschool.th.dat.studentinfo;fields=hdist) | This DAT is used to display the student's home district. |
|
To obtain the translation text for the specified fields, eg;arg.locale=th. | Object Report | 24.7.0 |
~(*powerquery;query=com.powerschool.th.dat.studentinfo;fields=hsubdist) | This DAT is used to display the student's home sub-district. |
|
To obtain the translation text for the specified fields, eg;arg.locale=th. | Object Report | 24.7.0 |
~(*powerquery;query=com.powerschool.th.dat.studentinfo;fields=hzip) | This DAT is used to display the student's home zip. |
|
To obtain the translation text for the specified fields, eg;arg.locale=th. | Object Report | 24.7.0 |
~(*powerquery;query=com.powerschool.th.dat.studentinfo;fields=mailunit) | This DAT is used to display the student's mailing house number |
| N/A | Object Report | 24.7.0 |
~(*powerquery;query=com.powerschool.th.dat.studentinfo;fields=mailcustomstring1) | This DAT is used to display the student's mailing village/building. |
| N/A | Object Report | 24.7.0 |
~(*powerquery;query=com.powerschool.th.dat.studentinfo;fields=mailcustomstring2) | This DAT is used to display the student's mailing moo |
| N/A | Object Report | 24.7.0 |
~(*powerquery;query=com.powerschool.th.dat.studentinfo;fields=mailstreet) | This DAT is used to display the student's mailing street. |
| N/A | Object Report | 24.7.0 |
~(*powerquery;query=com.powerschool.th.dat.studentinfo;fields=maillinetwo) | This DAT is used to display the student's mailing road. |
| N/A | Object Report | 24.7.0 |
~(*powerquery;query=com.powerschool.th.dat.studentinfo;fields=mailline3) | This DAT is used to display the student's mailing alleyway. |
| N/A | Object Report | 24.7.0 |
~(*powerquery;query=com.powerschool.th.dat.studentinfo;fields=mailaddress) | This DAT is used to display the student's full mailing address |
| N/A | Object Report | 24.7.0 |
~(*powerquery;query=com.powerschool.th.dat.studentinfo;fields=mprov) | This DAT is used to display the student's mailing province. |
|
To obtain the translation text for the specified fields, eg;arg.locale=th. | Object Report | 24.7.0 |
~(*powerquery;query=com.powerschool.th.dat.studentinfo;fields=mdist) | This DAT is used to display the student's mailing district. |
|
To obtain the translation text for the specified fields, eg;arg.locale=th. | Object Report | 24.7.0 |
~(*powerquery;query=com.powerschool.th.dat.studentinfo;fields=msubdist) | This DAT is used to display the student's mailing sub-district |
|
To obtain the translation text for the specified fields, eg;arg.locale=th. | Object Report | 24.7.0 |
~(*powerquery;query=com.powerschool.th.dat.studentinfo;fields=mzip) | This DAT is used to display the student's mailing ZIP code. |
|
To obtain the translation text for the specified fields, eg;arg.locale=th. | Object Report | 24.7.0 |
~(*powerquery;query=com.powerschool.th.dat.emergency;arg.rowno=1;fields=contactname) | This DAT is used to display the student's emergency contact name. |
| Here, "rowno" defines the priority of the contact. For example, if rowno=2, retrieve the details of the second emergency contact. | Object Report | 24.7.0 |
~(*powerquery;query=com.powerschool.th.dat.emergency;arg.rowno=1;fields=contactnameenglish) | This DAT is used to display the emergency contact's English name for the student. |
| Here, "rowno" defines the priority of the contact. For example, if rowno=2, retrieve the details of the second emergency contact. | Object Report | 24.7.0 |
~(*powerquery;query=com.powerschool.th.dat.emergency;arg.rowno=1;fields=contactrelationshipdesc) | This DAT is used to display the student's emergency contact relationship. |
| Here, "rowno" defines the priority of the contact. For example, if rowno=2, retrieve the details of the second emergency contact. | Object Report | 24.7.0 |
~(*powerquery;query=com.powerschool.th.dat.emergency;arg.rowno=1;fields=phonenumber) | This DAT is used to display the student's emergency phone number |
| Here, "rowno" defines the priority of the contact. For example, if rowno=2, retrieve the details of the second emergency contact. | Object Report | 24.7.0 |
~(*powerquery;query=com.powerschool.th.dat.emergency;arg.rowno=1;fields=phonetype) | This DAT is used to display the type of phone number for the student's emergency contact. |
| Here, "rowno" defines the priority of the contact. For example, if rowno=2, retrieve the details of the second emergency contact. | Object Report | 24.7.0 |
~(*powerquery;query=com.powerschool.th.admin.dat.schoolinfo;fields=school_provience) | This DAT is used to display the school province. |
|
To obtain the translation text for the specified fields, eg;arg.locale=th. | Object Report | 24.7.0 |
~(*powerquery;query=com.powerschool.th.admin.dat.schoolinfo;fields=school_district) | This DAT is used to display the school district. |
|
To obtain the translation text for the specified fields, eg;arg.locale=th. | Object Report | 24.7.0 |
~(*powerquery;query=com.powerschool.th.admin.dat.schoolinfo;fields=school_subdistrict) | This DAT is used to display the school sub-district |
|
To obtain the translation text for the specified fields, eg;arg.locale=th. | Object Report | 24.7.0 |
~(*powerquery;query=com.powerschool.th.admin.dat.schoolinfo;fields=school_zip) | This DAT is used to display the school ZIP code. |
|
To obtain the translation text for the specified fields, eg;arg.locale=th. | Object Report | 24.7.0 |
~(*powerquery;query=com.powerschool.th.dat.studentinfo;fields=grade) | This DAT is used to display the student's current Grade level in alternate language |
|
To obtain the translation text for the specified fields, eg;arg.locale=th. | Object Report | 24.10.0 |
~(*powerquery;query=com.powerschool.th.dat.emergency;fields=altcontactrelationshipdesc) | This DAT is used to display the student's emergency contact relationship. |
|
Here, "rowno" defines the priority of the contact. For example, if rowno=2, retrieve the details of the second emergency contact.
To obtain the translation text for the specified fields, eg;arg.locale=th | Object Report | 24.10.0 |
~(*powerquery;query=com.powerschool.th.dat.studentinfo;fields=formatted_nationalid) | This DAT is used to present the student's national ID in the Thai format, which is "X XXXX XXXXX XX X". |
| N/A | object Report | 25.3.0 |
~(*powerquery;query=com.powerschool.th.dat.studentinfo;fields=thaiPrefix) | This DAT is used to display the student's prefix in Thai. |
| N/A | object Report | 25.3.0 |
~(*powerquery;query=com.powerschool.th.dat.studentinfo;fields=englishPrefix) | This DAT is used to display the student's prefix in English. |
| N/A | object Report | 25.3.0 |
~(*powerquery;query=com.powerschool.th.dat.studentinfo;fields=altfirstname) | This DAT is used to display the student's first name in English. |
| N/A | object Report | 25.3.0 |
~(*powerquery;query=com.powerschool.th.dat.studentinfo;fields=altmiddlename) | This DAT is used to display the student's middle name in English. |
| N/A | object Report | 25.3.0 |
~(*powerquery;query=com.powerschool.th.dat.studentinfo;fields=altlastname) | This DAT is used to display the student's last name in English. |
| N/A | object Report | 25.3.0 |
~(*powerquery;query=com.powerschool.th.dat.studentinfo;fields=firstname) | This DAT is used to display the student's first name in Thai. |
| N/A | object Report | 25.3.0 |
~(*powerquery;query=com.powerschool.th.dat.studentinfo;fields=middlename) | This DAT is used to display the student's middle name in Thai. |
| N/A | object Report | 25.3.0 |
~(*powerquery;query=com.powerschool.th.dat.studentinfo;fields=lastname) | This DAT is used to display the student's last name in Thai. |
| N/A | object Report | 25.3.0 |
~(*powerquery;query=com.powerschool.th.dat.studentinfo;fields=studentnumber) | This DAT is used to display the student’s number. |
| N/A | object Report | 25.3.0 |
~(*powerquery;query=com.powerschool.th.report.dat.totalcredithours;fields=course_name,credit_hours,weighted_credit); Example: A DAT with full arguments for reference ~(*powerquery;query=com.powerschool.th.report.dat.totalcredithours;fields=course_name,credit_hours,weighted_credit;arg.storecode=Y1;arg.credittypelist=basic;arg.mingradelevel=10;arg.maxgradelevel=12) Note: Only include the fields that you want to print on the report. | This DAT is used to present the average weighted and credit hours for the course based on the given grade levels, using the arguments storecode, credittypelist, mingradelevel, and maxgradelevel. to retrieve the following fields:
|
|
| Object Report | 25.3.0 |
~(*powerquery;query=com.powerschool.th.report.dat.totalcreditweightedavg;fields=sum_credit_hours,avg_weighted_credit;) Example: A DAT with full arguments for reference ~(*powerquery;query=com.powerschool.th.report.dat.totalcreditweightedavg;fields=sum_credit_hours,avg_weighted_credit;arg.storecode=Y1;arg.mingradelevel=7;arg.maxgradelevel=9;arg.credittypelist=basic;) NOTE: Only include the fields that you want to print on the report. | This DAT is used to present the average weighted and total credit hours for the course, retrieved from the DAT, using the arguments storecode, credittypelist, mingradelevel, and maxgradelevel. This retrieves the following fields:
|
|
| Object Report | 25.3.0 |
~(*powerquery;query=com.powerschool.th.report.dat.overallgradegroupbygradelevel;fields=result) Example: A DAT with full arguments for reference ~(*powerquery;query=com.powerschool.th.report.dat.overallgradegroupbygradelevel;arg.storecode=Y1;arg.gradelevel=6;arg.credittype=lda;arg.excludedcreditlist=d;fields=result) Note: The above DAT return grade based on the gradescale alienged to the credit type if he is fail then DAT will return F or else it give the Grade only By using the decode in report user can display respective text against the grade Example: ~(decode;~(*powerquery;query=com.powerschool.th.report.dat.overallgradegroupbygradelevel;fields=result;arg.storecode=Y1;arg.credittype=elec;arg.gradelevel=9);F;ล้มเหลว | This DAT is used to determine the grade achieved for a specific credit type of course at the single grade level, using the arguments
|
|
| Object Report | 25.3.0 |
~(*powerquery;query=com.powerschool.th.report.dat.overallgradegroupbymultiplegradelevels;fields=result) Example: A DAT with full arguments for reference ~(*powerquery;query=com.powerschool.th.report.dat.overallgradegroupbymultiplegradelevels;fields=result;arg.storecode=Y1;arg.mingradelevel=7;arg.credittype=elec;arg.maxgradelevel=9) Note: The above DAT return grade based on the gradescale alienged to the credit type if he is fail then DAT will return F or else it give the Grade only By using the decode in report user can display respective text against the grade Example:~(decode;~(*powerquery;query=com.powerschool.th.report.dat.overallgradegroupbymultiplegradelevels;fields=result;arg.storecode=Y1;arg.mingradelevel=7;arg.credittype=elec;arg.maxgradelevel=9);F;ล้มเหลว | This DAT is used to determine the grade achieved for a specific credit type of course at the given grade level, using the arguments
|
|
| Object Report | 25.3.0 |
^(*powerquery;query=com.powerschool.th.report.dat.credithrsbygradelevel;fields=enrolledcredits,passedcredits,passedhours,enrolledhours) Example: A DAT with full arguments for reference ^(*powerquery;query=com.powerschool.th.report.dat.credithrsbygradelevel;fields=enrolledcredits;arg.storecode=Y1;arg.gradelevel=7;arg.credittypelist=basic) Note: Only include the fields you want to print on the report. This DAT will provide information for a single grade level. | This DAT is used to display the credit hours and credits based on the provided arguments: storecode, gradelevel, credittypelist, and coursenumberlist. The retrieved fields are:
|
|
| Object Report | 25.3.0 |
^(*powerquery;query=com.powerschool.th.report.dat.credithrsbymultiplegradelevels;fields=enrolledcredits,passedcredits,passedhours,enrolledhours) Example: A DAT with full arguments for reference ^(*powerquery;query=com.powerschool.th.report.dat.credithrsbymultiplegradelevels;fields=enrolledcredits;arg.storecode=Y1;arg.mingradelevel=7; arg.maxgradelevel=9; arg.credittypelist=basic) Note: Only include the fields you want to print on the report. This DAT will provide information of an average based-on minimum and maximum grade level. | This DAT is used to display the credit hours and credits based on the provided arguments: storecode, mingradelevel, maxgradelevel, credittypelist, and coursenumberlist. The retrieved fields are:
|
|
| Object Report | 25.3.0 |
~(*powerquery;query=com.powerschool.th.report.dat.test.validate;arg.testname=O-NET;arg.gradelevel=9;fields=result); Note: The above DAT will provide a "Y" or "N" to determine whether a student has appeared for the test. If you want to perform any manipulation based on this result, use the decode function as shown in the example. Example:~(decode;~(*powerquery;query=com.powerschool.th.report.dat.test.validate;arg.testname=O-NET;arg.gradelevel=9;fields=result);Y;O-NET ชั้นประถมศึกษาปีที่ 6 | This DAT is used to determine whether the student has appeared for any of the subjects in the test specified in the testname argument, retrieving the following field: Result: This field indicates whether the student has appeared for any of the Subjects for the specified test in the argument. It provides a "Y" (appeared for at least one of the subject listed under the testname in the argument) or an "N" (did not appear for any of the subject listed under the testname in the argument). |
|
Note: These arguments help in determining whether students in the specified grade level have appeared for the specified test. | Object Report | 25.3.0 |
~(*powerquery;query=com.powerschool.th.report.dat.testscore.validate;arg.testname=O-NET;arg.subjectname=MATH;arg.gradelevel=9;fields=result); Note: The above DAT will provide a "Y" or "N" to determine whether a student has appeared for the test for a specific subject. If you want to perform any manipulation based on this result, use the decode function as shown in the example. Example:~(decode;~(*powerquery;query=com.powerschool.th.report.dat.testscore.validate;arg.testname=O-NET;arg.subjectname=MATH;arg.gradelevel=9; fields=result);Y;O-NET ชั้นประถมศึกษาปีที่ 6 | This DAT is used to determine whether the student has appeared for the specific subjects in the test specified by the testname and subjectname arguments, retrieving the following field:
|
|
Note: These arguments help in determining whether students in the specified grade level have appeared for the specified test. | Object Report | 25.3.0 |
~(*powerquery;query=com.powerschool.th.report.dat.testscore;arg.testname=O-NET;arg.subjectname=THAI;arg.gradelevel=6;fields=testname,subjectname,percentscore,numscore,alphascore;) Note: Only include the fields you want to print on the report. | This DAT is used to determine the score for a test for the specified subject, test name and gradelevel in argument and retrieving the following fields:
|
|
| Object Report | 25.3.0 |
~(*powerquery;query=com.powerschool.th.report.dat.gpax;fields=gradeweight,testweight,result;) Example: A DAT with full arguments for reference ~(*powerquery;query=com.powerschool.th.report.dat.gpax;arg.storecode=Y1;arg.mingradelevel=7;arg.credittypelist=basic;arg.maxgradelevel=9;arg.testcolumn=numscore;arg.testweight=30;arg.gradeweight=70;arg.testname=O-NET;fields=gradeweight,testweight,result;) Note: Only include the fields you want to print on the report. | This DAT is used to display the GPAX calculation by passing the required arguments: testname, credittypelist, mingradelevel, maxgradelevel, testweight, and gradeweight. This will retrieve the following fields:
|
|
| Object Report | 25.3.0 |
~(*powerquery;query=com.powerschool.th.report.dat.formerschooldetails;fields=schoolname;arg.storecode=Y1) | This DAT is used to display former school name of the student. |
| arg.storecode: Required argument indicating the store code.
| Object Report | 25.3.0 |
~(*powerquery;query=com.powerschool.th.report.dat.formerschooldetails;fields=altschoolname;arg.storecode=Y1) | This DAT is used to display former alternate school name of the student. |
| arg.storecode: Required argument indicating the store code.
| Object Report | 25.3.0 |
~(*powerquery;query=com.powerschool.th.report.dat.formerschooldetails;fields=gradelevel;arg.storecode=Y1) | This DAT is used to display former school grade level of the student. |
| arg.storecode: Required argument indicating the store code.
| Object Report | 25.3.0 |
~(*powerquery;query=com.powerschool.th.report.dat.formerschooldetails;fields=schoolprovince;arg.storecode=Y1) | This DAT is used to display former school province of the student. |
| arg.storecode: Required argument indicating the store code.
| Object Report | 25.3.0 |
~(*powerquery;query=com.powerschool.th.report.dat.formerschooldetails;fields=earnedcrhrs;arg.storecode=Y1) | This DAT is used to display earned credit hours in the former school of the student. |
| arg.storecode: Required argument indicating the store code.
| Object Report | 25.3.0 |
~(*powerquery;query=com.powerschool.th.report.dat.formerschooldetails;fields=credits;arg.storecode=Y1) | This DAT is used to display credits in the former school of the student. |
| arg.storecode: Required argument indicating the store code.
| Object Report | 25.3.0 |
~(*powerquery;query=com.powerschool.th.report.dat.graduationdetails;arg.gradelevel=9;fields=transcriptnumber) | This DAT is used to display the transcript number of the student against the grade level given in the argument. |
|
| Object Report | 25.3.0 |
~(*powerquery;query=com.powerschool.th.report.dat.graduationdetails;arg.gradelevel=9;fields=runningnumber) | This DAT is used to display running number of the student against grade level given in the argument. |
|
| Object Report | 25.3.0 |
~(*powerquery;query=com.powerschool.th.report.dat.graduationdetails;arg.gradelevel=9;fields=graduationnumber) | This DAT is used to display graduation number of the student against grade level given in the argument. |
|
| Object Report | 25.3.0 |
~(*powerquery;query=com.powerschool.th.report.dat.graduationdetails;arg.gradelevel=9;fields=graduationdate) | This DAT is used to display graduation date of the student against grade level given in the argument. |
|
| Object Report | 25.3.0 |
~(*powerquery;query=com.powerschool.th.report.dat.graduationdetails;arg.gradelevel=9;arg.dateformat=DD-MM-YY;fields=transcriptnumber,runningnumber,graduationdate,gradelevel) | This DAT is used to display transcript number, running number, graduation number, graduation date, grade of the student against grade level given in the argument. |
|
| Object Report | 25.3.0 |
~(*powerquery;query=com.powerschool.th.report.dat.reenrollmentdetails;arg.gradelevel=9;arg.dateformat=DD-MM-YYYY;fields=exitdate) | This DAT is used to display exit date of the student against grade level given in the argument. |
|
| Object Report | 25.3.0 |
~(*powerquery;query=com.powerschool.th.report.dat.reenrollmentdetails;arg.gradelevel=9;fields=exitreason) | This DAT is used to display exit reason of the student against grade level given in the argument. |
|
| Object Report | 25.3.0 |
~(*powerquery;query=com.powerschool.th.report.dat.reenrollmentdetails;arg.gradelevel=9;fields=exitcode) | This DAT is used to display exit code of the student against grade level given in the argument. |
|
| Object Report | 25.3.0 |
~(*powerquery;query=com.powerschool.th.report.dat.reenrollmentdetails;arg.gradelevel=9;fields=exitcode,exitreason,exitdate,gradlevel) | This DAT is used to display exit code, exit reason, exit date and gradelevel of the student against grade level given in the argument. |
|
| Object Report | 25.3.0 |
~(*powerquery;query=com.powerschool.th.report.dat.thaidateformat;fields=thaidate;arg.gregoriandate=^(DOB;dateformat=DD/MM/YYYY)) Note: This DAT Gregorian date is input argument it must be DD-MM-YYYY format | This DAT is used to display the date after the formatted Gregorian date in the argument to Thai date format. Example: arg.gegoriandate:10-01-2001 output (Thai date):10 มกราคม 2257 | N/A |
| Object Report | 25.3.0 |
~(*powerquery;query=com.powerschool.th.report.dat.thaidateformat;fields=thaiday;arg.gregoriandate=^(DOB;dateformat=DD/MM/YYYY)) Note:
^(decode;^(DOB;dateformat=DD/MM/YYYY);00/00/0000; ;~(*powerquery;query=com.powerschool.th.report.dat.thaidateformat;fields=thaidate;arg.gregoriandate=^(DOB;dateformat=DD/MM/YYYY))) | This DAT is used to display day in the date after the formatted Gregorian date in the argument. Example: arg.gegoriandate:10-01-2001 output(Thaiday):10 | N/A |
| Object Report | 25.3.0 |
~(*powerquery;query=com.powerschool.th.report.dat.thaidateformat;fields=thaimonth;arg.gregoriandate=^(DOB;dateformat=DD/MM/YYYY)) Note: 1.For this DAT Gregorian date is input argument it must be DD-MM-YYYY format
^(decode;^(DOB;dateformat=DD/MM/YYYY);00/00/0000; ;~(*powerquery;query=com.powerschool.th.report.dat.thaidateformat;fields=thaidate;arg.gregoriandate=^(DOB;dateformat=DD/MM/YYYY))) | This DAT is used to display month in the date after the formatted Gregorian date in the argument to Thai date format. Example: arg.gegoriandate: 10-01-2001 output(thaimonth): มกราคม | N/A |
| Object Report | 25.3.0 |
~(*powerquery;query=com.powerschool.th.report.dat.thaidateformat;fields=thaiyear;arg.gregoriandate=^(DOB;dateformat=DD/MM/YYYY)) Note: 1.For this DAT Gregorian date is input argument it must be DD-MM-YYYY format
^(decode;^(DOB;dateformat=DD/MM/YYYY);00/00/0000; ;~(*powerquery;query=com.powerschool.th.report.dat.thaidateformat;fields=thaidate;arg.gregoriandate=^(DOB;dateformat=DD/MM/YYYY))) | This DAT is used to display year in the date after the formatted Gregorian date in the argument to Thai date format. Example: arg.gegoriandate:10-01-2001 output(Thaiyear):: 2257 | N/A |
| Object Report | 25.3.0 |
~(*powerquery;query=com.powerschool.th.report.dat.thainumbers;fields=thai_number;arg.engnumber=123) | This DAT is used to provide numerics into Thai numerics by passing math numerical as argument. Example: arg.engnumber=123 output(thai_number)=๑๒๓ arg.engnumber=abcd123 output(thai_number)=abcd๑๒๓ | N/A |
| Object Report | 25.3.0 |
~(*powerquery;query=com.powerschool.th.report.dat.pref;arg.preffield=districtname;fields=value) | This DAT is used to display the district name of the school. |
|
| Object Report | 25.3.0 |
~(*compliance;dat.name=DAT_localization_currentselectionids) | This DAT is used to get the ID’s of the selected students in the search. |
| 25.3.0 | ||
~(*powerquery;query=com.powerschool.th.report.dat.studentcountongender;fields=totalcount;arg.studentids=~(*compliance;dat.name=DAT_localization_currentselectionids)) | This DAT is used to display the total count of student selected to generate report. |
| Object Report | 25.3.0 | |
~(*powerquery;query=com.powerschool.th.report.dat.studentcountongender;fields=malecount;arg.studentids=~(*compliance;dat.name=DAT_localization_currentselectionids)) | This DAT is used to display the male count of student selected to generate report. |
| Object Report | 25.3.0 | |
~(*powerquery;query=com.powerschool.th.report.dat.studentcountongender;fields=femalecount;arg.studentids=~(*compliance;dat.name=DAT_localization_currentselectionids)) | This DAT is used to display the female count of student selected to generate report. |
| Object Report | 25.3.0 | |
~(*compliance;dat.name=DAT_localization_seqno;evenmax=14;oddmax=10;seqno=1) | This DAT is used to display Sequence number in object report. | N/A | evenmax: Need to give the total no of students/max sequence print on even pages. oddmax: Need to give the total no of students/sequence print on odd pages. seqno: Need to give the sequence no/position of student in a given page. Note: The | Object Report | 25.3.0 |
~(*powerquery;query=com.powerschool.th.report.dat.parentnamevalidation;fields=remark) | This DAT is used to display remark in report Graduation Report in Thai language as per smart requirement: Case 1: If father or mother has value that is “-“, Report display: “ไม่มีหลักฐานตามกฎหมายว่าด้วยการทะเบียนราษฎร”
Case 2: Could you match the student’s last name with the parent’s last name? If diff., Report display: “ไม่มีหลักฐานตามกฎหมายว่าด้วยการทะเบียนราษฎร | N/A | N/A | Object Report | 25.3.0 |