Foundation

We have a use case (on Appian), where a user wants to see both the older as well as new updates made to any field of a Record, and to pull out an excel version of the same from Appian. For example, a record with Car's mileage initially marked as 10000, and then updated to 12000, the user wants to pull an excel that shows two rows of thus record with both the mileage values, also with a timestamp (Created or updated date)

Hi all, We are currently running into an issue with selecting record action items with the Cucumber for Appian framework.  We've tried every possible predefined Appian step and fixture.click related to actions and buttons, using both the action name, key and index; however, it does not seem to detect the component.  I attached the snippet of code of how the recordActionField is configured: a!recordActionField( accessibilityText: "Actions", actions: { a!recordActionItem( action: 'recordType!{cf46c7e0-d175-4d07-9daa-2d3a1739795e}ECMS Patrol.actions.{6c6e1f29-2673-4099-a78d-305b32688e93}createPatrol' ), a!recordActionItem( action: 'recordType!{46271c62-4660-4e17-a39a-a5ea6a9eca68}ECMS Incident.actions.{e51cba01-d80a-4893-a583-21c711ff357b}createIncident' ) }, style: "CALL_TO_ACTION", openActionsIn: "DIALOG", align: "END", showWhen: a!defaultValue(value: ri!showActions, default: false) )

Hi guys, In editable grid i have two fields one is scheduled date and one is Assignee. Condition: Scheduled date is mandatory field if the user add any name in assignee field. If there is no name in assignee field, the system should allow to continue without scheduled date. I tried this below code but its not working fine 1. When we add assignee and scheduled date its working. 2. When we add assignee without scheduled date i am getting a warning message. 3. When we add scheduled date without assignee its showing nothing, but i want to get display error message as "The scheduled date is mandatory if assignee is populated. Code: required: if( not(rule!AF_RULE_General_isBlank(ri!riskAssessmentData.assignee)), true, false), validations: { if( and(not(rule!AF_RULE_General_isBlank(ri!riskAssessmentData.assignee)),rule!AF_RULE_General_isBlank(ri!riskAssessmentData.scheduledDate)), "The Scheduled date is mandatory if there is an assignee", {} ) }

i made a expression rule (Name of Expression rule -> CD_Dict) of dictionary: { Sunday:{0,6,13}, Monday:{0,7,14}, Tuesday:{1,8,15}, Wednesday:{2,9,16} } i made another interface in which i selected "Read-Only" grid and pass that CD_Dict(Dictionary Expression) as a data in read_only grid. now my output look like this -> but i want these values in separate-separate rows. All the values are showing in single cell i want output like this: Sunday     Monday    Tuesday    Wednesday     0                 0               1                2     6                 7               8                9    13               14  &n

I have a requirement where i need to filter values according to date but the field in CDT is given as date and time field.  For Eg: bookingDate in CDT is the date and time field.  But, when I filter the data in the expression rule ,  I need to get data based on booking date only not time. ( For eg: I need to get the number of people who booked the tickets for the day but i dont want  according to date and time I just want the count for the particular entire day). Can anyone please help me to solve this! Thank you in advance.

We have a requirement to build the scheduler process to run 3 days before every quarter. The  Logic has been built in the expression rule . When I am trying to call the rule in the timer to get the specific day to run, the process is not running whereas when I implicitly paste the logic, it works. Is there any limitations that expression rule can't be evaluated inside the timer.

Client has requirement as below if upload of file is failed because of some validation then that circle of file upload should be red of half circle can we meet this type of requirement 

