How to update row in view

Did you consider using the data fabric feature in Appian instead of a view?

This is what ChatGPT thinks:

CREATE ALGORITHM=UNDEFINED SQL SECURITY DEFINER VIEW `ISR_v_MeetingProposals` AS
SELECT
    `mjs`.`meetingId` AS `MeetingId`,
    `mjs`.`studyRequestId` AS `StudyRequestId`,
    `mjs`.`sortOrder` AS `SortOrder`,
    `sr`.`referenceNumber` AS `ReferenceNumber`,
    `sr`.`studyTitle` AS `StudyTitle`,
    (SELECT GROUP_CONCAT(DISTINCT `ta`.`name` SEPARATOR ';')
     FROM `ISR_TherapeuticArea` `ta`
     WHERE `ta`.`therapeuticAreaId` IN (
         SELECT `srt`.`taId`
         FROM `ISR_j_StudyRequest_TherapeuticArea` `srt`
         WHERE `srt`.`studyRequestId` = `sr`.`studyRequestId`
     )) AS `TherapeuticArea`,
    `c`.`name` AS `countryName`,
    `c`.`code` AS `countryCode`,
    `cc`.`code` AS `currencyCode`,
    `ss`.`totalAmountRequested` AS `totalAmountRequested`,
    `ss`.`convertedTotalAmtRqsted` AS `convertedTotalAmtRqsted`,
    GROUP_CONCAT(DISTINCT CONCAT(`srp`.`firstName`, ' ', `srp`.`lastName`) SEPARATOR ';') AS `PrimaryInvestigator`,
    `sr`.`medicalScientist` AS `medicalScientist`,
    `sr`.`researchType` AS `researchType`,
    `sr`.`mastSlideDocId` AS `mastSlideDocId`,
    `mp`.`primaryReviewer` AS `primaryReviewer`,
    `ma`.`adhocReviewer` AS `adhocReviewer`
FROM
    (
        (
            (
                (
                    (
                        (
                            (
                                (
                                    `ISR_j_Meeting_StudyRequest` `mjs`
                                    LEFT JOIN `ISR_StudyRequest` `sr`
                                        ON (`mjs`.`studyRequestId` = `sr`.`studyRequestId`
                                            AND `mjs`.`isActive` = 1
                                            AND `sr`.`isActive` = 1
                                            AND `mjs`.`mastDecision` NOT IN ('MASTNODIS', 'MASTTAB'))
                                )
                                LEFT JOIN `ISR_j_StudyRequest_TherapeuticArea` `srt`
                                    ON (`srt`.`studyRequestId` = `sr`.`studyRequestId`)
                            )
                            LEFT JOIN `ISR_TherapeuticArea` `ta`
                                ON (`srt`.`taId` = `ta`.`therapeuticAreaId`
                                    AND `srt`.`studyRequestId` = `sr`.`studyRequestId`)
                        )
                        LEFT JOIN `ISR_j_

Hi stefen,thanks for the update .where to update this code in view.could you please help me ?

I am not sure how to read you question ...

Do you know what database views are and how to develop one? In case you have some very generic questions, I suggest to first learn that skills. Database views are NOT a feature in Appian but the MariaDB database.

I want to apply the above functionality to view in MariaDB database of appian

Here you can find the documentation for the included database

https://docs.appian.com/suite/help/23.2/appian-cloud-database-administration.html

I am still not sure what your actual question is. If you are not familiar with database views, learn that first and then return.

Hi sfefan,thanks for the information.Actually my question is to add group_concate functionality to view ,currently one of the field in my view fetching a single value instead of fetching all the values that are linked to it.

I already tried to answer this question.

Before doing a group concat in a view, are you certain you can't use a record type for the tables? This can be done with a customRecordField.

Otherwise, if you need help creating database views, I would suggest you take a look at ChatGPT or some other resource. Tons of help available online.