customSelectExpression and velocity variables: possible?

[Sytematic]

Hello,

Using Power nightly of 06-30-2011.


I have a field like this:

    <field name="attendancePercentage" type="float" customSelectExpression="(SELECT COUNT( * )
FROM Lecture_presence_student AS lps
INNER JOIN Lecture AS l ON l.Lecture_id = lps.Lecture_id
WHERE l.CourseEdition_id = '$criteria.CourseEdition_id' AND lps.status='aanwezig' )
/
(SELECT COUNT( * )
FROM Lecture_presence_student AS lps
INNER JOIN Lecture AS l ON l.Lecture_id = lps.Lecture_id
WHERE l.CourseEdition_id = '$criteria.CourseEdition_id' AND lps.status != 'onverwerkt')*100" />

It calculates the number of lectures a student attended, as a percentage.

This query runs, but the $criteria.CourseEdition_id is not resolved, see the logs:

=== 2011-07-11 13:04:41,178 [l0-3] DEBUG SQLDataSource - [builtinApplication.fetchSubscriptionDetail] Using SQL Limit query
=== 2011-07-11 13:04:41,178 [l0-3] DEBUG SQLDataSource - [builtinApplication.fetchSubscriptionDetail] SQL windowed select rows 0->75, result size 75. Query: 
SELECT CourseEdition_students_Student.cb2_thesis_title, CourseEdition_students_Student.cb4_status_practical, Student.phone, 

(SELECT COUNT( * ) FROM Lecture_presence_student AS lps INNER JOIN Lecture AS l ON l.Lecture_id = lps.Lecture_id WHERE l.CourseEdition_id = '$criteria.CourseEdition_id' AND lps.status='aanwezig' ) / (SELECT COUNT( * ) FROM Lecture_presence_student AS lps INNER JOIN Lecture AS l ON l.Lecture_id = lps.Lecture_id WHERE l.CourseEdition_id = '$criteria.CourseEdition_id' AND lps.status != 'onverwerkt')*100 AS attendancePercentage, 

CourseEdition_students_Student.cb1_POK_graduationdate, Student.sofinummer,
 Student.street, Student.surname, CourseEdition.endDate, Student.city,
 CourseEdition_students_Student.Student_id, Student.voorletter, CourseEdition_students_Student.cb2_remarks, 
Student.cellphone, Student.gender, Student.number_addition, CourseEdition_students_Student.cb3_regular_extraneus,
 CourseEdition.editionName, CourseEdition_students_Student.students_id, 
Student.tussenvoegsel, CourseEdition_students_Student.cancelled, 
CourseEdition_students_Student.studentMarkOff, Student.number, Student.postcode, 
Student.country, CourseEdition_students_Student.cb1_POK_postponed, CourseEdition.MoodleCourse_id, 
Student.birthplace, Student.email, Student.Moodle_id, CourseEdition.Course_id, Student.active, 
CourseEdition_students_Student.cb2_defense_date, Student.userAccount, CourseEdition_students_Student.CourseEdition_id, CourseEdition_students_Student.cb2_thesis_accepted, CourseEdition.startDate, CourseEdition_students_Student.cb4_status_theory, CourseEdition_students_Student.cb1_OO_checkbox, CourseEdition_students_Student.cb1_OO_date, 
CourseEdition_students_Student.cb3_teaching_plan, CourseEdition_students_Student.cb1_POK_date, 
Student.archived, Student.birthdate, CourseEdition_students_Student.cb2_graduated_cancelled, CourseEdition.published, CourseEdition_students_Student.waitinglist, CourseEdition_students_Student.cb3_exam_regulations, 
CourseEdition_students_Student.cb2_planned_thesis_date, CourseEdition.percentageOfSubscriptions, 
CourseEdition_students_Student.cb1_POK_checkbox, Student.firstname, CourseEdition_students_Student.cb3_cohort, 
CourseEdition.lmsAccess, CourseEdition.Status, CourseEdition_students_Student.checkbox, (users.username IS NOT NULL) as userAccount 
FROM CourseEdition_students_Student INNER JOIN Student ON CourseEdition_students_Student.Student_id = Student.Student_id 
      INNER JOIN CourseEdition ON CourseEdition_students_Student.CourseEdition_id = CourseEdition.CourseEdition_id 
      LEFT OUTER JOIN users ON Student.Student_id = users.Student_id WHERE (CourseEdition_students_Student.CourseEdition_id='1') LIMIT 0, 75

