Discussion Categories

Hi Team, I am working on the record history of my Appian application.  I created a new table with a similar column in application addition with Modifiedby, Modifiedat, and Operation in order to see create/update and delete history of the application record. Along with the db table, I have created a record type and data type. I have done the entity mapping successfully in the datastore. Now while I am updating the code in create/update/delete interface, I am unable to fetch the data. Below is the code snippet I am updating in submit button to save the record simultaneously in history table as well. buttons: a!buttonLayout( primaryButtons: { a!buttonWidget( label: "Submit", saveInto: { a!save(ri!record['recordType!{031f0b84-9549-4b3a-942c-a8fd3d0dfa62}NH_Handover_History.fields.{b5d840ba-2408-425d-b829-510414356ac2}serialnumber']), a!save(ri!record['recordType!{031f0b84-9549-4b3a-942c-a8fd3d0dfa62}NH_Handover_History.fields.{d7f705b2-c020-47c9-95c4-cbe0e6df18a2

I have a requirement where I have to process, filter and Validate 35-40 MB  data in excel with 100+ columns and if validation is successful then Import the data into Landing table. What could be the best way to design this. We don't have any control on excel to create multiple excel files and upload. It has to be done with all. We are already managing 2K rows with process & validate but Customer wants Appian to do filtering and then process. But After filtering we need to do validation on resultant data after filter and inform user via popup or message in UI.

Hi, Is there a way to show the "user login history" on the interface screen  used by end-users?  I do know that system admin can monitor the "Current User Activity" from [Appian Administration Console > MONITORING > Current User Activity]. But, the needed function is to show the "history of user login". Thank you

Hi, I am using Create PDF smart service to generate a PDF with plain text. Am getting the following error in the Create PDF node. ???contents.error.alertMsg??? Error Text: U+000A ('controlLF') is not available in the font Helvetica, encoding: WinAnsiEncoding Am using the following expression to generate PDF contents a!localVariables( local!text: "Firstname Vikrant " & char(10) & "Lastname Bhardwaj " & char(10) & "Address 100 NW AVE " & char(10) & "City Irving " & char(10) & "Zipcode 12345 "&char(10) & "Country USA",'type!{urn:appian:ps:pdftools}PdfContent'( sections:{ 'type!{urn:appian:ps:pdftools}PdfSection'(   style:'type!{urn:appian:ps:pdftools}PdfStyle'(   font:"Times New Roman"   ), components: {  'type!{urn:appian:ps:pdftools}PdfText'(  value

"Your account is locked because of too many authentication attempts." What shall I do? Can anyone help me please?

Hello everyone We have a requirement where we must group repeated values ​​in a table, that is, as seen in the image, the name of a user appears 3 times, how to make it only appear once /resized-image/__size/320x240/__key/communityserver-components-multipleuploadfilemanager/e7419661_2D00_e8f0_2D00_4b40_2D00_9d0d_2D00_44f18f7d1bd9-92092-complete/pastedimage1672865100983v2.png

Hi, I want to implement  a functionality, wherein I am displaying a button, and on click of that buttton, I am letting user to download a file containing data from the database. I am using exportDataStoreEntityToCsv() smart service to achieve this. But it is a 2 step process, and I am not quite sure how to integrate the download functionality in the button.  Can anyone help me in this ?

Hello,  While attempting to access the site in the browser it continuously spin. Even tried rebooting server and restarting service even though APPIAN was down.   Below is the dump of my tomcat-stdOut.log --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Using CATALINA_BASE: "D:\appian\tomcat\apache-tomcat"Using CATALINA_HOME: "D:\appian\tomcat\apache-tomcat"Using CATALINA_TMPDIR: "D:\appian\tomcat\apache-tomcat\temp"Using JRE_HOME: "D:\appian\java"Using CLASSPATH: "D:\appian\tomcat\apache-tomcat\bin\bootstrap.jar;D:\appian\tomcat\apache-tomcat\bin\tomcat-juli.jar"2021-10-26 16:45:24.778 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Server version name: Apache Tomcat/8.5.502021-10-26 16:45:24.779 INFO [main] org.apache.catalina

Hii,   I have created a read only gird and added my record. So, now I would like to use record action for multiple rows at a same time. Eg. I my grid for now I could able to approve only one row at a time , but now I need to approve them Bulk.

Integration returns: HTTP/1.1 302 Date: Wed, 04 Jan 2023 16:05:55 GMTServer: Apache/2.4.41 (Win64) OpenSSL/1.1.1cX-Content-Type-Options: nosniffX-XSS-Protection: 1; mode=blockLocation: /MyWeb/CreateNoteContent-Length: 0Set-Cookie: MYSESSIONID=ABCXYZ123456; Path=/MyWeb; HttpOnlyVia: 1.1 myserver.dev.comKeep-Alive: timeout=5, max=100Connection: Keep-Alive I want to cal this integration via a link or a button from an appian interface.

I would like to rename the source field name for a field in one of my record types ('source field name' is the field in the database table, holding the record type). In the record type, screen Data Model > Configure Fields, I am allowed to change the record field name (the field name visible in Appian), but the source field name is readonly! In this particular case, I would like to change "workzonecaseid" to "WORKZONE_SAGS_NR": Here's the current situation in MariaDB:

Hello Team, Please, can you confirm if the service_manager.conf file generated in one server will be copied across other server nodes in a load balance setup as highlighted here --> https://docs.appian.com/suite/help/22.3/High_Availability_and_Distributed_Installations.html. The documentation states : As part of a distributed installation, it is a requirement to copy the service_manager.conf file located in /services/conf/ across all machines in the distributed environment, for it is necessary to enable authorized connections to the service manager and the engines across machines. Since running the password script will generate unique password for each server; will a service_manager.conf file generated on one server work for other servers in the load balance setup? Also, will I run the password script on all servers in the load balance setup? Your prompt response will be highly appreciated. Thanks

I want to create a date filter with the following options. 1. This month 2. Previous month 3. This Year 4. previous Year.

Hi, I have created an interface where I am tracking some details which even has a Links column so I have created a paragraph/text field to receive the user's inputs (External URL links), now after the links are inserted, submitted, and saved. I am showing them up on a Record view using the links field > a!safeLink. If one link is updated by a user then it's okay its working fine and opens the window in a new tab see image 1: But if a user is updating more than 1 link then it's not differentiating between multiple links and assuming the entire entry as a single link, I tried using commas, semi color between links but nothing is working, see below: Could someone please help me with this? Best, Mohammed Khaiserulla

Hi in my project there is a requirement to read the polled email data. I used the Poll Email plugin to poll the mail in to the folder. The body is polled with a .EML file extension. The body of the mail is unstructured and I need to poll the body in text format in to a table. Any suggestions??

How to configure smart service "Load CSV File To Database" in process model ?

The team is using the automated import plugin to perform database upgrades. Flyway produces logs that the team can retrieve by pressing the link on the information page that appears after the deployment. Is it possible to retrieve the logs at a later time?

Hi Everyone, I have the requirement where the excel file is to be read by IDP. But I am not sure if IDP can extract data from excel file. Can anyone please help me out if it is possible through IDP or any other alternatives? Thanks, Shubham

how i will use Any type datatype

Plzz suggest me the alternate of getdatasubsetdownloadlinkfromrule

Hi Gurus, The Appian documentation (https://docs.appian.com/suite/help/22.4/record-type-relationships.html )states: If you use a process model to delete a Customer from the database table, any Orders referencing that Customer would have an invalid foreign key. Therefore, the database will either cause the delete operation to fail and nothing will be deleted, or it will delete both the Customer and all Orders associated with that Customer. If the delete operation fails, no sync is needed because data has not changed. If it succeeds, Appian will immediately sync the deletions from both record types. We defined a one to many relationship in the record type and a cascading delete in the database (mariadb) however data in the Orders table is not synced, do I miss something here? Btw not having a cascading delete in the database leaves the Orders records orphaned. Any ideas?

I'm using pp!id of a process instance value as orderId field for my db, As I  thought it is unique for all process instances, but when I checked It was not. I was wondering is it really unique?

Hi community, I have a PPT document, is there any way to convert it into PDF file ? Even converting to DOCS would be fine then I can convert DOCS into PDF easily. Thanks

I am creating a Summery View based on a record with multiple one to one relationships that I want to use to display data in the view as well. However, I can't get the data to show up in the view by just referencing the relationship (although the relationships, and their associated fields, do show up as options when selecting the record field to be used). I can use a!queryRecordType to successfully access the data, but I don't want to have to make a query for each relationship if I can avoid it, since there are about 24 relationships and that would probably have an impact on the performance. I have created a local variable that just tries to call data from a relationship, but all it returns is null. When I change it to call data from the source record it work perfectly. I have also verified that there is data in the row being called, and the relationship works properly when used in the record type (shown in the second image). Below is the local variable that is mentioned above,

Hello, Anyone know how this can be achieved? docs.appian.com/.../High_Availability_and_Distributed_Installations.html Shared files The following directories must be shared across all servers that run that component. All servers that run the given component need both read and write access to these directories. omponent Name Folder Name Application Server APPIAN_HOME/_admin/accdocs1/ Application Server APPIAN_HOME/_admin/accdocs2/ Application Server APPIAN_HOME/_admin/accdocs3/