Foundation

Hi,  Am using Send email smart service to send email from process model. Have inserted a web image along with some text in the body of the email. Have the following issues: 1. While configuring the process, the image is displayed correctly but when an email is received the image is not being displayed correctly. 2. Instead of using Web Image, is it possible to use image stored as an Appian document ? Thanks in advance. Vikrant.

Hi we have a textfield where we perform validation  by calling a webservice query.  validations are working fine when i test it from interface in designer mode. When i test from site, it throws below error. An error occurred while executing a save: Expression evaluation error in rule at function 'webservicequery' [line 13]: Could not parse WSDL inside saveinto of the textfield a!save(local!result, webservicecall), validation:if(local!result,"","Please enter valid date") CAn we call webservice query in saveinto? Please advice

Hi Team, I am getting special character i.e ";" in empty field, how to remove the special character and save the value? Already tried stripwith() and it is not working as expected.

Hi Team, I have an excel template in which i need to map values to the particular cell positions like {B2,B3,B4,E2,E3}; that are being retreived from a table. I am getting all the data in single row currently even after giving the cell keys. Any suggestion? Thanks Anandita

Hi, I updated multiple records at the same time, I test "Rule!" it working fine. I also "enable activity chaining", but it did not update username properly but updated as "Appian Administrator" do you have any suggestion? Thanks,

Is there a way to query up who is assigned to a particular task? I've got a process report, but I'd like to somehow pull the assignee for a particular task out of that for use elsewhere. What is the best way to do that? 

As you can see on this attachment a scroll bar is appearing when displaying a rich text edited field.  If I go in and remove a couple of lines of text the scroll bar goes away.  Does anyone know why this scroll bar is showing up?  It does not matter how big the area field is in it always shows up. For example, I can remove the last sentence and the bar goes away.  So it seems to be tied to a character count.