Here is the operationbinding that is being called for this particular fetch:

<operationBinding requiresRole="ROLE_USER" requiresAuthentication="true" operationType="fetch"  operationId="fetchSubscriptionDetail" customValueFields="students_id,editionName, attendancePercentage,startDate,published,Status,percentageOfSubscriptions,lmsAccess,firstname,     tussenvoegsel,surname,voorletter,birthdate,birthplace,gender,sofinummer,street,number,number_addition,postcode,city,country,phone,cellphone,email,active,archived,Moodle_id,waitinglist,cancelled" customCriteriaFields="students_id, editionName,startDate,published,Status,percentageOfSubscriptions,lmsAccess,firstname,tussenvoegsel,surname,voorletter,birthdate,birthplace,gender,     sofinummer,street,number,number_addition,postcode,city,country,phone,cellphone,email,active,archived,Moodle_id,waitinglist,cancelled, attendancePercentage" > 
   <selectClause>$defaultSelectClause, (users.username IS NOT NULL) as userAccount</selectClause>  
   <tableClause>
      CourseEdition_students_Student INNER JOIN Student ON CourseEdition_students_Student.Student_id = Student.Student_id 
      INNER JOIN CourseEdition ON CourseEdition_students_Student.CourseEdition_id = CourseEdition.CourseEdition_id 
      LEFT OUTER JOIN users ON Student.Student_id = users.Student_id</tableClause> 
</operationBinding>

Is this because it is not possible? Do I have to put the subquery in the <selectClause> instead?

[Isomorphic]

Without knowing what was in the request, we have no idea. Another reason to always post the complete server log for the request.

[Sytematic]

Sorry, again:

=== 2011-07-11 15:05:33,357 [0-12] DEBUG RPCManager - Request #1 (DSRequest) payload: {
    criteria:{
        CourseEdition_id:1
    },
    operationConfig:{
        dataSource:"CourseEdition_students_Student",
        operationType:"fetch",
        textMatchStyle:"exact"
    },
    startRow:0,
    endRow:75,
    componentId:"isc_ListGrid_10",
    appID:"builtinApplication",
    operation:"fetchSubscriptionDetail",
    oldValues:{
        CourseEdition_id:1
    }
}
=== 2011-07-11 15:05:33,357 [0-12] DEBUG AppBase - [builtinApplication.fetchSubscriptionDetail] No userTypes defined, allowing anyone access to all operations for this application
=== 2011-07-11 15:05:33,357 [0-12] DEBUG AppBase - [builtinApplication.fetchSubscriptionDetail] No public zero-argument method named '_fetchSubscriptionDetail' found, performing generic datasource operation
=== 2011-07-11 15:05:33,358 [0-12] INFO  SQLDataSource - [builtinApplication.fetchSubscriptionDetail] Performing fetch operation with
	criteria: {CourseEdition_id:1,SaasCustomer_id:1}	values: {CourseEdition_id:1,SaasCustomer_id:1}
