My db traces students activities during last year.

modules

students

events

A portal in students layout working fine showing related events...

A new portal I placed in "modules" table to show related students aint wonking. Need help on this.

Thanks

Edited August 3, 200916 yr by Guest

Solved in the same way you told me. Thanks again for your eye in catching those little things...

The field disciplina was initially created as a word field to be filled as a popup. I just deleted that field in "avaliação" and created a new one. Imediately worked both portals, the aluno (student) and the disciplina (module).

Edited August 3, 200916 yr by Guest

I am sending a revised version with renamed tables for you to take a clue whats going on. As you can see, the portal in modules (former "disciplina") works now. I tried to went further and created a portal in "new class" layount, (former "turmas")to list all students in there. There is a bug somewhere in showing module for each student. I also tried to set that portal up in a layout called "class 2" but it went bad.

Hope you can find what's going wrong in my relational schemma. Thanks

Edited August 4, 200916 yr by Guest

I am sending you a new version. I made a major upgrade, as "events" now scores faltas (missing classes by the students - fault). Faltas carries a date but dont need a value associated with...

In students portal, I wished to separate "faltas" from other events, therefore I created a calculation field event_faltas_check which works fine. I guess my portal wont filter faltas from the other events :

Well I have an idea, which is, to sorting event_faltas_check in both situations...

Edited August 4, 200916 yr by Guest

Right. I went further and applied the same method to filter all tests events. I called filter_event_provas but...

it works as expected if filter_event_provas = "testes escritos"

However if I wanted "testes escritos" or "fichas formativas", the portal stays empty. I believe a more conplex expression should be written or the relationship refined...

moduleportal_rev4.zip

Edited August 4, 200916 yr by Guest

I created two new fields in events table. Both having troubles

event_record_number = Get ( FoundCount ), when listed in a portal, displays the same value, not an incremental list 1, 2, 3...

previous_value = Case (event_type="teste escrito" or "ficha formativa" ; event_value ; ( Get ( FoundCount ) - 1 ) ) should return the event_value prior to the last. I am not sure the field is correctly sat up, as I still have fewer data.

moduleportal_rev5.zip

Edited August 8, 200916 yr by Guest

Ok, done. I need previous_value to display, for each student, his/her event_value previous (before) the last event_value achieved.

Example: a student had in September 60 points. In October he had 70 points. The previous_value should display "60"...

Please help me in this calculation.

Edited August 7, 200916 yr by Guest

I created two fields in students

event_portal_number

event_record_number

trying to run two different get funtions. Unfortunately, none result in encremental numbering as "@@". Why?

moduleportal_rev6.zip

Thanks for your kindness in tutoring my questions.

I made a new db to illustrate my question. Please lets switch to this topic . Appreciate.

Edited August 8, 200916 yr by Guest

Using the same example, now I called it "date range", I tried to calculate the average for event:event_value within a date interval. I called that field

student:event_1st quarter

It is a calculation so

Case ( event::event_date

You will see that Carlos Dias (student_ID 1), has a teste escrito [color:green]after Date ( 12 ;31 ; 2008 ). However, student:event_1st quarter still includes it in the average calculation. Why?

date_range.zip

Edited August 23, 200916 yr by Guest