Discussion Categories

Hello Everyone, I am trying to insert a record which would be using the Write to Records or Write to Data Store Entity smart service to a table that has a trigger at the backend DB. The trigger is for checking for the existence of a particular value in another  table. If the ID being inserted exists in the another table, the insertion will proceed without any issues. If the ID does not exist in the another table, the trigger will prevent the insertion and typically raise an error. So in the second scenario if  the ID is not found, will the write to records execute normally or would it give an error because of the trigger? 

I tried to complete a user's task via Chrome browser by adding a signature using the a!signatureField. But the signature gets disappeared after it's drawn. Does anyone know the root cause and a solution for it?

Currently getting expression evaluation errors in a rule and without resolving the problem currently (no time to at this moment and no issue to client), I am wanting to reduce the number of alerts I receive a day. Like if it errors 10 times in a day, I don't want 10 emails, but one email with all the errors that occurred that day maybe? 

When we execute the API Endpoint to load the data in DB, we get Generic Error Message " 500 There was an error writing to the data store"  Is there a way to capture the Actual Error message and Return it as a message instead of the above? Example:  Details: javax.persistence.PersistenceException: org.hibernate.PropertyValueException: not-null property references a null or transient value Following is the code :onError: a!httpResponse( statusCode: 500, headers: { a!httpHeader(name: "Content-Type", value: "application/json") }, body: a!toJson( { error: "There was an error writing to the data store" } ) )

for example my array size is 3400 in the first write - 1 to 10002nd time write 1001 to 20003rd time write 2001 to 30004th time write 3001 to 3400 How we can achieve this one  can anyone help me out  TIA

hi team. I have a requirement as: I have to create data using some dropdown values and after creation of that data user can delete that data from where that drop data is coming and once data is deleted from frontend then when user tries to edit that created data then error throws as: since value of that dropdown is deleted by the user then while editing how to handle this error please suggest any answer  [mention:b45a4f6a20b14a008e4e0ec732a8bf98:e9ed411860ed4f2ba0265705b8793d05]  [mention:57fc948ec4c44d7fbda6e5509555d197:e9ed411860ed4f2ba0265705b8793d05] 

We have a process where data from a third party system is imported daily into Appian based on a scheduled time of process model. Currently we are using the sync record web service to manage this data transfer. However , we are not using any data base in Appian. we're concerned about the 4 million record limit of this web service sync record. What happens when the record count reaches to the 4 million limit? is there an optimal approach to manage this process in Appian to avoid reaching this limit or any best practices for managing large volume of data with Appian record sync .

I have a Record Type that has 2 Record List Actions.  Web Browser shows both entries and on a Mobile device only the first one displays.  I confirmed this on an iPhone. I also noticed that if you have more than one Record List Action it moves the actions below the filters. Are these expected behaviors? On a Web Browser: On an iPhone:

Hi, I have an interface where I have few buttons. These buttons I have created using a a!buttonArrayLaoyout, a!buttonWidget. Now, when the user clicks on one of the button, I need to calls a "recrodActionItem". Can someone advise how I can do this. Thanks

Hi,everyone I was using Post Method and when I tested with the expression rule, I was able to get 355 rows of data.When i tested webapi only 300 lines are responded from Webapi response. Can I change the size limit or number of lines for webapi?If so, where can I change it?

Hi,  We need to get access tokens from our id provider and we had thought about using a Connected System with the OAuth 2.0: SAML Bearer authentication method but the documentation says:  "As soon as Appian gets that SAML bearer assertion, it decrypts it if necessary and signs the user in. Then, for each Connected System that uses the OAuth 2.0: SAML Bearer Assertion Flow, Appian will immediately pass the SAML bearer assertion (along with the Client ID, Client Secret, Scope, and any Additional HTTP Headers set in the connected system) to the authorization server at the Token Request Endpoint. Appian will always pass the SAML assertion unencrypted" Our id provider requires that scope, grand type and assertion must be provided into the body and we have some questions:  Where does the SAML assertion travel, header or body? Can we get the SAML assertion in some way? Can we move the scope from the header to the body? Thanks in advance

Hi, using local variable, i am calling expression rule, which gives category codes as output, now i neeed to convert this local!updatecategorycodes into array form to use contains() function. can anyone please help me local!updateCategoryCodes:index( rule!CNAM_qeGetUpdateCategoryCodes(), "CATEGORY_CODE", "" ),

I have a requirement to filter negative values from readonly  grid and It needs to get configured from expression rule but Im not able to filter the negative values. I tried using "<" as operator for that particular field but still not filtering out. please help me achieve this

I tried upload the template(Doc) many times after editing those not working fields plenty of times  but still the fields seems like above

Hi All, Why do we get this type of error in Process Model while writing to the data base? How Do I Check this issue in more detail, When  i don't have system logs to check the logs? Can SomeOne Please suggest ,It would be more helpful if anyone replies and Provide me the solution. Thanks In Advance.

