topic Re: How to get the column name for drilldown in the Table module in All Apps and Add-ons

How to get the column name for drilldown in the Table module

cmak — Wed, 06 Feb 2013 22:35:56 GMT

When I use the SimpleResultsTable module, I can get the column name and cell contents of the clicked cell with the following code when I drilldown

Column Name: $click.name2$ 
Cell Value : $click.value2$

However, I am unable to find an equivalent with the Table module. I can only get the column name of the first column with

$row.name$

Thanks

Re: How to get the column name for drilldown in the Table module

sideview — Mon, 28 Sep 2020 13:14:56 GMT

You should use the more useful Sideview keys of $row.fields.fieldName$, $row.fields.someOtherFieldName$, etc.. However if you want the legacy keys only, they would be $row.name$, $row.value$. There is no "row.name2" key, a the Table module does not support that funky behavior where the user's click chooses both a column and a row at the same time. In practice I found that nobody ever really needed that behavior beyond it's interest as a novelty.

In general check out the pretty extensive documentation page at "Module Documentation > The Table Module > Table - Inline Drilldown". ( /en-US/app/sideview_utils/table2_drilldown )

Once you're at that page, follow the instructions to click a row on the Table module. A whole lot of HTML will appear illustrating all of the keys that are available.

Re: How to get the column name for drilldown in the Table module

cmak — Wed, 06 Feb 2013 22:55:20 GMT

$row.name2$ and $row.value2$ does not give me the column name as it returns nothing. I am simply trying to find the key that will give me the equivalent to $click.name2$ and $click.value2$. I imagine it is something simple

Re: How to get the column name for drilldown in the Table module

sideview — Wed, 06 Feb 2013 22:58:55 GMT

Oh I see. Do you really need the name2 and value2 keys? In the SimpleResultsTable module they are specific to just the "all" drilldown mode. Since I've so rarely seen that mode used in the field, I have not implemented anything like it in the Table module.

Re: How to get the column name for drilldown in the Table module

cmak — Wed, 06 Feb 2013 23:04:01 GMT

Yes, I would like to know if there is a way to dynamically obtain the column name and cell value of the clicked cell. With the table module, it seems i have to hardcode which column name i would like to obtain, such as $row.cell1.name$ and this is independent of where I clicked

Re: How to get the column name for drilldown in the Table module

sideview — Wed, 06 Feb 2013 23:05:48 GMT

There is not. As with the module's highlighting behavior, the click behavior does not differentiate between clicks on different cells within a single row - only the row is considered selected.

Re: How to get the column name for drilldown in the Table module

cmak — Wed, 06 Feb 2013 23:28:47 GMT

Alright, thanks for letting me know

Re: How to get the column name for drilldown in the Table module

cmak — Tue, 12 Feb 2013 01:10:33 GMT

Would the 'all' drilldown mode ever comes to Table module?

Re: How to get the column name for drilldown in the Table module

sideview — Tue, 12 Feb 2013 05:51:03 GMT

Well, to be honest you're the first person to ask for it.

People in the field don't seem to use it much on the SimpleResultsTable, so when I built the Table module I left it off. I figured if someone needed it, they would ask for it, but until you nobody ever has. Do you really need it? In situations where I might use it, I always either use a stacked column chart, or I break the interaction into two stages - generally where the first table has some level of summary detail about the second layer, and an inline drilldown that runs a search/postprocess to show the second dimension.

Re: How to get the column name for drilldown in the Table module

cmak — Wed, 13 Feb 2013 18:17:21 GMT

I suppose it is not absolutely vital, but would be a nice to have.

Re: How to get the column name for drilldown in the Table module

martin_mueller — Tue, 23 Apr 2013 14:00:18 GMT

I'd occasionally use this as well.

Re: How to get the column name for drilldown in the Table module

ahogrefe — Thu, 05 Mar 2015 17:48:58 GMT

Hi there, I "need" this feature, too ... Would love to see it in future versions 😉