Selecting Data not 1:1 related

[#1]

Hi,

i have a mastercalender, so other tables are connectet 1:1 per date (one field).

I have a Leader Table.

Now i have the following (seminar) table, who may connectet by more then one field.

SeminarID

Startdate

Enddate

Leader 1

Leader 2

Leader 3

Leader 4

Leader 5

I have to verify, if the selected date in the mastercalender ist BETWEEN the startdate/enddate, and only showing this data.

On the other hand, i have to verify, if the selected Leader is in one of the 5 fields above (so maybe a i get a $SYNTH Table?), and only showing this data.

How can i integrate my seminartable in my QVW correctly?

Regards,

Michael

[#2]

Use the function intervalmatch(). That will do the first one.

which field do you pick up when you say "if the selected Leader"?

[#3]

I don't get it how the funktion intervalmatch() works.

Here my script (simple):

Load

     TicketID,

     Datum

from Tickes;

Load

     LeaderID,

     Leadername,

from Leaders

Load

     Datum,

     Year,

     Quarter,

     Month,

     Week,

     Day

from Mastercalender

Load

     SeminarID,

     Seminar_Startdate,

     Seminar_Enddate,

     Leader1,

     Leader2,

     Leader3,

     Leader4,

     Leader5

from Seminar

The table "Seminar" is not directly connected to the other two tables.

Please help me, how i can use the function intervallmatch() in this script.

For the Leader-Selection:

I select "Leadername" and want to verify, if "LeaderID" is in one of the Fields "Leader 1" to "Leader 5".

Regards,

Michael

[#4]

Hi,

please find an example with the function attached. You also can use the documentation, it's really helpfull.

[#5]

Hi,

thanks for the example. Thanks to that, i have now an integrated seminar-table (by intervalmatch (date)).

Now, how can i connect the LeaderID to all possible 5 Leaderfields?

If i make another intervalmatch function, i get a loop.

Is there a possibility?

Regards,

Michael

[#6]

Could you give a data example?

Are yours 5 leader fieds <> null in the same time? There is more than one fill?

[#7]

Hi,

sorry for late example.

I want to select "Hans" in Leader.

If selected, all possible Seminars shoud be selected too, where "Hans" could be in Leader1, Leader2 or Leader3.

Regards

Michael