Hi all, I have a requirement as: I have table in readonly grid where there are different site we can name it as A1, A2,A3,A4 , B1,B2, B3, B4 and each one has status as pending approval . and there are action button as approve and reject if user click on approve button on A1 status then its status is changing to preliminary approved and button color remains as green and user again click on approve button of A1 then status changes to approved and button changes from green to grey and link gets disbaled when user click on approve button of A2 then status changes from pending approval to preliminary but here button color changes to grey and link gets disabled since A1 is in approved status , it means if any of the sttaus of A is in aproved then any of A status is  preliminary approved then button will turn to grey and link also gets disbaled. now for B1 same cycle goes and if A1 status is approved  and B1 , B2, B3, B4 status is eather pending approval or

All nodes and sub-processes are completed but this process instance somehow got cancelled, can anyone advise what could be the cause?

Geeting this error when used SP that returns datasubset for populating grid. Can someone provide more info on why this issue is coming up. UI Code a!localVariables( local!variableName, local!selectedSource, local!selectedCategory, local!pagingInfo:a!pagingInfo( startIndex: 1, batchSize: 10 ), local!categories:index(rule!OMS_getPreSelectCategories( ),"data",{}), local!sources:index(rule!OMS_getPreSelectSourceTypes( ),"data",{}), local!mdmVariableList: a!refreshVariable( value: rule!OMS_SP_getPreSelectVarsByFilters( variableName: local!variableName, source: local!selectedSource, category: local!selectedCategory, pagingInfo: local!pagingInfo ), refreshOnVarChange: { local!variableName, local!selectedSource, local!selectedCategory } ), a!cardLayout( style: "TRANSPARENT", contents: { a!columnsLayout( columns: { a!columnLayout( contents: a!richTextD

We have created entity backed record using database table. That time length of column was 50 character later we update to 100 but source field is not taking 100 it still shows 50.Anyone knows how to update column length?

Hi All, I have a record type process variable  - MAC User (list), This record type contains the list of users and their information like name, email, last name etc.  I'm trying to create the users within appian with the Create User Smart Service, but since its a list is not allowing and its throwing an error, do I have to do a loop for this? I was thinking the smart service could create more than one user at the time. If looping is the only option - can someone recommend what would the best way? thanks in advance

Hello Folks, I am getting this error while write to Data store entity.:"An error occurred while trying to write to the data store. No values have been written. Details: org.hibernate.PropertyValueException: not-null property references a null or transient value :" Can anyone help me on this? Actually I want one column in a table is non nullable that is also behave as a foreign key. Thanks

Good day experts!  I am attempting to merge two maps and have gone thru many examples from the forum but can't seem to get those solutions to work for my use case. I have two maps that have different key value pairs that I want to merge into one map.  The example in my code shows that the maps are related by participantId.  I was able to get the key and value for one of the keys in the queueMap to update into the participantMap.  However I am struggling with getting all of the keys and values in queueMap to update into the related particpantMap. Here is my successful attempt at just getting the first key value from queueMap to update into participantMap: a!localVariables( local!participantMap: { a!map( participantId: 3402, blockId: 881, policyNumber: "VF80U16350", policyEffectiveDate: fn!date(2023, 9, 25), dateOfBith: null, firstName: "Bill", lastName: " Johnson", middleInitial: "W", ssn: "123456789",

Hi team ,recently I have created a new account to learn Appian again, its a free version, in this I  am not  able CDT, DSE objects and also not able  to create them. Also not able to access the MySQL Database.

a!columnLayout( contents: { a!buttonArrayLayout( buttons: { a!buttonWidget( label: "Next", size: "LARGE", style: "SOLID", saveInto: { if( len(ri!checklists) > 1, { a!save(ri!steps, append(ri!steps, "name")), a!save(ri!nextStep, 3) }, { a!save( local!showAddChecklistErrorMessage, true() ) } ) } )

Hello everyone, Please have a look at below code:local!array1: { a!map(id: 1, name: "Name1"), a!map(id: 2, name: "Name2") }, local!array2: a!forEach( items: enumerate(10), expression: concat("key", tostring(fv!index)) ), here i want to extend array1 map key from array2, which is dynamically generated through array2 and values should be the value of id from array1. so i am expecting the new array would be like this: { a!map( id: 1, name: "Name1", key1: 1, key2: 1, key3: 1, key4: 1, key5: 1, key6: 1, key7: 1, key8: 1, key9: 1, key10: 1 ), a!map( id: 2, name: "Name2", key1: 2, key2: 2, key3: 2, key4: 2, key5: 2, key6: 2, key7: 2, key8: 2, key9: 2, key10: 2 ) } any easiest way to do this. Thanks in advance