Discussion Categories

Expression evaluation error at function a!queryEntity_22r2: An invalid start index of 0 was passed in. Start indices must be greater or equal to 1. I am getting this error for the below code pagingInfo: a!pagingInfo( startIndex: ri!pagingInfo.startIndex, batchSize: ri!pagingInfo.batchSize, sort: { a!sortInfo(field: "createdOn", ascending: false) } )

Hi, I am tasked to do a timesheet POC, I am asking the user to select the date, and I will using the weeknum function to find out the week number, after that will add into the database and wait for supervisor approval.  How to verify the week number is exist in the database record before the user submits the form.  Please kindly assist me thank you 

Hi Team, We are using "googleHistogramChartField"  by "Appcino Technologies" the requirement is  Is it possible to color the boxes (of reach composition) based on the overall risk (green, yellow, red) I was unable to find any setting for the same  https://developers.google.com/chart/interactive/docs/gallery/histogram can anyone suggest that how we can implement histogram in Appian without 3rd party plugin Regards Bihitak

Hi, Recently I have deployed a new application to Production environment. But facing DB connectivity issue. But there is no problem regarding DB connection at lower environment. I have created the Data Source at Admin Console and here it shows Test Successful. The Screenshot: But when I am trying to verify the Data Store, it is not able to connect to DB. The Screenshot: Can anyone please help me regarding this DB connectivity issue? Pertinently I like to inform you the a few days ago the connection was successful and in-between nothing was changed related to configuration or not any further deployment was done in production. Thanks, Surajit Sen

Hello, can the usage of plugins (once installed) restricted with a security(role/permission model or something similar? Thank youThomas

Please share any example to write HTML code into the Expression rule 

Hi, I have a pie chart that displays the 'label' & 'data' outside the pie chart. I want to display the 'label' outside the pie chart and the 'data' inside the pie chart. Is there a way to do this?

Hi Team! Good morning! Need your help/suggestion on the below: I have got a requirement like the check box should appear on the UI with all possible values as selected(ticked) by default, then the user unselects the option that they does not require and submit it. I have tried the below snippet, where in UI its appearing with all the values checked, but upon unchecking the box, it gets selected again. Can you please help me or let me know if there is any possibility to achieve this functionality ? Code snippet: a!localVariables ( local!Checklist:{"A","B","C"}, a!checkboxField( label:"Checkbox testing", choiceLabels: local!Checklist, choiceValues: local!Checklist, value:local!Checklist, saveinto: a!save(local!checked, save!value) ) ) Expected result: 1. At first ,all the options get checked by default 2. The user can able to unselect one or more of the option and submit it  Actual result: But after unselection, the values gets chec

I'd like the employee ID to auto increment and populate automatically whenever a new employee is being added to the record.

Hello all. I am following the Appian online course and making a side project to practice. In the query data section for querying VehiclesAddedThisMonth it shows us how to query and filter a vehicle that was added this month. The problem I am having is that the field I am using is datetime and not date. Error: Expression evaluation error at function a!queryRecordType: Cannot apply operator [EQUALS] to field [createdOn] when comparing to value [TypedValue[it=1,v=10]]. Code: a!queryRecordType( recordType: 'recordType!{7dc09094-e6de-418e-855a-35ab22892fc7}BB Product', filters: a!queryFilter( field: 'recordType!{7dc09094-e6de-418e-855a-35ab22892fc7}BB Product.fields.{34fab307-ea54-4ea9-a01b-40a0706f32c7}createdOn', operator: "=", value: month(now()) ), pagingInfo: a!pagingInfo( startIndex: 1, batchSize: 100 ) ).data Seems like the issue is that the operator cannot compare the month function to my datetime field however it is ok if the month compare to

Hello All, I need to display excel within appian UI (interface may be). I need to edit the excel and save it back to where it was (knowledge Centre). How can I implement it? any suggestion is appreciated.

Hi, Recently we deployed a new application to Production environment. It's working fine. The screenshot But facing DB connectivity issue every 37 minutes we are getting this error. Can anyone please help me regarding this DB connectivity issue?

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.