General

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 

Same tasks are getting assugned to the multiple user We are using Appian version 22.3 We have the lists of tasks available for picked-up from task pool. On a click of button GetNext, same tasks are getting assigned for the multiple users if click on the same exact time . Can someone guide us for the resolution . Thanks !!

Hi. I'm interested in creating a plugin for Appian. As per the developer guide I need to set up a developer instance so I can build, test and iterate on my design before it is reviewed. When trying to set up the developer instance I am running into a few problems.  When looking at the MySQL set up and the JConnect, the MySQL links are pointing towards a general home page. I can navigate to find the MySQL versions but it is not clear which versions are required. More importantly when I navigate to download an Appian installer, all the versions state "Installers Not Available". What is the most recent version which I can install? Thanks in advance. Jonathan

Hi All, Recently, I started learning Appian as I was assigned to take care of an existing Appian project. Can you please share all the important points and topics that I need to get from the existing team in a knowledge transfer session? Note: Currently using 21.4 version and planning to migrate to 23.1 version. Thank you very much for your support.

can anyone suggest me why is the error

I want to Display Link in Confirmation message of submit button is it possible?

Scenario : i have to upload csv file in file upload once its getting uploaded .. in Next screen it will show the data in Appian Which was present in File in the form of paging grid .. but i want some of the fields to be mandatory in paging grid 

Hi All, Might be a silly question. But i was in a assumption that list of condition added in XOR node will be evaluated in order as it is showing if else logic. BUT in documentation, I could see in different way.  Please let me know if my understanding is wrong. Thanks in advance!

Hi All, Need a confirmation, I have a  package create on 22.1.1845  version  can it be imported into 22.1.745(lower minor version).  Both are Linux environments But both have same versions 22.1 only, Reagrds, Bhanu Prakash