1. Greg Galipeau
    Greg Galipeau avatar
    13 posts
    Member since:
    Jul 2009

    Posted 03 Mar 2016 Link to this post

    Does the Everlive Power Fields (i.e.: expand relationships) have a concept of InnerJoin?

    I have a table called Friends. The Friends table has a relationship field called Users. I need to make a query to get the Friends row for a particular User.

    I understand the Filtering concept of the expand. But, that still brings back all my Friends and just has a null for Users in the ones that don't meet the filter (i.e.: an OuterJoin). I need it only to return the Friends that match the User.

    Here is how I tried it with the expand/filter (this returns 2 rows. 1 with Users and 1 without. i.e.: OuterJoin):

     var friendsTable = app.everlive.data('Friends');

                var expandExp = {
                    "User": {
                        "TargetTypeName": "Users",
                        "Filter": {
                            "FBID": selectedFriend.id

                var filter = new Everlive.Query();



    I've also tried this (but, this returns nothing):

      var friendsTable = app.everlive.data('Friends');
                var filter = new Everlive.Query();
                filter.where().eq('User.FBID', selectedFriend.id);


    Please let me know if this basic SQL concept is available in Everlive?




  2. Martin
    Martin avatar
    1 posts

    Posted 04 Mar 2016 Link to this post

    Hello Greg,

    I believe that this thread from our forums will be helpful for you - http://www.telerik.com/forums/filter-on-entities-with-relationships because it discusses a similar scenario.

    Perhaps you may consider the approaches explained there in regard to the NoSQL schema and capabilities for working with relations.

    Please contact us if you need further assistance or information.

    Kind regards,
    Everlive is now Telerik Backend Services, and is part of the Telerik Platform.
Back to Top