General

Hi, I have a requirement to display the header and footer on every generated page of the PDF report through HTML I tried using header and footer tags, but that is not working

Hi everyone, I'm getting an error while querying data. Scenario here is logged in user will have multiple countries associated. so when user logs in we are fetching loggedin user counties and  passing the list of country id's to the view to get data. when user having upto 70 countries it is working fine but when exceeds it is throwing error. Can anyone please help me how to resolve the issue.  PFA image

How to Query a database values which exceeds the memory limit without any filters. Is there a way we can just type the first 3 characters and the respective values should be fetched?

Hello, I need to pass the yesterday's date and a specific time to a variable of dateTime type. Basically today I want to get all the data which is saved in database yesterday. How to achieve this? Thank you.

In an Appian paging grid, when clicking the "Preview" text in one of the columns, the goal is to display the data from the PDF document in another tab and provide an option for downloading. How can this be implemented in Appian?

Hi I have data type which have data with site id, site name, workingstartDate, workingendDate.  I want to create line chart which is for each day of month, nu of sites worked? how can i do that?

Hi All, I have 2 site pages A and B. There is a link on page A and on click of the link the contents in site page B should be displayed. Can anyone please help me how to achieve this?

Hi All How can we see user last login details? Right now I am using this function getlastlogindatetime  but it onlys shows only for those users who logged in with in 30 days. Can anyone tell me how can we see those users login in date and time which are logged in with in 90-120 days? Many thanks in advance

Hi,  I got the certification on July 29, 2022, to maintain the certification I saw that there are release courses. I would like to ask, which releases are mandatory in my case? Only the 22.4 and 23.1 or also the earlier ones? Erzen

Hello everyone Iam struggling in finding the SAIL Design system inside Figma , is there a way to do so?

Let me share with you the results of this code snippet a!map(    length: length(local!taller.resultado.contractSetting.annuitySettings.paymentMethods),    pm: local!taller.resultado.contractSetting.annuitySettings.paymentMethods,    isnull: a!isNullOrEmpty(local!taller.resultado.contractSetting.annuitySettings.paymentMethods)  ) I'm wondering why length of a null array is equal to 1.I appreciate any explanation to this. Regards

List of Dictionary - 3 items Dictionary icon:"arrow-circle-o-left"(Text) action:26(Number (Integer)) Dictionary icon:"sitemap"(Text) action:25(Number (Integer)) Dictionary icon:"check-circle-o"(Text) action:28(Number (Integer)) As i want to remove second item from dictionary what should i do 

Hi All, I have a scenario where i am getting details in a recordtype which is multiple. Now i have to subsitute the record field value at a specific index  of a recordtyep in interface. Is that possible as i am not seeing any option to index it.

We are using Appian cloud for our application. Our application is retiring and all the clients are offboarded , However we  want to take backup of our ARCHIVED processes. Please let me know the process to take backup of ARCHIVED processes. The business people want to store it for future reference.

Hi All, Is Spell check is possible in Appian? Regards,Sandeep