Hello, We have a problem when uploading a document with a webApi, to do the test we are using postman, we pass the document to it, we pass it the name and the extension as follows: We see that it goes up to the folder that we have indicated in appian, but when we try to download it to open it, it tells us the following: I have tried with jpg and the same thing happens to me: code: a!localVariables( /*Check whether the request body contains a document*/ local!success: not(isnull(http!request.body)), if( local!success, /*If a document was uploaded, return a successful response*/ a!httpResponse( statusCode: 200, headers: {}, /*Print the document id, name, and extension of the uploaded document*/ body: concat( "Upload Successful: ", document(http!request.body, "id"), " - ", document(http!request.body, "name"), ".", document(http!request.body, "extension") ) ), /*If no document was uploaded, return an error code*/ a!htt

Hi, How can we save the values to the database when a n-number of rows are added to editable grid. I have table(table1): Now I have each row values saved to the rule input. In the process model, when I write to a database only a single row is added. What can I do to add all the rows.

After i click on a particular record in a list , i get this record summary page . So, i inserted back button to go back to the list . But when i click on the button , it goes back to the list but it contains the record summary header ( like seen below , with the record title and related action). Can anyone suggest how to solve this ! I tired using the safe link as well , but it didnt work.

Suppose there is a sub process in a main process. When we execute main process multiple times then it will generate multiple instances for main process as well as sub process. So how to identify which sub process instance belongs to which main process instance?

Hello, I am using the appian selenium api library for my tests and my problem is: How can I locate a textbox that does not have a name? I am currently using: fixture.populateFieldWithValue("", "");  but I don't know how to use if the element doesn't have name. ¿There are a way to use xpath us selenium? ¿There are another option that i can use?

Is Apian Mobile app iOS 15 Compliant  ?

We are using MySQL DB, we have a use case where a text column in the DB table is having a UNIQUE constraint that accepts NULL, all values apart from NULLs have to be unique.While using write to DSE smart service, Appian product by default is converting the NULL value to empty value/empty string and mapping to table, due to which we are facing issues due to unique constraint while inserts.Please suggest a solution to overcome this issue.

I'm trying to load in a grid on interface an excel file content. I use a file upload component, and on submitform button i use a "startprocess". "OnSuccess" event i'm trying to get a PV that contains the parsed value, return null. I have had a first problem that going to fail the process but i introduce a 1 second delay on a node and now the process end everytime successufully, but i cant get that value in my interface. With same sintax i'm trying to get a pv that i'm just passed like process parameter, so that variable (a simple number) i have successufully recovered, from the same process.

Hi, I have a CDT meeting_details, in that I have a field attendees with type CDT  Child CDT named Attendees is the foreign key in the parent table In Interface I have used User picker, and collecting multiple users into text format, further I will be using those users to create a group and users into that.When i am trying to use write to multiple data store entities and giving a single user in the interface, the parent as well as child table is getting updated, but when there is a array of users from interface, then it is populating this error. I am providing here the code for configuring of write to multiple data store entity smart service = { { entity: pv!meetingDSE, data: { pv!meetingDetails } }, { entity: pv!attendeeDSE, data: { pv!attendeeData } }}I am providing here the process variable snippet Can anyone help me out from this issueThanks in advance Prithvi

if( fv!success, if( /*In the response, if the resultCode parameter is "Error," or the errors parameter is not null, return false*/ or( fv!result.body.messages.resultCode = "Error", not( isnull( fv!result.body ) ) ), false, true ), false) The API response I am getting  HttpResponse statusLine: "HTTP/1.1 200 OK" statusCode: 200 headers: Dictionary Cache-Control: "no-store" Pragma: "no-cache" Content-Type: "application/json; charset=utf-8" X-OPNET-Transaction-Trace: "9d4ed313-4f4e-4699-9a26-8192fc4fabcb-3288-74350853" Access-Control-Allow-Credentials: "true" Access-Control-Allow-Headers: "x-requested-with,cache-control,content-type,origin,method,SOAPAction" Access-Control-Allow-Methods: "PUT,OPTIONS,POST,GET" Access-Control-Allow-Origin: "*" Strict-Transport-Security: "max-age=31536000" X-Cnection: "close" Date: "Tue, 26 Oct 2021 08:59:16 GMT"

Hello, In a project we have to do an appian update from version 19.2 to 21.3 and therefore we are reviewing the pugins.Until now we had a service exposed in appian in which the service that called us passed us a string in base64 in a json and we converted it to a document with the smart service base64todoc, it seems that this plugin is deprecated for the new version.Does anyone have any idea how to supplement this functionality? I was looking and I saw the integration object but in this case it would not help us because they consume us and they already pass this chain to us at the entrance. Greetings and thank you

I have one CDT where a single field which stores date and time. Now i am selecting a date from datefield component. I have a grid in the same interface where i am selection date from datefield. Once i select a date from this datefield, then the grid should filter all the dates from the grid .How can i do that?

Hi Community, Just wondering if there is a way to download a document automatically upon loading the user interface. Please share your thoughts. Thanks, Arun

Does anyone know, when a process model is republished, who gets the email?  I always thought it was the designer/author of the process model.  However, our objects in an upper environments have a service profile as the designer/author.  The service profile has a distro list as it's email address.  I'm told (I'm not on the list), that for our application they are getting the "Alert: Sub/linked process models are republished" emails, but for another application they are not.  Is it possible to configure these emails by application or object when a republish happens?

For a short period of time, perhaps since we upgraded to 21.3, I've noticed a strange behavior with Dropdowns. When I pass a null value, I get a pink box that says I need to provide a placeholder text.  This is expected.  However, now, when I DO provide the placeholder text, it still complains in a completely different error that simply states that it has received a null value.  But dropdowns with placeholder text are SUPPOSED to accept null values.  I haven't found a way around the issue except to trick it into working by making sure the value is never null, and providing a value to replace null if it is. Basically, placeholder text now seems to be useless.  Is this an Appian bug?  Does it work differently now?  Are placeholders redundant?  Is it the 21.3?

how can we change the language of the interface in appian, when i had a gulf customer as a user

How to get the data from GraphQL to the Appian Interface. Please suggest different methods.

Hello everyone! Im just toggling with the documentViewerField function and would like to know how to hide the documentViewerField once the user clicks on the dynamic field [that opens up the field]. I've tried toggling with the code for a while but was not successful. Any advice, tips, guidance is welcomed [emoticon:c4563cd7d5574777a71c318021cbbcc8] Code:  a!localVariables( local!documents: {47149, 47150}, local!link, a!forEach( items: local!documents, expression: { a!linkField( links: a!dynamicLink( label: "Click Here to View File: " & document(documentId: fv!item, propertiy: "name"), value: fv!item, saveInto: local!link ) ), a!documentViewerField( document: fv!item, showWhen: fv!item = local!link ) } ) )