Skip to Content
avatar image
Former Member

Agentry search in a Object Collection

Hello,

i have a parent object "order" this have a object collection "orderItems". Every orderItem have a attribute "status" which can be open our close.

Now i need to combine the status from the orderItems to the orderStatus and show this on a detailscreen label.

  • If one orderItem status is open, the status from the order should be open too.
  • If all orderItems from one order have the status closed the oderStatus is closed.

I know i can create a rule with collection_find_by_str but the rule dose not do what i want.

Could someone explain me how i can use the collection_find_by_str correct or how i can search in a collection for special attribute.

Thanx André

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Mar 04, 2014 at 04:24 PM

    Andre,

    Here is an example:

    This rule will search the WorkOrders Collection looking for an EquipmentID matching the target stored in TempHeader.  TYPE will return TRUE if a record is found.  Think of the TYPE function as a "Where Exists" target check.  It will return True if the target is found, and False if not.

    I will also create a blog with some other similar tips from an old document I wrote a while back.  I'll link it here when finished.

    Jason Latko - Senior Product Developer at SAP


    findbystring.jpg (10.8 kB)
    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Dear Mina,

      i can not see in your rule picture the search property. The collection find by string function should hvae 3 parameters first is the collection, second the search string and third the property from the collection in where you will search fore.

      In your case the equipmentWorkList have the child propertys equipment and each equipment have a property where the barcode is stored?

      Then you have to do the collection find by string so:

      collection property:  equipmentWorkList

      search string: ZBARCODE property (is the transaction value or the last scanvalue if you scan the barcode)

      search property: the barcode Property from the equipment object.


      Can you try this?


      Maybe i could help you,

      André