Foundation

I need to write a validation to avoid user from selecting past data and time. My problem is when I use today() for comparison I get 13/09/2021 10:00 as date and time. There is a GMT component of 10 hours. I am expecting  userInputDateTime >13/09/2021 00:00 

Hi All want to create Ann expression Rule to check weather the array of values say rollnumber with the column field in the database . Condition If 2 value passed and one is there and another is not there then i don't want user to continued

We've just started getting the following UI expression error in all our lower environments: Expression evaluation error [evaluation ID = 59de2:e8179] in rule 'u1b_com_workitemsgrid' (called by rule 'u1b_ui_workitemsdashboard') at function a!gridField [line 5]: A grid component [label="null"] has an invalid value for "columns". A grid column [label="Team"] has encountered an error. Expression evaluation error in rule 'u1b_getdirectgroupnamesforanuser' at function 'getgroupsformemberuser' [line 20]: The user Incorrect privileges to get groups for user. [User Context: test.user2] does not have sufficient privileges to perform the requested action. And the follow in the system logs: 2021-09-01 09:36:19,992 [Appian AppianServerThreadPoolProvider 2246648] ERROR com.appiancorp.ps.people.function.GetGroupsForMemberUser - Incorrect privileges to get groups for user. [User Context: test.user2]PrivilegeException[null=>null]: Insufficient permission

