Discussion Categories

Hi, In DB we have one date set to 12/31/9999 (MM/DD/YYYY) which is a data source for a recordtype. When this record type is used in one of the site page the recordlist date and time column is display the wrong date as below  Is it somewhere setting max date? Not able to find. Expected Date to display in recordlist: 12/31/9999

Hi ,All My question is that  in the view summary page of Record type, I have add an interface to show the data  in summary view page . So I am fetching data with the rule expression ,and call it in the interface. My problem is that ,all data is showing in the interface but  some data is not showing in the summary view page . Please help me how can I resolve this issue of inconsistency of Data in summary page.

Greetings everyone, I had found a previous post from 7 years ago, however the solution found is not one that works for our use case.  We have a usage monitor application that pulls data from the csv files of login-audit.csv from the shared-logs. Currently, files of login-audit.csv are stored in a folder inside the application's Knowledge Center. I was wondering if there is a method to getting files from shared-logs into Knowledge Center folder. The plugins such as login reader and login information parser would not work in this case as the data is pulling from the folder in knowledge center already. I was wondering if this can be kept intact, and if there is a way to automate moving files from shared-logs to knowledge center. 

Hi,  Has anyone ever had to send an encrypted password from Appian to an external system? In my case, I need to send an encrypted password to RPA (Blue Prism) and I have tried the encryptvalue() function of this Encryption Functions plugin  that uses the AES-256 method to encrypt, but the RPA team is not able to decrypt it from Blue Prism... I had also thought about using the native encryptedTextField() component but I don't know what method it uses to encrypt or how to obtain the key needed to decrypt from an external system. Thanks

a!localVariables( local!array: cast( 97, { { item: "stapler", name: "Mike", countryId: 1 }, { item: "printer", name: "Larry", countryId: 2 }, { item: "laptop", name: "Mike", countryId: 1 }, { item: "glass", name: "Mike", countryId: 3 } } ), local!updatedArray: a!forEach( items: local!array, expression: remove(fv!item,"item") ), local!finalArray: a!forEach( items: local!updatedArray, expression: remove(fv!item,"name") ), local!finalArray )

I need to read and save data from XLS document. I tried using "Export excel to Database" smart service, but it is giving error "???The supplied data appears to be in the OLE2 Format. You are calling the part of POI that deals with OOXML (Office Open XML) Documents. You need to call a different part of POI to process this data (eg HSSF instead of XSSF)???". I also tried to convert the XLS document to CSV document using the "Convert excel to CSV" smart service and also tried to read XLS file in expression rule using fn!readexcelsheetpaging but still getting same error. Is there any way we can read XLS document? 

Hi All, I was wondering if there is a way to limit the number of characters shown per column in a grid. For example, I have a grid that has one column that shows a field called description and its data max character limit is 2000, but in the grid visually I only want to show 500 and then .... if they put their cursor over can see the rest. Is this possible or even something similar, this way the grid looks more harmonic since some data has up to 2000 characters but other ones are only 100-200  and things like that. thanks in advance

What am I missing? Why is it taking weeks to set up Community Environments for new users? Could Appian not create some sort of RPA process to generate them? It's REALLY difficult going through the Developer training activities without an environment.

Any idea why the input value is not recognizing the array? I've tried with/without the comma, but Appian is still saying there is only 1 item in the list.

An Award Record has 3 sections: Section 1, Section 2, and Section 3. Section 1 and 2 combine to serve as a unique identifier. When you edit Section 3 of an Award Record, all of the Awards with the same values for Section 1 and 2 should be updated as well. This process model updates the value for Section 3, but it does not check to see if there are other awards with the same combination of Section 1&2 before writing to the DB. I was told to "build a dictionary in building the CDT before the DB write and write the array". Any help would be greatly appreciated! Thank you

Hi, what is the Appian's Policy for data collection in regard to a company data?  and we have a use case to enable the SSO authentication via Microsoft to login into the site or portal that we made in an application. what is the process for the same?  

