Discussion Categories

Hi, I am planning to attend the appian world event, and would like to know the experiences of some people who have attended it in the past.

Hi, I would like to realize a site like this shown in Appian challenge in Europe. I need to understand how to set a billboard static and the footer at the end of the page. https://ae-lbc-ms.appianportals.com/97258e0e-81fa-4f9a-99fe-123f1e324fab-portal thx Matteo

Hi, On a entity backed record a related action has been defined to set a status flag on the record to canceled. When user choses the related action from a (summary) view, the related action is performed and returns to the same (summary) view. i.e. writes to db a status of canceledThe changes made by the related action are not reflected on the view. i.e. status is not set to canceled although the status flag in the database has been set correctly.Refreshing the browser page then correctly displays the view with the record at canceled status. Any help much appreciated Thanks

Hi, I found a code that explain how to display files in a grid, but my problem is that I can't create new columns with more information, for example the Description of the file. Please, can you give an advice? This is my currect code. Thanks a lot. load( local!data: { { id: 1, folderId: 4768/* Folder ids*/ }, { id: 2, folderId: 4947/* Folder ids*/ } }, a!gridLayout( label: "Documentación", labelPosition: "ABOVE", headerCells: { a!gridLayoutHeaderCell( label: "Nombre documento" ) }, columnConfigs: {}, rows: { a!forEach( items: local!data, expression: a!gridRowLayout( id: fv!index, contents: a!richTextDisplayField( value: a!forEach( items: folder( index( fv!item, "folderId", {} ), "documentChildren" ),/*Getting documents from folder*/ expression: { a!richTextItem( text: document( fv!item, "name" ), link: a!documentDownloadLink( document: fv!item ) ), a!richTextItem( text: char(10), showWhen: not( fv!isLast ) ) } ) ) ) ) }, selectionSaveInto: {}, validations: {}, shadeAlternateRows

So, I am trying to capture and store nested data from USDA Database - API (image below)  Now I am trying to store this data in a record - fields being gtinUpc, number, name, amount, and unitName.  I am trying to use the forEach-nested loop example from  https://docs.appian.com/suite/help/23.1/fnc_looping_a_foreach.html. However, when I try to nest another forEach and iterate over the foodNutrients, I get errors.  I have tried moving lines around - for example, move line 21 to outside the inner a!localVariables - nothing seems to work.  As always, any and all feedback/assistance would be appreciated. Thanks

Hi All, i have 2 tables. 1.project(id,requesttype,automationname,etc), 2.Task(id,projectid,workflowtype,etc) Project:{ { "",test,test}, {"",test,test},{"",test,test}}  task:{{ "","",task}, {"","",task},{"","",task}} } for example  After write to data store entity of my project data is{ { 1,test,test}, {2,test,test},{3,test,test}}  once project data is created i want to create the task respectively before that i want to assign the PROJECT DATA (ID) which is 1,2,3 to Task Data(PROJECTID) finally after i write the task data into db i want my task data as: {{1,1,task},{2,2,task},{3,3,task}} can you please help how i can set the id of project to particular cloumn in the task data

Dear All, I have created a stored proc which is returning an output parameter 'caseid' and I would like to access the case id in stored proc smart service. But I am getting error incorrect number of argument passed. Please correct me if I am doing something wrong. I have attached the screenshots below:

Hi! Does anybody know if there is a data limit for and export sql to flat file? I've been asked to research that as our App need to export large numbers of data in the future! I know it's. deprecated but it's what we have developed and I don't think the product owner will want to update de feature! Thank you

Title: Record sync issue post write to DB smart service call Body: I have used Write to datastore entity smart service for updating a record in database table, this works fine via a record action but when I'm using a related action, I am getting sync issue in recordType after related action process flow completes and returns back to the record summary dashboard. Below are the logs I could find for the issue: 1. Loading updates to synced record type(s) in ADS failed, invalidated record type(s) 2. Record type is marked as synced, but its data has not yet been synced or its existing synced data has been invalidated. Contact your system administrator. (APNX-1-4205-039) Can you please let me know why is this issue happening and how to fix it.

Dear Team, Am using a!startProcessLink(),When User Click on Edit just am popule all values which we are passing through a!startProcessLink().But in interface am not getting values for a particular CDT.Getting two values out 13 columns.  Sample Code: local!Billinfdetails:getting values from expression rule a!startProcessLink( processModel:Cons!ProcessModal, processParameters:{ billingDetails:local!Billinfdetails } ) when am mapping this billing Details to ruleInput in Interface not able to get the all values getting two columns values only. Can please help on this any one )

No longer need assistance, thanks!

Hi, I have below process model where I am trying to use "Export Data Store Entity to Excel". It was throwing an error when I try to use. I have not used any crazy setups related to this smart service, but still I am getting an error like ":  An error occurred when attempting to write the document Excel Export 3_9_2023 7_10 PM GMT+00_00. Please contact your system administrator for additional details. (APNX-1-4505-056) ". This error message is not giving any kind of clue to trace exact issue.

