Skip to main content
piyusha6151
Known Participant
Aug 17, 2022 4:57 PM UTC
Question

How to retrieve rows from entity data type

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

deepakg681722
Inspiring
Aug 17, 2022 5:11 PM UTC

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
    }
  )
)

piyusha6151Author
Known Participant
Aug 17, 2022 6:11 PM UTC

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
Brainy
Aug 17, 2022 6:37 PM UTC

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