Skip to main content
October 9, 2023
Question

Write Records smart service

  • October 9, 2023
  • 4 replies
  • 0 views

Hi,

I noticed that in write records it only saves primary key, what if i want to use other fields in next set of forms do i have to query record or there is a way ?

Regards 

Chandra

    4 replies

    stefanhelzle0001
    Brainy
    October 9, 2023

    Yes, you need to add a separate query to fetch the data. I described that in my blog post: https://appian.rocks/2023/08/30/appian-233/

    raul.cancino
    October 13, 2023

    Hi Stefan, ¿do you know the why for this abrupt change on Write records smart service? one of the attractive things about that smart service use to be that you don't have to query again 

    My scenario looks like this:

    Case

    ->Documents

    ->MIlestone

    ->->Workflow

    ->->->Task

    we really need a OOTB (or generic ER on the blog?) function that merges the returned keys in updated record with the records i have in memory after i write the record and related records, so i don't have to query again all of the hierarchy

    Regards

    Raúl

    stefanhelzle0001
    Brainy
    October 13, 2023

    I had a conversation with some of your colleagues in which we found out that this is a difficult matter and has no final perfect answer. So the current solution is considered the best approach for now.

    rishikeshr4182
    October 10, 2023

    Yes, chandra, as per the new version 23.3, we  will only get the primary key through the output. So if you want to use the same, you will need to query.