How to display a list from a different table than the form refers?

[joomla123]

Hello

I have a question - how to display a list from a different table than the form refers?
Possibly as part of SQL Userspace utilities for Fabrik 3.0.4?
If you can not view the list of comments from iinej table than the form refers to the chance that the sql element is allowed.

I will add that I have installed the latest from github fabrik ...
I tried to put the SQL element - as files and the option to detect ..
Fabrik sees as element of .. but not to enter any questions ..

I have another option - Display two forms (each with a different table of data) on one page of results .. But I do not know if this is possible ..

 

[Jaanus]

Learne about Fabrik content plugin in f wiki. You can use it in articles, but also in form/details view. For the latter you can use form intro or display text element.
Posted via Mobile Device

 

[joomla123]

Hi thanks for the reply.
Partially solved the problem - just by the intro (where the letter will show .. but I have a problem with filtering ..)

How can I view a filtered list in detail?
I mean this effect:
In the list of X I click on one position - show me the details of this position.
Below these details left, should be filtered to display a list of Y. This is nothing but comments from the list displayed to the object Y from the list of X

Do you know any elements / plugins ktoe will display a list of the form or detail?

Regards

 

[Jaanus]

oeh... please make some pictures, some screenshots about what do you want

 

[lutana]

list in a form

Hello Jaanus, can you (or anyone) please explain how to show a list in a form. I can get it working in a joomla article no problems using {fabrik view=list id=1} but dont know how to use so shown in a form.

thanks

 

[cheesegrits]

I don't think we support doing what you have in mind.

-- hugh

 

[Jaanus]

I don't think we support doing what you have in mind.
-- hugh

Are you sure?

Hello Jaanus, can you (or anyone) please explain how to show a list in a form. I can get it working in a joomla article no problems using {fabrik view=list id=1} but dont know how to use so shown in a form.

{fabrik view=list id=1 some_field=[rowid]}

I use this kind of code two possible ways
1) in form/details intro or
2) I create a "display text" element and write this code there.
In this case, some_field is a field in this db table that the displayed list represents. Its values are corresponding to the current form/details primary key value. That means if this form/details PK value is 2, then only those rows from this other list are displayed where the some_field value is 2.

Notice -
1) The form should be set to process Joomla content plugins!
2) My experiences are related to Fabrik 2.1.1 (Joomla 1.5.25) but I believe it works also in F3/J2.5

Example: here you see one person's data and when you click on the tabs containing words Muusikateosed or tekstid, then you see data from two other table views related to this person.

 

[lutana]

list in form

Thanks for info, yes by using your method I can get a list to show in F3 J2.5.

What I would really like is an element like a list box (ie a dropdown that stays open) but using your method and if I can strip down the list to only show the list data I might get close to what I am looking for.

thanks again

 

[Jaanus]

strip down the list to only show the list data... ??? What does it mean?

When you display a list it shows the list data, nothing else.

Maybe you mean data from a single element... Or what?
Posted via Mobile Device

 

[cheesegrits]

@jaanus - interesting! I never thought about using a {fabrik ...} plugin in a display element.

By "stripping down", I presume he means to get rid of all the buttons, pagination, etc.

To do that, you may want to just copy the List, configure the copy of the list to the absolute minimal display (turn off all navigation, buttons, etc), set the element display to only the ones you need, and use that as the one you show in your display element.

Or ... "strip down" may mean filtering by something other than [rowid] ... and I think you could do that by using placeholders from the current form as plugin filters, like table_a___elementname=[table_b___something].

-- hugh

 

[lutana]

Yes Hugh your first option was what I am looking at, thanks for your comments.

 

[joomla123]

it can from the other side ..
If I have a list based on the MySQL view displays the details of this list, the elements / field of view.

I can not add any additional item (eg, display, etc) even though the screen is read-only.

The problem is that this is not the table list, (so I can not add any fields)

Is there any chance add display box back in this situation?

Maybe you can manage to display in detail:
vidok group based on MySQL,
and below the group based on a mysql table?

 

[lutana]

By using a {fabrik ...} plugin in a display element I have a form that shows a list of related records from another table. Eg I have a table of clients and a table of contacts (1 client can have many contacts). Then when selecting a client from the Clients List it opens the Client Form showing the selected client and the Display Element shows a list of any Contacts for that client.

From this form I am able to select an Add Contact button (opens Contact Entry Form) where I can add a new contact for the selected client. Saving and closing this form redisplays the Client Form and the Display Element is updated with the new contact.

The downside is I cannot now edit or add new client records (the parent). Unpublishing the Contacts Display Element (in the Clients Form) allows adding or editing Clients.

So close to what I need - any other suggestions to how to get this working would be very much appreciated.