Discussion Categories

Hi,  I have used the Text Doc from Template smart service to pass text to my document by using ###tag###. I have checkbox fields in the document, is there any way i can pass the yes/no value to the checkboxes from Appian so that the document is generated with filled checkbox fields?  Thanks in advance!

Hi All, Is it possible to Zip a folder with multiple files and share the same to SAP. we are using on-prem version 22.1. Thanks in advance. Warm Regards Vineeth

Hi All,We have an issue while trying to publish the Data Store.Couple of points to give you a background: Appian User is not assigned with proper Default DB Schema - the schema where all of the tables and views are held - (Therefore we're using Synonyms) After upgrade to Appian 22.4 we're unable to Verify / Publish the data store We have found the workaround by adding schema  annotation to all CDT XSD <xsd:appinfo source="appian.jpa">@Table(name="TABLENAME", schema="SCHEMA"). This workaround fails however when the CDT in question has 'primitive array'. In such case Appian creates a related table for the 'array' field.Because those tables were created in another schema we now cannot publish the entire Data Store. We have multiple such tables, therefore we would appreciate any help (Other than changing the default schema - which is currently not an option in our business case). Can you please advise if you

Hello guys, I failed for the developer exam for the second time now. I studied for the Appian developer test for 180 hours, but i still failed the exam TWICE now. I'am lost i feel like i know everything but the way the questions are formulated is very hard. I just want to review the exam so i can maybe change my studying style.  i used the exam checklist, i studied the developer course, i took the practice test 12 times and i studied the appian documentation. ANY TIPS? thanks.

In Python, how can I practise polymorphism? Assume we have a very basic version of the option pricing algorithm that requires just three inputs (option type, spot price, and strike price) to compute the intrinsic value of our option. Please see the example code below. from abc import ABC, abstractmethod import attr @attr.s(auto_attribs=True, frozen=True) class Option(ABC): strike_price:float @abstractmethod def price(self, spot_price: float): raise NotImplementedError("This method must be implemented in the subclasses.") class Call(Option): def price(self,spot_price: float) -> float: return spot_price - self.strike_price class Put(Option): def price(self,spot_price: float) -> float: return self.strike_price - spot_price def calculate_option_price(option_type:str, spot_price:float, strike_price:float) -> float: if option_type == "CALL": return Call(strike_price=strike_price).price(spot_price=spot_price) elif option_ty

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