Student score query

Downloads7
Subscribe
2
Bookmark
2
This application is not supported by InterSystems Corporation. Please be notified that you use it at your own responsibility.
Details
Releases
Reviews
Issues
Videos
Articles
Reports

What's new in this version

add LICENSE

first

This application is mainly used to modify and query students' subject scores

The insertion method mainly uses SQL statements, and the query method mainly uses global

The specific operations are as follows:

  1. Import 7 CLS files, including school Student ,SCHOOL. Stuscore is an entity class and others are registered classes. SCHOOL. Student is the main table and stores student information. School Score is a sub table, which stores score information

  2. Initialize student information table data. The initial data has been prepared and can be inserted directly.

Execute command: W ##class(school.API).Api("InitSutdentInfo").%ToJSON()

  1. Query students' performance information

Input parameter format: JSON string

Student: student name (not required)

Subject: account name (not required)

w ##Class(SCHOOL.Api).Api("QueryStuSubj", "{""student"":"""",""subject"":""""}").%ToJSON()

  1. Modify students' performance information

Input parameter format: JSON string

Student: student name

Subject: account name (insert if none, update if any)

Score: Score

w ##Class(SCHOOL.Api).Api("UpdateScore", "{""student"":""student6"",""subject"":""art"",""score"":""99""}").%ToJSON()

  1. Query the modified student's score information

Input parameter format: JSON string

Student: student name (not required)

Subject: account name (not required)

w ##Class(SCHOOL.Api).Api("QueryStuSubj", "{""student"":""student6"",""subject"":""art""}").%ToJSON()

  1. Query the information of students exceeding the passing score of a subject and sort them according to the score

Input parameter format: JSON string

Subject: student name (required)

Passscore: pass score

Order: sorting method, 1 asc, - 1 desc

w ##Class(SCHOOL.Api).Api("SortByScore", "{""subject"":""art"",""passScore"":""60"",""order"":""1""}").%ToJSON()

first

Rating
1 (1)
Category
Technology Example
Works with
InterSystems IRIS
Tags
Info
Version
1.0.4
Last updated
2022-04-01
Repository
Open
Documentation
Open
License
Link