Discussion Categories

Hi! I have a summary view with a read-only grid (from Record 1). When I run my process model, I make a query (type "UPDATE" and "SET") to change the status of one of the fields, and I need the read-only grid to update After I run the process model, the value of the variable in my Record Type (Data Preview) changes succesfully... But it does not change in my read-only grid (based on this record I have shown in the last image). To make it "update", I have to go to "Sync Options" --> Start Full Sync manually. After doing this, the read only grid updates. Y tried to use the refresh button of the read only grid but doesn´t work, only full sync What can be happening? Thanks a lot!

Hi! I´m trying to use the smart service "Query Database" to change the value of a concrete field. I have managed to use the an "Update" and "Set" SQL statement to update a database used in the process model which works correctly The fact is that now I would like to do a similar query, but to update a record which is NOT BEING USED in this process model ("CPF Lineas Pedido") Even though I created the query and the process model runs OK, the value of the field "facturada" does not change properly. Also, I brought the new Record as a process variable, but its value does not change (I´m not using it in the process model because I only need to update one value, the one with the query) What can I do?

Hi ,mails are not getting polled in the UI , getting the below error."Invalid client secret provided. Ensure the secret being sent in the request is the client secret value, not the client secret ID"Can someone please let me know what can be the cause and what is the latest version of poller.

Hello everyone, I have one question : I need to generate 7-8 different types of reports and when the user clicks on the particular report it show get downloaded in Excel.  So, how to implement it and what to use? Thanks.

Hi, I am trying to upload an email attachment (size: 1.5MB) via the a!fileUploadField component on an interface, but it throws an error indicating that the file "could not be uploaded. Please try uploading it again." On trying with different files (email attachments), this seems to be working fine. I could not find any specific issues with the file which results in the error, but I'm interested to know what is causing this. Can you help me out with what may cause this error? I am also interested to know where I can find the logs for this - I did check the system logs (Appian Cloud), but I am unable to find a file that will contain the log for this issue.

I'm trying to populate conditional dynamic data in my docX. I have regular data populating fine, but I can't seem to find the correct syntax for conditional statements. Here's what I have so far that keeps evaluating to false:{if "<<${doc.center.subjectType}>>" = "Individual" "Is Individual" "Not Individual"} Anyone know what's going wrong here? or where I can find documentation on this? Thank you

Hi Team, I'm using a single process model for creating employee and updating employee(related action). While creating employee simply i create a new folder and move employee documents there. But incase of updating i need to add documents to the same folder. I don't know how to achieve this. I tried with tofolder("emp 1") function with a or gate to check whether it's updation or creation but getting error. Then i removed or gate and checked with the create folder then move documents methods again for updation process it creating a new folder with same name. Need support on this.. Thanks in advance 

Brief Summary: I have a CDT with near to 500 fields that holds some values and just to mentioned I am not using any nested CDTs. I'm using that CDT inside an interface to hold values. I am worried if the application could face any issues in the future if it grows larger. I would like to know even if I have more than 500 fields, is it safe to use that CDT in the application or is it causes any issues in the future. Note: I don't wish to proceed for partial CDTs by breaking the entire CDT into sub-CDTs. Please list down what kind of issues my application may face, if any, down in the comments. Please help me clearing this and I would be gratefully for your help, Thank you.

I am a new bie into APPIAN.would like to know how  we can create CDT and access the COlumn from DB

