I'm trying to link to a service-backed record in a Post System Event to Feed

Chris over 9 years ago

I'm trying to link to a service-backed record in a Post System Event to Feed node, and having difficulty for some reason. Per the documentation I'm using (what appears to be) the same ID field in both the Record Tag and dataSubset returned in the source expression. fldID is the unique identifier in my table and what I am trying to use here, but for some reason this is not creating the link. This was working fine before I converted from a entity-backed record to service-backed. Am I missing something here? I'm assuming the documentation "ID field of the dataSubset" is referring to the "identifiers" parameter? forum.appian.com/.../System_Functions.html

Record Tag:

=a!toRecordIdentifier(cons!SIR_RECORD,pv!CDT_SoftwareInstallRequest.fldID)

Data Subset:

a!dataSubset(
data: local!data,
identifiers: index(local!data, "fldID", {}),
startIndex: index(local!queryInformation.pagingInfo, "sta...

Discussion posts and replies are publicly visible

0 Chris over 9 years ago

...rtIndex", 1),
totalCount: index(local!queryInformation.pagingInfo, "totalCount", local!maxSize),
sort: index(local!queryInformation.pagingInfo, "sort", null),
batchSize: index(local!queryInformation.pagingInfo, "batchSize", local!maxSize)
)
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Chris over 9 years ago

Note the dataSubset returned is via a queryEntity() call to the DB, fldID is the @Id (PK) in the table.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Mike Schmitt
Certified Lead Developer
over 9 years ago

Can you try running the rule in expression editor with a manual fldID number and see what happens?
I.e. a!toRecordIdentifier(cons!SIR_RECORD, 1)
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 PhilB
A Score Level 1
over 9 years ago

I've seen something similar to this issue before and had to cast the IDs to string - might be worth a try?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Chris over 9 years ago

Thanks guys. Testing out a hard coded entry with an expression rule shows success for both integer and string values, a!toRecordIdentifier(cons!SIR_RECORD, 1), etc. However updating with tostring() in the process model seems to work! Good thing to watch out for, apparently a!toRecordIdentifier() is a little buggy with service backed records since it claims to accept any type for ID. Working:

=a!toRecordIdentifier(cons!SIR_RECORD,tostring(pv!CDT_SoftwareInstallRequest.fldID))
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel