General

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?

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 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!

Hi, I had an requirement to send a file over SFTP. To acheive that  i had created key under third party credential in admin console(Remote server). Using that specific key in send file over SFTP plugin. But getting below error. Error establishing SFTP connection. Confirm your hostname, username and password. See application server log for more details. Error Message: Unable to retrieve credentials from SCS: This plug-in [com.appiancorp.a2.process.runtime.activities.sftp] is not registered to access secured values for the given external system key [sftp-credential]. Check the external systems plug-ins list in the Administration Console.  what could be the reason behind this error?  what does below error mean? Error Message: Unable to retrieve credentials from SCS: This plug-in [com.appiancorp.a2.process.runtime.activities.sftp] is not registered to access secured values for the given external system key [sftp-credential].

I'm trying to parse a large data file into our sql database.  I have found the import csv to database smart service which would work with the "|" delimiter of the dat file except it has metadata as its first and last lines (not a csv header).  I have uploaded the file into an appian document object, but I can't figure out how to remove those lines so it works with the smart service. I should also note the dat file is coming from an external datasouce and cannot be altered prior to ingestion.

Hi All, AM facing an unknow issue on send email node. In our lower environments the response body is configured as attached below Deployed the same process model in PROD, but i could see additional html tags are added in response body section as shown below This is not happening in send email nodel where response body in wrapped inside expression. Can anyone suggest why this is happening? I deployed the same PM from dev to test to prod... But prod is showing differently. Thanks in advance

Hi Team, I have a column(Assignees) in a record type, there in the filter I'm thinking to write a logic like below a!queryFilter( field: 'recordType!Record Details.fields.assignees', operator: "=", value: loggedInUser() ), id, Assignee(text) ----------------------- 1, "user1;user2" 2, "user2" if the user1 login, record 1 should be displayed in the grid if the user2 login, record 1,2 should be displayed in the grid

We have various Appian applications, and generally we want all our developers to have view access to each others applications for transparency and knowledge share. Now, I am the developer and owner of an application and I have created a Record Type for an entity, generated the SQL script and database table, and all the process models that allow the manipulation of that data through my Record Type. Effectively my application and it's objects are the "owners" of that data, and should be the only objects allowed to modify the data. How do I stop another developer from simply creating a Record Type in his application, pointing it to my database table, and then using his new Record Type in his application to modify the data in my database tables ? I don't want other developers to simply be able to create applications that can modify data that my application should own and manage.

Here is a very rough ERD: Each case has many subcases; each subcase deals with a software and each software has a status  I have a Rule Input "dcmCaseID" that is populated with the parentCaseID for the Case entity.When the query is run, I get data for all the subcases that are linked to the case ID The query looks something like this:a!queryEntity( entity: cons!DSE_SUBCASE, query: a!query( logicalExpression: a!queryLogicalExpression( operator: "AND", filters: { a!queryFilter( field: "case.parentID", operator: "=", value: ri!dcmCaseID ) }, ignoreFiltersWithEmptyValues: false ), pagingInfo: a!pagingInfo(startIndex: 1, batchSize: - 1) ), fetchTotalCount: false ).data, I need to modify the query to return only subcases where the software statusID is null. Using a queryRecordType either breaks the process completely, or returns no subcases at all. Any help will be greatly appreciated! Blessings Stephen

If there is a change of DB, how can we deploy the changes made in DB in the deployment stage

i am trying to update constant with same data type. it shows below error com.appiancorp.suiteapi.knowledge.Community cannot be cast to com.appiancorp.suiteapi.rules.Constant can you provide me the format for updating a constant using screenshots can anyone provide the solution please

Hello, I'm preparing to take a certification exam, and I'm struggling to find a use case that would help me better understand functions reduce() and merge(). Can you help a brother out?

Hi All, Is there any way to get the logged-in user's  Site URL? We are using multiple sites in my application and I Just to confirm which Site user is currently logged In. Thanks in Adavance. Regards,

i have date column in database  it holds the values like  01/02/2024 06:29 GMT+00:00 17/03/2023 17:59 GMT+00:00 but i have to fetch only date which is equal to today date how can i achieve that

