Discussion Categories

When I called the webAPI, I want to check the parameter that comes from by caller, I checked the check box of the webAPI properties. But I can not find any information in the web_api_req_resp log file. How can I get the api request information?

Hi , I have a requirement to make logic when suppose I have a table with different columns as: A, B, C, D and here there are 5 version for each row example: V1 has A1,B1,C1,D1 V2has A2,B2,C2,D2 and so on till V5 Now what is need to be done is when user is updating v1 version then he is allowed to update only D1  and once he update D1 column as 2 then future version of D2, D3, D4, D5 will only update as 2 when A1+B1+C1 combination contains exact value and if any of the version does not contains the combination of A+B+C then value of D as 2 will not update for that version example: V1:  A1=cat  B1=dog C1=bat D1=1 V2: A2=cat B2=dog C2=bat D2 = 2 while updating D1 = 5 ( V1: A1=cat B1=dog C1=bat D1=5) then value changes for V2 (future version only if a1 b1 and c1 is identical as a2 b2 c2): V2: A2=cat B2=dog C2=bat D2= 5 [mention:b45a4f6a20b14a008e4e0ec732a8bf98:e9ed411860ed4f2ba0265705b8793d05]  

We are migrating from deprecated 'executestoredprocedure()' to new a!executeStoredProcedureForQuery() function to call one stored procedure.  We have been receiving correct result with existing  executestoredprocedure() , however when we replaced with new function it's throwing below error, "Failed to process the stored procedure result due to encountering a duplicate column label: processParametersConfigId." Please let me know if anything needs to be changed in SQL script to use new function. Below is code to call SP, Below is actual Sql Query in SP, Thanks.

Facing the following issue when I tried Record Type Tutorial (Web Service) from the documentation Expression rule and integration for this tutorial are as follows Please provide suggestions to resolve this issue

I need to query the Appian database (MariaBD) from my KPIs application. What would be the best way to do it? Does Appian have any webservice available?

Hi,We have a task page where users will accept tasks and work on it. In the page, we have some filters as well. While trying to open the task without selecting the filter, the task opens normally and we are able to complete the task. But when filter is selected and trying to open task, we are getting "Are you sure you want to leave this page?" message. Any way how to not encounter this message

We are running a process based on given exact Date Time which is stored in UTC entered by the user in the UI with schedulers. Lets take example the scheduler planned to run at 11/10/2024 12:00 AM,  and its stored in DB as 11/10/2024 -4:00 UTC. When time zone change from EDT to EST its coming as 11/09/2024 11:00 PM which kicks the process 1 hour before which is not expected. I'm wondering so all the dates entered or captured in DB during EDT will be shown in Appian as  Actual time - 1 hour. Isn't this unusual?

Hello, I have been trying to establish SSO for Appian. I have uploaded .pem file and IdP metadata as well, also I have filled out all rest the information required in SAML form of Admin portal. But I encountered below issue when tried to test the configuration.  Authentication was unsuccessful. Reason: The user you attempted to sign in as does not authenticate through SAML. Close this window and return to Appian Administration Console. I see this is tomcat logs :  ERROR com.appiancorp.security.auth.saml.SamlTestServlet - Error occurred during SAML authentication test: null com.appiancorp.security.auth.saml.exception.NonSamlUserExceptionFYI, IdP is Azure Ad. Interesting part is Azure sign in logs mentions that the connection was successful even though we see above issue response from Appian

I am working on the following step in the Interfaces 101: Build Forms and Other Interfaces shown below.  I have run into an issue with configuring the rule inputs. The directions are unclear to me and I am receiving the following error:  I have named the rule input "vehicle" and made it a W777SA Vehicle data record type. I'm uncertain what the value for the "Value" field should be. 

Faced this issue when tried this tutorial Expression rule and integration for this tutorial are as follows Please provide suggestions to resolve this issue Thanks in advance

Hi All,Is there any way to create the fields dynamically in cdt and then assign values. I have a use case,User will be uploading a excel and i need to show the excel data in grid format (excel can be different),So for that i am using readexceldata function and and I am trying to create a cdt with the column names and their respective row values (here column names are dynamic) to use that in the data field for grid field. Ex:excel file has 2 columns A,B now the cdt will be an array of row data like {{A:first row A value,B:first row B value},{A:seconf row A value,B:second row B value}} and if the excel has 3 columsn as A,B,C then the expected cdt should be {{A:first row A value,B:first row B value,C:first row C value},{A:seconf row A value,B:second row B value,C:second row C value}} and use this cdt in gridfield data parameter. Thanks in Advance,SSP

"I am having trouble displaying checkbox values in a PDF generated by Appian. I am using a PDF Doc Template, and the checkbox values are not displaying as expected. Here’s a screenshot of the issue. Can anyone help me figure out what I might be missing?"

