I want to use ari datatable to show swimresults in our swimclubwebsite.

What is want to do is to show all the swimevent in one saison. A swimevent has a unique key. This key i want to pass to another ari datatable which then show the swimmers with their results who participate in that swimevent.

Is it possible to pass the unique key to another ari datatable.

Hello,

If results are stored in database, it is possible to pass key through request variable to another page.

Regards,
ARI Soft

That's great, can you give me an example.

Table 1 (Swimevent)
column 1: Id
Column 2: NameEvent

Table 2 (Swimresult)
Column 1: ResultID
Column 2: EventId
Column 3: SwimmerId
Column 4: Result


Aritable 1 has sql:

Select Id, NameEvent from Swimevent

On click in aritable 1 ,aritable 2 has to bu updated

Aritable 2 has sql:
Select SwimmerId, Result From Swimresult wher EventId = ??


How must i fill in the ??

Hello admin, can you explain to me how, a can pass a valeu from one sql statement to another sql statement.

For example, if the second module instance (with sub-details) is loaded into separate article with ID equals to 74. Open the first module instance (for main details) settings page, find "Columns settings -> Columns settings" parameters section and set "Columns settings -> Columns settings -> ID" to Id and "Columns settings -> Columns settings -> Format" parameter to index.php?option=com_content&view=article&id=74&eventId={$value} value.

After this use the next SQL query for the second module:



PS: If you wish, you can provide temporary access to your Joomla! backend by email, describe where you want to use the module and we will help to configure it.

Regards,
ARI Soft

Hello admin, thank you for logging in to the backend of my site and resolve this problem. My next question is now: Is it possible to pass multiple variables to another query in the same hyperlink

For example:

SELECT SwimmerId, Result FROM Swimresult WHERE EventId = {$REQUEST:eventId} and SwimmerId={$REQUEST1: SwimmerId}