Foundation

Hi I am using below code but my value is not saved in the database. Please suggest. a!paragraphField( label: "operations", showCharacterCount: true(), value: local!cashNotesval, saveInto: { ri!comments, a!save(local!cashNotesval,ri!comments), a!save(ri!comments,save!value), a!save( ri!Transaction.comment_txt, ri!comments ), }, I am saving local value into rule input but it is not passing in database. Basically this local!cashNotesvals is autopopulated when on selecting dropdown value.But this value is not save in database. If i am typing manually in this paragraph field then value is saved.

HI everyone , Is it safe to remove the unnecessary heap dump files from the bin folder without stopping the services? If I delete these files, will it cause any issues? We've resolved the heap memory problem, and the application is functioning properly, but I need to clean up the storage. Thanks, Udhaya

I have an expression rule that returns a value based on rule inputs. When I run this rule as a stand alone rule, it gets the data I expect. When I run this rule in process model A, I get the result I expect. But when I run the rule in process model B, I don't get the results I expect. These 2 process models are child processes that get called at the same time, and have the same inputs. The node that runs the rule has the exact same inputs, settings, assignments, etc. I can't see any reason why the rule would work correctly when run manually, or when run from process model A, and not process model B. For context, they are expected to return the same value in both process models. Am I missing something? If it helps, I'm using Appian Cloud v22.3

I’m working on an interface where I need to display the latest update for each case dynamically. Here’s the setup: Data Source: A record type (HistoryCase) that logs all movements for cases. Another record type (CASE) storing the status of each case. Goal: Show the latest "Update" (LogText = 'Updated') for each case on a dashboard. Exclude cases where the status is "Close." Add filters for a specific date range (e.g., 2024-11-01 to 2024-11-30). Challenges: How can I efficiently query and display this data in an interface, ensuring performance for large datasets? What’s the best UI design pattern to display the results dynamically as the user applies filters? I’d love your suggestions on: How to structure the query for this use case. Best practices for designing an interface that’s user-friendly and responsive.

Hi All.  Am using Set External PV plugin to update process variable of two different process. Lets say process ids 12345 and 54321 and both PM are having same security. But I could able to update PV for process 54321 whereas I couldn't do the same for other process. Its showing below error.  "An error occurred while trying to update the PVs of process with id 12345: Insufficient permission" Can anyone suggest how to troubleshoot this? Thanks in advance!

On the Landing Page, I have a Navigation menu on the left and Record List on the right, When I click on the Loan Id hyperlink on one of the Record, it takes me to the Summary Page for that record clicked. Issue I am having is, the Summary page is taking up full page and overwriting the Navigation pane on the left hand. Please see 2 screenshots I have attached. How do I get the Summary page to be restricted to the right side of the Interface section and not go over the Navigation pane on the left?

hi I am trying to implement an editable grid , which should have collapsible rows  I am trying to avoid nested loops and wanted a check box option for all the rows . Any coding examples will help. Thank you

We currently support a site with a static image on entry for our internal users and customers. I was wondering if it's possible to have a video loop play in the background on entry navigation in Appian before progressing into the applications? As an example of a website that depicts a real pop in what the business offers: Kirby Corp has a great video of how the business moves chemical pressurized, dry bulk, or heavy product while still allowing the users to interact with the interface.

Hi, I have a process model where a rule is processed in a script task running parallel to a user input task. At the second AND gate, there are two possible scenarios: First API Call Path Reaches the AND Gate First: The API path reaches the AND gate before the user submits the task. This scenario works as expected, triggering the next chained User Input Task (UIT) in the process after the submission of first UIT. User Submits the Task First: The user submits the task before the API path reaches the AND gate. In this case, the next UIT is not triggered as expected. anyone knows what's the reason for this to happen ?note : the script task is not an actual API call but just an expression rule with some dummy dataThanks

Hi All,I have few records and out of those if i am trying to open any sync enabled records it's taking more than 30 mins ,not only opening if i am trying to sync these records it's taking forever.At the same time if i am trying to create or update any value for these synched records using "Write Records" in process model it's taking minimum of 15 mins, in some cases it's throwing "system encountered an error" , but when I checked in the database the write happened quickly (<1 min). We are using Oracle Database.We are not quite sure why this is happening,any leads /ideas? Thanks in Advance.

a!localVariables( local!map1: {    a!map(Id: "Map 1", key1: "A", key2: "C", key3: "C"),    a!map(Id: "Map 2", key1: "C", key2: "A"),    a!map(Id: "Map 3", key1: "C", key2: "B", key3: "C") }, local!map2: a!map(     Key1: "ky1",      Key2: "ky2",    Key3: "ky3" /*This list can be very long e.g. Key4: "ky4", Key5: "ky5" etc.*/ ), /*code here*/ /*desired output starts - swap the keys based on mappings in map2 */ /* {   a!map(Id: "Map 1" , ky1: "A", ky2: "C" , ky3:"C"),   a!map(Id: "Map 2" , ky1: "C", ky2: "A"),   a!map(Id: "Map 3" , ky1: "C", ky2: "B" , ky3:"C"), } */ /*desired output ends*/ /*Is it possible ?*

I have an expression rule will return 2 types of record type - Case - Error depends on if there is any error occur during the expression rule process so when I get the result from the expression rule, I do need to know what type is the returned value, how can I achieve that? I tried to use typeof(), but it does not work. I am wondering if I need to use type!, but I do not know how to write a valid reference using type!

I've got a requirement that needs a expandable readonly grid, I saw Expand/Collapse Rows in a Tree Grid - Appian 24.2 in other post but this is a gridLayout which seems can't be paged But I want the grid to be paged and expandable, the collapsed rows should be just same to the main row that can be selected and has recordactions in every row How can I implement this

  I have an Interface with Cancel and Submit button. This interface also has Rule Inputs defined for Cancel and Submit. I also had defined a process model for this Interface. I have kept the process model screenshot as well to this. When I am testing the Process Model, program always goes to "Import Excel to Database node", this happens even when I hit Cancel button the Interface. I feel the button clicks are not sending/capturing the correct values onto process model. Can you please let me what am I doing wrong here?

Hello there! Here is my use-case: I have a large record type (80'000 rows), which users want to be able to filter and export to Excel. It works pretty good, but my platform admin is kind of obsessed by the health of the platform. He is afraid that many user export the whole set of data at the same time, putting the server CPU into heavy load. So it is required to limit the number of records a user can export. Did anyone ever have something similar to do? I know the limit is set to 100'000, but can we decrease the same in some Appian administration setting? I see no property in the gridField to do so, e.g. to set "showExportButton" to false if the size of the dataset exceeds a given value. Is there any? I think it would be possible to obtain something with something like a readOnlyGrid or so, but I would like to avoid it for the pain of handling filters (and pagination?). Please help!

My project exists as three environments hosted on three separate URLs with three separate app names (dev, test and production respectively).  I want to make changes to my interfaces that only render in certain environments (mainly dev) so that they don't interfere with the client's UI experience.  I was wondering if there was some sort of metadata or variable that I could use to identify them for conditional logic.  I know pp! variables do something similar for processes.  Also, using string fragments from the unique parts of the URLs might work too, but I wasn't sure what methods are the current gold standard.

I am trying to build a custom export to excel icon which should download all the filtered records to excel. I can see a smart service i.e. write data store entity to excel but that is not useful in my case since i am using record type not cdt, hence no datastore exist in my case. Please let me know do we have any possibility to achieve this or not? I think just like data store entity there should be some feature related to record type as well but i cannot see that plugin.

Hi all, i have a related action that simply update a value in a record. Everytime i click on the action a loading page appears, like this one in link: see attachment/resized-image/__size/640x480/__key/communityserver-discussions-components-files/13/pastedimage1732014098437v1.png I want to not show it, i want to be able to see my site after the action.  Any suggestions? Thanks in advice

I have a requirement to convert date to text in this format yyyy-MM-dd.  First i used this function  datetext(local!date,"yyyy-MM-dd). but it didnt work for all users time zone. so i handled timezone by adding GMT function ie  datetext(gmt(local!date,usertimezone(loggedinuser()),"yyyy-MM-dd) This time it worked for all time zone.  But when i try to execute in the script task in process model, date is coming as -1 day. I also verified override with user time zone setting in PM is already checked.  Could you someone explain why it is not working. I am attaching snapshot 1. Admin console  2. my timezone setting  3. expression rule . I am getting expected result in expression rule  with different time zone. 4. PM timezone setting  5. result in PM script task when above expression rule is executed. Anyway, i was able to find out simplest function ie text (local!date,"yyyy-MM-dd).

I am creating a cardlayout button that uses an a!startProcess link (which is shown below). On the initial grid page, I have a cardlayout button that when selected initiates a Create/Update Process model that users can update or create records for. The process model takes in a dynamic input for what type of file to create, and what location the file is associated with. The main issue is that once the user either cancels the form, updates a record, or creates a record, the form does not refresh to the initial page with the cardLayout and grid view of all the current records within the database. The data is added to the database and shows in the grid view when the user manually refreshes the page. However, the task does not exit out of the form to enter/update/cancel data. I also double checked the create(update)/cancel buttons and both have submit as true. I am not sure why the process doesn't close and refresh the initial page the process was initiated from.I should also add that th

I am using Record List on one interface. I have two questions here: 1. Can we color the Record List Header that has column names? 2. Can we freeze the Record List header when I am scrolling the bar down?

Hi, I have a process model where a rule is processed in a script task running parallel to a user input task. At the second AND gate, there are two possible scenarios: First API Call Path Reaches the AND Gate First: The API path reaches the AND gate before the user submits the task. This scenario works as expected, triggering the next chained User Input Task (UIT) in the process. User Submits the Task First: The user submits the task before the API path reaches the AND gate. In this case, the next UIT is not triggered as expected.the API call is not an actual API call but an expression rule with dummy data in output

Hi,  I have a requirement to remove attributes with null values from a cdt, so that downstream system can consume it properly.  Given: {a:null, b: 10, c: "", d: 20} Expected: {b: 10, d: 20} Please let me know if there is an easy way to do this. 

Engine start-up fails after running the start.sh|bat script. Although port 2181 is free While attempting to start the ZooKeeper server using the start.bat command with the -p <password> -s all, 2024-11-14 15:51:17,675 [myid:] - INFO [main:o.a.z.s.q.QuorumPeerConfig@177] - Reading configuration from: C:\appian243\appian\services\conf\zookeeper.properties...2024-11-14 15:51:18,707 [myid:0] - INFO [main:o.a.z.s.NIOServerCnxnFactory@660] - binding to port 0.0.0.0/0.0.0.0:21812024-11-14 15:51:18,711 [myid:0] - ERROR [main:o.a.z.s.ZooKeeperServerMain@91] - Unexpected exception, exiting abnormallyjava.net.BindException: Address already in use: bind at java.base/sun.nio.ch.Net.bind0(Native Method) at java.base/sun.nio.ch.Net.bind(Net.java:555) at java.base/sun.nio.ch.ServerSocketChannelImpl.netBind(ServerSocketChannelImpl.java:337) at java.base/sun.nio.ch.ServerSocketChannelImpl.bind(ServerSocketChannelImpl.java:294) at java.base/sun.nio.ch.ServerSocketAdaptor.bind(ServerSock

Hi Folks, How can we make appian act as middleware where frontend is built in another tech and all the business logics should be performed by appian. Thank you for suggestions!