Discussion Categories

Hi there. Related to the best practices, wich is the best way to call to an interface rules on my interface? Calling the interface rule on a rule input, Using keyword syntax or Always use consistent ordering of rule parameters? Thanks in advance.

I want to change the field name of a CDT to match the renamed field in the database. The old name was "FIRSTNAME" and the new one is "FIRST_NAME". Related to the best practices, the best way to do so is to download the CDT as XSD, change the field name in there, and re-upload the XSD, verify and publish the data store as a last step or is there any other best practice thing? Thanks in advance.

Hello Everyone, I am using another client’s SFTP server for demo purposes, which uses SSH key pair authentication with a private key that works in FileZilla. I have created Third-Party Credentials in Appian using the username only and uploaded the private key along with a constant associated with it. Here is my File Transfer Configurations CDT: 'type!{plugins.ps.appiancorp.com/.../}FT_Config'( serverHostName: "xyz.com", serverPort: 22, scsExternalSystemKey: "aws-cmd", usePerUserCredentials: false(), privateKeyFile: tointeger(cons!MS_SFTP_USER_PRIVATE_KEY_FILE) ) I am getting an error: invalid private key: [B@5bbde572. I know the private key works fine because I have used it in FileZilla.

Can I add hidden record fields if data sync is NOT enabled on a record type?

I have two records. I prepared the data attached. The records are: one is LTM GROUP and the other is LTM USER. Both are related records. I have heard that we can store data in the base and related child record in one shot. As GroupId is the primary key in LTM Group (autogenerated), plus LTM User has a foreign key named userGroupId, and obviously, this table also has a primary key userId which is autogenerated. Can you please help me with storing data in tables with the help of writing records in a single shot? /*Group*/ { recordType!LTM GROUP( LTM Group.applicationkey : 1, LTM Group.appiangroupkey : 25, LTM Group.name : "Admin", LTM Group.updatedby : "rt343", LTM Group.addedby : "rt343", LTM Group.dateadded : fn!date(2025, 2, 25), LTM Group.disabled : false ), recordType!LTM GROUP( LTM Group.applicationkey : 1, LTM Group.appiangroupkey : 26, LTM Group.name : "RTR User", LTM Group.updatedby : "rt567", LTM Group.addedby : "rt567", LTM Group.dateadded : fn!date

If the task is assigned in process model and it is still in pending and it arrives archiving time then the process will be archived or not 

Hi Team, I need to fetch data from a GraphQL API endpoint, but I'm unsure about the connected system required for the connection. The client has provided the ClientId and ClientSecret for AWS Cognito and mentioned that they are using SRP (Secure Remote Password) Authentication. However, I'm not sure what additional information is needed to establish the connection to the GraphQL service. Can you please provide more details?

I'm getting the error 'JAXB failure trying to convert value ProcessInfo{.....} to Appian type ProcessInfo (id=xxx)' when using the Start Process node in a process model. Does anyone know what may have caused this issue?

Hi, I have section of questions using 15 fields of a cdt (cdt has total 30+ fields).  Based on a dropdown value change, I want to make all 15 fields to null.  Is there any way I can make all 15 fields to null in one go, instead of writing 15 a!save.

Hi All, Hope you all are doing well, quick question, is it true that using a!queryEntity can skip the Record Type synchronization? I'm facing issues in my application cause I have an after insert trigger that is inserting a record based on some conditions, but the new record inserted is not being reflected in the application until I manually click Start Full Sync, wondering how can avoid this issue. By the way the version that I have is 23.4 Any help would be greatly appreciated. Thanks in advance, Jose Castellot

Hello, We had recently updated the SFTP Functions plugin to v3.0.2. After the update, the SFTP Send File smart service is failing with the error "Auth fail". Third-party credentials are setup and have not changed. The plugin has access to the third party credentials. The FT_Config CDT has got updated (due to the plugin update) and has the below structure: Smart Service Inputs: We are passing the values to the smart service as below:             File Transfer Configurations: 'type!{plugins.ps.appiancorp.com/.../}FT_Config'(             serverHostName: cons!SFTP_HOST_NAME, (text)             serverPort: cons!SFTP_SERVER_PORT_NUMBER, (integer)             scsExternalSystemKey: cons!SFTP_EXTERNAL_SYSTEM_KEY, (text)             usePerUserCredentials: false(), (boolean)             pr

Hi,I want to add an dollar icon inside the floating point field or a text field, How can I achieve this?If the above one is not possible then, How can I add the Dollar Icor right before the field?Thanks in advance.

Hi Team, I need to fetch data from a GraphQL API endpoint, but I'm unsure about the connected system required for the connection. The client has provided the ClientId and ClientSecret for AWS Cognito and mentioned that they are using SRP (Secure Remote Password) Authentication. However, I'm not sure what additional information is needed to establish the connection to the GraphQL service. Can you please provide more details?

Hi Team., I have made changes in the DB for the column size changes, but in the Record type is not getting reflected in RT, or is any modifications need to be done here. note: no CDT used in the application only RT. thanks.

User uploads the word file with number of screenshots to APPAIN using file upload component in an interface, but some of the images in the word file is missing and facing the blank space in the place of image, what might the cause for it.

Hi, Am unable to use aggregate functions on child CDT having many to many relationships with parent CDT. Background I have a parent CDT called Campaign which has many to many relationship with child CDT called Channel. I have Campaign table, Channel table and mapping table as well to hold the relationship in database. Requirement I need to group the Campaigns based on Channels. Issue I am unable to use Aggregate functions on channels field in my Parent CDT - Campaign. How can I achieve this using CDT relationships. Thanks  

todate function subtracting date with day minus one day

We are importing the SCIM User Management application provided by Appian on the market place:  [mention:f8e98d7fbd7245cbb0e4083fc4357870:f7d226abd59f475c9d224a79e3f0ec07]  The locale for that application is en_US. The locale for our Appian server is GB. We get the following error when trying to import:  Problems (1):processModel 0002e9c5-4ae7-8000-558d-3a4d983a4d98 "{en_US=SCIM Deactivate User}": An error occurred while creating processModel [uuid=0002e9c5-4ae7-8000-558d-3a4d983a4d98]: com.appiancorp.process.validation.ValidationException: Process Model is not valid. The process model must have a valid name in the site primary language: English (GB). (APNX-1-4071-007) How are we suppose to import applications if they are for a different locale? Thanks

My requirement is to know the process model status i.e. i wanted to know all the process models that are failed so that i can use them to trigger some api. As per current approach, process model either completed or failed with errors both are giving me status as 0. How can we create the difference. Please guide

Hi team, I am fetching data from database for KPI and the field names that are showing on y axis taking lot spaces can anyone help in this. Requirement: "New product Development" field   Name taking lot of space and  the field name is dynamic it may be 20 characters or 30 characters. How can I restrict space on y axis

Hi Team,Could you please check and suggest a solution for below issue?Expression evaluation error in rule 'appian_rule1' (called by another rule 'appian_rule2') at function a!queryRecordType: Cannot invoke "Object.getClass()" because "activeProcessCount" is null

Hi, Is there a possibility to connect Appian Cloud Database from outside. Thanks, Sadhu Surendra

Hi all, I am facing an issue related to data being refreshed in read-only grid. The issue is in my read-only grid, I have navigated to a different page say 21-30. But after certain interval i.e., 30 sec my grid page navigates back to 1-10 automatically. I have a configuration of refresh Interval of 30 sec in the read-only grid. Does the grid refresh configuration update only the grid data or it also impacts the current fv!pagingInfo of the grid? Reason to add refreshInterval was to update the grid data for user as soon as a new work item is created. BTW the data field is a recordtype which allows me to use certain other features of grid.

Hi, Can I have a button inside of a dropdown?  Thanks in advance

Appian Family,  Here is my Interface -- JR_InterfaceName 1) File Upload field in an interface >> Define the Target Folder with all correct permissions. 2) Submit Button: "submit" set to true. I have 2 scenarios here 1) Just the interface by itself is just working fine when I upload the file and click submit. It gets save to the target folder. 2) When the same interface is either called from another interface as rule (rule!JR_InterfaceName) it doesn't work. The file is not saved to the target folder. I am pretty sure the document object is there but it's just not available to either save in a target folder or for anything else. What is it that I am missing? is it an Appian shortfall/Issue? I am assuming that this is very basic need for almost everyone. 3) Just to play around further I called a Process Model using "saveinto" property of the button passing some dummy variables and the Document Uploaded from the upload control, The PM got call