CDT With Very Very Many Fields

davids735 over 8 years ago

I'm creating a proof of concept with a CDT containing 1352 Text fields to see if there are practical limitations like lag or database writes failing. I was just wondering if anyone had formulated a script for writing the same value to each and every one of a CDT's fields quickly. For instance a rule that took in the CDT and "Steve" or something like that and made every one of the fields "Steve" without me having to manually insert all 1352 "Steve" strings myself.

Discussion posts and replies are publicly visible

Parents

0 Dan Tobias
Appian Employee
over 8 years ago

Use the function update()

It's "hidden" but it works just fine for developing and non-production work.

It takes parameters: cdt, field, and value, in that order.

So you could run this SAIL and update all of your fields:

reduce(
update(_, _, "Steve"),
type!YOUR_CDT,
{"field1", "field2", "field3".... "field1352"}
)
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 Dan Tobias
Appian Employee
over 8 years ago

Use the function update()

It's "hidden" but it works just fine for developing and non-production work.

It takes parameters: cdt, field, and value, in that order.

So you could run this SAIL and update all of your fields:

reduce(
update(_, _, "Steve"),
type!YOUR_CDT,
{"field1", "field2", "field3".... "field1352"}
)
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data