Discussion Categories

Hi folks! Good day!! I am facing one issue while configuring the record directly in read-only grid and configure the recordActions But while clicking the Add new role button and clicking the Create or cancel button, I am facing the below issue. Note: This will work properly in the Record under the Tempo site. Could you please help me with this?

Hello, I am new to Appian and have a requirement to create grid columns dynamically based on the data available in the database. I need to generate these columns dynamically according to the available data.Thank You..!!

I need some help with datefield masks, i'm trying to input the date 15062000 and i need that the text be corrected to 15/06/2000.How can I do that? Keep using dateField

I accidently delete the current version of a PM but dont't load & save the last published version again of the same PM. So if this PM is referrred in a constant & that constant is used in some Start Process nodes. So in this case does this start process node is having issue to start because of this below mentioned issue.

I'm querying from a datastore, I only need one column, how do I give the column name in field

Hi I have below code: when i am clicking on add row link value is getting save in CDT structure but not displaying added row in design preview what is wrong in that?

Dear Community, I have created a simple interface (csr_ui_requesttask_userfiltersui in this example) that has a list of Map as rule input (inputRecordSets in this example). The structure of the Map (list items) is as follows (attributes) a!map( labels: { "Option A", "Option B", "Option C" }, choiceValues: { "Value A", "Value B", "Value C" }, selectedValues: { "Value B", "Value C" } ) The idea is to have a reusable interface that will display a multi-select drowdown box for each list item. Dropdown item choice labels, choice values and initially selected options (values) will be provided by the labels, choiceValues and selectedValues attributes. For example, when I call the expression rule from another interface and pass a list consisting of two items (two maps), two dropdown boxes should be displayed. This is the code of the interface: { a!columnsLayout( columns: { a!columnLayout( contents: { a!forEach( items: ri!inputRecordSets

Hi all,We are using record type PVs in our process model and passing the same to user input task. In the task, we are updating the values and after submit is clicked, we are updating the variables to database using write to records smart service. But when we are doing the same, the values are getting updated in pv level, but not getting updated in database. All configurations are correct inside the process model. Not sure what is the gap in this? Please provide your insights.

Hi All, We are using "write to data store entity" smart service for storing the data into the database and getting the below error and there are no unique constraints declared in the XSD and Table. Below are the two requests which occurred while executing the smart service Error 1: An error occurred while trying to write to the entity "VT_TASK_MASTER" [id=99aa89ed-622b-477f-9671-2c22df01831b@1429, type=VT_TASK_MASTER (id=3112)] (data store: VT Tables). Details: org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update: java.sql.BatchUpdateException: ORA-00001: unique constraint (APPIANBUSINESS_PROD.SYS_C0059560507) violatedData: TypedValue[it=3113,v={{<null>,43,Initiation,initiation,1,Employee,User(s),7,1,ltideploymentAccount,2024-08-05 14:47:12.64,,<null>,1,[Group:1261],0}}] Error 2: An error occurred while trying to write to the entity "VT_TASK_MASTER" [id=99aa89ed-622b-477f-9671-2c22df01831b@1429, type=

Hi Everyone, If the user is assigned more than 1000 tasks and if his account gets deactivated and he left. How can we reassign to those assigned tasks or what will happen to those tasks.

Hi All, I am facing a weird issue. I have removed myself from the group and is not part of whether direct or indirect. When I execute isUserMemberOfGroup function, it gives true. Can anyone please help me out.

hi team, I am working on interface, i wanna delete one text field but mistakly it goes in "viewing read only"mode. how do i remove it and make text editable. thanks, kiran

for list of data have to execute the one subprocess foreach data in list how can we configure without subprocess here for each integer am executing the sub process, can we configure that in the same PM 

I'm using the Query Database smart service to connect to an external database. I've set up the connected system correctly, but when I run the process model, it doesn't work as expected and doesn't show any errors. However, when I use the Execute Stored Procedure smart service with the same connected system, it works fine. Can you help me understand why the Query Database smart service isn't working?

I am facing the issue while trying to get the below mentioned logic through subtractdays() function. logic: we need the value i.e. current date - 74 days used expression:  subtractdays(today(), 74) error found:

I have followed the document as described but getting the following error when running in debug mode: Even the sample application provided has the same issue. My Interface is configured as follows: Up to this exercise everything seems to have worked as expected. I tried changing the rule input in the interface to Vehicle which resulted in a lot more error messages. I deleted the process model and generated a new "Create" process model automatically. Any help to get working would be greatly appreciated.

I am querying a record to fetch two fields jurisdiction and lineofBusiness and displaying in a read only grid,Currently I am getting data like this but I want to display only one row,which will have jurisdiction as 44 and all the three line of business in a single cell of column Line of Business

I am querying one record and aggregating two fields name and hobbies.I want to display all the hobbies in a single cell for a name ,in a single row in the read only grid.For Example Name Hobbies Ram Playing dancing cooking Please help with this,how to achieve this example

Hi all [emoticon:c4563cd7d5574777a71c318021cbbcc8] What is the easiest option these days to deploy specific applications between two environments (both cloud instances) daily and automatically and on a schedule? Preferably without downloading applications onto a server or an employees device. We want to back up our applications from Environment A to Environment B daily at say 23:00 without manually doing a Compare And Deploy.  What do you use? Many thanks,Uel

Is Azure Database for PostgreSQL or Azure Database for SQL Server supported for Appian Self Managed Instance deployed in Azure? If not, what is recommended approach for Appian Self Managed Instance deployed in Azure. My customer preferred Azure native PaaS Database. I could not find it in the following list.

Hi Team, I have a requirement where I need to post data from process model. We don't have any interface to keep the integration in save into parameter , so we need to run it in process model itself. After posting the data, we will get some id in response where I need to use the id in the next node. I was trying to fetch the id from the response and I am not able to do it as when I am calling it in expression rule or script task the response is getting considered as "reaction tree". Can anyone please help me how can I achieve my requirement.Thanks in advance!!

We have a requirement to save login-audit.csv files into the database and show them in grid format. The problem is that the files older than 1 month are saved in 'gzipped' format and I am unable to access them using 'Log reader' plugin. I thought of an approach that includes saving these files into appian and then unzipping them for further processing but I am unable to save them.Any help is much appreciated.

Import Excel to Database  Plugin -  we are importing the data with this plugin and using the latest version of it, but in the new version we are seeing one issue,  Excel headers and Table columns name required  to keep the same, for example  CONTACT_NUMBER(Excel template)  = CONTACT_NUMBER(Table column) then only plugin is going to work. but user's file header with Contact Number not CONTACT_NUMBER.  is there any alternative way to have headers with camel case and the logical wording not the table column name in the template like CONTACT_NUMBER or any way to edit the template headers after upload and to make change in header from Contact Number->  CONTACT_NUMBER(Excel template) to match table column name?

I have a scenario. I have a parent folder ID and inside the parent folder there is may folder. And inside the folder there is many sub folder. Now I have to find out a specific subfolder ID withe help of  parent folder ID. Please suggest. Thanks!

Hi Guys, I Have a requirement where the user will enter the date&time(date&time component) and the timezone(given in the dropdown). I want it to be converted based on the timezone user has given which in turn has to be converted again to GMT and be stored in the database, but in the screen level i want to display whatever the user has entered without any conversion. Is this achievable ?