Forums

oining / retrieving information from another table (v5 + v6)

casals 04 Sep, 2017
Hi,

Can somebody help me..? I desperately need some help ;-)

I have to read from all the maching 'requests' (easy), all their 'infolines' (several key=values), so i will have a table like;

request_id, user_id, request_date, request_status, info_key1, info_value1, info_key2, info_value2, info_key3, info_value3


Yes, i know that this should be easy, but for some reason, I can not do it, no in ChronoConnectivity v5 or v6.
I also have problems with the v6 and the [add new model] that is not working, so i appreciate the v5 solution more - this time. :-)

TABLE:REQUESTS
request_id
user_id
request_date
request_status

TABLE:INFOLINES
info_id
request_id
info_key
info_value
Max_admin 06 Sep, 2017
Hi casals,

v6 is better so we focus on v6, please make sure that you update to the latest Chronoforms before testing.

You have multiple infolines for each request ? if yes then just setup the infoline as a new model and in the relation type select the "multiple matching" and set the foreign key to "request_id"

Best regards,
Max
Max, ChronoForms developer
ChronoMyAdmin: Database administration within Joomla, no phpMyAdmin needed.
ChronoMails simplifies Joomla email: newsletters, logging, and custom templates.
casals 07 Sep, 2017
Hi Max,

Fine, but i have the problem with the v6 (as in the other topic).. :-(

Meanwhile, I would be very happy to hear suggestions / instructions on how to accomplish the above-mentioned problem.. even with version 6 :-)
Max_admin 20 Sep, 2017
Hi casals,

Apologies for the late reply!

Please let me know where we are on this issue now ? you still have a problem with v6 ?

Best regards,
Max
Max, ChronoForms developer
ChronoMyAdmin: Database administration within Joomla, no phpMyAdmin needed.
ChronoMails simplifies Joomla email: newsletters, logging, and custom templates.
This topic is locked and no more replies can be posted.