General

Hi, Can we add dynamic link to entire row instead of one column. The below screen has link on Make field. But I need It for entire Row. Is it possible in Appian. If it is what changes do I to make to below expression. Please suggest.

When editing a rule in expression mode, and searching for some text, the search control positions itself over the scroll window such that you cant easily scroll a single line to make the selected search result visible . Here's an example:

How we will Debug Application ?

Hi Team, I am facing a problem in Displaying data in OSM Map , I have show Patients Address data in Map, for that I have to make data of patients as list of Dictionaries. which I am not aware of How to make that list of Dictionaries using expression editor. But manually i can add list of dictionaries (Dummy) and show them on MAP as below,  { {name: "abc", lat: 17.9467, lon: 78.2879, address: "abc street.", marker: {icon: "bus", iconShape: "marker"}},{name: "xyz", lat: 17.23, lon: 78.879, address: "abc street.", marker: {icon: "bus", iconShape: "marker"}},{name: "QWERTY", lat: 17.6947, lon: 78.8279, address: "abc street.", marker: {icon: "bus", iconShape: "marker"}}} Which Results me the following, I am able to make manually dictionaries , But i dont know how values which are present in recordtype are converted into list of dictionaries. so i can show them o

Aegon posted a ticket about our entire process instance being stuck (594230) and since this is production-blocking, i wanted to know what status this ticket has. But i could not find it, and the link tells me "access denied" .

What is Record Search ?

Which performance log should we check to get the mean evaluation time of the rule? >expression_details.csv >expression_metrics.csv >expression_summary.csv >expression_trace.csv

Can someone please briefly tell custom_properties, logging properties ,appian_log4j.properties file  uses. And Some Issue in SAML Configuration so which file we can make change to trace the SAML changes??

Hi Appian Team, I have completed Developer learning path and received badge too. Paired with Member Organization and its shows reduced price but is it possible to attend free?. Is there any free Voucher Code for ACD100 exam. If so can you please send me to registered email id. It is possible to directly take ACD300: Appian Certified Lead Developer or ACD200: Appian Certified Senior Developer? instead of going one by one and spending amounts... Thanks and Regards, Vigneshkumar

Hi Team, Looking for a function which can provide hours and minute difference between two date and time considering business calendar. calworkhours() only provide hours plus it rounds off it to nearest hour. Looking for below calculation : Start Time : 20/04/2023 10:00 AM End Time : 24/04/2023 11:30 AM Output -  hours : 17 , minutes 30 Calworkhours output - hours : 18

Hi Guys, Our client checking the node timings for each step in the process in that time we noticed the simple expression rule took around 1 to 1.5 seconds, however the same rule checked in direct expression rule it took only 1ms. Can any one facing this type of issue? Any solution for this. Please find the below examples, Example: Obj: Sharing simple example below which i done for testing perspective. Expression rule logic: elapsedtime(now(),now()+52) => took 1ms Call the rule in process model(without activity chaining) => took around 500 ms. Thanks, Pradeep Sridharan

Hi All, Our customer wants a functionality in Appian where let's say they took screenshot or snipped an image from anywhere and they should be able to paste into Appian without saving it to folder in their computers. basically they do not want to use File upload field which source a documents saved in the computer instead just snip an image and paste into Appian. Is something like this is possible or exists in Appian? Thanks

Recently I tried to configure Appian on Kubernetes for desktop development but was informed that I needed to have a license for Self Managed accounts. This is confusing to me as I have been able to download versions of Appian since 2018 and install on local servers with no issues, licenses have been granted every time I make the request. In my opinion, these downloads and installations are self managed as Appian surely does not maintain the servers I have my installations hosted on. Can anyone help me understand the difference between the ability to download and install (what I call on premise) Appian environments and what are called Self Managed environments? It really makes zero sense to me and hoping someone can shed some light on this. Apologies if this is duplicated anywhere, didn't really see anything directly related.

