Discussion Categories

I'm getting the errorExpression evaluation error at function a!recordActionField [line xxx]: Cannot compare incompatible operands of type Null and type Boolean.I'm not sure why this is occurring.Code: a!gridColumn( value: a!defaultValue( value: ri!recordActions, default: a!recordActionField( actions: { a!recordActionItem( action: relatedAction1, identifier: fv!identifier ), a!recordActionItem( action: relatedAction2, identifier: fv!identifier ), a!recordActionItem( action: relatedAction3, identifier: fv!identifier ), a!recordActionItem( action: relatedAction4, identifier: fv!identifier

We have several Appian applications with records backed read-only grids which our business users can quickly search, filter, page through to access record instance data. One of the main gripes (over the years) with Appian is that while paging and taking an action on a record, the user has to page back through a series of data sets to arrive where the user initially started the action from. Honestly, it's a bit surprised a paging cache feature hasn't made into a default platform offering in Y2024 but would the Appian community be able to provide examples of how we can implement a "cached paging paradigm" to improve user experience. It's definitely a slight annoyance platform-wise but I'd prefer to hear your opinions and implementation thoughts on how best to improve a one-less-click experience.

Hi All, We are looking to grant read-only access to users along with access to monitoring tab. Is there a way to achieve this? Does Appian even allow this? Thanks in advance

While receiving file using smart service "Receive File Over SFTP", I am getting error as "Error copying the remote file to disk. See application server log for more details. Error Message: The message [filename] is not extractable!". It worked fist time and from 2nd time I am getting error. Also I tried next day but still getting same error. I am using plugin "SFTP Smart Services" with version 2.2.1. Can you please suggest solution on this? 

I'm looking to configure a filter in a!queryRecordType() that's similar to checking for null values on the outer side of a relationship that behaves like an outer join. For example, I have a data structure as described below. The table Invoices is managed by an Appian application and we have a synced record type based on that table. The table SAP Documents is updated by an external source and we have another synced record type based on that table. There is a many-to-one relationship configured in our record type from Invoices.SAP_DOCUMENT_ID to SAP Documents.SAP_DOCUMENT_ID. Invoices ID (PK) a bunch of other fields SAP_DOCUMENT_ID (FK) SAP Documents SAP_DOCUMENT_ID (PK) a bunch of other fields I need to query the Invoice records and return those where there is a value in Invoices.SAP_DOCUMENT_ID and where there is no corresponding row in SAP Documents - and I need to combine this with some other query filters, so this is not the only co

Currently we have a site that has several pages at the top in the Header bar. However, one user is unable to see these pages unless they are in incognito mode indicating this is not a permissions issue on Appian's end but a chrome setting that must be hiding these tabs.  We tried opening the site in both chrome and edge and both fail to load the site pages. The whole Navigation bar shows up for that user including the Logo, we are just unable to see the site pages at the top. I am Creating a post to see if anyone knows of this issue and a potential fix?  Thank-you so much for your time. 

what is the main difference and what to use where

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"}))

How to convert Unicode characters to emojis. Our process saves the emojis to Cloud DB as "utf8mb4_general_ci". I want to show them as emojis on the richTextFieldWithTables

Hi I am using PDF from single Docx ( with fonts ) to generate PDF from a docx document. Everything is working fine, i.e. the pdf is generated and can be opened. But there is 1 small issue wherein the generated pdf  document is not showing bold characters. I have also attached the Arial Bold TTF file to the smart service ( since all my text is in Arial ) but still there seems to be difficulty in displaying bold characters Docx Document containing bold characters  Generated PDF  If you see the table heading as well as table column headings are not in bold in the pdf but the word doc seems to have bold text  Can anyone please help me to get the text bold ?

Hi  I am using PDF from single Docx ( with fonts ) to generate PDF from a docx document. Everything is working fine, i.e. the pdf is generated and can be opened. But there is 1 small issue wherein the generated pdf  document is not showing bold characters. I have also attached the Arial Bold TTF file to the smart service ( since all my text is in Arial ) but still there seems to be difficulty in displaying bold characters Docx Document containing bold characters  Generated PDF  If you see the table heading as well as table column headings are not in bold in the pdf but the word doc seems to have bold text   Can anyone please help me to get the text bold ?

Hi I am using the PDF from Single Docx ( With Fonts ) Smart service to convert my docx file to PDF. Everything is working fine, my document is getting generated and all, but there is one issue i.e I am not able to display text in bold even though the docx have the text in bold. I tried including the Arial Bold ttf font file to the smart service, but it doesn't seem to work ( I had attached arial bold file because my entire contents in the docx file is in Arial font and I have made some parts of it bold )  Docx File with bold text :  The generated pdf :  If you see the heading of the table as well as table column headings are not bold  Can anyone help me understand how to make the text bold ?

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