Foundation

I want to reset my password for appian community but not able to reset, When I click on forgot password I got a mail Password can only reset by administrator. Already send a mail to appian community regarding reset my password but not getting any response. Anyone have idea regarding this issue please help me out.

Hi Appian experts, Here, I am trying to get the cText based on the passed typeId. How I can achieve this. a!localVariables( local!selectedtype: "IM", local!myDictionary: { { cText: "Internal Memo", typeId: "IM" }, { cText: "External Memo", typeId: "EM" }, { cText: "Correspondence", typeId: "CP" } }, local!myDictionary.cText[local!selectedtype])

Is there a way to prevent an Appian object in conflict to be overwritten while importing the package. If there is no way to prevent a particular conflict to be overwritten . Is there any  properties file settings to prevent overwriting of all conflicts in that import? what I am looking for is something like importSetting.FORCE_UPDATE=true in import customization properties file, ideally for one particular object in conflict or all objects if that's not possible

My requirement is to display current month as default option in dropdown and user can change month value from dropdown if they want to change and for each month there should be integer value saved in Rule Input "selectedMonth", so I have applied dropdownFieldByIndex() function for this. If user select blank then it will revert it to current month but I am getting below issue: SAIL Code: local!currMonth: datetext(today(),"M"), local!monthName: {"Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec"}, a!dropdownFieldByIndex( label: "", labelPosition: "ABOVE", placeholder: "--Select Month--", choiceLabels:union(local!monthName,local!monthName), /*choiceValues: tointeger(union(local!monthValue,local!monthValue)),*/ value: if(rule!APN_isNotBlank(ri!selectedMonth),ri!selectedMonth,local!currMonth), sa

Hi I have a question  i have 3 rule inputs i.e, ri!uniqueref1,ri!uniqueref2, ri!uniqueref3 these 3 rule inputs needs to be updated to DB   but 3 rule inputs have to refer to single column but different rows in DB  can anyone help me for this how can i write logic for creating  process model  3 rule inputs needs to refer single column but different rows in DB and update the values 

Hi, We are using Cucumber for Appian and we tried every way to click on related actions that are in a dots menu like so : Anyone facing the same issue did find a solution? Thank you, Jeremy.

HI Appian, I have to pass multiple cdt values as process parameter from a webapi how can i do that? Please someone  help me for this. I have attached the sample code for your reference.PF_Request and PF_REQUESTITEMDETAIL is the table which i am passing as parameter from webapi to  process model as Process variables. a!startProcess( processModel: cons!PF_Create_Request_WithChanges, processParameters: { PF_Request : a!fromJson( http!request.body ), PF_REQUESTITEMDETAIL:a!fromJson( http!request.body ) }, onSuccess: a!httpResponse( statusCode: 200, headers: { a!httpHeader(name: "Content-Type", value: "application/json") }, body: a!toJson( fv!processInfo ) ), onError: a!httpResponse( statusCode: 500, headers: { a!httpHeader(name: "Content-Type", value: "application/json") }, body: a!toJson( { error: "There was an error starting the process" } ) ) ) Thanks S

Is there a way to query the Appian user database and discover those users whose passwords are expired (rather than account deactivated.  I've looked at the user() function and none of the arguments help..

How can I change the language or translate the language of the interfaces of an application to other languages both its interfaces and the site itself?

Hi, I would like to know if there is a way or workaround in Appian to receive multiple files in a single webAPI call? Scenario: A third party system needs to drop files to Appian by calling the Appian Web API.

How I can upload book as pdf file and preview it in Appian 

Hi I need to compare each item in two arrays  e.g. local!dtmdata: {9, 9, 33, 33},local!databaseData: {9, 33, 33, 33} i have tried:  a!localVariables( local!dtmdata: { 9, 9, 33, 33 }, local!databaseData: { 9, 33, 33, 33 }, local!notAtIndex: a!forEach( items: local!dtmdata, expression: if( wherecontains(fv!item, local!databaseData ), wherecontains(fv!item, local!databaseData ), "false" ) ), local!notAtIndex ) But its not sufficient as I want compare the numbers at each index So I need to  compare the first item in array local!dtmdata with the first item in array local!databaseData and so on.  If at any point they are different then I need to know the index of the difference in the example above it would return index 2 as it is different Thanks!!

Hi, I am getting an error while logging into the development environment of my organization whereas my rest team members are able to login.. Error 401 - Unauthorized Sorry, your request could not be processed. Could anyone please suggest what should i do? Thanks.

I have an integration which makes a POST (read-only) to a database. The returned value is a string formatted in pascal-case. There are a total of 25 possible string value responses, here are some examples from the 25 possibilities: "DeferredStudentLoan" "LeasePayment" "PersonalLoan" I need to convert these strings from the above pascal-case to standard-case (I guess you call it that?). "DeferredStudentLoan" should be converted to "Deferred Student Loan" "LeasePayment" should be converted to "Lease Payment" "PersonalLoan" should be converted to "Personal Loan" Here are some snippets of code... a!localVariables( local!line4_addedLines: 1, local!PostCall: rule!EI_FieldReader_CDpg3_UCD_Sec_K_Line4(), ........ local!PostCall: rule!EI_FieldReader_CDpg3_UCD_Sec_K_Line4() creates a dictionary of the post call made in the integration (not shown anywhere in this thread).  I call upon a speci

I have a question... am using reusable rule, in that rule...  date need to be editable for some set of process model and not editable for some set of process models...  how can i write code for it? is it possible with IF condition? if so can anyone let me know  Thanks Kavya

How can I achieve validation in dateField....  in the date field i shouldn't able to pick past date only future date i can select..  how can i achieve this with validation  can anyone help with this  

how to get most recent document uploaded in grid.I have created grid with 3 columns ,in which how to get most recent document which is uploaded by user.

Hi , I have a editable grid having 17 columns and horizontal scroll is appearing in the page due to large number of columns. I am trying to use weight of the a!gridLayoutColumnConfig(width: "DISTRIBUTE", weight: 8) for width distribution like making one column wide and other less wide but non is showing any effect on the width distribution of columns, all are appearing fixed width on the screen. Is it like a!gridLayoutColumnConfig stops working if number of columns are huge ? Please help with pointers. Regards Bihitak 

Hi, I've a form which has about 10+ fields which are calculated based on various input fields (including editable grid input fields). I need to figure out a way to have the calculation logic in one place so it can be managed without a lot of code duplication. I want to avoid copy pasting the a!save for each calculated field into saveInto() of multiple input fields.

I have this expression rule : a!localVariables( /* Loop checks against passed in value of type to pull values from specific requirementActivity match */ a!forEach( items: ri!requirement.requirementActivities, expression: if(contains(fv!item.type, ri!activityType), 'type!{urn:com:appian:types:UW}UW-Requirement-Activity'( key: fv!item.key, type: fv!item.type, creatorId: fv!item.creatorId, creatorFullName: fv!item.creatorFullName, createdDate: fv!item.createdDate, commentText: fv!item.commentText ), {}), ), ), And I'm using it in my interface : a!localVariables( requirementsResponse: rule!UW_GetRequirementsByCase_RDS("SomeKey"), local!requirements: { a!forEach( items: local!requirementsResponse, expression: a!map( type: fv!item.name, status:fv!item.status, orderDate: fv!item.createdTimestamp, orderRe

I am using a!fileUploadField in my interface and its not showing any error when I am editing in expression Mode but when i change it to designer mode its showing error.Could not display interface. Please check definition and inputs. Interface Definition: Expression evaluation error at function a!fileUploadField [line 78]: a!fileUploadField( label: "Upload An Image :", labelPosition: "ABOVE", target: cons!CS_DOCUMENT_FOLDER, fileNames: fv!files.name: local!registratioNo, fileDescriptions: "This is the uploaded file for the vehicle : " & local!registratioNo, maxSelections: 1, value: local!file, saveInto: { local!file, a!save(ri!Vehicle.UploadedFile, save!value) }, required: if(

my code is correct? let me know if any changes required... my requirement is - if cr_app_la_all_processs_model process model is running then don't show that add projects link if not listed process model then show the add project link  can anyone let me know if am wrong 

I am trying to find a sail expression that will return the current day's timestamp at the first second of the day. For example: now() returns 11/15/2021 4:39 PM EST Looking for something along the lines of:  myFunc(now()) returns 11/15/2021 12:00 AM EST I tried  now()-hour(now())/24-minute(now())/(24*60)-second(now())/(24*60*60) but it returns 11/14/2021 7:00 PM EST(Date and Time) Any help will be appreciated, 

Hello, I'm using the following to return all user rows, but I'm only getting one back: local!usersAll : cast('type!{urn:com:appian:types}AL_Users' , a!queryEntity( entity:cons!AL_USERS, query:a!query( pagingInfo:a!pagingInfo( startIndex:1, batchSize:-1, sort:a!sortInfo( field:"name", ascending:true ) ) ) ).data) I'm using this inside a local variable in a interface. Is there a limitation to this approach? Do I need to do it somehow else? In a Web API, this works and returns all, but not here, is it something with usage inside an interface?

Hi Community, we are using currently Appian 21.3 on premise. The system language is German. The translation went down hill during the last versions from funny and incomplete to really "cant ignore it any more and makes my daily life difficult". It is just insane and awful. Incomplete translations - error messages still only translated partly and the result is a mixture of german and english, inconsistent translations - different translations for the same words within the same window just so completely wrong translations, that I was confused once or twice for some seconds how to proceed. - like translating the verb "load" not in the sense of "to load" and more like the noun "a truck load" Do you guys have any idea how to place that as topic at appian? Support case(s)?  Kind regards,Richard