Link to detail-view of another list

[kissinger]

In lists, we can display a link to the detail view. This detailed view relates to the current list (table).

Now I want to display in a column of this list a detailed view of another list (table).

For example: I have a column with an Id, this id is the primary key of a different list (table).
When I click an this Id I want to display the detailed view of this other list (table).

How can I do that?

Thank you!

 

[troester]

Set your element to "Link to details" and add a custom link pointing to the different details view with formID X, e.g.
index.php?option=com_fabrik&view=details&formid=X&rowid={your___element_raw}

 

[kissinger]

Thank you troester, it works.

But I have another problem now.
In the table "&rowid={your___element_raw}" points to the primary key-field "id".
But I want to show not the data with the id, but with the user_id field.

Example:

The table
-------------------
id | user_id
1 | 3
2 | 4
3 | 7
4 | 12
ect...
--------------------

The link "&rowid=4" points to the record with id=4, but I need the record with user_id=4.

What I can do?

 

[troester]

So {your___element_raw} contains a user_id?

index.php?option=com_fabrik&view=details&formid=X&rowid={your___element_raw}&usekey=user_id
should do; if there is more than one recordwith this user_id it will show the first one (I think)

 

[kissinger]

It works with this link. Thank you troester.

 

[bruno123]

If {your___element_raw} is databasejoin element the fabrik put in URL the label and not the value.
Is it possible to put the value?

 

[cheesegrits]

If you append _raw to the element name, you should get the raw value, not the label?

-- hugh

 

[bruno123]

Thank you Cheesegrits I did not know this method.