Hello everyone, I need a bit of help for an accessibility task in Appian. I require a parameter that identifies an element as a <nav> tag and an Aria-label type parameter when viewing the code of the 'Site' in the HTML console. I've tried with parameters like 'accessibilitytext' and 'helptooltip' but it translates to <div> and without that essential parameter, 'Aria-label.' How can I achieve this?

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

I am working on a project where I want to use or() function. While using the or() function I found one bug when you write any word starting with the letter "T" in the or() function you will get a true return and for any other word then "T" returns false. I am adding some images for more clear discussion. in this, I used random words starting with the letter "T" using words other than the "T"

Hello, I need to improve the accessibility of an interface that includes grids. In HTML, the "caption" tag can be used to provide additional description or context to an element, such as a table. However, I can't find a direct way to achieve something similar in a grid in Appian. My question is is there any way or recommended approach to add additional description or context to a grid in Appian?

Hello everyone,  I am getting a base64 value as a request. But I am unable to convert the base64 value into an image document. As a result record is not getting stored into the database table. Is there any way to convert the base64 string into document?

Actively hiring Appian Developers for the following locations  Philadelphia, Delaware, New Jersey. Any one would like to know more about this exciting opportunity please contact me abhilash.p@KGIS.CO  Here is the brief JD: 4+ years related experience working in a technical role Primary responsibilities will involve developing, integrating, and debugging Appian objects; writing validation tests against existing baselines to ensure integrity of the code during Agile development efforts. Create integrations with other enterprise systems using REST APIs. Create Web APIs in Appian and secure them using OAuth 2.0 credentials. Strong background in relational database design and SQL Strong problem solving and design skills Strong communication and presentation skills

Should able to Select only one radio button from the grid as shown in the below attachment. a!radioButtonField( label: "Sort On", labelPosition: "COLLAPSED", choiceLabels: { "Yes" }, choiceValues: {true()}, value: fv!item.sortOn, saveInto: {local!sort, a!save(local!sortIndex,fv!index), a!save(index(ri!input,"sortOn",local!sortIndex,{}),true())}, choiceLayout: "STACKED", validations: {} ) How to achieve this please suggest.

a!localVariables( local!input1: if( len(ri!input2) > len(ri!input1), concat( a!forEach( items: enumerate(len(ri!input2) - len(ri!input1)), expression: 0 ), ri!input1 ), ri!input1 ), local!input2: if( len(ri!input1) > len(ri!input2), concat( a!forEach( items: enumerate(len(ri!input1) - len(ri!input2)), expression: 0 ), ri!input2 ), ri!input2 ), concat( a!forEach( items: enumerate(len(local!input1)), expression: if( and(local!input1[fv!index] =1, local!input2[fv!index]=1), 1, 0 ) ) ) )

a!localVariables( local!input1: if( len(ri!input2) > len(ri!input1), concat( a!forEach( items: enumerate(len(ri!input2) - len(ri!input1)), expression: 0 ), ri!input1 ), ri!input1 ), local!input2: if( len(ri!input1) > len(ri!input2), concat( a!forEach( items: enumerate(len(ri!input1) - len(ri!input2)), expression: 0 ), ri!input2 ), ri!input2 ), concat( a!forEach( items: enumerate(len(local!input1)), expression: if( or(local!input1[fv!index]=1, local!input2[fv!index]=1), 1, 0 ) ) ) )

a!localVariables( local!input1: if( len(ri!input2) > len(ri!input1), concat( a!forEach( items: enumerate(len(ri!input2) - len(ri!input1)), expression: 0 ), ri!input1 ), ri!input1 ), local!input2: if( len(ri!input1) > len(ri!input2), concat( a!forEach( items: enumerate(len(ri!input1) - len(ri!input2)), expression: 0 ), ri!input2 ), ri!input2 ), concat( a!forEach( items: enumerate(len(local!input1)), expression: if( local!input1[fv!index] =local!input2[fv!index], 0, 1 ) ) ) )

Hi, I'm getting this Authentication failed when I replay the script. I made the user as an Admin account, added the CSRF token in the header but still the authentication fails. We have Okta SSO enabled for the application. I'm able to successfully pass through the Okta authentication via JMeter and the subsequent Appian request are failing with the above error code. Thank you for your input! Best, Manisha