Discussion Categories

Hi there. I'm creating a new Connected System object to connect to an Oracle database. I have to fill the fields related to the Connection URL, User and Password. Considering that when I deploy the application to the production environment I will need to change the connection settings, is there a way to get this information from a properties file instead of setting this object again in the production environment when the application is deployed? Thanks in advance.

Hello, I'm facing an issue while exporting the package, it's showing as in progress since a long time, Has anyone encountered the same issue before? pls let me know. The package has a single object to export. Thank You!!

hi, I was wondering if I can export data in process model  with expression rule? Data from expression rule: List of Dictionary - 2 items    Dictionary           name "John"(Text)           memberID"X123"(Text)    Dictionary         name "Jane"(Text)         memberID"X456"(Text) Export the below data to csv or txt file( without any header) John, X123 Jane, X456

Hi Team, Appian seems down for me https://us.appian.community/ Getting below maintenance Page, would be helpful if you can help ETA for restoration

Hi All, we are getting JDBC begin transaction failed: in the process model when one record going to store in database. and another process  model we are getting -Unable to write to or delete from the source due to system error.Error Details: Failed to update database "TN_Transaction" because the database is read-only. note : both error happening at same time.  could you please someone help me on which scenario we wil get this error. thanks!

Hi everyone,I’m signed up to the Appian feed on Sprout Social https://advocacy.sproutsocial.com/feed (formerly Bambu). It’s been a great source for Appian articles. However, I have no idea how I signed up originally and no idea how to have a colleague of mine sign up as well. In my personal settings I'm not an admin, team lead, or anything like that.Please could someone assist in the steps to have a colleague of mine sign up, so that they too can access the Appian feed on Sprout Social? Or is as simple as creating a Sprout Social account and searching for Appian?Many thanks.

Issue with DOCX Page Count Plugin - Incorrect Results Hi Team, We're encountering an issue with the DOCX page count plugin we're currently using. This is impacting our document processing and causing problems with element positioning. Problem: The plugin is incorrectly reporting a page count of "1" for some DOCX documents when they actually contain a significantly higher number of pages (e.g., 22 or 25). Impact: This incorrect page count directly affects our element positioning logic, leading to misaligned elements within the documents. Our use case relies on accurate page counts to properly position elements. Investigation: We have thoroughly examined the affected documents and found no issues that would explain the incorrect page count. The page count reported within the document's properties/info section is correct (e.g., 25 pages). This suggests the problem lies within the plugin itself. Urgency: This issue is blocking our workflow as

I need a plugin or a way to delete packages using a function in an interface. We are building an interface where we specify the packages that are already deployed, so it can be deleted automatically for storage purposes.

Hello Team, There was a course related to 'Install and Configure Appian for On-Premise Systems'. This course had a topic regarding Appian Log files summarizing the important points from Appian Logs. Does anyone know if Appian Log related content can be found as part of a different course? Regards, Sabry

