Uploaded image for project: 'PUBLIC - Liferay Portal Community Edition'
  1. PUBLIC - Liferay Portal Community Edition
  2. LPS-159377

Cannot search for object entries using the relationship with the headless API

Description

    Steps:

    1. Create two objects with text fields, "Employee" and "Department"
    2. Create a one-to-many relationship, "Department" to "Employee", titled "Department to Employee"
    3. Create several object entries for each and relate the "Employee" entries to the "Department" entries
      1. Note the ID for the Department entries
    4. Navigate to localhost:8080/o/api > REST Application > c/employees
    5. Expand getEmployeesPage
    6. Search for department
      1. departmentId eq XXXXX
    7. Click execute

    Expected result:
    Expected only the employees related to departmentId to be returned

    Actual result:

    WARN  [http-nio-8080-exec-8][BaseExceptionMapper:70] Problem {detail=null, status=Bad Request, title=Incompatible types., type=null}
    com.liferay.portal.odata.filter.InvalidFilterException: Incompatible types.
    

    Reproduced on:
    Tomcat 9.0.56 + MySQL 5.7
    Portal master GIT ID: 0b5fc90dc43557eec5200c247a5ea7389f308cd1

    Attachments

      Issue Links

        Activity

          People

            support-lep@liferay.com SE Support
            timothy.pak Timothy Pak
            Samuel Romeiro Samuel Romeiro
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:
              34 weeks, 3 days ago

              Packages

                Version Package