Discussion Categories

Hello guys, can anyone explain how the save draft functionality works in some detail. In my task i have a grid in which i select a row and then press save draft. After opening the task again, the row is not selected. 

I am not able to select multiple selection from the multiple drop down list and able to select single option,I am getting error like below. Please suggest in the code what needs to be done getting below error if I select multiple options.

Hi All, One of the if conditions in a XOR gate is defined as follows and the output is getting written to a DS entity. However, this code is getting stuck at the XOR gate level itself giving the error as below. Please advise:Error: An error occurred while evaluating expression: =a!localVariables( local!statusCode: if( rule!APN_isBlank( pv!RMO_CDT_TxnLog.responseMessage ), "400", a!fromJson( pv!RMO_CDT_TxnLog.responseMessage ).StatusCode), and( or( local!statusCode = "0", local!statusCode = "200" ), pv!Result.statusCode = "200" )) (Expression evaluation error at function a!fromJson: The jsonText parameter was not valid JSON.) (Logic Output)Code configured in XOR gate: = a!localVariables( local!statusCode: if( rule!APN_isBlank(pv!RMO_CDT_TxnLog.responseMessage), "400", a!fromJson(pv!RMO_CDT_TxnLog.responseMessage).StatusCode ), and( or( local!statusCode = "0", local!statusCode = "200" ), pv!Result.statusCode = &q

I have an authentication problem when connecting my integration with the Connection System, my credentials are correct since I have checked them in different ways, for this reason I have not been able to continue making my call in the interface.

We have created a process model that retrieves an XML file from an external system and starts a new process instance using the "Start Process" smart service. The second process instance then extracts data from the XML file and stores it in the database. Despite deleting the process instances after completion, we are experiencing increased memory utilization over time. The memory is not being released from RAM, even after the instances are deleted. We need to understand the mechanism Appian uses to release memory from deleted instances. Is there a specific Appian process or configuration that ensures memory is properly freed up? If not, are there any additional steps or practices we should follow to manage and optimize memory usage effectively?

Hi All,  getting an error as below and flow is stuck at XOR gateway. Please advise:Error:An error occurred while evaluating expression: =a!localVariables( local!statusCode: if( rule!APN_isBlank( pv!RMO_CDT_TxnLog.responseMessage ), "400", a!fromJson( pv!RMO_CDT_TxnLog.responseMessage ).StatusCode), and( or( local!statusCode = "0", local!statusCode = "200" ), pv!Result.statusCode = "200" )) (Expression evaluation error at function a!fromJson: The jsonText parameter was not valid JSON.) (Logic Output) Code in XOR gateway: = a!localVariables( local!statusCode: if( rule!APN_isBlank(pv!RMO_CDT_TxnLog.responseMessage), "400", a!fromJson(pv!RMO_CDT_TxnLog.responseMessage).StatusCode ), and( or( local!statusCode = "0", local!statusCode = "200" ), pv!Result.statusCode = "200" ))

Hi experts, I have an interesting requirement and I am currently investigating whether it is possible in Appian or not. The requirement is to have a page that is constantly refreshing so it always shows the latest data on the screen and ideally have that auto-refresh prevent the logged in user from getting timed out/auto sign out due to inactivity. I've set the session timeout for my app to the minimum which is 15mins. The data of the dashboard is coming via stored procedure. I've tested this by adding the refreshVariable function together with the refreshInterval property for a local variable on the page that just keeps getting a random number and each time the refreshInterval hits, the number shown on the interface gets updated. This seems to work although I haven't tested whether this would work when the data of the local variable is coming via stored procedure. Regardless, it still doesn't prevent the time out.  In summary, my data is coming from stored proce

I want to have users upload files within a foreach - ie like an array of arrays. Think a use case like an apartment/landlord asking for multiple documents for same person ie banking will have multiple documents, ID will have multiple docs, references, etc. But all within the same ForEach in the interface. Each element of the ForEach has a different file upload instance. Thoughts?

Hi,I'm trying to create a very common UI with a background image in the background using a billboard section and a search box like the examples below but I get an errorCould not display interface. Please check definition and inputs. Interface Definition: Expression evaluation error at function a!barOverlay [line 12]: A bar overlay has an invalid value for "contents". The overlay contains a component that is not supported in the billboard layout. Received: TextField.:  is there a way to accomplish this in appian ? Thanks in advance 

We’re wondering if anyone have any recommendation in applying hotfixes after a major upgrade, I see that hotfixes are released weekly.Can the hot fixes be done via rolling restarts(with no downtime of the environment) ?

Hi All, I have a requirement in which i am opening summary page in new tab, and from previous tab i have deleted that record through record action. Now, when I am going on summary page tab of same record, and reloading the UI, It is showing error like  "An Error has occurred. Record does not exist, either deleted or don't have permission " Please help me if there is any way i can replace this message with custom appian UI showing This URL does not exist and 404 - not found  Thanks in Advance, Shree Krishna Tiwari 

You are referencing and using arrays of a CDT (Custom Data Type). Which two statements are true? (Choose two.) A. Other Appian functions can be used within the square brackets "[]" when using dot notation to return specific data from the array. B. There is no difference between using "dot notation" and the index() function. C. An array of integers can be passed as the second parameter to the index() function to return the data at those position in the array. D. The function where contains can act on operands of different types. I think options B and C are correct. Option D is incorrect. However, option A is not clear to me. The following code does not give any error: Hence, is option A correct? If that is the case, which one is incorrect?

Hi Experts, I am using a grid layout and I have rule input of array type, I want to select data present at specific index in rule input, Please help  me how can I get index of array type rule input? Thanks in advance.

Hi All, I'm using the Aspose plugin for converting DOCX to PDF, specifically the Convert DOCX to PDF feature. The original DOCX file uses the Open Sans font, but when converting to PDF, the font formatting changes. The plugin has an input variable for font IDs, which is an integer. what could be Could  provide the font ID for Open Sans? Alternatively, is there a way to ensure that the PDF retains the same formatting as the DOCX? Thanks in advance!

We are trying to deploy SQL scripts through Appian's compare and deploy, but we ran into this error: Access denied; you need (at least one of) the SUPER, SET USER privilege(s) for this operation The user who requested this package to be deployed has system admin permissions in the target environment, and I'm 99% sure they have system admin permissions in the source environment too. They weren't the ones who built the package itself though, but I'm not too sure if that matters here? Does anyone know what this error is referring to?

Hi guys, when I call an Integration and it return some files to Appian Folder.  I could set all those files' name as requestDoc.xml, but could I set dynamic name using response property like result.body.fileName ?

Hi All, Wondering if there is a way in appian to create a Web API with No Auth?

Hi Team, I have observed a strange case happening, For one of my account "XYZ", I'm unable to receive emails using "Send Email Smart service" from past two days. My hunch is, in the system logs, I see it as locked. Is this issue due to that or what could be case, here? Workflow: I have process model, that sends an email. That has input of a group as constant with the users included.

Hi there, I need to export data to an excel file shown below. I know it's easy to use "Export Data Store Entity to Excel" smart service to export the material list at the bottom, but could anyone know how to combine the upper and bottom parts together to export to an excel file? regards, L

Yeloow, I am currently working in a use case, I have an array of Entity data where entites from different datastores will be inside this array, I want to segregate or group the entities by their datastore so I noticed one thing while trying this out, [Data Store Entity:"xxxxxxxxx-xxxxxxxxf-9143-xxxxx8c102b00@4872"](Data Store Entity) [Data Store Entity:"xxxxxxxxx-xxxxx-43a9-a20d-3xxxx744b9aae@4872"](Data Store Entity) [Data Store Entity:"xxxxxxxxxx-xxxxx-4adc-b46f-axxxxa5990bd@6308"](Data Store Entity) [Data Store Entity:"xxxxxxxxxx-xxxxxxx-4c81-9ddc-axxxx0d18e9@6308"](Data Store Entity) after the @ every entities belong to same Datastore have the same 4 digit number so I assume entites belong to same Data store have these 4 digit number common, is my assumption right ? can any Appian legend confirm this [emoticon:4191f5ee34e248a29fa0dbe8d975f74a].  

How to query table count from oracle DB and display the result in appian screen? I have used the below "Query Database" smart service to fetch the number of table count from DB. But I receive the below error: "You should enter only a single query in a row." My query - SELECT COUNT(1) AS NO_OF_TABLE_CNT FROM USER_TABLES;   Please help me to get the table count. Is there any other option available apart from using this Query Database smart service?

Hi all, I have an issue concerning Add Documents to Zip plugin.  More specifically with the customer being able to unzip the files with the default WinZip utility.  Currently the zip files are empty and they are forced to use 7-Zip.  Since it's not really a best practice to ask the customer to download a third party software to unzip the files, I would like to try and troubleshoot the issue.  Side note** All company internal members have no issues unzipping the files using WinZip.  This is purely an external issue.

Hi Experts, I am using "Authorization Code Grant" for Docusign integration.I have to call this integration on my process model and run this process model as scheduler on every hour to checking token status.I have  set assignee of this integration node "Run as whoever started the process".The Problem I am facing is that, every time I am getting "[title=Missing Credentials, message=No OAuth Access Token found for current user, detail=]" API response. when I am manually running this integration, it is working fine. As per my understanding it is because, when the process is running according scheduler  it is not able to find valid assignee and the integration is returning false response every time ,even if the token is not expired. Please help me on this.

Hi there, I am trying to convert a CDT to excel,  but notice the smart service "Export CDT To Excel" is "Deprecated". I dont want to save the data into database, then use "Export Data Store Entity to Excel". could you please let me know what I can do here? Regards, Lin

Hi Everyone, Can anyone pleas guide me how to handle multiple end points in appian integrations. Do I need to create multiple integration object for each end point?