Hello Appian Community, I've been given a somewhat complex JSON format to ingest into Appian and stage all the data into the DB.  The intention of the data is for reference/comparison/reporting.  I've tested the regular readtextfromfile/fromJson/jsonPath functions to grab each attribute but it feels very tedious/clunky to have an JSON path expression for ever attribute I need.  Could I get any advice on a more efficient way to parse this data and get it in the DB? Data Context: One JSON will have thousands of "FullProduct" entities so I will be dealing with files with a size of at most 25MB.  This structure is the final format so there is no altering the original file. JSON Sample: { "FULLPRODUCTFILE": [ { "FullProduct": { "ID": "*dfg333", "Details": { "StatusType": "LIVE", "Status": "ACTIVE" }, "Classification": [

Hello, I have submit disabled, validate set to true, required set to true but the required message only appears on one field when clicking save button. Here is my code for the amount to refund field:   a!sideBySideItem( item: a!textField( label: "Amount to Refund", labelPosition: "ADJACENT", value: if( local!updatedStatus = "Closed - Full Refund", a!currency( "USD", local!data.paymentAmount ), a!currency("USD", local!refundAmount) ), saveInto: local!refundAmount, refreshAfter: "UNFOCUS", required: if( local!updatedStatus = "Closed - Partial Refund", true, false ), required

Does appian support wild card certificates? in the form of *.dev.orgname.com

I have created a rule to display date time how to resolve it ?

I have a REST service that posts a lot of data to a table in Appian (136k+ rows).  The problem is the primary key in the service is not the same primary key that Appian is using.  I cannot match the keys because, the service's key is unpredictable.  Government data, yea!   For my REST post I simply need it to find the record with a matching value (if it exists) then update it, or else create a new record. a!localVariables( local!value: cast( 'recordType!{b44d0eeb-090e-4c8f-b858-1f684423adbc}DCQ Weekly Extract', a!fromJson(http!request.body) ), a!writeRecords( records: local!value, /* * Construct an HTTP response to return to the caller */ onSuccess: a!httpResponse( statusCode: 200, /* * Set an HTTP header that tells the client that the body of the response will be in JSON format */ headers: { a!httpHeader(name: "Content-Type", value: "application/json") }, /* *In

Hi All, I need to connect and post data in to an existing table in share point. How to connect with that existing table and in where can i find those details in microsoft documentation. Thanks, Ganesh.

log file name where all user data exist which contains when user got created and deactivated.

How to get an Active and Inactive users in appian .. also what was the time when  they got deactivated.

Hi All .I hope everyone is doing good. I have a scenario , but not sure if its possible / correct/not . Please let me know if any one has any ideas or any suggestions. Scenario: I have used navigation pattern in interface . This uses different interfaces in choose function and get the data accordingly .  Is it possible to do it in a single interface instead of using multiple interfaces or can we use a single grid ( instead of calling a!grid and the data for all the remaining status) and call the value in local variable and pas the local variable and get data accordingly .........! Below is the code for an idea what i am describing about . Any ideas / suggestion please let me know. Thank you in advance [emoticon:c4563cd7d5574777a71c318021cbbcc8] { a!localVariables( /* The selected navigation section */ local!activeNavSection: 1, /* The navigation sections */ local!navSections: { a!map(name: "Requested"), a!map(name: "Inprogress"), a!map(name: "Delayed&q

Hi, I am working my way through the associate developer learning path but the environment is currently down. What languages would you suggest brushing up on? I have an undergraduate certificate in programming and have recently completed a bootcamp. I have experience in - html/css - js - ruby - rails (a long time ago) - python (my favourite) - django - react Thanks in advance!!!

I have a question about the text() function.When I used "#" in the second argument to text(), the following behavior occurred.When I tried to match the digits and separators to the format,the numbers after the decimal point changed.The documentation says that "#" is a format for numbers,but does it also convert the numbers themselves? ・document docs.appian.com/.../fnc_text_text.html ↓exmapletext("12,333,333,333,333.12","##,###,###,###,###.##")　→　"12,333,333,333,333.11" is returned.

Hi  Team, I am trying to generate the excel with 100 columns in the same sheet. Since there is a limit of 50 columns per sheet I am trying to use the same service two times so that I can generate the required columns. But the issue is it is either generating the remaining 50 columns in the separate sheet or replacing the first 50 columns with the second 50 columns. Is there a way where i can generate all the columns in a single sheet? Thanks

hi,  I am trying to split a map based on user input  local!data: { a!map(id: 1, name: "Alice", age: 10, city: "New York",school:"NewYork"), a!map(id: 2, name: "Bob", age: 12, city: "Los Angeles",school:"NewYork"), a!map(id: 3, name: "Charlie", age: 13, city: "Chicago",school:"NewYork"), a!map(id: 4, name: "David", age: 14, city: "Houston",school:"NewYork") }, if I give input : age  I should get two  local!data1:{ a!map(id: 1, name: "Alice", age: 10, ),a!map(id: 2, name: "Bob", age: 12, ),a!map(id: 3, name: "Charlie", age: 13, ),a!map(id: 4, name: "David", age: 14, )}  and  local!data2:{a!map(city: "New York",school:"NewYork"), a!map(city: "Los Angeles",school:"NewYork"),a!map(city: "Chicago",school:"NewYork"),a!map(city: "Houston"

It has been a missunderstood because I scheduled the exam for today 12 AM but in my country 12 AM means at the morning, not at the evening so my boucher is no longer valid to take the exam anymore. Do you know if is there any solution to reschedule the exam to another day with the same boucher? Right now, the state of my exam is "Not show" and is not longer valid. Thanks in advance.

I have a scenario where the users is viewing an interface from a record action.   Before they click submit to complete the record action I want them to click a button that will call an integration and that value returned will either allow them to submit or not (it is a backend validation process).   Everything I am trying I run into issues because the refresh variable.The code: a!localVariables( local!loggedInUserVar:fn!loggedInUser(), local!isLoading: false, local!isValid: a!refreshVariable( value: if( local!isLoading, rule!UWM_Map_Calculate_Data( caseId: ri!case.caseId, loggedInuserVar: local!loggedInUserVar ), false ), refreshOnVarChange: local!isLoading, refreshAlways: true, ), a!columnsLayout( columns: { a!columnLayout( contents: { a!sectionLayout( contents: { a!cardLayout( conte

I have a View in the Appian Cloud database with a column that concatenates some values, lets call it column "CODES". I started in our dev environments creating a CDT from Table/View and verifying the datastore. I then did a distribution to the test environment of the CDT, View and Datastore. While verifying in test environment I get an error that CODES is not a MEDIUMTEXT, it's a LONGTEXT. Not knowing what to do I try to create the CDT in test environment and actually the generated CDT in this environment is different that the one that was generated in dev, even though the database view is the same. Any suggestions on how to solve this issue? The thing is that I don't know in a production environment which datatype Appian will choose, and I don't want to create objects manually in production, I shouldn't even be able to. Thank you!