How to query Record Type by Comparing Record Type field and Relationship field?

Question

Hi,
Could you please help me with the below requirement

Sample Table and Data

RequestTable
id name       email                 createdOn            createdBy1    N1   n1@mail.com 2020-07-27 13:15:30 n1@mail.com2    N2   n2@mail.com 2020-07-27 13:15:30 n2@mail.com3    N3   n3@mail.com 2020-07-27 13:15:30 n3@mail.com4    N4   n4@mail.com 2020-07-27 13:15:30 n4@mail.com2    N5   n5@mail.com 2020-07-27 13:15:30 n5@mail.com
Conversation:
id  reqId    message       sentBy 1    1            Xyz         n1@mail.com2    1            abc         reviewer1@mail.com3    1            pqr          admin@mail.com4    2            xxx          reviewer2@mail.com5    2            yyy          n2@mail.com6    2            zzz          n2@mail.com

I want to get the Conversations which are not sentBy the same user of that particular request
Below is the SQL query:
SELECT b.* FROM RequestTable a join  Conversation  b on(a.id=b.reqId) where a.createdBy<>b.sentBy and a.id=1;
Output:
id  reqId    message       sentBy2    1            abc         reviewer1@mail.com3    1            pqr          admin@mail.com

I wanted to know how to achieve it in Appian using Record Types

Thanks

sriramk5349 · Answer

Hi [mention:863e5dee5cf148d0961cf1608a7e6158:e9ed411860ed4f2ba0265705b8793d05] ,you can use relatedRecordData parameter in a!queryRecordType() Function - Appian 24.2.

Sign up

Login with SSO

Login to the community

Login with SSO