Skip to main content
Nintex Community Menu Bar
Question

How do you combine data.length for different models in a tab?

  • July 9, 2024
  • 4 replies
  • 6 views

Forum|alt.badge.img+2

I have a tab that has three tables with all of the same object (Cases), but different models to separate them. How do I get a total of all cases to show in the tab to let the user know there are records present? I know how to get the count for one model, but I can’t figure out how to get the sum.

Thanks!

This topic has been closed for replies.

4 replies

Forum|alt.badge.img+20

Short of using javascript, I’d create another model just for this purpose. That model have three conditions that with the following logic. 1 OR 2 OR 3
Each condition would be Id “in” field model of another model field Id.


Forum|alt.badge.img+2

Thanks for that answer. The conditions have changed on my end, though.

Is it possible to get an aggregate count of records from three different objects?


Forum|alt.badge.img+17
  • Nintex Employee
  • July 9, 2024

No,  it is not possible to aggregate data from multiple sObjects. 


Forum|alt.badge.img+17
  • Nintex Employee
  • July 9, 2024

Digging for another answer and I see this question.  Things have changed!

Make a UI only field that aggregates the length of each model together.  Something like this. 

{{$Model.myModel1.data.length}}+{{$Model.myModel2.data.length}}

That should get you your aggregated value to put in a tab…