Hi can anyone help? This is the error we are receiving as you can see that the datat server has started successfully but we are getting the below error and when run health.bat its showing health status as false. {"level":"INFO","time":"2024-10-25T06:57:41.932Z","logger":"watchdog","caller":"LogRotation.java:58","thread":"log-rotator","msg":"LogRotation is enabled. To disable, set property "wd.log.rotation.interval.seconds" in file "C:\appian24.1\appian\data-server\bin\..\conf\custom.properties" to a negative number"}{"level":"INFO","time":"2024-10-25T06:57:43.016Z","logger":"watchdog","caller":"Watchdog.java:1349","thread":"main","msg":"Data Server started successfully."}{"level":"INFO","time":"

In my process model i am giving multiple timer for sending notification in every timer am passing process variable with some calculated date and time value but when the date and time passes timer is not getting triggered what can be the issue and process is still active .Note-> whatever Process variable am passing with some calculation in process details am seeing the value like 11/10/2024 6:00 pm.

Appian delivers process automation powered by enterprise AI. We help organizations design, automate, and optimize business processes with a unified platform for process orchestration, automation, and intelligence. This release, Appian 24.4, welcomes Appian Autoscale and new updates to the Appian Platform for process automation, data fabric, enterprise AI, and more. Join our team of Appian experts as they dig into highlights from the release. Tune in to see Appian 24.4 in action and ask the experts your questions. Turn on notifications to make sure you don't miss it!

Hi all, I installed Hotfix 23.3.1380.0 and after I start Appian, I see a login page and after login I only see a blank screen for all URLs /design, /tempo, /sites. Anyone else experienced anything similar?

Hello Appian Community, I'm trying to figure out why both of these codes don't react the same way ? Any guess ?

Hi, I am starting the online academy course (Appian Dev) . I would like to know how to restart a process using the Web API. I have been successful in starting a process using Web API.Now I am wondering if it is possible to use Web API to resume a process that has already been started.

I have a process that has data that flows into fields within a PDF. After that document been created I want the document to be flattened to make it read only, then to add a layer from a duplicate document (with the portions we want still fillable). I can't figure out a solution to make this possible. Does anyone have any suggestions.  We have the PDF Tool Plugin currently.

For partners focused on government sales, the new Government Acquisition Management (GAM) learning journey offers essential resources to help you deliver Appian’s government acquisition management solution. In the learning journey, you'll find our collection of training for Appian Solutions, implementation resources, and just-in-time resources for developers. Explore the Government Acquisition Management learning journey in the partner resource library!

Hi All, I have created a new custom record field for a record type - this new record field depends on a relationship with another table . So when I'm writing to the child table(relationship table) how long does it take the main table with the new custom record field to get updated? I'm asking this because first I write to the child table then I want to write to the main table using this new custom record field for a calculation. The issue I'm facing is that the main table record field is not getting updated quick enough before it writes - its considering as if the new custom record field is empty , I tried adding a sync node before writing to the main table but is still not working. Any recommendations here?

Hi there,  I have a record type, just want to show the recent 7 days data, so in "Data Model" tag, I added a filter like this: a!queryLogicalExpression( operator: "AND", filters: { a!queryFilter( field: "verifiedon", operator: ">", value: todatetime(today() - 7) ) }, ignoreFiltersWithEmptyValues: true) but seems it did NOT dynamically sync, after just set the filter, I manually sync, I just saw the last 7 days data. but for today, it's supposed to just see the data since 6/24. but I still see the data older than that. so do I need to set the sync options to do the sync every day? or any better way to do this? regards, L

Hi All, For Site tab we want to show ÖPPNA ÄRENDEN (means Open Cases) but instead it is showing like this OPPNA ARENDEN which is not correct as per Swedish language translation. Please guid us on this issue.

Hi everyone, I'm using the latest Appian Community Enviroment, but I can't finish the Step 5.  In the Edit List part I use this Expression: if(a!isNullOrEmpty( fv!row[recordType!W#SA Vehicle.fields.image] ), a!EXAMPLE_DOCUMENT_IMAGE(), fv!row[recordType!W#SA Vehicle.fields.image] ) And I get the following error:  Expression evaluation error at function a!gridField_23r3 [line 51]: A grid component [label="null"] has an invalid value for "columns". A grid column [label="Image"] has encountered an error. Expression evaluation error at function a!imageField [line 52]: User Does Not Have Rights to Perform this Operation I don't have access to the database or any vehicle data to manage the user permissions.Thanks!

I have two processes: Process A and Process B Process A calls Process B using the SubProcess Smart Service. When Process A starts it will have a target completion date for the entire process. Process B is configured with a ProcessVariable that indicates a number of weeks prior to the target completion date that it should start (pv!startWeek). What I would like to do is set the scheduled start of the Subprocess Smart Service node based on that value like: = a!subtractDateTime(startDateTime: pv!reset_date, days: pv!startWeek * 7) My issue is that I'm currently not able to reference pv!startWeek from ProcessB from the Configuration of the SubProcess Smart Service in that calls it from ProcessA.  Is it possible to access this value in the configuration of the Smart Service? Is there a better way to set this up?  I'd prefer to keep this config in the SubProcess Model as I wouldn't want to change all of my processes that call this SubProcess if we determine the sched