Discussion Categories

Hi, I want to know how to create " Functions" & "Procedures" section in custom Database not the in-built APPIAN one. We have created our own custom DB for our APP  Using Appian 22.3 Regards Bihitak

Hi All,I have a scenario, say, for example, I have 20 rows in the paging grid, based on a condition I need to hide a few of the rows in a Grid.

Is it possible to read a password protected excel? I tried using function readexcelsheetpaging() as below readexcelsheetpaging(  excelDocument:<<doc>> sheetNumber:0, pagingInfo:a!pagingInfo(1,-1),   password:"ABCD@1234") However, I am getting error: Expression evaluation error at function 'readexcelsheetpaging': The passed parameter(s) are of the wrong type. Received the type com.appiancorp.common.xml.JaxbConversionException: JAXB was not able to produce a value for typed value TypedValue[it=3,v=ABCD@1234] as java class java.lang.Integer.

Hi friends, I got a chance to interact with [mention:115d03e07c2843c691ef69b0951c7286:e9ed411860ed4f2ba0265705b8793d05] on my podcast and she has explained a lot of things related to the Appian Community that should be very useful for all my fellow community contributors. The discussion includes topics like -  The solution to spams in the community Big plans with the Appian community  And the upcoming problem with the Appian World 2023 Live build challenge. Find it here - https://www.youtube.com/watch?v=PDiFsvfYWWY

Hello. I have and component(card layout) shown in the interface using showWhen() function, and want it to disappear after 30 seconds. I thought of using the showWhen() function and refreshInterval of refreshVariable, but couldn't make it work. I'd appreciate it if you could let me know if there is a way to make this possible. Thank you.

Hi All, I need to extract the process completion date of process instances  which has been archived. Is there any way that I can extract the archival processes in report. Regards, Vikram Kumar Singh

Hi, There is an issue i am facing with query databse smart service, Where i am executing a stored procedure which fetches data from multiple tables and insert same data to a table. - It works if i execute the stored proc with same parameters by SSMS(SQL Server Management Studio) - By Query Database Smart Service it sometimes gives me error -  The amount of time allocated for the completion of an unattended activity was insufficient to allow the activity to complete. attached screenshot for reference Thanks 

Pls answer the below question How to Send email to multiple recipients in Appian?  Thanks in Advance!

Hello everyone, Is there a plug-in, or an option in Appian, to implement a RFC 3161 Protocol compliant external Time Stamp, when applying a Digital Signature to a PDF document? The Timestamp should be embedded in the PDF document itself. There should be a possibility to choose the Hash algorithm which can be one of the following: SHA1 SHA256 SHA512 MD5 Any help is appreciated.

Hi Can anyone help me to understand what is in below screenshot?How can I delete the data in db in this case, I wanted to delete product table row and corresponding rows from Product quantity table which is having pId = Product table ID Product table -  ID, pName Product_Quantity_table - ID,pId(foreign Key),Quantity

Hi All,      Pls answer the below question Users accessing and editing the same record at the same time, race conditions may occur when writing to the database. what is the resolution for that  For example: Users A and User B access a customer record of Customer Corp. at the same time. They both then start a related action to edit the company’s address and they will both see the current address that is saved. If user B submits their edits after user A, user B’s input will overwrite user A’s input (last save wins).  how to resolve that  Thanks in Advance!   

Hi <Summary for the current situation> 1. In "Data Source Management" of "Appian Admin Colsole". The existing "Name", "Type", and "Connection String" are maintained, and only "Username" and "Password" are changed and applied.      ex) previous username= appian1, changed username= appian2            (previous schema= appian1, new schema= appian2) 2. In this case, the problem that arises is, the previously created CDT continues to look at the previous schema (appian1).          (The following error message appears.) 3. I don't see a way to change the schema anywhere in the CDT object or XSD file. 4. Is there a way to change the schema of CDT, or is there a way to solve the situation? Thank you

Hi All,  I am working on a use case where i need to first convert CSV to excel then import converted excel with extra column to a staging table.  Reason to use import excel to database intend of directly using csv to database is i need to dynamically add process instance id in staging table. I didn't find any option to achieve same in CSV to Database.  CSV to excel is working fine. I am able to generate XLSX file and passing it to import excel to database. My process is getting completed successfully but i don't see data in staging table.  I tried converting csv to xlsx in my local machine and used locally converted xlsx in process model, it worked but same when i am trying to achieve from CSV to excel smart service generated excel, data is not getting imported. I don't have auto generated column in my XLSX file. Please advice what can be done resolve this issue.  Thanks in advance for your help. 

Hey Guys, i just want to write a rule expression. wrting(create) data to the database using record type. the record type is already synced with the database. I can not figure it out. i also tried using Write to record smart serice but  i keep getiing error that i can not use record type.  how is something so easy so difficult to find solution. please help. i just need a a expression structure for writing data to the database using record type

I am currently having issues while working with a one-to-one nested cdt design (without reference data).  I have simplified this problem by creating the following 2 tables: CREATE TABLE TEST_PARENT(parentId INT PRIMARY KEY AUTO_INCREMENT,parentName VARCHAR(50)); CREATE TABLE TEST_CHILD(childId INT PRIMARY KEY AUTO_INCREMENT,parentId INT,childName VARCHAR(50)); ALTER TABLE TEST_CHILD ADD CONSTRAINT FOREIGN KEY(parentId) references TEST_PARENT(parentId); While trying to publish the nested CDT TEST_PARENT with the following configurations: I am receiving the following error: The repeated column error does not make sense to me as the columnName defined in the second screenshot is the foreign key column on the child table which is pointing to the parent.  I am struggling to get this to map properly and get around this error and would appreciate any assistance.

Hi,We are getting below error when trying to read document from MFT folder. It was working fine and suddenly breaking.[Appian Work Item - 245513 - WorkID 6 - execution02 - process 537248294 - model 8379 : UnattendedJavaActivityRequest] ERROR com.appiancorp.process.engine.UnattendedJavaActivityRequest - An error occurred while executing activity: id=536905115, classname=com.appian.ps.plugins.sftpsmartservices.ReceiveFileOverSFTPBasic java.lang.StringIndexOutOfBoundsException: String index out of range: -1Could you please help me here?

Can Appian receive an email and create an action based upon that email?

HI I have a requirement to export more than one lakh records into excel sheet. challenges:      -> Data is coming from a view having multiple joins.( Facing performance issue at production)     -> So we followed appian records approach, but export to excel button is getting disabled when record count is more than one lakh.     -> As the records count is high, we are not interested to go stored pro and staging table approach Any advice is helpful

Hello Community, I have an interface that displays two types of data coming from two methods that delivers the json values. If this is an individual I have built out a CDT that ties into the method "individualResult".  If it's a group, I will have to tie into the "groupResult" method.   The properties are the same, but the methods are different.  I'm wondering if anyone has a recommendation as to how to build this out? Let me know if more information is required. Thank you.

Hi all,  May i know how to extract data from an xml file Thank You In Advance

How to retrieve the sign document back to the appian

Hi All, In our application folder more than 4000 child folder reside inside the folder. First of all, I want to extract all the folder and show in the grid and then I want to seach them by folder creation Date. Kindly guide me on how to do this. Regards, Vikram Kumar Singh

Hi  all,  may I know, how to extract data from an xml file Thank You

Hi There, I’m trying to use card as buttons pattern to call an interface. Interface is having gridfield used inside a!headerContentLayout() to display task lists. However, I’m not sure how can I call call this interface using card as buttons pattern. Is that a right way of calling ? Please do let me know if you need any more details.