Discussion Categories

Hello,Looking for some help in configuring MQ in Appian 20.4.Here are the details that we configure in apache-tomcat server's suite.xml file. <Resource name="jms/MyQCF" auth="Container" type="com.ibm.mq.jms.MQQueueConnectionFactory" factory="com.ibm.mq.connector.outbound.ManagedConnectionFactoryImpl" description="JMS Queue Connection Factory for sending messages" HOST="myMQserver" PORT="1414" CHAN="myChannel" SCPHS="mySSLcertName" TRAN="CLIENT"/> <Resource name="jms/WriteQueue" auth="Container" type="com.ibm.mq.jms.MQQueue" factory="com.ibm.mq.connector.outbound.MQQueueProxy" description="JMS Queue for receiving messages from Dialog" QU="myQueueName"/> <Resource name="jms/ReadQueue" auth="Container" type="com.ibm.mq.jms.MQQueue" factory="com.ibm.mq.connector.outbound.MQQ

Hi All, For my requirement , I have to create a stored procedure in database which executes a sql query. And I have to execute that store procedure in appian process model and have to save that output in  process variable to proceed further. While creating the stored procedure in Database ,I am facing some difficulties. If I just run the sql query in DB by passing value for input(task_id = 261),then it gives me output of 16 rows with 22 columns , I want that to be saved as output in my process variable as a result. For this query I written below code to create store proc, create or replace procedure test(i_task_id in NUMBER)ASBEGINselect column1,column2,column3,.... from xyz where task_id = i_task_id;END; But this shows me the error like PLS-00428: an INTO clause is expected in this SELECT statement. Can anyone kindly help me to solve this.Thanks in Advance.

Hello! I would like to prevent users from using emojis in comments, however I have absolutely no idea how to accomplish that. Have you got any advice, folks?

How to make a card layout collapsable?

Hello, when a record type has a (1,n) relation, Appian supports some aggration for those related records ( 'Create Custom Record Field' --> 'AGGREGATE RELATED RECORD FIELDS'). The avaible aggregation functions seem to be dependend on the data type of the 'AGGREGATE RELATED RECORD FIELDS' - in any case, I'm looking for something like FIRST_OF (LAST_OF) so that I can get the first record field(s) of related data records (which are string based). Maybe a small example: (Author)  <-- (Books) (an author can have many books) Should be presented in a list author number of books book title (first) book release year (first) Scott Lynch 6 The Lies of Locke Lamora 2006 ... What would be a good way to achieve this? Thank you in advance Thomas

Getting this error how can i resolve it. I have given 2 different CDTs  Thanks In Advance

Hello guys, I have a page html and I want call web api appian, but retrivied this error: can you help me? thanks

Hey everyone! I'm working on an email template which I'll be using inside a Send email node and I have to add a logo as a signature. Because of company requirements, I can't use href HTML attributes and I already tried using inline-css, svgs and base64 versions but those are not viable options due to email provider incompatibility. So the only option left I could think of was the following: Storing the logo inside the Document Folder in Appian. Creating a constant pointing to the logo file which is a PNG. Inside the process model I create a Document type process variable. That pv as a value has the file constant. Inside the Send email node I went to the Setup window an inside the Message body I inserted the logo pv as an expression.   But the received email doesn't show the image, it only shows the following message.  Do you know if there's a way to send files that are stored in Appian through the send email node? Also, attache

Hello,  I am trying to design an interface when a technician clicks on "Accept Ownership" will trigger a process where we capture the user who clicked on the link and update the database. Below is part the interface code for accept ownership. a!sideBySideItem( item: a!richTextDisplayField( label: "Technician Name: ", labelPosition: "ADJACENT", value: { if( a!isNotNullOrEmpty(local!technicianInfo['recordType!{668f9fee-8c8c-4ec0-8719-8fe261ecebe6}CG Technician.fields.{28788328-2480-438c-be68-4a5bfccfa974}assignedto']), local!technicianInfo['recordType!{668f9fee-8c8c-4ec0-8719-8fe261ecebe6}CG Technician.fields.{28788328-2480-438c-be68-4a5bfccfa974}assignedto'], a!richTextItem( text: "ACCEPT OWNERSHIP", color: "NEGATIVE",

I have a question, well I have a requirement which we need to extract files from appian from a directory on a server using the Sftp functions, the problem is that when we want to do that function the destination folder does not support SFTP, Well, is there any solution to send files to a folder if it does not support sftp? Thanks!! 

Hello, I want an event to happen (send email) after submitting a user interface (form) only if a certain attribute has been changed. I figured that I would need the old and the new value of this attribute in the process. What would be a good way to achieve this? Thank you in advance

I am retrieving a large JSON document from a web service and need to display this on a set of interfaces.  The JSON has separate sections for different aspects of the data and my plan is to create separate interfaces for each section then add each of these interfaces to a single master interface.  The end user will be directed to this master interface to view all the necessary information from the JSON document.  This data is strictly read-only.  We will have other JSON documents that may allow edits which are then passed to an integration to be saved in a database, and/or to notify other system components of the change. Some of these components are made available to multiple Appian applications which are created by other developers (not involved in the creation of these common components). The question I have is around passing data internally between Appian objects (process model to interface, interface to interface, interface to expression rule, etc).  Should

How can I apply an order or sort to the values shown in a picker field? I am using a a!pickerFieldsRecord on a single record type Employees (ID, First Name, Last Name) but would like to sort it by first name.

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!