Foundation

We have a structure in db with an id, INFO, fatherID, level I have to given an ID, have to reconstruct all the Hierarchical Structure under the Given ID The Structure is a Three                                                                                           /------------ID1------------\                                  ID2[fatherID:ID1]                                                                               ID3[fatherID:ID1] ID4[fatherID:ID2] -/&nbsp

One of our customers has a requirement to send messages to students. Currently, we use AT&T's email-to-text feature to send these messages via email. However, AT&T is deprecating its email-to-text and text-to-email services, which means we’ll no longer be able to send or receive SMS messages using email. We're looking for alternative approaches to achieve the same functionality within or alongside Appian.Has anyone faced a similar challenge or implemented a different method for sending SMS notifications from Appian? Any guidance would be greatly appreciated.

HI , I have a requirement where I need to pass Sting values with separate Line to API . here is the  List of Sting with 4 items. “28978937982932090” “28978937982932091” “28978937982932092” “28978937982932093” I want to send it as single string with line break to API  “28978937982932090 28978937982932090 28978937982932090 28978937982932090” Can you help me with this scenario. Thanks in advance

I've been having trouble writing to a record that wasn't giving me trouble last week. I decided to rebuild the record as that seemed like a quicker solution than figuring out what weird issue that was. However, now when I am generating record actions for the record, appian generates them in a completely separate application. The components don't even show up in the application I am building in, they just show in another one, even using that other prefix for the various generated objects. What is going on?

Hi, We are using Base64 Expressions plugin in our application in so many interfaces now this plugin is vulnerable and need to find the alternative for this plugin. can someone please help on this? Note: we are using it to encode and decode the text.

Hello, I'm using the code below, enter ../ it's redirected to "Access Denied",  any idea why? I don't see any error logged in the Tomcat log. a!localVariables( local!searchKeyword, a!columnsLayout( columns: { a!columnLayout( contents: { a!textField( label: "Search By Keyword", value: local!searchKeyword, saveInto: { local!searchKeyword, a!save( local!searchKeyword, trim(local!searchKeyword) ) }, refreshAfter: "KEYPRESS" ) } ) } ) )

hi , we are not able to get email alerts when site page got error.do we need to enable manullay or it will send automatically to administrators. when site page got error. In 24.2 appian released this feature -Site email alerts will be sent to site object administrators  I have administrators acces for  all objects in my application but when site got error during that time I'm not able to get mail from site page. We are currently using 25.1 version could you please let me know any have idea on it Thanks

Question: We are running a process model which has considerable number of steps, where few in a loop to accomplish our goal. We could see the 'Process Details' printing the values which is really helping us to debug and verify. But 'Process Details' could print this only for the first few steps but not for the rest of the steps (in the later stages of the process model). How can we see the complete log of all the 'Process Details' and variable values.

I have 2 dropdowns type and courses type will be premium, free and courses for premium java, c++, and also for free also I have java , python like this . i need to display all the courses when in default and when type selected as premium it will only show that category courses. but java is in both category it displaying 2 times by default . In db they have mapped with thier unique type ids only. I tried with union but choice values and choice values length varies because of that. Can anyone help me ?

Hi team, I have one field in the database for the budget. Sometimes the value may exceed 100 crores, so for storage purposes, I am storing it as text. However, I want to compare that value with an integer. When I tried to convert it into number   in Appian, it rounds the value by default. Any idea how we can achieve exact value?