Noticed something strange when using the datetext() function on dates near the end of December.  Using datetext() on dates December 27th or later display the next year rather than the correct one.  Example below... a!localVariables( local!dateDec25th: date(2021, 12, 25), local!dateDec27th: date(2021, 12, 27), { dateDec25th: local!dateDec25th, dateText25th: datetext(local!dateDec25th, "M/d/YYYY"), gmtThe25th: datetext(gmt(local!dateDec25th), "M/d/YYYY"), a: "********", dateDec27th: local!dateDec27th, dateText27th: datetext(local!dateDec27th, "M/d/YYYY"), gmtThe27th: datetext(gmt(local!dateDec27th), "M/d/YYYY"), aa: "********", toDate25th: todate(local!dateDec25th), toDate27th: todate(local!dateDec27th), gmt: todate(gmt(local!dateDec27th)) } /**** The above returns... dateDec25th: 12/25/2021(Date) dateText25th: "12/25/2021"(Text) "********" dateDec27th: 12/27/2021(Date) dateText27th: "12/26/2022"(Te

Good afternoon, We used the node Send File Over SFTP (com.appiancorp.a2.process.runtime.activities.sftp.SendFileOverSFTPwithSCSUsernameAndPasswordV2) Later we updated to version 2.2.1(Send File Over SFTP (com.appiancorp.a2.process.runtime.activities.sftp.SendFileOverSFTPwithSCSUsernameAndPasswordV3) and since then, passing the same values ​​in the input inputs, the shipment no longer occurs and gives us the following error: Does anyone know if anything has changed? A greeting and thanks in advance

Hello, I am trying to achieve below 2 things and need your help please. My form consists of 5 fields (ClientName, SubmittedBy, SubmittedDate, isSaved, isSubmit) which will be save into to DB table. 1. Form is having 2 buttons save and submit. On click of Save, it should save all the 5 fields with isSubmit=false in the database and the form should not be closed. On click of Submit, the isSubmit=true and the form is closed. 2. How to create a reusable function which is called from both Save and Submit button. That function should have the a!save code which will save the fields accordingly. The below 3 lines are called in both the buttons and based on from which button is called, it should save fields.                              fn (isSubmitClick) {                                              

in my database i have time in 24 hours format for example "8:00". when i create a query for this datetime what i receive is   a result with four hours difference how can i achieve to get it in the same time zone  as the database

My scenario is to check the date past 45 days.  todate(now())-local!creat_dt return intervals(days to Seconds). How to retrieve Days from it. Or is there an other solution to find?

Hello, I am getting the below error when querying a particular table from the application. The entity I am querying is a nested CDT.  Expression evaluation error in rule 'dcm_getproductbycaseid' at function 'queryruleexec': Error evaluating function 'queryruleexec' : Error converting query output (rule: [DCM_getProductByCaseId], type: [DCMCaseProductDT3274], objects successfully converted: [0] Server Log file Caused by: com.appiancorp.suiteapi.common.exceptions.AppianRuntimeException: com.appiancorp.suiteapi.common.exceptions.AppianException: Error converting query output (rule: [DCM_getProductByCaseId], type: [DCMCaseProductDT3274], objects successfully converted: [0]) (APNX-1-4164-025) at com.appiancorp.type.external.teneoimpl.QueryRuleExceptionHandler.handle(QueryRuleExceptionHandler.java:50) at com.appiancorp.type.external.teneoimpl.TimedWorkRunner.run(TimedWorkRunner.java:62) at com.appiancorp.type.external.teneoimpl.TeneoQueryExecutor.execute(Te

I am a beginner working on the Appian Developer course and while creating a process model had an issue with a Write to Data Store Entity node.  Details of my error: "An error occurred while trying to write to the entity "AX_Maintenance" [id=a715498b-834b-4663-914f-c2b5b2246cf3@3764, type=AX_Maintenance (id=3832)] (data store: AX Data Store). Details: org.hibernate.PropertyValueException: not-null property references a null or transient value: AXMaintenanceDT4982.vehicleID Data: TypedValue[it=3832,v={<null>,<null>,2022-01-28,0,test,Scheduled,<null>,<null>,<null>,<null>,<null>" Process Model: It looks like the issue is leading back to the AX_Maintenance Data Type that was created as part of Exercise 9 in the Appian Developer course - same exercise where this process model is later created. Instructions: This Data Type is used for two interfaces and connected to a Data Store as well. Status says problem with task.  

Hi Readers, I have a idea to make an user interface with a form and a read only grid at top right needed insights and what would be required to do this,  The form contains a box to enter the value(int) and a drop down with two variables sum and sub, the read only grid has some value let the initially value would be 0 for suppose. when i enter the value as 10 and select sum and submit then it need to be added to the value present in read only grid and change it to 0+10 -> 10(read only grid value),  when i enter the value 5 and select sub and submit then it need to be substracted from the value present in the read only grid and change it to 10-5 -> 5(read only grid value) Just wanted to know how we can do this happen and what all needed to do this happen. Thanks readers, will be waiting for your insights/ideas/answers

How to send Interface rule input value to the Expression Rule?

Hi Readers, I have a query regarding the process model designing, i want to know can we do the below thing to happen. A single process start for which has a drop down options A, B, C and D for suppose, based on which the process model acts up on. There are four databases as well named as db-A, db-B, db-C and db-D. And Now, when i select A from the drop down present in the start form and click on submit then the details entered in the form need to go to db-A,when i select B from the drop down present in the start form and click on submit then the details entered in the form need to go to db-B, when i select C from the drop down present in the start form and click on submit then the details entered in the form need to go to db-C,when i select D from the drop down present in the start form and click on submit then the details entered in the form need to go to db-D.    Is it possible to make this happen from a process model. If Yes please provide me the insights for doing so

Hi, I would like to ask if is there a possibility in the process model to get the value of the timer to start from an expression rule or constant?,My task is to create an admin page where the user can configure the cronjob like change the schedule and make it on and off on the specific page. does it have any alternatives on the process?Thank you!

No refresh token was captured, which means users may need to manually reauthorize more frequently. Check the external system's documentation to determine if refresh tokens are supported and how to request them. this type of error  showing while i was authorizing the integration.

I would like to use the feature to "Notify task assignees of new task via email and mobile push notification if applicable" and it sends emails successfully, but there is a problem with the link to the task.  Our envrionment has multple identity providers set up via SAML and the link in the email always trys to use the default identity provider.  Is there a way to specify which identity provider to use for task assignee emails other than the default one?  Adding a query string parameter of ?signin=my-signin-method would work if I generated the email in a custom way, but I'm hoping to just use the out of the box emails if the right signin method can be added to the link.  Any help would be great!

Hello Everyone, I am getting the following error when querying one of the table from application. The entity I am querying is a nested CDT.  Expression evaluation error in rule 'dcm_getproductbycaseid' at function 'queryruleexec': Error evaluating function 'queryruleexec' : Error converting query output (rule: [DCM_getProductByCaseId], type: [DCMCaseProductDT3274], objects successfully converted: [0] It is an existing CDT which used to work just fine. The only recent change I have made is increased the column length for some of the fields in the table and removed the length parameter from the xsd annotation. Could it be the issue? I am able to get data by sql select statement. Please help if anyone knows or have experience on how to fix this issue. Thank you.

Hi, I have a requirement to load the data in a grid format and along with paging options, Export to Excel, Few Search Filters. Right now I have used "a!gridField" to load the data and I am able to provide paging to navigate between pages. But, I am unable to provide user filters / SearchFilters, ExportExcel features with "a!gridField" control. Can someone advise on this? Thanks in advance.

Hi, I have a process model with a start node that will trigger an interface. Now, I would like to call this process model when a specific button/link is clicked. When I try to use the below code, it is actually initiating a process model, but it is not loading an interface form where the user can enter data through form elements/fields. Am I missin anything here. Can somone advise please. Thanks. a!formLayout( buttons: a!buttonLayout( primaryButtons: { a!buttonWidget( label: "Submit", value: loggedInUser(), saveInto: a!startProcess( processModel: cons!AT_ConsCaptureEmployee, processParameters: "", onSuccess: "Ok", onError: "Not Found" ), submit: true, style: "PRIMARY" ) }, secondaryButtons: { a!buttonWidget( label: "Cancel", value: true, saveInto: ri!cancel, submit: true, style: "NORMAL", validate: false ) }

When searching for objects in appian, is there a way to exclude something? Like if I was going to Google something, for example, I could search for "fruit" but not "apples" by typing "fruit -apples" is there some equivalent in Appian? Most of the objects in my application have a specific prefix and I'd like to search for the ones that don't have that prefix so I can eliminate them. 

Hi all, I'm looking for some advice. We have a potential requirement to gather an approval or rejection from a user who would not necessarily be a user of Appian. The business cannot define up-front who they would need to gather the approval from and it could be someone different every time so my initial thoughts were to send an email from an Appian process that includes one or more links to send a reply email back to Appian that would start a process model to capture the approval or rejection, the sender and date time stamp. Has anyone tried anything similar? Is it possible to create an email in Appian with the necessary links to send a reply back to Appian? Does anyone have any alternative solutions? Any suggestions would be gratefully appreciated.