Hi... I've parsed through the docs but couldn't find an answer to this. I'll simplify the setup to just focus on this one thing.

I have a non-wp db that I'm going to retrieve two columns from:

• item_id (example value 1234)
• item_hash (example value secret-hash1234)

When displaying the item_id column I need to format it in the form of a link so that users can click on the item_id and be taken to a page url defined by item_hash.

So the item_id column would show 1234 as a link formatted something like https://my-domain.com/secret-hash1234

Is this something that can be done and can you provide me some instructions?

Thanks,

-Norm

I'm making some progress on this request through trial and error.  I found another ticket post looking for a way to filter column data and found "wpdatatables_filter_cell_output".  It is getting me closer but it still isn't quite what I need.

That filter seems to return the formatted cell data after it has been converted into a link (if the column is defined as a link type.)

What I need is a filter that accesses the column data before it is formatted into the url. That way I can insert the correct link address for the cell value including the dual pipe characters (e.g. "https://mydomain.com/cellvalue||cellvalue".  

Then, since the cell is now formatted the way wpDataTables wants it, it can then pass through the column formatter and return the desired final link.

So.... is there a filter similar to 'wpdatatables_filter_cell_output' that gets the cell data before it is formatted?  Something like 'wpdatatables_filter_cell_value'.

Thanks Aleksandar.  Using SQL concat is a good idea.  I thought about using it - and I believe it would work in some situations - but it won't quite work for my explicit case.

I did simplify the use case in my OP, but as usual, there's always more to the story.  In this case, I can't just use concat with static values.  The leading portion of the URL will change depending on data in the cell.  So therefor I have to dynamically build the leading part of the link. That is, in some cases the leading part of the link might be "https://mydomain.com/section1/cell-value" while in another case it might be "https://mydomain.com/section5/cell-value"

So that's one of the reasons I'm looking for a filter.  Something like a filter similar to 'wpdatatables_filter_cell_output' that gets the cell data before it is formatted?  Something like 'wpdatatables_filter_cell_value'.

Also... is there an object or filter that returns all of the current row values?  This would be useful if needing to make decisions in one column based on the data value in another column.

Thanks,

-Norm