General

why sites cant be configured with not more than five pages

As the community is growing, do we have a site or a placeholder where we can see the number of associate developers, senior developers or lead developers we have have in our community and may be we can get a list of them. Which would enable us to reach out to them as per the expertise required for the upcoming projects.

Hi Community, How to add 'n' number of days(excluding weekends and holidays) to a given date? We have defined holidays in Database. I know it is possible to define a Process Calendar with a list of non-working days and then use it in caladddays() function to achieve this outcome. As process calendars are not exportable and needs to be created in each environment separately, we are not considering this option at the moment. Having said that is there any alternative way to achieve this result? Thanks, Arun

If we post on the forum will it ever actually be seen by Appian Engineering? Also it would be great if there was a single location to view all the requests that have been submitted. I would love to vote on stuff to help Appian see the things that would add the most value.

Hi I'm using the AppianSelenium API framework in Eclipse.On one of my web pages, I need to upload a document.I use the code below to click the upload button (Called UPLOAD):fixture.clickOnButton("UPLOAD"); ... and a Windows dialog box appears allowing me to navigate to the document I want. Question: How do I interact with the Windows dialog box so the automation can find the file I want to upload? Thanks

Hi everyone, in Maven setup(settings.xml) , is maven_API_key the same as the Appian API created under admin console  ? Thanks in advance.

