Skip to main content
Nintex Community Menu Bar
Question

How to select rows from a table, concantenate their respective ids...

  • July 11, 2024
  • 3 replies
  • 11 views
  • Translate

Forum|alt.badge.img+13

Hello,

Would anyone know of way (hopefully declarative, as i’m a JS noob) that I can select rows from a table, concatenate their respective ids, and send that concatenate field to another model’s condition

So example table has 5 rows i select , first 2, the Id would be concatenated as such: ‘0011W00001wQsPb’,‘0011W00001wQrTV’

And the ability to use this concatenate field to activate & set value of another’s field condition

Thank you!

Did this topic help you find an answer to your question?

3 replies

Forum|alt.badge.img+3
  • Rookie
  • 24 replies
  • July 11, 2024

Hi Dave,

I am new to Skuid too. So hopefully someone else will add to this comment. But I had a similar request; I needed to take the ids of the selected rows and add them to a field in a concatenated format. I’m pretty sure once you get them into the field you can use that field in the condition. My question was answered here. Hope it helps.

http://community.skuid.com/discussion/7977887/generate-a-soql-from-the-results-of-a-model-and-populate-a-field-with-the-soql#latest

Translate

Forum|alt.badge.img+20
  1. Here you go.

    Create a model called ConditionRows.

Create a condition on your target model to use a field from another model using the new model, it's operator set to in, and field as I assume to be Id. Set your mass action to: Adopt Rows to ConditionRows Query target Model

Also another reason to have folders for Models as I would create a folder for all the non component used models.

Translate

Forum|alt.badge.img+10
  • Scholar
  • 224 replies
  • July 11, 2024

Note that from my testing (v1 pages) there is a hidden limit on the number of rows that can be passed from one model to the condition of another model. That limit here I don’t believe is an exact limit, and could sneak up on you. Typically unless I’m absolutely sure that the number of rows I’m passing is small I won’t use ‘in (rows from) another model’ conditions. When you do hit the limit, the over-limit rows are simply not passed to the model condition so you only end up with some of the data being passed to the condition, and the rest not. It won’t be obvious when this happens as there is no error or anything like that, you just simply end up with partial data returned from the query in your end result.

Translate

Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie Settings