=== 2011-07-11 15:05:33,358 [0-12] INFO  SQLDataSource - [builtinApplication.fetchSubscriptionDetail] derived query: SELECT $defaultSelectClause, (users.username IS NOT NULL) as userAccount FROM CourseEdition_students_Student INNER JOIN Student ON CourseEdition_students_Student.Student_id = Student.Student_id INNER JOIN CourseEdition ON CourseEdition_students_Student.CourseEdition_id = CourseEdition.CourseEdition_id LEFT OUTER JOIN users ON Student.Student_id = users.Student_id WHERE $defaultWhereClause
=== 2011-07-11 15:05:33,360 [0-12] DEBUG SQLDataSource - [builtinApplication.fetchSubscriptionDetail] Executing row count query: SELECT COUNT(*) FROM CourseEdition_students_Student INNER JOIN Student ON CourseEdition_students_Student.Student_id = Student.Student_id INNER JOIN CourseEdition ON CourseEdition_students_Student.CourseEdition_id = CourseEdition.CourseEdition_id LEFT OUTER JOIN users ON Student.Student_id = users.Student_id WHERE $defaultWhereClause
=== 2011-07-11 15:05:33,360 [0-12] DEBUG SQLDataSource - [builtinApplication.fetchSubscriptionDetail] Eval'd row count query: SELECT COUNT(*) FROM CourseEdition_students_Student INNER JOIN Student ON CourseEdition_students_Student.Student_id = Student.Student_id INNER JOIN CourseEdition ON CourseEdition_students_Student.CourseEdition_id = CourseEdition.CourseEdition_id LEFT OUTER JOIN users ON Student.Student_id = users.Student_id WHERE (CourseEdition_students_Student.CourseEdition_id='1')
=== 2011-07-11 15:05:33,371 [0-12] DEBUG PoolableSQLConnectionFactory - [builtinApplication.fetchSubscriptionDetail] Returning pooled Connection
=== 2011-07-11 15:05:33,372 [0-12] INFO  SQLDriver - [builtinApplication.fetchSubscriptionDetail] Executing SQL query on 'Mysql': SELECT COUNT(*) FROM CourseEdition_students_Student INNER JOIN Student ON CourseEdition_students_Student.Student_id = Student.Student_id INNER JOIN CourseEdition ON CourseEdition_students_Student.CourseEdition_id = CourseEdition.CourseEdition_id LEFT OUTER JOIN users ON Student.Student_id = users.Student_id WHERE (CourseEdition_students_Student.CourseEdition_id='1')
=== 2011-07-11 15:05:33,374 [0-12] DEBUG SQLDataSource - [builtinApplication.fetchSubscriptionDetail] Using SQL Limit query
=== 2011-07-11 15:05:33,383 [0-12] DEBUG SQLDataSource - [builtinApplication.fetchSubscriptionDetail] SQL windowed select rows 0->75, result size 75. Query: SELECT CourseEdition_students_Student.cb2_thesis_title, CourseEdition_students_Student.cb4_status_practical, Student.phone, (SELECT COUNT( * ) FROM Lecture_presence_student AS lps INNER JOIN Lecture AS l ON l.Lecture_id = lps.Lecture_id WHERE l.CourseEdition_id = '$criteria.CourseEdition_id' AND lps.status='aanwezig' ) / (SELECT COUNT( * ) FROM Lecture_presence_student AS lps INNER JOIN Lecture AS l ON l.Lecture_id = lps.Lecture_id WHERE l.CourseEdition_id = '$criteria.CourseEdition_id' AND lps.status != 'onverwerkt')*100 AS attendancePercentage, CourseEdition_students_Student.cb1_POK_graduationdate, Student.sofinummer, Student.street, Student.surname, CourseEdition.endDate, Student.city, CourseEdition_students_Student.Student_id, Student.voorletter, CourseEdition_students_Student.cb2_remarks, Student.cellphone, Student.gender, Student.number_addition, CourseEdition_students_Student.cb3_regular_extraneus, CourseEdition.editionName, CourseEdition_students_Student.students_id, Student.tussenvoegsel, CourseEdition_students_Student.cancelled, CourseEdition_students_Student.studentMarkOff, Student.number, Student.postcode, Student.country, CourseEdition_students_Student.cb1_POK_postponed, CourseEdition.MoodleCourse_id, Student.birthplace, Student.email, Student.Moodle_id, CourseEdition.Course_id, Student.active, CourseEdition_students_Student.cb2_defense_date, Student.userAccount, CourseEdition_students_Student.CourseEdition_id, CourseEdition_students_Student.cb2_thesis_accepted, CourseEdition.startDate, CourseEdition_students_Student.cb4_status_theory, CourseEdition_students_Student.cb1_OO_checkbox, CourseEdition_students_Student.cb1_OO_date, CourseEdition_students_Student.cb3_teaching_plan, CourseEdition_students_Student.cb1_POK_date, Student.archived, Student.birthdate, CourseEdition_students_Student.cb2_graduated_cancelled, CourseEdition.published, CourseEdition_students_Student.waitinglist, CourseEdition_students_Student.cb3_exam_regulations, CourseEdition_students_Student.cb2_planned_thesis_date, CourseEdition.percentageOfSubscriptions, CourseEdition_students_Student.cb1_POK_checkbox, Student.firstname, CourseEdition_students_Student.cb3_cohort, CourseEdition.lmsAccess, CourseEdition.Status, CourseEdition_students_Student.checkbox, (users.username IS NOT NULL) as userAccount FROM CourseEdition_students_Student INNER JOIN Student ON CourseEdition_students_Student.Student_id = Student.Student_id INNER JOIN CourseEdition ON CourseEdition_students_Student.CourseEdition_id = CourseEdition.CourseEdition_id LEFT OUTER JOIN users ON Student.Student_id = users.Student_id WHERE (CourseEdition_students_Student.CourseEdition_id='1') LIMIT 0, 75
=== 2011-07-11 15:05:33,402 [0-12] DEBUG PoolableSQLConnectionFactory - [builtinApplication.fetchSubscriptionDetail] Returning pooled Connection
=== 2011-07-11 15:05:33,407 [0-12] INFO  DSResponse - [builtinApplication.fetchSubscriptionDetail] DSResponse: List with 1 items
=== 2011-07-11 15:05:33,408 [0-12] DEBUG RPCManager - Content type for RPC transaction: text/plain; charset=UTF-8
=== 2011-07-11 15:05:33,408 [0-12] DEBUG RPCManager - non-DMI response, dropExtraFields: false
=== 2011-07-11 15:05:33,411 [0-12] INFO  Compression - /generatedcode/sc/IDACall: 708 -> 442 bytes
=== 2011-07-11 15:05:33,662 [0-12] INFO  RequestContext - URL: '/generatedcode/sc/IDACall', User-Agent: 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10.6; rv:5.0) Gecko/20100101 Firefox/5.0': Moz (Gecko) with Accept-Encoding header
+++ [INFO,LoggerListener,btpool0-12] Security authorized for authenticated principal: org.springframework.security.authentication.UsernamePasswordAuthenticationToken@655d02f7: Principal: nl.sytematic.projects.Technicom.server.security.SytematicSaltedUser@99ac08b4: Username: superadmin; Password: [PROTECTED]; Enabled: true; AccountNonExpired: true; credentialsNonExpired: true; AccountNonLocked: true; Granted Authorities: CAN_CHANGE_PASSWORD,CAN_CREATE_COMPANY,CAN_CREATE_CONTACTPERSON,CAN_CREATE_COURSE,CAN_CREATE_COURSECORRESPONDENCE,CAN_CREATE_COURSEEDITION,CAN_CREATE_CREBOINSTITUTE,CAN_CREATE_EXAMREGULATION,CAN_CREATE_LECTURE,CAN_CREATE_LECTURETEMPLATE,CAN_CREATE_LOCATION,CAN_CREATE_PROJECT,CAN_CREATE_STUDENT,CAN_CREATE_STUDENTNOTE,CAN_CREATE_TEACHER,CAN_CREATE_TEACHINGPLAN,CAN_CREATE_USERACCOUNT,CAN_DELETE_COMPANY,CAN_DELETE_CONTACTPERSON,CAN_DELETE_COURSE,CAN_DELETE_COURSECORRESPONDENCE,CAN_DELETE_COURSEEDITION,CAN_DELETE_CREBOINSTITUTE,CAN_DELETE_EXAMREGULATION,CAN_DELETE_LECTURE,CAN_DELETE_LECTURETEMPLATE,CAN_DELETE_LOCATION,CAN_DELETE_PROJECT,CAN_DELETE_STUDENT,CAN_DELETE_STUDENTNOTE,CAN_DELETE_TEACHER,CAN_DELETE_TEACHINGPLAN,CAN_DELETE_USERACCOUNT,CAN_READ_COMPANY,CAN_READ_CONTACTPERSON,CAN_READ_COURSE,CAN_READ_COURSECORRESPONDENCE,CAN_READ_COURSECORRESPONDENCELOG,CAN_READ_COURSEEDITION,CAN_READ_COURSEEDITION_PUBLISHED,CAN_READ_CREBOINSTITUTE,CAN_READ_EXAMREGULATION,CAN_READ_LECTURE,CAN_READ_LECTURETEMPLATE,CAN_READ_LOCATION,CAN_READ_MY_ACCOUNT,CAN_READ_PROJECT,CAN_READ_STUDENT,CAN_READ_STUDENTNOTE,CAN_READ_TEACHER,CAN_READ_TEACHINGPLAN,CAN_READ_USER_MANAGEMENT,CAN_UPDATE_COMPANY,CAN_UPDATE_CONTACTPERSON,CAN_UPDATE_COURSE,CAN_UPDATE_COURSECORRESPONDENCE,CAN_UPDATE_COURSEEDITION,CAN_UPDATE_CREBOINSTITUTE,CAN_UPDATE_EXAMREGULATION,CAN_UPDATE_LECTURE,CAN_UPDATE_LECTURETEMPLATE,CAN_UPDATE_LOCATION,CAN_UPDATE_PROJECT,CAN_UPDATE_STUDENT,CAN_UPDATE_STUDENTNOTE,CAN_UPDATE_TEACHER,CAN_UPDATE_TEACHINGPLAN,CAN_VIEW_MAIN_PANEL,ROLE_ADMINISTRATOR,ROLE_SUPER_ADMINISTRATOR,ROLE_USER; Credentials: [PROTECTED]; Authenticated: true; Details: null; Granted Authorities: CAN_CHANGE_PASSWORD, CAN_CREATE_COMPANY, CAN_CREATE_CONTACTPERSON, CAN_CREATE_COURSE, CAN_CREATE_COURSECORRESPONDENCE, CAN_CREATE_COURSEEDITION, CAN_CREATE_CREBOINSTITUTE, CAN_CREATE_EXAMREGULATION, CAN_CREATE_LECTURE, CAN_CREATE_LECTURETEMPLATE, CAN_CREATE_LOCATION, CAN_CREATE_PROJECT, CAN_CREATE_STUDENT, CAN_CREATE_STUDENTNOTE, CAN_CREATE_TEACHER, CAN_CREATE_TEACHINGPLAN, CAN_CREATE_USERACCOUNT, CAN_DELETE_COMPANY, CAN_DELETE_CONTACTPERSON, CAN_DELETE_COURSE, CAN_DELETE_COURSECORRESPONDENCE, CAN_DELETE_COURSEEDITION, CAN_DELETE_CREBOINSTITUTE, CAN_DELETE_EXAMREGULATION, CAN_DELETE_LECTURE, CAN_DELETE_LECTURETEMPLATE, CAN_DELETE_LOCATION, CAN_DELETE_PROJECT, CAN_DELETE_STUDENT, CAN_DELETE_STUDENTNOTE, CAN_DELETE_TEACHER, CAN_DELETE_TEACHINGPLAN, CAN_DELETE_USERACCOUNT, CAN_READ_COMPANY, CAN_READ_CONTACTPERSON, CAN_READ_COURSE, CAN_READ_COURSECORRESPONDENCE, CAN_READ_COURSECORRESPONDENCELOG, CAN_READ_COURSEEDITION, CAN_READ_COURSEEDITION_PUBLISHED, CAN_READ_CREBOINSTITUTE, CAN_READ_EXAMREGULATION, CAN_READ_LECTURE, CAN_READ_LECTURETEMPLATE, CAN_READ_LOCATION, CAN_READ_MY_ACCOUNT, CAN_READ_PROJECT, CAN_READ_STUDENT, CAN_READ_STUDENTNOTE, CAN_READ_TEACHER, CAN_READ_TEACHINGPLAN, CAN_READ_USER_MANAGEMENT, CAN_UPDATE_COMPANY, CAN_UPDATE_CONTACTPERSON, CAN_UPDATE_COURSE, CAN_UPDATE_COURSECORRESPONDENCE, CAN_UPDATE_COURSEEDITION, CAN_UPDATE_CREBOINSTITUTE, CAN_UPDATE_EXAMREGULATION, CAN_UPDATE_LECTURE, CAN_UPDATE_LECTURETEMPLATE, CAN_UPDATE_LOCATION, CAN_UPDATE_PROJECT, CAN_UPDATE_STUDENT, CAN_UPDATE_STUDENTNOTE, CAN_UPDATE_TEACHER, CAN_UPDATE_TEACHINGPLAN, CAN_VIEW_MAIN_PANEL, ROLE_ADMINISTRATOR, ROLE_SUPER_ADMINISTRATOR, ROLE_USER; secure object: FilterInvocation: URL: /generatedcode/sc/IDACall?isc_rpc=1&isc_v=SC_SNAPSHOT-2011-06-30&isc_xhr=1&isc_tnum=41; configuration attributes: [ROLE_USER, ROLE_ADMINISTRATOR, ROLE_SUPER_ADMINISTRATOR]
=== 2011-07-11 15:05:33,681 [0-15] INFO  RequestContext - URL: '/generatedcode/sc/IDACall', User-Agent: 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10.6; rv:5.0) Gecko/20100101 Firefox/5.0': Moz (Gecko) with Accept-Encoding header
=== 2011-07-11 15:05:33,697 [0-16] INFO  RequestContext - URL: '/generatedcode/sc/IDACall', User-Agent: 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10.6; rv:5.0) Gecko/20100101 Firefox/5.0': Moz (Gecko) with Accept-Encoding header
+++ [INFO,LoggerListener,btpool0-16] Security authorized for authenticated principal: org.springframework.security.authentication.UsernamePasswordAuthenticationToken@655d02f7: Principal: nl.sytematic.projects.Technicom.server.security.SytematicSaltedUser@99ac08b4: Username: superadmin; Password: [PROTECTED]; Enabled: true; AccountNonExpired: true; credentialsNonExpired: true; AccountNonLocked: true; Granted Authorities: CAN_CHANGE_PASSWORD,CAN_CREATE_COMPANY,CAN_CREATE_CONTACTPERSON,CAN_CREATE_COURSE,CAN_CREATE_COURSECORRESPONDENCE,CAN_CREATE_COURSEEDITION,CAN_CREATE_CREBOINSTITUTE,CAN_CREATE_EXAMREGULATION,CAN_CREATE_LECTURE,CAN_CREATE_LECTURETEMPLATE,CAN_CREATE_LOCATION,CAN_CREATE_PROJECT,CAN_CREATE_STUDENT,CAN_CREATE_STUDENTNOTE,CAN_CREATE_TEACHER,CAN_CREATE_TEACHINGPLAN,CAN_CREATE_USERACCOUNT,CAN_DELETE_COMPANY,CAN_DELETE_CONTACTPERSON,CAN_DELETE_COURSE,CAN_DELETE_COURSECORRESPONDENCE,CAN_DELETE_COURSEEDITION,CAN_DELETE_CREBOINSTITUTE,CAN_DELETE_EXAMREGULATION,CAN_DELETE_LECTURE,CAN_DELETE_LECTURETEMPLATE,CAN_DELETE_LOCATION,CAN_DELETE_PROJECT,CAN_DELETE_STUDENT,CAN_DELETE_STUDENTNOTE,CAN_DELETE_TEACHER,CAN_DELETE_TEACHINGPLAN,CAN_DELETE_USERACCOUNT,CAN_READ_COMPANY,CAN_READ_CONTACTPERSON,CAN_READ_COURSE,CAN_READ_COURSECORRESPONDENCE,CAN_READ_COURSECORRESPONDENCELOG,CAN_READ_COURSEEDITION,CAN_READ_COURSEEDITION_PUBLISHED,CAN_READ_CREBOINSTITUTE,CAN_READ_EXAMREGULATION,CAN_READ_LECTURE,CAN_READ_LECTURETEMPLATE,CAN_READ_LOCATION,CAN_READ_MY_ACCOUNT,CAN_READ_PROJECT,CAN_READ_STUDENT,CAN_READ_STUDENTNOTE,CAN_READ_TEACHER,CAN_READ_TEACHINGPLAN,CAN_READ_USER_MANAGEMENT,CAN_UPDATE_COMPANY,CAN_UPDATE_CONTACTPERSON,CAN_UPDATE_COURSE,CAN_UPDATE_COURSECORRESPONDENCE,CAN_UPDATE_COURSEEDITION,CAN_UPDATE_CREBOINSTITUTE,CAN_UPDATE_EXAMREGULATION,CAN_UPDATE_LECTURE,CAN_UPDATE_LECTURETEMPLATE,CAN_UPDATE_LOCATION,CAN_UPDATE_PROJECT,CAN_UPDATE_STUDENT,CAN_UPDATE_STUDENTNOTE,CAN_UPDATE_TEACHER,CAN_UPDATE_TEACHINGPLAN,CAN_VIEW_MAIN_PANEL,ROLE_ADMINISTRATOR,ROLE_SUPER_ADMINISTRATOR,ROLE_USER; Credentials: [PROTECTED]; Authenticated: true; Details: null; Granted Authorities: CAN_CHANGE_PASSWORD, CAN_CREATE_COMPANY, CAN_CREATE_CONTACTPERSON, CAN_CREATE_COURSE, CAN_CREATE_COURSECORRESPONDENCE, CAN_CREATE_COURSEEDITION, CAN_CREATE_CREBOINSTITUTE, CAN_CREATE_EXAMREGULATION, CAN_CREATE_LECTURE, CAN_CREATE_LECTURETEMPLATE, CAN_CREATE_LOCATION, CAN_CREATE_PROJECT, CAN_CREATE_STUDENT, CAN_CREATE_STUDENTNOTE, CAN_CREATE_TEACHER, CAN_CREATE_TEACHINGPLAN, CAN_CREATE_USERACCOUNT, CAN_DELETE_COMPANY, CAN_DELETE_CONTACTPERSON, CAN_DELETE_COURSE, CAN_DELETE_COURSECORRESPONDENCE, CAN_DELETE_COURSEEDITION, CAN_DELETE_CREBOINSTITUTE, CAN_DELETE_EXAMREGULATION, CAN_DELETE_LECTURE, CAN_DELETE_LECTURETEMPLATE, CAN_DELETE_LOCATION, CAN_DELETE_PROJECT, CAN_DELETE_STUDENT, CAN_DELETE_STUDENTNOTE, CAN_DELETE_TEACHER, CAN_DELETE_TEACHINGPLAN, CAN_DELETE_USERACCOUNT, CAN_READ_COMPANY, CAN_READ_CONTACTPERSON, CAN_READ_COURSE, CAN_READ_COURSECORRESPONDENCE, CAN_READ_COURSECORRESPONDENCELOG, CAN_READ_COURSEEDITION, CAN_READ_COURSEEDITION_PUBLISHED, CAN_READ_CREBOINSTITUTE, CAN_READ_EXAMREGULATION, CAN_READ_LECTURE, CAN_READ_LECTURETEMPLATE, CAN_READ_LOCATION, CAN_READ_MY_ACCOUNT, CAN_READ_PROJECT, CAN_READ_STUDENT, CAN_READ_STUDENTNOTE, CAN_READ_TEACHER, CAN_READ_TEACHINGPLAN, CAN_READ_USER_MANAGEMENT, CAN_UPDATE_COMPANY, CAN_UPDATE_CONTACTPERSON, CAN_UPDATE_COURSE, CAN_UPDATE_COURSECORRESPONDENCE, CAN_UPDATE_COURSEEDITION, CAN_UPDATE_CREBOINSTITUTE, CAN_UPDATE_EXAMREGULATION, CAN_UPDATE_LECTURE, CAN_UPDATE_LECTURETEMPLATE, CAN_UPDATE_LOCATION, CAN_UPDATE_PROJECT, CAN_UPDATE_STUDENT, CAN_UPDATE_STUDENTNOTE, CAN_UPDATE_TEACHER, CAN_UPDATE_TEACHINGPLAN, CAN_VIEW_MAIN_PANEL, ROLE_ADMINISTRATOR, ROLE_SUPER_ADMINISTRATOR, ROLE_USER; secure object: FilterInvocation: URL: /generatedcode/sc/IDACall?isc_rpc=1&isc_v=SC_SNAPSHOT-2011-06-30&isc_xhr=1&isc_tnum=43; configuration attributes: [ROLE_USER, ROLE_ADMINISTRATOR, ROLE_SUPER_ADMINISTRATOR]