Hi All, I am using the Navigation pattern in my interface. I am having different tabs on the left navigation. I am referring to separate interfaces for each tab. So now when i am moving between the tabs, the content is not refreshing. (When I am changing from WorkSpace Tab and clicking back the Workspace tab i can see the content previously where i left.) I want to reload the content when we click on the tab each time. Here i am using rule!testPage1(), rule!testPage2() interfaces for different tabs. {  a!localVariables(    /* The selected navigation section */    local!activeNavSection: 1,    /* The navigation sections */    local!navSections: {      a!map(name: "Workspace", icon: "briefcase"),      a!map(name: "Tasks",     icon: "tasks"),      a!map(name: "Requests",  ico

Hello Guys, Can anyone help us on the below issue ASAP. We have created the backup script based on the Appian documentation. Below is the script #!/bin/bash source ../../../../server/_scripts/exports.sh INSTALLDIR=$AE_HOME/_admin/_scripts/tools/datamaintenance/antScripts ant -f $INSTALLDIR/aecopyfiles.xml -Dae.source.location=$AE_HOME -Dae.dest.location="/data/aebackups" - Created backup script in ‘/apps/appian/_admin/_scripts/tools/datamaintenance’ -> ‘appianbackup.sh’     But, while running the backup script getting below error : “appianbackup.sh: line 6: ant: command not found” Please suggest what we need to do on this issue.

Hi All, Is there any way to open an external link using safe link and Write operation into Data Base on Single Link from User Interface Read-only Grid level. Current functionality using two columns in Grid Column1: Link (safe link) will open the external URL Column2: Start Process Link Writing operation in Database User Requirement: Merge these two columns with single Click do both operations.  Thanks Vinod

how to find difference of minutes between 2 time parameter. For example i have StartTime: 6:00 PM, and EndTime: 7:30PM.

I created an expression rule for a summary view of a record. I have an expression rule calling all the information needed within a view DSE constant. When prompted with the error, after clicking "Okay," nothing happens. Is there a way to edit this rule without drilling into the record?Here is the modal:

 Hello, I created a post-deployment process model in the Dev environment and deployed it into a test and my deployment status is failing. Is there anything I have to modify the code before deploying into the test, I followed the configure post-deployment in the documentation.  Can anyone suggest to me the steps to follow for post deployment.

Hi, i am using multidrop down field , i want to update my new values into local variable first then i want to update into my rule input without effecting the rule input  values when it is in editable condition and i have tried using the local variable but it is not getting store, can you guys guide how to solve this a!multipleDropdownField( label:"Pets", placeholder:"select a value", choiceLabels:index(local!pets,"petsNm",null()), choiceValues:index(local!pets,"petsId",null()), value:if( ri!isEditable, ri!pets.petsIdFk, local!pet ), saveInto: if( ri!isEditable, { a!save( local!addition, a!forEach(

Why we are using .@attributes.@anyAttribute._recordRef in the below rule and what is the need for using it in that rule. cons!COM_ENV_TXT_SITE_URL & cons!CLM_TXT_RECORD_URL & a!recordLink( recordType: cons!CLM_RECORD_REQUEST_DETAILS, identifier: ri!requestId, dashboard: ri!dashboard).@attributes.@anyAttribute._recordRef & "/view/" & ri!urlStub

Hi folks , I have a look up  table named "gender" , I want to develop a interface using which i can see,  add add, update , delete values in table without going in the appian cloud directly instead we want to perform this from the interface . For example i have genderId and gender column in lookup table , where there are two entries male with id 1 and female with id 2 , how can we add another gender in the table  directly or delete male row  from the table or update it. I hope you guys understood my query . Thanks in advance. 

Hello, As mentioned in the title, I have an SQL table that has a JSON type column. When I query it using a!queryEntity() in an expression rule, the resultant datasubset returns all the fields EXEPT the JSON field.  Do I need to take special measures when I deal with a!queryEntity() when it comes to JSON fields?  Thank you,

I am using a!recordLink() inside Editable grid row configuration : a!gridRowLayout( contents: { a!linkField( links: a!recordLink( label: fv!item.ID, recordType: cons!REQ_RECORD, identifier: fv!item.ID ) )} After clicking on the ID column link field I am getting below error: An error was encountered while processing your request. Could you please help me how can I configure the a!recordlink() field inside the editable grid row configuration.

Some of the nodes of process model are getting stuck . 

Is there limitation to add viewss on appian records? If i add more than 30 views on appian records it will affect on the performance?

I have a form has 5 rule inputs as follows:     1 CDT variable, 3 Text variables, 1 Integer variable.     According to best practices, how many process variables are required in the process model to Input Task?

Hi All I am working on version 21.2. I have a requirement, wherein if my process takes an exception flow, I need to send an email notification. This email should have a link to this process instance. I think a process task report should be made which should have one of the columns as below: Kindly let me know if this is the appropriate way of doing it, then how to proceed further. Also if there is some other way of achieving the requirement, kindly let me know. Thanks in advance!!

Hi, I have a requirement where i have to calculate the Business Day of a particular Date in a Month. The calculation happens from 1st  of every month. Basically my requirement is  opposite of workday(), in workday() business day is passed and it provides the date. Here i have the Date and the Business day has to be calculated. Thanks in advance

Hello, I would like to implement a "set" data structure in appian.  My use case prefers a "set" data structure as opposed to a list or dictionaries, because a set only contains unique values, or in my use case, unique sets.  I tried to search in the documentation, but to no avail. 

Hi All, is it possible to create a close button on a record page to close current browser window tab? or is it possible to do something like " window.open('', '_self', '').close(); " at Appian UI page? thanks, Gaurav

Hi I have an interface with load and with, when a user updates a value in the interface I need to return a boolean value and I am using that in another rule. In the load I have a local variable in which I am saving the old value and in the with I an doing a isnull(symetricdifference9oldval,newVal) and assigning this to a local variable and passing this to the other rule.  I am having an issue in setting the boolean value please advice me here.  Thank you. 

Hi Team, We have created Dashboard using Angular , user can view task summary and an Appian task link is available to user to work. we have a requirement to display closed task details and status of the instance to user.  Please can you suggest how to create and get a closed task link at Appian. Thanks, Gaurav

Hi, In our application users have initiated actions many times to upload a file due to some integration issue for file upload. Issue has been resolved. Now the support guys have been asked to trigger the instances from Monitoring. Now the problem is if we trigger blindly without seeing we may end up running multiple instances for same file upload and it may lead to file duplicate issue in the integrated system. Could someone tell easy method to trigger only one instance for the same request?(I do not want to open each instance and see and then run. It will take time) Thanks Faisal