Sublist items should have a lookup to parent case file

Idea created by Patric on Oct 31, 2018
    Open for voting
    Score2
    • BrunoS
    • Patric

    Currently the items in a sublist of a case file (for example "documents") are only placed in a folder which marks their relationship to the parent case file item ([Case file list URL name]-[case file item ID]).

     

    It is often needed that we want to get the parent item, from the context of a sublist item (for example for easy filtering). In the partner presentation 4/2018 skybow seem to have recognized themselves that this is a much wanted feature and showed us some custom code that can be inserted into an calculated expression of the lookup column:

     

     var folder = [[@Web.GetFirstValueForQuery('ListXy', '<View Scope="RecursiveAll"><Query><Where><Eq><FieldRef Name="ID"/><Value Type="Text">[[ID]]</Value></Eq></Where></Query></View>', 'FileRef')]];
    if (folder && [[FileLeafRef]])
    {
    folder = folder.substring(0, folder.lastIndexOf('/'));
    folder = folder.substring(folder.lastIndexOf('/')+1);
    var namesArr = folder.split('-');
    return namesArr[namesArr.length-1]+';#';
    }
    return null;

     

    It would be great if we wouldn't have to put this workaround into a manually added lookup ourselves if we need this lookup/relationship. It would be great if something like this would automatically happen in the background or at least if we could specify during the case file configuration and sublist configuration that this is needed (checkbox) and then those things are automatically added in the background.