Foundation

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

Can you help me on how I can restrict the visibility of my page if I put this in but the other role I have still sees it? not ( isusermemberofallgroups( user: loggedInUser(), groups: a!groupsByName("RDCR Ejecutivo")   ))

How can we extract user uploaded pdf document using multiple part file.

Hello All, Few users are facing issues currently on different interfaces and they come up with identifiers to find the resolution. When I checked the system log, I found that design_error.csv file is not generated since nov-9. Does anybody knows why its not getting generated? or is there a way to generate it?

Hi, When I try to use multipleDropdownField to display multiple language selection and if I try to use "employeelanguages" rule input to save. When I uncomment the below commented code, I am getting an error Could not display interface. Please check definition and inputs. Interface Definition: Expression evaluation error at function a!multipleDropdownField [line 19]: A multiple dropdown component [label="Languages Known"] has an invalid value for "value". All selected values must be present in the choiceValues array, but value was 4 and choiceValues was 1; 4; 2; 5; 3.

Hi Appian team, I have changed the display name for CDT and there for modified the field name in interface as well. I have done the below code change, but the regular expression added for validation is not working as expected. Can anyone help me out to solve this issue? below is the code snippet used. a!textField( label: "Purchase order (PO)/Sales order (SO)/STO/Requisition", labelPosition: "ABOVE", value: trim( index( ri!PF_Request, "Order_Del_Number", null ) ), saveInto: { a!save( ri!PF_Request.Order_Del_Number, /*if(ri!PF_Request.GBEID=18,*/ /*left(*/ /*trim(*/ /*save!value*/ /*),10),*/ /*trim(*/ /*save!value*/ /*))*/ trim(save!value) ) }, required: true, validations:if(ri!PF_Request.GBEID = 18, if(regexmatch("^([0-9]{1,10})$",ri!PF_Request.Order_Del_Number),null,"The number provided should not contain any special character and can have upto 10 digits"), null ) ) Also please see the below discuss link to understand what are the ch

I have a CDT "AT_employeelanguages" like below-attached screen I am pulling the below table data using an expression and referring to the same using an expression rule AT_GetLanguages() When I use the below code, nothing is saved into my CDT "employeelanguages". Can someone guide me to solve this issue? Thanks in advance. a!localVariables( local!languages: rule!AT_GetLanguages(), local!selectedLanguages, a!formLayout( label: "Test" & local!selectedLanguages, contents: {a!checkboxField( label: "Languages Known", choiceLabels: index(local!languages, "name", null), choiceValues: index(local!languages, "languagenumber", null), value: local!selectedLanguages, saveInto: { local!selectedLanguages, a!save( ri!employeelanguages, local!selectedLanguages ) } ) } )