Arranging data based on various characteristics while maintaining parent/child connections

Question

Arranging data based on various characteristics while maintaining parent/child connections

My data consists of an array of objects:

    x {sortOrder: 4, parentID: -1, questionID: 371}
    y {sortOrder: 2, parentID: -1, questionID: 800}
    z {sortOrder: 4, parentID: 23, questionID: 123}
    p {sortOrder: 1, parentID: -1, questionID: 371}
    q {sortOrder: 4, parentID: 371, questionID: 456}
    r {sortOrder: 3, parentID: -1, questionID: 371}
    s {sortOrder: 2, parentID: 800, questionID: 223}

I want to organize them in the following structure:

Sort Order

Parent ID
- Child (Question ID)

The desired order based on the given example would be:

p y s r x q z

If needed, I am willing to change the "-1" representing a parent to a different value. My goal was to remove it from the sorting process by ensuring it cannot match an actual Question ID.

I have written code that successfully prioritizes the sort order and groups children together, but they are not grouped under their respective parents. All parents are grouped together instead.

    return (aSortorder < bSortorder ? -1 : (aSortorder > bSortorder) ? 1 : ((aParentid < bParentid) ? -1 : ((aParentid > bParentid) ? 1 : 0)));

I appreciate any assistance. Thank you.

javascript sorting

Answer 1

Answer №1

Here is my approach to the problem:

OrganizeQuestionsByParent:function(x,y){
    var xElm = $(x).data();
    var yElm = $(y).data();     
    var xParent = xElm.bindParentid;
    var yParent = yElm.bindParentid;
    var xQuestionId = xElm.bindQuestionid;
    var yQuestionId = yElm.bindQuestionid;
    var xOrder = xElm.bindSortorder;
    var yOrder = yElm.bindSortorder;
    var xTempId;
    var yTempId;
    (xParent < 0) ? xTempId = xQuestionId + ".5" : xTempId = xParent + ".9";
    (yParent < 0) ? yTempId = yQuestionId + ".5" : yTempId = yParent + ".9";
    var outcome = xOrder - yOrder || xTempId - yTempId;
    console.log(outcome);        
    return outcome;
}

Answer 2

Here is my approach to the problem:

OrganizeQuestionsByParent:function(x,y){
    var xElm = $(x).data();
    var yElm = $(y).data();     
    var xParent = xElm.bindParentid;
    var yParent = yElm.bindParentid;
    var xQuestionId = xElm.bindQuestionid;
    var yQuestionId = yElm.bindQuestionid;
    var xOrder = xElm.bindSortorder;
    var yOrder = yElm.bindSortorder;
    var xTempId;
    var yTempId;
    (xParent < 0) ? xTempId = xQuestionId + ".5" : xTempId = xParent + ".9";
    (yParent < 0) ? yTempId = yQuestionId + ".5" : yTempId = yParent + ".9";
    var outcome = xOrder - yOrder || xTempId - yTempId;
    console.log(outcome);        
    return outcome;
}

Arranging data based on various characteristics while maintaining parent/child connections

Answer №1

Similar questions

What steps are involved in extracting post data from the javascript DOM using php?

Combining Two DIVS Side by Side

When the route is modified, the image fetched from the JSON disappears

Sending JSON data back to React in a file format

Utilize lodash/Javascript to organize the class into groups and keep track of the number

Executing an AngularJS function through CasperJS is a common task that can

Adding an Item to the Cart in React.js

Interpolating within conditionals through pipes

Tips for using Angular's formatDate function to format dates

Unable to link to 'mdMenuTriggerFor' as it is not a recognized attribute of 'button'

Extracting Data from Input Box Using Query

Check through an array for any updates whenever a function is called and my react state is altered

What steps can be taken to ensure that JSON.parse() interprets all numbers as BigInt values?

Android params not being transferred to Node.js properly when using Volley

ng-class not displaying the correct results

The interconnected promises of nodes and readability in coding

Node.js error: Attempting to set property '' on an undefined object not allowed

What is the best way to activate a function within an npm package in a Vue application?

How can I use jcanvas to edit the drawImage layer in order to add cool Instagram-style filters to my image?

How to set up Node 6.9 on Ubuntu Zesty 17.04