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

[cmak]

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

[sideview · Accepted solution]

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.

[ahogrefe]

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

[martin_mueller]

I'd occasionally use this as well.

[cmak]

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

[sideview]

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.

[cmak]

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

[cmak]

Alright, thanks for letting me know

[sideview]

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.

[cmak]

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

[sideview]

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.

[cmak]

$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