Hi all, I'm writing a one-to-many relationship to a database, and

cgoldsberry over 10 years ago

Hi all,

I'm writing a one-to-many relationship to a database, and am having trouble with some of the variables in my CDT which are supposed to be the same for all of the entries in my 'many' table, like today's date as a timestamp. When I pass in a single value for these variables (like 'today()'), only the first entry in the list gets the timestamp. What's the best-practice way to ensure that single-value variables can be correctly applied to each of the entries in my table when I write to a data store?...

Discussion posts and replies are publicly visible

0 Patty Isecke
Appian Employee
over 10 years ago

Can you create an array containing the value of today(), or use the repeat() function to apply the value to each entry in your "many" table?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 cgoldsberry over 10 years ago

Sorry, I should mention that I'm using Appian 6.6; I'm not sure the repeat() function is available to me (please let me know if that's not the case). I can create an array of the value of today(), but is it sufficient to just have {today()} as the passed value, or do I need to make the length of the today() array equal the items on my list? I've been playing with the makerange() function, but when I use it in a script task, the task errors out as 'unattended'.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Patty Isecke
Appian Employee
over 10 years ago

Can you use enumerate(): forum.appian.com/.../Function_Recipes
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 cgoldsberry over 10 years ago

Gorgeous. Thanks! I was able to successfully use ={today()}[1+0*enumerate(length(pv!CDTvariable))] to create a list of today's date as long as my CDT
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel