Details

    • Feature Request
    • Status: Under Review
    • Minor
    • Resolution: Unresolved
    • None
    • None
    • Objects
    • None
    • Orchestrate

    Description

      Description: As a developer I want to add filter to my objects which contains a Relationship

       

      Use Case:

      Objects Entities

      • Project
        • Team (Relationship)

      Objects today supports filter, for example

      http://localhost:8080/o/c/projects?filter=name eq 'Liferay Portal 7.4'

       

      As a developer, I would need to apply filter to my Relationship, for example

       

      I want to list all projects, filtering by relationship id, or any other indexed field

      Something like:

      http://localhost:8080/o/c/projects?filter=team/id eq 123

      http://localhost:8080/o/c/projects?filter=team/name eq 'Solutions'

       

      UPDATE:::

      Filter Nested Relationship’s

      Description: I Need to Filter by a Foreign Key of a Relationship

      Objects - Schema Definition

      1. Requirements (Object)
        1. ID (Field - Primary Key)
        1. Key (String)
        1. Component (Object Relationship)
      1. Component (Object)
        1. ID (Field - Primary Key)
        1. Name (String)
        1. Team (Object Relationship)
      1. Team (Object)
        1. ID (Field - Primary Key)
        1. Name (Field)

      Considering the following list:
       

       
      I need to apply filters to this list of requirements:

      1. Filter All Requirements by Component ID (Portal Services - 1234)
        1. http://localhost:8080/o/c/requirements?filter=componentId=1234
      1. Filter All Requirements by Team ID (Core Infrastructure - 123)
        1. http://localhost:8080/o/c/requirements?filter=component.teamId=123
      1. Filter All Requirements combining Component and Team
        1. http://localhost:8080/o/c/requirements?filter=componentId=1234 and component.teamId=123

       

      Attachments

        Issue Links

          Activity

            People

              luiz.jardim Luiz Jardim
              keven.leone Keven Leone
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:

                Packages

                  Version Package