General

I have this local variable local!variable: {2017,2018,2019,2020} local!variable2: a!forEach( items: local!variable, expression: if(fv!item

Hi I have this code written local!productgroup: a!queryEntity( entity: cons!MPPCONSCDT_megaMasterFile, query: a!query( /*selection: a!querySelection(*/ /*columns: {*/ /*a!queryColumn(*/ /*field: "productline",*/ /*alias: "productline",*/ /* */ /*)*/ /*}*/ /*),*/ aggregation: a!queryAggregation( aggregationColumns: { a!queryAggregationColumn( field: "EOMYear", alias: "EOMYear", isGrouping: true() ) } ), pagingInfo: a!pagingInfo( startIndex: 1, batchSize: -1 ) ), fetchTotalCount: true ).data, I returns below result Is there any way I can remove the null one?

Hello  how to convert this text string: "2022-11-12 00:00:00"(Text) to text string in format "dd/MM/yyyy" ? Thank you!. 

Hi All, I required to generate JSON in the below format for the data that needs to be sent to another system thru integration: Req format:  "[{\"ods_service_affected\":\"testetset\",\"ods_outage_start_datetime\":\"2021-11-30 13:00:00\",\"ods_outage_end_datetime\":\"2021-12-01 22:18:45\",\"ods_utage_duration_requested\":\"02 01:00:00\",\"ods_effect_on_site\":\"off\"},{\"ods_service_affected\":\"1213546\",\"ods_outage_start_datetime\":\"2021-12-01 13:00:00\",\"ods_outage_end_datetime\":\"2021-12-02 22:19:09\",\"ods_utage_duration_requested\":\"01 05:00:00\",\"ods_effect_on_site\":\"lor\"}]" As you can see there are escape characters that were added to the JSON. I tried adding those escape characters however I noticed an additional double quote is getting added to the string. It looks like by default double quotes are added to the values by JSON Below is my code: """ods_service_affected""": """" & fv!item.serviceAffected

I am using user filter in recordtype . Type of filter is daterange. Filter is done by expression rule not by selecting field of record data. I want  start date and end date from daterange picker . How will i get both date? or how can i find data whose date is between this date range.

Dear all, I am facing an issue while I try to run the appian status.sh script  as root user despite the ownership is root. I am getting the following error: ERROR: JAVA_HOME is not set and no 'java' command could be found in your PATH. Please set the JAVA_HOME variable in your environment to match thelocation of your Java installation. Any idea of how I can run it as root? Thanks beforehand. Kind regards,

Hi All,  I have a condition where I want to show a user profile photo if it is there otherwise show initials.  For Image , I am using a!Image and for Initials I am using a!stampField.  Can i use these two together so that if user profile is not present than I can show Initials. Thanks In Advance, Saurabh

Hi,  I have a table where username and password is stored , now in an interface i want to access password based on the username, can it be possible to access data from dB using a constant in the interface?

Hi ,       Is there an Appian function to retrieve Severs' primary locale ? I am looking for something like userlocale() , but specific to server not user. I know this can be be achieved in plugin/java. But I am looking Appian function. Ideally , I am looking for a function which can return highlighted settings in admin console as shown in the screenshot The usecase is a process model scheduled to run as batch which is developed by a single country but runs in different countries with its own servers. I am looking to dynamically disable or enable this PM , by setting up an expression or condition in the start timer.

This feature request involves navigation controls upon Site Action completion.  Currently, as with all Appian Actions, when one is completed the user is returned to the area they initiated the action from. This makes sense in a number of situations, however, not always with Site Actions in my experience.  In most situations I've encountered, a user is expected to submit 1 action at a time.  Typically we will have a few Site Pages, maybe a Home Page interface with general process details/contacts, a Record with some reporting capabilities, and a Action to submit a request.  Currently when the action is completed, the default behavior is to return the user to the same action's start form, essentially now a blank interface for the same process they have already submitted.  This causes end user confusion and creates extra development when we want to show a user a confirmation screen and allow custom navigation.  Best case, an extra click and an orphane

In the process model I used "Bar Chart To Image", can I change the color of the chart?  I had this result but I need to change the colors, there is any way?

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.

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

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.

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

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.

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  

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, 

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")   ))