Hi I am getting this error for checkbox Expression evaluation error [evaluation ID = IGMIN] in rule 'gai_managegeneraladdnlinfo' at function a!checkboxField [line 19]: A checkbox component [label=""] has an invalid value for "value". All selected values must be present in the choiceValues array, but value was false and choiceValues was true. ri!projectInfo.column is boolean type where i am saving this value how can i fix this? i have attached my code a!checkboxField( choiceLabels: " Check here if you are a non-profit organization", choiceValues: true(), value: ri!projectInfo['recordType!{ba1b9bf5-818d-401c-b540-67788e6d7d2d}GAI Application Project Info.fields.{3f6f4ef6-3667-485b-86f3-6519b03d80a2}isNonProfit'], saveInto: ri!projectInfo['recordType!{ba1b9bf5-818d-401c-b540-67788e6d7d2d}GAI Application Project Info.fields.{3f6f4ef6-3667-485b-86f3-6519b03d80a2}isNonProfit']

Does anyone else use multiple monitors when developing Appian applications?  How do you utilize them?  Would love for Appian to have a "dock /  undock" feature where you could put the expression editor on one screen and the preview on another.

Hi, i did the exam in september 2022 and i didnt completed any  realeased showcases. my cerificate is now inactive. what should i do? if i now look into them will the certificate active? 

Hi, I configured the sign-in Page with one link which was initially not showing on the sign-in page. But when I removed the link from the Sign In page it started showing in the login screen. Can anyone suggest how to remove the link? Screenshot of no links configured Screenshot of the link showing on the login screen

Hi All, We have given our client to add notes up to 10000 char. It is getting saved in DB as well, But when querying from Record it returns only 4000 char. I need help here to overcome this limitation. It's Urgent!!! Thanks in advance.

Hi Team,I have a constant which holds array of data store entities, In a interface I need names of those entities from constant.for example: cons!xyz is my constant, if I just simply use this in interface I'm getting something like this(internal representation) [Data Store Entity:"29c9c1bd-6809-486b-8da1-f993cd872bbc@867691"] [Data Store Entity:"95bb55be-5347-4ea3-9713-b78870bbf7e3@867691"]instead is there any way to get name of those entities like "employee","education" ,something like that.Thanks in advance [mention:126a676c85024855948336691b0a7b92:e9ed411860ed4f2ba0265705b8793d05] 

a!dropdownField( label: "Deposit Amount", labelPosition: "ABOVE", placeholder: "--- Select ---", choiceLabels: a!forEach( items: rule!CD_QE_Get_Amounts().data, expression: fv!item.amountFrom & " - " & fv!item.amountTo ), choiceValues:a!forEach( items: rule!CD_QE_Get_Amounts().data, expression: fv!item.amountFrom & " - " & fv!item.amountTo ), value: {local!DBben.Amount}, saveInto: {local!DBben.Amount}, searchDisplay: "AUTO", required: true, validations: {} ) Hello All,  I am facing this error "has an invalid value for "value". All selected values must be present in the choiceValues array, but value was -∞ and choiceValues was 100000 - 500000; 500001 - 1000000; 1000001 - 2000000;" any advice ?

We are experiencing an intermittent problem with Send Email node in a process. On the front end, the error is 'Failed to send email'.  On the stdout log, it is stated that the error is caused by: 'jakarta.mail.AuthenticationFailedException: 535 Incorrect authentication data - https://community.mimecast.com/docs/DOC-1369#535'.  According to the given Mimecast web-page, error 535 is due to 'Incorrect authentication data'.   The sender and receiver in this instance was the same as multiple other instances in the same day, which worked as expected, with email going out and being received successfully. Any ideas? Thanks for taking the time to consider this.

The Health Check for my application, for process sizing, has 3 process models that are all taking up about 16GB and 32,000 # of instances.If I reduce the archiving from 3 days to 1 days on each process, it should cut out 10GB and about 22,000 instances.  Would doing this have any positive impact on the applications performance as a whole? Would it free up resources or processing engines in any way where I could see improvements on process models?Right now, I'm seeing sometimes my write to data stores taking .90 ms in some cases and then in other cases, taking up to .300ms (which is too long)  For context, my prod environment has about 853,000 process a day (585,557 completed, 183,000 active)

Hi Team, I have requirement to run on scheduler to create case based on configuration and export some transactional data in the excel file, send an email. In the excel there is one column with datetime type is one of the columns and in the excel always it is exporting as the usertimezone. Example: This scheduler PM always run around 01:00 AM CST and last published designer time zone is GMT.As this user is administrator across platform level, so don't want to change user time zone to CST. Please find below items for reference. 1. I have run the PM in the CST timezone,Stil in the exported excel file taking the last published Administrator account time zone (GMT). 2. I can do it in data base, but i don't see any dynamic function to convert automatically handle daylight savings (Without hardcoding +06:00 hours..etc). Can you please help me out to export excel the column data datetime as CST timzone. Thanks and Regards Venkatesh Suram