Foundation

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.

Hello There, How to upgrade to Appian 22.1? I am using the free plan 

Hello, I have a table which have 5 fields. I am showing 3 non null fields on UI as user input and storing them in the record input of CDT type to that table. The other 2 fields (UserloggedIn and Unique Identification Number), I want to set it as default value to those record input fields on submit button but it is now working. I don't want to show this field in UI and allow modifcation by User. Placing my code below. Please suggest what is the mistake here or how to achieve it. Thank you. Interface: Code: load( local!reportedBy: loggedInUser(), local!uin:"TEST000000000005", a!formLayout( label: "Kk Testing Kk", contents: { a!columnsLayout( columns: { a!columnLayout( contents: { a!textField( label: "Tstclientname", labelPosition: "ABOVE", value: ri!record.tstclientname, saveInto: ri!record.tstclientname, characterLimit: 55 ), a!dateField( label: "Tstmasterdate", labelPosition: "ABOVE", value: date(2022, 03, 06), saveInto

I have installed appian 21.4 on local (Win 10) . I have observed once I start the process model for debug or through action it's always stuck on start node itself. I don't see any specific error in logs. but while starting the tomcat I'm getting below error: Error on tomcat startup: 022-02-17 01:22:30,579 [ForkJoinPool-1-worker-25] ERROR com.appiancorp.common.config.ConfigObject - An error occurred while trying to initialize the config LoadExceptionHandling [0ms] [resources 37ms]java.nio.file.InvalidPathException: Cannot store the note content, because the location is not valid.: C:/appian21.4/appian/_admin/process_notes/exec/00/3/0 at com.appiancorp.process.notes.services.NotesContentServiceImpl.createNoteContent(NotesContentServiceImpl.java:164) at com.appiancorp.process.notes.services.NotesContentServiceImpl.createNoteContent(NotesContentServiceImpl.java:178) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(N

Hello Team, I am trying to create a new view with expression rule or sql script that will include the sum(PaymentAmt) for cases where directDepositTF is 1. For example in the attached image, caseId 138465, I would like a view that sums the amount in paymentAmt column into a new view. Thanks

The project I am working on has a specific use case where they export a excel sheet and then convert that into a PDF from there. The excel sheet doesn't necessarily hold data. It holds data in the sense that fields are highlighted. My question is for the example attached is it possible to recreate this using the document generation/management tools or any other tools within Appian? If so what would I be looking for and how would I accomplish this? Attached is an example about states vs what foods they like, don't like, or indifferent as example data. What could I do to recreate an appian export of this data and it changing if I have a field that says if fries are good and burgers are bad etc.   

So someone on my team has a process model with the following error: There was an error in an expression in Process Model Properties at Process Start Form : Variable(s) not found: local!planType local!addActivity I can guess that some expression/interface hidden in that start form is missing some local variables (the start form itself has no errors), but the problem is there are tons of expressions in that interface and many of those expressions have multiple levels of nested expressions in them. Short of clicking through these countless expressions until I find an error, is there some way to quickly find which one might be the offending expression?  Or if I'm reading the error message incorrectly some advice on where I should look would also be appreciated. 

I just looking for a confirmation that Appian will populate pdf through a PDF with forms, no other PDF generation is possible. If this is the case its somewhat of a limitation. Kind regards PDF Doc From Template Smart Service - Appian 21.4

I want to create a rich text button in a interface that open a another interface when triggered. I tried with link parameter with a!dynamiclink() but it say it need all the rule input mapping from the interface that I want to link.my case opening interface have some rule output so rule input mapping may no need for opening interface. Is there any method to do my task 

Hi, I have a scenario like below. I have a a!textField and I using this for searching the data and loading based on the output into a a!dropdownField. This is working is fine for the first time when I searched by providing a text in the textField. The issue is happening when I try to re-enter a new text in textField after selecting an item in the dropdown. Error is saying, All selected values must be present in the choiceValues array..... Is there away I have clear dropdown values after user is trying to search with new text in search. Thanks in advance

Hey all,  I have a general question,  Why does Appian have a different appearance sometimes? Is this a matter of which URL they use? Sometimes looks like this:

Hello there! I have the following process: We send a email to a customer with a user with a link to a interface. The user has to complete an interface, then the user is redirected to an external page where a email with a temporary password is send. The user has to take this password and provide it in the page. Very simple. The problem comes with the mobile version. When users try to open the link in their mobiles, the page is opened in the same tab that the gmail app (i think that this happens because the integration between browser and gmail app), so when they want to see the password sent to their emails, they have to close the tab and, with that, all the process has to start from the beginning. My question is, can we open the link in another tab/interface after the user complete the interface? We tried with safelink but it doesn't work in mobile (it's opens the page in the same tab). If not, is it possible to do something to avoid the process or something to start in the sam

How to deprecate a existing constant?