Navigating from sorted first element to other associated entity records - Forum - Corticon - Progress Community

Navigating from sorted first element to other associated entity records

 Forum

Navigating from sorted first element to other associated entity records

This question is not answered

Let Entity1 has One to Many association with Entity2. I want to sort Entity1 collection based on some attribute and then pick the first record, then I want to navigate to Entity2 from the first picked entity.I can sort collections in Entity1 and pick first element like this entity1->sortedBy(DATE)->first . But, To navigate to the records on Entity2 from the first element of Entity1 how do you do that? I tried this way but it did not work  entity1->sortedBy(DATE)->first.entity2.Country='US'

All Replies
  • Not sure why that syntax is not supported.
    Maybe engineering can comment on that.
    This screen shot shows an alternative way to do it (maybe there’s an simpler way)
    Note that E2 is a many association so there could be several countries, some US and some not US.
    Is that what you intended
     
  • I agree, the syntax seems correct. Here row e is a combination of b and d which are each valid. It's likely a limitation in the parser. I'll open a bug but for now you'll need to use the two step process as Mike described.

    James Arsenault  |  Product Development  |  Progress Software
    email: james.arsenault@progress.com |  direct: 781-280-4934