Hi Everyone, Can we exit from a!forEach() loop?  I have a use case , where I need to iterate through the list of users and once the condition met ( checking for the user's organization and weight category), I have to stop iterating through the rest of the items. I need order to achieve this, I have to exit from the loop.  How can I achieve this ? Apologies for not clarifying the use case earlier. Use case is given below. Use Case: There is a list of Boxers. Each boxers belongs to particular organization and weight category. I want to select 2 boxers for the match randomly. 2 boxers must belong to same weight category but different organization. To achieve this I was trying to loop through list of boxers and fetch 2 boxers belonging to same weight category but different organization. Once I get 2 different boxers, then I wanted to exit the loop, because I got 2 boxers for the match and don't want to loop further. Note: Weight category and organization are not know

Hi Team , The requirement is to add dropdown filters to all fields between the header label and the first row in Readonly grid . Is this possible in Appian?

Requirement: How to implement a logic similar to the refreshAfter field in a!dateField as we do for a!textField? We would like the page to refresh when the DOB field is clicked again, and a different date is selected. a!dateField( label: "DOB", labelPosition: "ABOVE", value: ri!input.dob, saveInto: ri!input.dob, showWhen: cons!PARAMETER[2] = tostring(local!input), required: true),a!textField( label: "Address Line 1", labelPosition: "ABOVE", placeholder: "Enter Text ...", value: ri!input.addressLine1, saveInto: ri!input.addressLine1, refreshAfter: "KEYPRESS", showWhen: cons!PARAMETER[2] = tostring(local!input))

I'm using the "a!startProcess" to call a process model from the Appian interface. The process model takes more than 30 seconds to complete. Is there a way to increase the timeout when calling the process model from the interface.  Do we have property in the a!startProcess for this? We are trying to keep this as a synchronous process. a!startProcess( )

I have two interfaces 1. Home screen display all orders 2. summary page From page 2 i click on an record action to copy where a process triggered and on completion of order.  the new window closes and still the old summary page is dispalyed on the other tab. Example. when record action for copy is been triggered from order 1. new screen for order creation order 2 created and after completion. still order 1 summary page displayed on other screen unles user clicks on the menu for home page and navigate to new  order order 2 the requireemnt expects the home screen should be displayed or order to be displayed after completion  is there a way. 

We have one record type on database View. Record type is configured with Filter applied to 3 columns only i.e. "Limit search to selected fields" GRID with Record type source is showing Data with paging=50 in UI and able to see data in next page as well. User sees data with some mandatory Input filter on selected column.  GRID is configured with showSearchBox option. Now if user is entering some value in default searchbox(this value is applied with the record filter configuration which is again on 3 columns) with record type then getting below error- An error occurred because the record types source is currently unavailable, or the query reached a timeout or memory limit.  I need to understand the sequence of the search value applied to the data- 1- Will this apply to whole data(10000 rows) available to view without any User mandatory filter or only to the data coming in the Grid(with user filter applied) for e.g. 2000 rows(with pagination 50 per page)

Hi All, what are the different Namespace available in CDT? Thanks in Advance.

I have a requirement to configure "Approve" and "Reject" buttons in an approval email notification. When a user clicks "Approve", it should open a new email draft with the body pre-filled as "Approved." Similarly, if the user clicks "Reject", it should open a new email draft with the body as "Rejected - Rejection Reason: ". I have created an HTML template with Approve and Reject buttons.   It works fine when the HTML template is opened in a browser. However, when I configure the "Send Email" node in the process and using the same HTML template, the email is triggered and delivered to Outlook, but the buttons appear as plain text instead of functioning buttons. What could be the cause of this issue? Can we achieve this in appian? Are there any suggestions or alternate approaches to achieve the desired functionality? What is the best practice for configuring actionable buttons in an email notification, in

We are facing issue like the value is Number(Decimal) when user enters - 1595739.56 it gets round of to – 1595740. Which is a concern here. Also any number which is of 7 or more than 7 digit are getting round of. We understand appian recommends the uses of ‘text field’ instead of floating point field, but this will lead to the column type changes in Database because those decimal columns can either be calculated in appian or in database stored procedures, hence as converting the column from decimal to varchar will required us to type cast them from varcharToDecimal before doing any calculation s and those are many fields which are used in calculations. Any urgent help/suggestion is really great help to me to progress.

Well, there is the reference of a!cardChoiceField. https://docs.appian.com/suite/help/25.1/card-choices-component.html The component itself is amazing. However it has one big defect, which is: you cannot (at least easily) change its card's background color. I would like to be able to keep the interface's background color on its default (as it is), and change the choice card background color to gray, black, blue, etc. So only, the card choice should get the customization. I've searched a lot and I didn't find any hint or previous usage on this. Does anyone have any idea in mind on what to do about it? I would like like this to be possible and if it's not, it should be implemented on a next version of the component. This is for UX/UI purposes.  Thank you in advance for any hints on this.

I have a timer process, where the timer configured as following: Timer condition is a environment constant, and we a switch in UI where user can change the constants value from false to true or from true to false, to decide whether they want the timer process run It has been working fine, but today when I  turn on the switch, which mean I changed the value of the constant from false to true, the timer process is not triggered Can anyone advise?

Hello dear Appianistes,  I have a gap between how my app reacts in development tools (build) and in the site, Site : After using AJOUTER button : Builder : After using AJOUTER button : Any guesses ?  buttons: a!buttonLayout( primaryButtons: { a!buttonWidget( label: if(ri!isUpdate, "Enregistrer", "Ajouter"), saveInto: { /*sous-periode*/ a!forEach( items: local!sous_periode, expression: { a!save( ri!sous_periode[fv!index]['recordType!{77c00203-ec59-4d91-815a-0f6334649b51}alan_r_sous_periode.fields.{38d14ae2-8fd9-40ee-a277-dbc90afc6266}dateDebut'], local!sous_periode[fv!index]["deb"] ), a!save( ri!sous_periode[fv!index]['recordType!{77c00203-ec59-4d91-815a-0f6334649b51}alan_r_sous_periode.fields.{368c8cd0-aeff-4d35-b85f-e83787ea7fa8}dateFin'], local!sous_period

Hi, While running the installer getting below error after 'extracting setup files' Error in action ExecuteAction Error in action InstallSelectedFiles

I used if() to check the condition in Value() parameter of dropdown which is working fine from front end, but the value is not saved when i use the same logic in SaveInto() parameter of dropdown. Logic used in Value() parameter:  if( and( ri!eventType = cons!INS_INT_EVENT_TYPE_ID_ANZ_ARREARS, ri!policyNo = cons!INS_TXT_MULTIPLE ), "Contact Centre Outbound", if( and( ri!eventType = cons!INS_INT_EVENT_TYPE_ID_ANZ_ARREARS, ri!policyNo = cons!INS_TXT_SINGLE ), "Contact Centre Inbound", index(ri!application, "incomingSource", null) ), ) Logic used in SaveInto() parameter:  { if( and( ri!eventType = cons!INS_INT_EVENT_TYPE_ID_ANZ_ARREARS, ri!policyNo = cons!INS_TXT_MULTIPLE ), a!save( ri!application.incomingSource, "Contact Centre Outbound" ), if( and( ri!eventType = cons!INS_INT_EVENT_TYPE_ID_ANZ_ARREARS, ri!policyNo = cons!INS_TXT_SINGLE ), a!save( ri!application.incomingSource, "Contact Centre Inbound" ), ri!application.incoming

Hi all, I'm going crazy about this: I want a multiple dropdown be populated by a d query on a data store: local!config: a!queryEntity( entity:local!dse[ri!dse], query: a!query( aggregation: a!queryAggregation( aggregationColumns: { a!queryAggregationColumn(field: ri!fieldName, isGrouping: true) } ), pagingInfo: a!pagingInfo(startIndex: 1, batchSize: - 1) ), fetchTotalCount: false ).data[ri!fieldname], and this is my dropdown configuration: a!multipleDropdownField( data:null, placeholder:"null", choiceValues:local!config, choiceLabels:local!config, label: "", labelPosition: "ABOVE", value: ri!value, saveinto: ri!value, searchDisplay: "AUTO", marginBelow: "NONE" ) but in test display it generate this error: Could not display interface. Please check definition and inputs. Interface Definition: Expression evaluation error at function a!multipleDropdownField [line 4]: A multiple dropdown component [label="Multiple Dropdown"] has a