when I used a!pickerFieldUsersAndGroups() in filter .It gives error during selecting Group  Error:-- cannot apply [EQUALS] to field [assignee] when comparing to value [TypedValue[it =5,v=414]. what operator should I used for it

HI All, I am posting this question out of curiosity. As we know Appian is coded in Java.  I am just thinking is there a way to fetch the Appian Reports in my Java Application ? Like if there is any Java Class/package that appian provides or something ? I have found something here: https://docs.appian.com/suite/help/22.4/api/com/appiancorp/suiteapi/process/analytics2/ReportData.html But just want to check is this something feasible ? Thanks

I know we can check the resolution of the tablet if 'TABLET_PORTRAIT' or 'TABLET_LANDSCAPE' by using `a!isPageWidth({ "TABLET_LANDSCAPE" })`. But You know there is no 'PHONE_LANDSCAPE' in Appian, how to do the same thing with the Phone?  Or can we get page width and determine what it is? Is there a way to do this? Thanks in advance!

Hello, I have a Web API in Appian which returns ~4K records of custom data type (each data type has 14 fields). I am calling it using integration object and then using it as a webservice source in record type.  Issue - - The Web API returns ~4K records successfully whereas the integration object response shows only ~500 records.  - Is there a size limitation for integration object response? - What is the workaround? Regards, Abhay

Hello Appian Community, My team and I are in the process of installing Appian version 22.4 on Windows 2016 Standard with IIS 10 and MS SQL Server 2016 Enterprise Edition. After following the steps from the guide and attempting to start the app and all its components (Service Manager, Data Server, Search Server, app) we get an error in the logs that ends with this entry 2023-08-11 13:39:10,957 [localhost-startStop-1] FATAL com.appiancorp.common.web.StartupHaltingServletContextListener - Appian initialization FAILED: see above stacktrace for details and starts with this entry 2023-08-11 13:39:10,935 [localhost-startStop-1] ERROR org.springframework.web.context.ContextLoader - Context initialization failed Here is an excert of the rest of the message: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'org.springframework.security.filterChains': Cannot resolve reference to bean 'org.springframework.security.web.DefaultSecurityFilterCha

Hello,We have a start form with a simple file upload on a cloud installation, Version 21.4; Some users experience for some files the error from attached print screen (had to hide file name); Files have .tx extension.I can't receive the files as they contain business sensitive data so we cannot reproduce error on lower environments.Checked in logs and couldn't find any clue. In admin console, under file upload we don't have any extension blocked just the check for "Enable Real-Time Virus Scanning", is it safe to disable this and ask user to re-upload same file? in order to figure if it's from this one?Older similar post doesn't offer any solution, it's not the case for VPN now, /logs/audit/blocked_files.csv is empty in my case as well.https://community.appian.com/discussions/f/new-to-appian/18528/certain-pdf-documents-are-uploaded-but-not-others-message-file-pdf-could-not-be-uploaded-please-try-uploading-it-again/73058#73058If you have experie

Hi! I have a site page created from a record list (invoices) When I click in one of the Invoices Id, I access to a summary view (interface), in which I created not only additional information of the record "invoices", but also a read-only grid from another record (Invoice Lines). My problem here is that, if I try to eliminate the record (related record action) from this interface, it does not occur anything and the following error appears I suppose it is caused because of the read-only grid generated in the interface (if I add no editable grid, it works fine). How can I solve this and being able to delete the invoices with the read-only grid inside?

Hi, I have multiple sites inside Appian and whenever my session is expiring and when I click on "Return to Appian" link, system is always routing to same site. Is there a way I can configure and ensure it will route to the respective site.

I am saving multiple dropdown values like 3;4;5 and if I am passing the same value into an expression rule and doing for each it isn't taking individual value instead consider as 345. How to convert 3;4;5 into {3,4,5}

I have to aggregate data based on a column. With aggregate will I get all the Data if the DB contains > 20,000 records. How to achieve it

I'm trying to solve a problem where we should allow only the values between 1-10 as inputs for a specific record. Can anyone suggest me a method to solve this?

We recently had the following scenario on our cloud based Appian environment. 1. We do all our application building / designing / development on our development environment.2. We promote our applications to our QC environment and finally Production.3. Our development environment recently had issues where the Appian support team had to restore it to a point from the previous day.4. Once our development environment had been restored to the previous days recovery point, we had effectively lost all our application development from the recovery point to the time the server became unstable. Question: What is your process to avoid or mitigate this loss of work/code if your dev environment crashes ? I come from a non-Appian environment where we develop our source code and then commit it to a source code repository.From there it automatically checks the source code for quality, builds the application, and deploys it to our development environment.If our development environment crashes

Hi! I´m trying to update a value in my process model by using an script task (change value to "true" and saves it into the field "facturada) and then using the writeRecords smart service My configuration is: 1. Script Task: The value "true" is saved into the field "facturada" of my record. It´s important to say that I´m updating an ARRAY 2. Write Records Smart Service In the beginning, I was updating the entire record, but this was causing that my data got duplicated (f.example if I created 2 rows, there were 4 rows). So I´m trying to update just the field I want ("facturada") (The target in my last picture is the field I want to update (recordLineas.....recepcionada)) The error that appears is the following: How can I fix this? Thanks a lot

a!dateField( label: "Return To Office Date", labelPosition: if(ri!readOnly, "ADJACENT", "ABOVE"), value: ri!NIC_LeaveSummary.returntoofficedate, saveInto: ri!NIC_LeaveSummary.returntoofficedate, readOnly: ri!isLeaveApplied, validations: { if(calworkdays(ri!NIC_LeaveSummary.leavestartdate,ri!NIC_LeaveSummary.returntoofficedate)- 1 >5,"You can apply max 5 days leaves",{}), if( a!isNotNullOrEmpty(ri!NIC_LeaveSummary.leavestartdate), if( calisworkday(ri!NIC_LeaveSummary.leavestartdate), {}, "Please select weekdays. Weekends are not allowed" ), {} ), if( a!isNullOrEmpty(ri!NIC_LeaveSummary.leavestartdate), "Please select leave start date", {} ), if( ri!NIC_LeaveSummary.leavestartdate > ri!NIC_LeaveSummary.returntoofficedate, " Please select return to office date later than leave start date", {} ), } ),

Hi! I´ve just created a process model for invoices: first, the user fills the invoice fields, and then some checks are made in the process (logic nodes) to determine if the invoice is accepted or rejected (basically, if all the conditions apply then the field "status" of the invoice changes) Now, I´ve added an interface to create invoice lines. And I was wondering how can I make a similar logic (apply conditions for each row and then change the invoice line "status" to "accepted"). I know how to do it for one row, but not how can I "iterate" and make all the invoice line created to "pass" through the conditions Any help would be useful. Thanks a lot!

Hi All, I am trying to add the time to the date. todate(now()) + time(20,0,0)..it's returning GMT time.But, I need EST time to display. Any suggestion please. Thanks!