I have been unable to find a starting point to the COMPLETE documentation of the Appian expression language (I don't know the correct name as I have not been able to find one). As an example, I found this by searching Google: https://docs.appian.com/suite/help/23.3/expression-advanced-evaluation.html But, this seems to be a random orphan page. I am unable to find a series of pages to which this belongs, and if I start from the menu on the upper left, I don't see how one would encounter this page by navigating that menu. I have found the page with documentation to all the functions, but not a complete FULL documentation to the syntax of the expression language. I would absolutely love to read it in its entirety instead of having vague ideas of what can be done and how it works from random examples. Where can I find this documentation that I seek? Am I overlooking something obvious? Thank you

I have a one to one relationship between WorkItem and Lead where workitemId is a foreign key in Lead. I first create workitem and then pass its id to lead while creating lead. Conditions in table, workitemId is unique and not null. This has been working fine in previous version of Write Record Smart service but in new version it is not working and giving error for workItemId not being there. Lead: {leadId=505, workItemId=2843, qualityScore=4} This gives error: Unable to write to the source due to system error. Error Details: Field 'work_item_id' doesn't have a default value. Note: Same input still works with old version of write record smart service. In logs I see it creates prepared statement without workitemId field:  Caused by: org.springframework.dao.DataIntegrityViolationException: PreparedStatementCallback; SQL [INSERT INTO `PRO_Lead` (`quality_score`, `lead_id`) VALUES (?, ?)]; Field 'work_item_id' doesn't have a default value; nested excep

Hello Community! I have next error after running tomcat: aused by: java.lang.ClassNotFoundException: Unable to load class: org.postgresql.Driver from ClassLoader:java.net.URLClassLoader@326de728;ClassLoader:AppianWebappClassLoader  context: suite  delegate: false----------> Parent Classloader:java.net.URLClassLoader@326de728                at org.apache.tomcat.jdbc.pool.ClassLoaderUtil.loadClass(ClassLoaderUtil.java:56)                at org.apache.tomcat.jdbc.pool.PooledConnection.connectUsingDriver(PooledConnection.java:304)                ... 29 more        Caused by: java.lang.ClassNotFoundException: org.postgresql.Driver                at

Hi All ,  In File Upload Control , I don not want to save the File in Knowledge Center Folder  when User First Upload and then Click Cancel or Close the Tab . What should I do in this case .

Is there a way to alphabetize user filters within a read-only grid? My thought process was to use the a!sortInfo() for the related filter, however using this function has not worked for me. I have spent a few hours searching documentation and have not come to the conclusion I need, so I have decided to ask. 

Hi, I have a requirement for generating barcode or QR Code. At present I am using Barcode Utilities plugin which is available in App Market. But this is not cloud approved. Can anyone suggest me if any other plugin available or any alternatives for this?

Hai, I'm currently creating a Process model for adding employees... I had done all the things... the data also stores perfectly... but the process model variables... shows only the auto generated id... in my colleagues account... it shows all details... I had attached the screenshot of both.

I want to add this (Move Raws Up and Down ) functionality for the editable grid.

I have a process model in DEV that I have modified to use a Write Records node to store the data. The model is running perfectly and the data is being stored into the record and database. Issue is that when I use Compare & Deploy and click on the "Conflict Detected" link to check the differences between DEV and TEST its throwing this error:   If we delete the Write Records node C&D of the differences works. Any idea why its throwing an error?

Hi team, I'm getting this error in a start process node. I'm using a expression rule which will get and merge the date and time from DB and pass it to the don't start this node until this time option. This rule is working fine in other nodes such as xor or in script task. I don't know how to trace the error. If I'm using now() to that delay option it's working fine. Help please [mention:126a676c85024855948336691b0a7b92:e9ed411860ed4f2ba0265705b8793d05]

Hi ,     I have created an interface using rich text field components to display text as mentioned below. Task Details 1. attribute1: Text1 2. attribute2: Text2 3. attribute3: Text3 4. attribute4: Text4 Now the requirement is to generate this text as it is displaying in the interface using expression rule (for sending to another system using rule input). Is there any way or function in Appian to create listed text item like above mentioned using expression rule. Any suggestions would be really appreciated. Thanks in advance. Pradeep.

Hi Team, I need to set a delay to the process model to trigger exactly at 00 clock. Example: If I am publishing a model at 10:36 the delay should be at 11:00 or if I'm publishing at 11:00 it should be at 11:00 itself).The requirement is simple : we keep the time recurrence at an interval of 1hr. So to maintain a proper interval gap, I planned to execute this in the delay, so that for the next time recurrence will be at 00 clock.I need help in this case.Thanks in advance 

Hi All, I have a parent process A where I have wired another process B as a sub process. When I look at an instance of process A, I can see that the start process node takes 11 second to execute (I am looking at the process node > response time in the process details tab). When I look into the instance of process B, I can see that the response times for each and every node does not add up to 11 seconds (adds only up to 7 seconds). I would assume that in this case, the response time for individual nodes should be added up. Does anyone know how does the calculation of the response time is done? Thanks, S

Can we execute VB script in Appian? Is any type of custom code execution possible in Appian? If not what are the workarounds?