Hi All -- I'm stuck trying to get a 3rd CDT to pull into my interface using a query rule that has an input from a local variable... here is the error:
These are my local variables and here is the query rule that's throwing the error:
In the interface I am trying to save the local!formQuestions into a CDT as an array....why does it think I want to save it as an integer??
Instead of using a query rule to pass into the local!formQuestions I also tried an Expression rule that actually returns all the CTD's data but it is also an array of data which doesn't like being saved into the local, I get the same cast error.
Thanks for any help!
Discussion posts and replies are publicly visible
Hi nareshc647 thank you so much! This resolved the cast error, but now instead of only saving the ID I'd like to save the entire array of CDT -- is this possible? What you provided helps get rid of the cast error, but there are still in fact an array of formQuestionID's that need to get saved into the CDT... how do I achieve this?
I want this rule input to be saved with the entire CDT for all rows -- the whole array.
Hi nareshc647 , so actually I may only need the formID to pass into that CDT, since ultimately what I am trying to do is have a unique Identifier in my Delete from Datastore node, but I tried the following and it's not deleting the associated lines from my CMT_FORM_QUESTIONS data entity like I would imagine per this expression:
This configuration I would expect to take any FormID's with the value passed in from the form, and delete the associated lines from the CTM_FORM_QUESTIONS table, right? Am I missing something else?
© 2023 Appian. All rights reserved.