Custom Page to Query GPA

Submitted by rmartin on Mon, 07/09/2012 - 1:54pm

Forums:

Hi all,

I've been hitting my head against this one for a little while, I'm creating a custom page that pulls an SQL query, but I also want to include the GPA in the list. Since that value appears to be calculated live, it looks like I need to call the ~(*GPA Method) into a cell. I attempted to put the method call into a table cell, but it's not populating, and I either get an error, or nothing returns at all.

Anyone know how I should put that in there?

Thanks a ton,

Rob

brian_andle

Mon, 07/09/2012 - 3:58pm

You can't use that DAT in a tlist_sql. You would need to replicate your GPA using just sql. Depending on your setup this could be time consuming.

rmartin

Tue, 07/10/2012 - 6:19am

THANKS! Knowing that will change my direction on the project. Out of curiosity, are there some DAT's that can be used in tlist_sql?

brian_andle

Tue, 07/10/2012 - 10:33am

curstudid, curtermid, curschoolid and dats like ~([01]id) (all student dats) work if it's student specific. Really you can't use calculated dats that start with ~(*

aspiegel

Mon, 10/21/2013 - 8:17pm

I would like to add a cumulative GPA to the grade history page in addition to the quick lookup page in the EPP. Can anyone assist?

Thanks.

Bergen Catholic High School

Subscribe to Comments for "Custom Page to Query GPA"