a!forEach( items: local!milestonedata, expression: { a!gridRowLayout( id: fv!index, contents: { a!paragraphField( value: { fv!item.milestone }, saveInto: fv!item.milestone, characterLimit: 1000, required: true ), a!dateField( value: { fv!item.milestoneDate }, saveInto: { fv!item.milestonedate, a!save(fv!item.projectId, local!data.projectId), a!save(fv!item.phaseId, local!data.phaseId), a!save(fv!item.isActive, true), if( isnull(fv!item.projectMilestoneId), a!save(fv!item.createdOn, now()), a!save(fv!item.updatedOn, now()) ), if( isnull(fv!item.projectMilestoneId), a!save(fv!item.createdBy, loggedInUser()), a!save(fv!item.updatedBy, loggedInUser()) ) }, required: true ), a!dropdownField( label: "", labelPosition: "ABOVE", placeholder: "--- Select a Value ---", choiceLabels: rule!PLT_GetReferenceDataStatus(parentId: cons!PLT_ParentId[6]).Name, choiceValues: rule!PLT_GetReferenceDataStatus(parentId: cons!PLT_ParentId[6]).referenceId, value: fv!item.statusId, saveInto: fv!item.statusId, se

Zuuuuuuup people ! So, I'm trying to create a screen to upload files,, between 2 interfaces. Since I need to send files to process model, I need to set rule input. But, When I try it, the following message is poped up: Is it possible to send those files without using rule input ? I've tried to set rule input at button submit click, without success.

Hi team, I am Looking for an API that provides Services to fetch Cibil score by sending PAN Number. Can anyone Help me in finding the API for this Thank you J Vinay

Hi all, I want to learn how to upload document on a REST webAPI. What I want first is to fetch the document from POSTMAN to Appian ( for Test purposes only ). However, I'm getting 500 internal server just by including a document from my body. Without including a document, it works fine.  my Body is a "Form-data", My issue probably is on my Web API Object of Appian ( request ), can you advice on this one on fetching request data from POSTMAN? Thanks rule!REST_Route( request: http!request, handlers: { rule!REST_Route( path: "/test", handlers: rule!TEST_PostTestAPIHandler(request: _) ) })

Hi, I need to copy an existing application with cdt and data source in the same server environment with a different application name. Kindly let me know the best practice for this and the easiest way of doing this. I also need to create a copy of the table structures used in the DB.  Thanks in advance, Swetha.

When there is prolonged user inactivity, a popup comes from Appian stating that session is about to expire. We are not able to click on any of them. The screen freezes until we refresh the browser.  I am looking for guidance if anyone has encountered this in their projects. Any pointers are appreciated.

Hello,I'm trying to create a POST method WebAPI that waits for its process model to end.I need to receive a JSON data type, process this data, and return an XML generated with the process model as the WebAPI response, is it possible to process the JSON information received and make the WebAPI wait for the process model to end ?I know that by the own definition of this method, the process model runs asynchronously, but I don't know any other way of approaching this case.Any idea will be welcome.Thanks in advance !

Hi Techies, We have a requirement where we want to show a particular site page when a particular user logs in. We have provided the site page url directly to the users but the problem is they want to see different site page for different users on log in. Is there any way we can change the default page that opens after logging in for different set of users? Thanks

I have this querydelete from PLSM_note where noteId in (fn!substitute(fn!joinarray(ac!selectedRecordIds, ";"),";",","))as shown in the below image. This query should translate to: delete from PLSM_note where noteId in (1,2,4,50)A) This is all on a single rowB) This is a single queryWhat's the solution to this?

Dear Team, Could someone help me to understand the below issue please. I am trying to fetch the total count of the records from DB view. When I give fetchTotalCount=true it's throwing an error 'Expression evaluation error at function a!queryEntity [line 2]: An error occurred while retrieving the data. Details: Unexpected error executing query'. If I change the fetchTotalCount=false, it's working fine. Sample  code is below: a!queryEntity( entity: cons!DB_VIEWS_DSE, query: a!query( selection: a!querySelection( columns: a!queryColumn( field: "id" ) ), pagingInfo: a!pagingInfo( startIndex: 1, batchSize: 1, sort: { a!sortInfo(field: "id", ascending: false()) } ) ), fetchtotalcount: true )

I'm making an interface form with Appian. I'm making the form interactive. A textbox should only appear when specific variables are true. Appian offers a wonderful feature for this where you can add an expression to a "only show when" function. It presently holds the following expression: edate(today(), -804) >= ri!GeboorteDatum The variable on the form is ri!geboortedatum. Another statement that says: only show when the date value is not null is required. I tried everything but nothing worked. Is there a solution? The programming language appears to be similar to Microsoft Excel. Perhaps something like edate(today(), -804) >= ri!GeboorteDatum & isnull(ri!Geboortedatum)

Hi,  I have CDT which is created from a View. The view takes around 8 sec. I have process model which uses Export DSE to Excel  smart service to export the content of view to an excel. The process model executes fine and generates the excel when run in debug mode (Start process for debugging).  When the process triggers on a timer ( timer event) it fails to execute Export DSE to Excel node and raises error " Error accessing data store entity: <<xxx_V_xxxxx>>. Please contact a system administrator for additional details. (APNX-1-4505-026)) I have checked the system error logs, following logs are logged. Error accessing data store entity: <<xxx_V_xxxx>>. Please contact a system administrator for additional details. An error occurred while retrieving the data. Details: Unexpected error executing query (type: [xxxxxx], query: [queryentity expression], order by: [[Sort[id asc]]] Caused by: org.hibernate.QueryTimeoutException: could not execute que