Skip to main content
P
piyusha6151
August 17, 2022
Question

How to retrieve rows from entity data type

  • August 17, 2022
  • 7 replies
  • 1 view

I have a data with following format-

[entity: somevalue , data:[id:1,name:a],[id=2,name:b]

Now i need to pass data part in loop. As it has 2 occurrences for data so loop should run two times. And for each occurrence it should pas only relevant data.

1st occurrence-  [entity: somevalue , data:[id:1,name:a]

2nd occurrence-  [entity: somevalue , data:[id=2,name:b]

As data is type of array so not able to do indexing here.

Any suggestion.

7 replies

D
deepakg681722
August 17, 2022

Could you please try the below Code.

a!localVariables(
  local!data: a!map(
    entity: "Some Entity",
    data: { { id: 1, name: "ABC" }, { id: 2, name: "DEF" } }
  ),
  a!forEach(
    items: local!data.data,
    expression: {
      entity: "Some Entity",
      data:fv!item
    }
  )
)

P
piyusha6151Author
August 17, 2022

That didn't help as process is receiving process variable of entity type. As per your example, issue is to get data part of local!data  

csteward
csteward
August 17, 2022

deepakg's example is essentially it, here's the same just with a specific Entity Data type utilized.  What are you doing with the data?  Passing it where?

a!localVariables(
  local!data: a!entityData(
    entity: cons!COE_DS_SAMPLE,
    data: {
      {id: 1, name: "test 1"},
      {id: 2, name: "test 2"}
    }
  ),
  
  a!forEach(
    items: local!data.data,
    expression: {
      /* each data set can be utilized here */
      fv!item
    }
  )
)

Terms & ConditionsAccessibility statement