Is there an option / way to modify the a!documentBrowserFieldColumns to display the list of documents by "Last Modified Date" instead of Alphabetically?

What are the best storage capabilities of Appian?

If a Smart Service has a onError argument, can I capture the error message of what went wrong?  For example, the createUser SmartService has an onSuccess and onError arguments.  In the onSuccess, I can capture the created user with fv!user.  Which is great.  But in the onError, I don't see anything that will tell me what went wrong. I know the system knows what went wrong because if I happen to wrap the call to the createUser call in a WebAPI, I can see in the "Details" section of the "Smart Service Executed" response it says, "The username requested is not available".  But I want to capture that text so that I can log/report it and I don't see a way to do that.  I want to know more than "It failed".  I want to be able to report what actually went wrong. Thanks in advance,Steve

Here I set a timer for a re escalation  if the  user  is not active but it seems like it is not working. This  is the group that i'm   scalating this task to

What is max count of local variables can we use inside a interface  or inside an expression a!localvariables()?

a!queryEntity( entity: cons!D202301DIV_GRL_DSE_ENTITY_REQUEST_DETAILS, query: a!query( filter: a!queryFilter( field:"requestId", operator:"=", value:ri!requestId, applyWhen: not(isNull(ri!requestId)) ), pagingInfo: a!pagingInfo( startIndex: 1, batchSize: 50 ) ), fetchTotalCount: false ) I am facing this error when I'm opening one of my forms in my process model. 

I created this update records-related action from the "Generate a Record Action" button. following is the auto-generated process model. Its having following wrror  And following is an error on site : An error occurred while retrieving the data for "DDE Invoice Data". Details: Record type is marked as synced, but its data has not yet been synced or its existing synced data has been invalidated. Contact your system administrator.

Hello, I see in a log file named "db_PX..." a lot of error : [Activity Chaining] Could not chain to attended activity.  No attended activity with compatible assignment was found." but the related process seem working fine and I do not see any specific. The process is called by a webAPI and the result of the process is returned as result by the WebAPI. The process is very simple. The sub process called is Have you already received a similar warning ? I suspect the complex gateway. Regards Jean-Alain

Context: To customise an appian-plugin, I use Java as the primary language. I have added codes into a class that belongs to the plugin working space, and anytime I run maven clean install, my codes will be removed throughout the clean process. According to my colleagues, it might be due to a.wsdl file that produces files automatically when it is redeployed. Please advise. Thank you very much. This is the code fragment I'm attempting to put. public static Comparator sortWageIncrementFinancialYr = new Comparator () { public int compare(DummyFormData u1, DummyFormData u2) { int compare1 = u1.financialYr.get(0); int compare2 = u2.financialYr.get(0); Boolean result = compare1 > compare2; return result ? 1 : -1; } }; .wsdl codes associated with this

I'm creating an Appian web API to retrieve documents from our Appian system and link them with our other systems. To that end, I'm utilising Appian's folder() function to gather information about the contents of a folder. folder( theCaseFolder, "documentChildren" ) The issue I'm facing is that, while this code works most of the time, we have some instances with over 1000 documents recorded against the case. I notice in the Appian documentation that: The documentChildren and folderChildren properties provide the top 1000 documents or folders that are direct offspring of the specified folder, accordingly. My issue is that we have a few cases where there are over 3000 papers attached. Is it possible to obtain a list of those kid documents, or am I completely out of luck?

Hi: I was trying to learn about web-integration using the credit card integration example (https://docs.appian.com/suite/help/23.1/Integration_Tutorial.html) and the currency function in the interface doesn't seem to be working - Error:Expression evaluation error at function a!currency: The function a!currency is unavailable. I tried the basic example from the a!currency documentation page (https://docs.appian.com/suite/help/23.1/fnc_text_currency.html) and it gives the same error.  a!currency( isoCode: "USD", value: 1234.56) Looked to determine if this function is old - but it seems to be part of 23.1 release.  Any ideas of what is going on?  When it might be available?  Or is this not available in the community edition? Thank you! Ma

Hi there,  We are using using integrations inside saveInto of some components, I just wanted to know whether is there any difference in  performance between call to integration and start process(calling the integration inside the process model and using that process model instead of directly using call to integration) ? 

Good Day Experts, Can anyone please help me how to configure/use the password encryption for Fitnesse for Appian ? We can configure the user name and password in the user.property file and we can use as a RULE in fitnesse script but I'm not looking for that. We wanted to use the encrypted username and password (at least password ). I've gone through below documentation but still I'm not  able to figure out. http://fitnesse.org/FitNesse.UserGuide.AdministeringFitNesse.PasswordCipher Please let me know if you need more details. Thanks in advance. Cheers, Kalai.