Hi,
New to Appian!
I have a query filter rule:
a!queryEntity( entity: cons!PINBuddy_DSE_Wizard, query: a!query( logicalExpression: a!queryLogicalExpression( operator: "AND", filters: { a!queryFilter( field: "particpaitUpdateCutOffDate", operator: "<=", value: today() ), a!queryFilter( field: "paymentMethod", operator: "<>", value: null ), }, ignoreFiltersWithEmptyValues: true ), pagingInfo: a!pagingInfo( startIndex: 1, batchSize: -1 ) ), fetchTotalCount: true ).data
Based on these filters, a list of records get generated, how do i write to a specific column, say "particpantNoteExtracted" to these records?
Hope my question is clear.
Thanks in advance
Neil
Discussion posts and replies are publicly visible
QueryEntity works like a SQL-Select. To write to DB you would use a Write To Datastore Node in a process model.
When starting with Appian, did you try the tutorials?
docs.appian.com/.../Tutorials.html
Hey, If you need to write to the database, you would have to use Write to Datastore entity node in process model or function in saveInto on interface. You would also have to write the whole row otherwise the other columns would get nullified, so plase do not use selection while writing to DB.
How do i write to multiple records? Right now if i use the saveInto, it only writes to one row and same with the process model route. Thanks for the help
Is your rule input multiple type? If it is you can write multiple rows to the table.
how do i know it is multiple type?
Check out the documentation:
Use the Write to Data Store Entity Smart Service Function on an Interface - Appian 21.2
The Process model nodes:
Write to Data Store Entity Smart Service - Appian 21.2
Write to Multiple Data Store Entities Smart Service - Appian 21.2
While creating the rule input, process variable or activity class parameter you would need to click the check box to make it "Array"