Hi Everyone, I have to update some columns for multiple IDs in database. Ca

It depends on how the data is managed in Appian. Here are some thoughts. In general, I'd recommend using Write to Data Store as this allows you to perform multiple row transactions in a single call. Secondly, this is underlying SQL or database agnostic. Execute Stored Procedure is ideal for, as the name suggest, executing SP in your database. and Query database requires you to write your own SQL statement and manage it. That's my thought on your requirement.

@Sathya. I have some columns, lets assume ID, Name, Age, Number, City, State, Country. I want to update Age, City, State, Country columns for multiple IDs. How can I update those multiple IDs using Write To Datastore Entity.

The most straightforward approach is to populate the data into a CDT array in the process (via query or whatever menas you prefer), update the columns directly to the CDT, then re-write the CDT array to the DB using the WTDS node.

If you need to maximize efficiency (like in cases where such updates will be very frequent or the CDT is very large compared to the number of columns you need to update), a technique used sometimes is to create a special CDT mapping to the same DB table but only containing the columns you wish to update in this situation.

I made my CDT as multiple but its not meeting my functionality. I am passing name: JOHN and number: 1234 for m_id: 23;24. But the name and number is updating only for first m_id. I want to update the multiple IDs at a time with the given name and number. mul_sampleTable(variable) of Type: SampleTable (CDT) = [m_id=23, name=JOHN, number=1234, archive=0, pid=268439932], [m_id=24, name=, number=, archive=, pid=].

Something I am missing, can any one help me how to update the data for multiple IDs.

As multiple IDs are passing its updating m_id, I also want to update name and number at the same time for the given IDs.

In order to update multiple values of a CDT, the easiest way is, in a script task, set the multiple value to be saved into the CDT[].element.
for e.g. you can save {John, James} --> Save Into cdtArray.name
Repeat the same for others as well. As long as the size of the cdt array and the array size you are saving are same, the corresponding index will be updated with the values you are attempting to save.

@Sathya. What ever you are telling is correct. But I am not passing multiple names, I am passing only one name and multiple IDs. The given name should be updated for selected IDs.

So you want the same name to be appended to all the values of the CDT.name, in that case, use repeat() to create an array of the name multiple times - for e.g. repeat(COUNT(cdt), "John")

Its working. Thanks Sathya.

Sathya, The IN operator in the sql used in Query Database smart service has not seen any improvement in 5 years.  It doesn't work when you just pass an arrray to it like this -

where id_col_name  IN ( ac!ids )

People are doing complicated clauses using the INSTR function which is very very unintuitive and complicated.  What should I do to get Appian to address it?