Portal dont show relationship

[Coriolan_66]

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, 2009 by Guest

[Coriolan_66]

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, 2009 by Guest

[Coriolan_66]

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, 2009 by Guest

[Coriolan_66]

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, 2009 by Guest

[Coriolan_66]

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, 2009 by Guest

[Coriolan_66]

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, 2009 by Guest

[Coriolan_66]

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, 2009 by Guest

[Coriolan_66]

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

[Coriolan_66]

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, 2009 by Guest

[Coriolan_66]

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, 2009 by Guest