Hello Appian Community, Hope you are doing fine! I am new in Appian and I am managed to install Appian 21.2 HA Distributed environment in RedHat RHEL 8.4, so far all the installation steps were successfully completed, the Apache with Mod_JK is successfully working and I can access to the login page of the Administration Console (https://appian.mydomain.com/suite/admin) without any problem. But if I try to login using the username and password specified in the passwords.properties I got always a 401 Unauthorized in all the login pages (admin and suite base). I dig into the logs but there is no information neither error. I have 3 servers with all the services running (services, data-server, search-server, tomcat) and no information about the authentication. After the first start, the file passwords.properties is removed (as expected), so all should be working fine, isn't it? I reinstall already 3 times, tried to encrypt the password using the configure.sh script but so far I alw

Hello Appian Community, Hope you are doing fine! I am new in Appian and I am installing an Appian 21.2 HA Distributed environment in RedHat RHEL 8.4, so far all the installation steps were successfully completed but I am stuck in the Validation step. This is my configuration: Running as user Appian. Created a new environment called dev. Environment variables: APPIAN_HOME=/opt/appian/appian JAVA_HOME=/opt/appian/appian/java PATH=/opt/appian/.local/bin:/opt/appian/bin:/sbin:/bin:/usr/sbin:/usr/bin:/usr/local/sbin:/opt/appian/appian/java/bin Then my configuration files located in /opt/appian/appian/conf (I just modified the following files): appian-topology.xml.dev

Can anyone help me to create a process model which runs everyday if the month is jan or apr or jul or oct with the  timer. Thanks

I have active L1 certification under old certification flow and now planning to appear for the next level. So as per the new ones, can I appear for Senior Developer directly or I need to go for Associate Developer certification?

Hi All, In MySQL/MariaDB, we have an option to default the column value while creating a table(For Example createdBy: System; createdOn: CURRENT_TIMESTAMP). In Appian, if we set those values to NULL and pass them to DB, those default values get initialized and stored in the appropriate table. This works fine in MySQL and MariaDB However, Whilst tries the same in SQL Server, I don't see that the default values get triggered and stored into the fields. Should I add anything else for SQL Server DB? Did anyone face this issue before? Note: I don't want to set the values in Appian and store them in DB. Instead, I need to handle it DB end. Thanks in advance.

Good morning, We have an interface in which we are using! DocumentAndFolderBrowserFieldColumns to paint a hierarchy of documents, the problem is that we are trying to obtain the path to display it as text in the following way, if we have the following selected we would have to obtain something like this: "TST_Documentos_Texto_Con… / Prueba2/ Prueba1" Has anyone had the same problem? A greeting and thanks in advance.

Hi, I need to convert the hex data stored in database to image. I am aware about base64 to image. Please suggest some points to convert hex code to base64. I tried the function hex2base64, but is returning null value. Note: Hex data is 65K chacracters long Thanks

Users has the access to multiple application over the Appian cloud server ,but we want to capture last login of a user to particular application

Hi All, i am working on some integration and need to download document. In previous version of Appian "http file download" smart service were available and now it has been deprecate. Kindly suggest me here. Regards, Vikram Kumar Singh

Recently one of the dev updated the Excel tools plugin from 2.0.2 to new 2.2.13 version in Appian and this has lead to breakage of the Export CDT To Excel smart service. can anyone suggest what can be done to resolve this issue?Note:  We are on Cloud. We tried to use the new Export Data Store to Excel plugin however it does not support XLSM files. EDIT: Export Data Store to Excel also does not support alias with space in it. this makes it hard to generate excel files in user friendly manner. We use the generated files to upload to a system and it requires header to be in specific manner and does not accept with different headers.   Example:       Previously: First Name      Now: First_Name Thanks,Bhushan.

In creating new group, I have recently created an application with the new group name Acme All Users, but I deleted my entire application and wanted to start over. Now, when I create the same application name and same group name as Acme All Users, I see the error saying Name already exist. Where do I go to totally delete this group so I can start from scratch.

/* I am trying to extract cancelled status but having error. Can you please help me. Thank you*/ a!queryEntity( fetchTotalCount: true, entity: cons!CAS_DSE_VIEW_POLICY_RECORD, query: a!query( pagingInfo: if( rule!GBL_isBlank(ri!pagingInfo), a!pagingInfo( startIndex: 1, batchSize: 5 ), ri!pagingInfo ), logicalExpression: a!queryLogicalExpression( operator: "AND", filters: { if( rule!GBL_isBlank(ri!policySearch.policyId), {}, a!queryFilter( field: "policyId", value: ri!policySearch.policyId, operator: "=" ) ), if( rule!GBL_isBlank(ri!policySearch.currency), {}, a!queryFilter( field: "projectCurrency", value: ri!policySearch.currency, operator: "=" ) ), if( rule!GBL_isBlank(ri!policySearch.carrierPolicyId), {},

Hi All, In one of my POC I am having requiremnt of converting a document(jpg,pdf) into base64 and storing the base64 in Database. I am using Base64 to Database Services to store the document, but instead of base64 string it is storing Appian ID itself. Below are the screenshots of smart service node and database design. Any comments on this would be appreciated. Thanks Table Structure (also I tried Varbinary, blob data type for base64)

We are having a requirement where we are getting values from an external application via a webAPI. In the web API we are casting the data into a CDT.The value we receive from the application would be something like.{"person" : {"name": "Shaun","age" : 27},"address" : {"addressLine" : "24-Wall Street","city":"London"}}.After this we are casting this into person and address CDT in appian and passing to the process model. If the person and address values is empty we would be receiving the data like {"person" : {},"address" :{}}.Now when I am casting this null Data inside CDT, this is getting casted and passed in process model like [name=null;age=null][addressLine=null;city=null]. I need to perform a null check in process model on these values which is getting failed.Also when I am checking the length of "person" or "address" its showing as 1 instead of 0.

The "Save Interface As Action"  option is not available to me in the Save Interface As dialog. Can anyone please help on why this behavior? Thanks in advance.

The only documentation I've seen does not have any examples for this object type. I managed to create one shown below but I don't know if this is correct. Some input/guidance would be appreciated. ## connected system credentials for API## Name: WM Maximo Passport Connection content._a-0000e671-0a5b-8000-9c01-011c48011c48_9065909.baseUrl=evelopment..com/.../content._a-0000e671-0a5b-8000-9c01-011c48011c48_9065909.authTypeOAuth Client Credentials Grantcontent._a-0000e671-0a5b-8000-9c01-011c48011c48_9065909.clientSecret=myClientSecretValuecontent._a-0000e671-0a5b-8000-9c01-011c48011c48_9065909.clientId=myCleintIdvaluecontent._a-0000e671-0a5b-8000-9c01-011c48011c48_9065909.tokenUrl=development.com/.../token

HI, I have the code below but only one file upload is allowed. How do I make it multiple upload? a!fileUploadField( label: "Attachments", labelPosition: "ABOVE", target: cons!Electronic_File_Checklist_Document_Folder, maxSelections: 5, value: ri!Electronic_File_Processing.attachment1, saveInto: ri!Electronic_File_Processing.attachment1, validations: {} ) Thanks in advance Neil

Hello All,  Email notifications (process alerts and emails from send email node) are not working.This was working fine and users were receiving emails until last week. but they are not receving any  emails for the last two days. There was no change in custom.properties file alsoDid someone face a similar issue?

I'd like to create an expression rule that will set the branding for logo, logo alt text, and/or favicon to either a value specified by expression rule, or (if that is null) the default Appian graphics/alt-text.  Also...if the logo/favicon is saved as a document, is this how you display the correct image? todocument(<id as provided by expression rule>)  In essence, I want to write the Expression for the branding as something like these lines: a!defaultValue(todocument(rule!getBranding(attribute: "logoImage")), <Appian's logo's ID>) a!defaultValue(todocument(rule!getBranding(attribute: "logoAltText")), <Appian's default alt-text for the logo>) So, basically--if the rule!getBranding with its specified ri!attribute comes up empty, use the Appian defaults for each of logo image, logo alt-text, and favicon.