Breadcrumb in joinSelf Table
Breadcrumb in joinSelf Table
MarekAdam
Posts: 30Questions: 9Answers: 1
Link to test case: https://editor.datatables.net/examples/advanced/joinSelf.html
Description of problem: I have table like joinSelf example. Cols: id, name, parent. Parent id is the parent in this table (recurency). Is there posibility to show in column all name parents like Breadcrumb on websites? Like aaa>bbb>ccc>ddd
If not i will make new col in mysql and do it as 'static' text.
Replies
I'm not actually sure how that would be expressed in SQL. I think it would need a recursive query to keep looking up the tree. Recursive queries are not something that the Editor server-side libraries currently support.
Allan
ok, i make it manually.
editor.on( 'initSubmit', function (e, action)
and call by ajax php script with recursive function
Careful you don't end up with an infinite loop and DDoS your own server
Allan