Forums

Hello -

My general goal here is to create a 'downstream', or drill-down report, that is, where a user can drill-down through reports, to get to sub-details. For example, assume one database, with tables linked four layers deep:

Customer table
- Merchant table (inc. CustomerID Foreign Index)
- Device Table (inc. MerchantID Foreign Index)
- Transaction Table (inc. DeviceID Foreign Index)

Customers log into the website, as a user under a single Customer
I have already successfully created a Merchant report, lists all the merchants associated with the given Customer. However, that is as far as I have been able to go - my goal is for the user to then be able to click on one of the Merchants, and get a display of Devices for that Merchant.

First, is this even possible in CCv5 (I can generate the SQL code no problem), and if so, can you point me to the critical configurations to make this happen?

Thank you ahead of time for any help you can provide.

~ Cliff

Hi Cliff,

I'd probably do this using separate CC listings for each layer. So clicking a Merchant link in the Merchant listing would open a Device listing. You can add the merchant ID to the link in each row of the listing so that this is passed on and used in the Conditions box of the next listing.

Bob

Thanks, Bob -

That helps - I thought it was possible, and that confirms we were headed in the right direction.

Any hope for CCv5 documentation in the future?

Best ~
Cliff

Hi Cliff,

Documentation, maybe, I'm learning as I go - which is a patchy process with CC. If it's a long cold winter I might get some more done.

Bob

Bob -

Almost there - but I'm missing one piece, that is probably obvious, but I'm still a novice. Per your help, I need to pass in a value from the current CC list, to the one being called. In the link field, I have:

:index.php?option=com_chronoconnectivity5&cont=lists&act=index&ccname=DevicesByMID&itmid=[ITPMID]

ITPMID is a known field/value in the displayed list; how do I reference that value in the link text?

Thanks so much ~
Cliff

Hi Cliff,

I think you need {model_id.ITPMID} - but replace model_id with the id you are using.

Bob

Perfect - that was it!

Thanks so much, Bob!

~ Cliff (CC Noob)