Foundation

Hi Team, we have modified a field (lobId) from normal to an array type (highlighted below) In an interface, I'm getting the following error: The error I'm getting at the following code. line_of_business: if( isnull( local!line_of_business ), if( rule!APN_isEmpty( tostring( index( local!userlist.data, "lobId", {} ) ) ), {}, tostring( rule!CTR_QE_getLineOfBusinessById( lineOfBusinessId: tointeger( tostring( index( local!userlist.data, "lobId", {} ) ) ) ).data.line_of_business_code ) ), local!line_of_business ), If i send the values manuall

Hi All, We have requirement to remove list of users from All the groups whichever they belongs to. How we can achieve this in Appian 18.3 version? Any help will be appreciated. Regards, Sarvesh

I have an ID.  It's currently an integer. I want to know if there's a Document with that ID, or if there's a Folder with that ID.  Why?  Because if I guess and try to put it in the document() function, it will crash if it's a folder.  If I guess and try to put it in the folder() function, it will crash if it's a document. I've tried plugins, but the plugins have a super fun tendency to throw lots of Java errors destroying our logs whenever we try to find out if this stupid thing is a Document or a Folder. Is there a way to do this out of the box?  I want a rule that receives an integer and outputs the word "Document" or the word "Folder" or the word "Neither" and DOES NOT PINK BOX no matter what integer is.

hello,   I need to upload file by make submit : true() , for submit button . but i do not want to refresh the interface. is it possible? 

Hi All, Could someone answer my all the below questions/doubts? Ques 1: At what phase Import Customization File are clubbed while performing Compare and Deploy (Not Manual)?Because I did not see any options for the same as I can see for objects/database scripts  and pug-ins. Ques 2: When a stored procedure is used or when views are used or when Materialized Views are used in Appian and why they are used? Need scenario Based examples!. Ques 3: What is main reason we need Reports and Records separately in Appia (Because can display data)? Ques 4: When we have duplicate rows in a DB except their Primary Ids, then how can we return a complete Unique Row using a!queryEntity() function or any other functions. Ques 5: What happens to the pending Process instances if the current Process Model version is changed to newer version? Ques 6: What are the differences we will experience or when the system migrated to cloud from in-premises? Ques 7: What impact will be on running processes if w

Hi , Can we update Appian userid of the user? Thanks

Hi  I have observed two issues with hierarchyBrowserFieldTree. Any thoughts/suggestions are helpful.   1- if we want to narrow down the data by applying some filters, Its not refreshing the nodes but the nextNode counts are getting updated. 2- in the hierarchyBrowserFieldTreeNode attributes, showwhen attribute is not doing its job when we want to set false based on some condition, Interface is throwing an error. It can be tested easily with appian given example. a!localVariables( local!path: {5,2}, a!hierarchyBrowserFieldTree( nodeConfigs: a!hierarchyBrowserFieldTreeNode( showWhen:not(tointeger(fv!nodeValue)=0), id: fv!nodeValue, label: "Node" & fv!nodeValue, description: "Description for node " & fv!nodeValue, details: "Details for node " & fv!nodeValue, image: a!documentImage(document: a!iconIndicator("PREVIEW")), nextLevelCount: fv!nodeValue ), pathValue: local!path, pathSaveInto: local!path, nextLevelValues: en

 When I select the items in the grid and click on the button in the background the process model should trigger, and it must complete successfully, But when I click the button instantly twice or thrice immediately another process model is triggering the items which have selected becomes duplicate in next section. So, Here race condition occurs. Actually, we tried to restrict that button not to click it a second time by the user. The problem is before writing to the DB by the first process model in the fraction of seconds processes model also. In the interface, we are passing the selected items through the start process and try to capture the output. But nothing works. Let me know is there any way to stop the race condition either in an interfcae or process model

Hi All, Hope you all are doing well. There are two user accounts in Appian :- 1) aamir_khan 2)aamir.khan So when aamir.khan updates his profile picture ,from change profile picture in his account , The picture gets updated for both the account .The aamir.khan and aamir_khan  both will be having the same picture. Can someone please guide further to rectify or look further into this issue , it will be very helpful. Thanks in advance. 

Hi,  I'm trying to create an email template for outlook using the following code snippet,  a!safeLink( uri: concat( "mailto://", ri!email, "?subject=", "Random Text", "&cc=", "abc.com", "&Body= Hello", ) ) I have to add the company logo in the signature of the email body, can someone please let me know if this is possible? If so, direct me on how to do implement this.  Thanks in advance. 

 this is the code related to start form  a!localVariables( local!groups,a!formLayout( label: if(ri!readOnly,"Meeting Information","Request New Meeting"), contents: { a!columnsLayout( columns: { a!columnLayout( contents: { if(ri!readOnly, a!textField( label: "Meeting Subject ", labelPosition:"ADJACENT", value: ri!MMS_Meetinginfo.subject, saveInto: ri!MMS_Meetinginfo.subject, readOnly:true ), a!textField( label: "Meeting Subject ", labelPosition:"ABOVE", value: ri!MMS_Meetinginfo.subject, saveInto: ri!MMS_Meetinginfo.subject, required: true, validations: if( len( ri!MMS_Meetinginfo.subject ) > 50, "Value may not be longer than 50 characters. You have entered " & len( ri!MMS_Meetinginfo.subject ) & " characters.", null ) ) ), if( ri!readOnly, a!paragraphField( label: "Meeting Body", labelPosition: "ADJACENT", value: ri!MMS_Meetinginfo.body, saveInto: ri!MMS_Meetinginfo

Hi Everyone, I have a Request dashboard with few filters. This dashboard includes all the active tasks part of the application.I am facing a timeout issue (> 2 secs) when I use the filter for assignees (intermittent). User can select a particular group or an user to filter. I am looking for suggestion on this filter for assignees. To fetch the active tasks we are using a process report that filters all the active tasks with the report context being all the process models within the application.We have around 70 process models and currently active tasks in the Production is around 5600. When it was below 4000 active tasks the filters were working great. Key points:1. The tasks can be assigned to multiple assignees which could be group and/or multiple users.2. On the report I have a column "Task Assignees" which I has: - Definition: =joinarray(task_assignee_owner(),";") - Formatting: Normal Text The "Task Assignees" column was made this way because of mu

local!vehicleBaseLocations: append(local!vehicle,"ALL"), I have written a rule and called that in local!vehicle(i am fetching data from DB). Am calling that in local!vehicleBaseLocations,I need to add ALL option also, I have used append to achieve it but its throwing error "  Could not cast from Text to AB_location. Details: CastInvalidCould not cast from Text to AB_location. Details: CastInvalid  Can someone help what exactly am missing

Let us say I have array of dictionary    {{id:1,name:"Faisal",department:"EEE"},{id:2,name:"Hasan",department:"E&E"}, {id:3,name:"Faridi",department:"E&C"}} and I want  to return id and name only based on department="EEE" How can this be achieved using functions? I have tried the below but not able to get the result and from this query I am able to return only one field. a!localVariables( local!employees:{ {{id:1,name:"Faisal",department:"EEE"},{id:2,name:"Hasan",department:"E&E"}, {id:3,name:"Faridi",department:"E&C"}} }, a!forEach( items: local!employees, expression:if(fv!item.department="EEE",fv!item.name,{}) ))

Is it possible to add attachments to 'mailto://' while generating email popups for Outlook?

Hi Team, I'm having an old grid layout. I'm having a field "Classification", Currently if the data is null its showing as emply(rounded below). Now i want to put a condition, if any of the value is null/emply i should display as "None'" otherwise as it is value existing data              Classification          Insurance          Banking        Null/Empty Expected:        Classification          Insurance          Banking          None Using the following code a!gridTextColumn( label: "Classification", field:local!gridDatasubset.columnConfigs[31].field, data: if( rule!APN_isEmpty(local!gridDatasubset.data.c61), "

In a!richTextDisplayField() , helpTooltip is used as a parameter. When I used it, the tooltip symbol(?) comes above the label. It should be appearing next to the label like it happens helpTooltip is used as a parameter for a!textField(). Can you suggest some way by which I can place the tooltip symbol(?) next to the label.

Hello, In the "user input task" there is an option "Allow users to save a draft of in-progress tasks". I'd like to know if there was a way to launch the save draft by the system, I mean if we can do the save without an user's action (click on the button or do the "ctrl+s" shortcut). We need to be able to have kind of "auto save" of the current form. Do you think that is possible ? Thank you

Provided the getdatasubsetdownloadlinkfromrule plugin is no longer available, do we have any alternatives to export datasubset into excel

I have a component that contains user picker field which is a required field. This component also has a submit button. Something like the code snippet below. { a!pickerFieldUsers( label: "Request Owner", maxSelections: 1, groupFilter: cons!EEP_GRP_ESTIMATORS, value: property(ri!request, "cdo_owner", null), saveInto: ri!request.cdo_owner, required: true, showWhen: ri!request.status_id_fk cons!EEP_VAL_STATUS_COMPLETE ), a!buttonArrayLayout( buttons: { a!buttonWidget( label: " Submit for Review", icon: "arrow-right", saveInto: { a!save( ri!request.status_id_fk, cons!EEP_VAL_STATUS_IN_REVIEW ), rule!EEP_UT_saveAuditData( createdBy: ri!request.created_by, createdOn: ri!request.created_on, lastModifiedOn: ri!request.last_modified_on, lastModifiedBy: ri!request.last_modified_by ), /*Save Audit History Data*/ { a!save( ri!auditHistoryUpdate.estimation_id, ri!estimation.id_pk ), a!save( ri!auditHistoryUpdate.event_timestamp, now() ), a!save( ri!auditHistoryUpdate.initiator_name, lo

i need to append the dictionary in the left pic with the list of text strings mentioned in the right pic. First dictionary should have title:task Name appended after id and 2nd dictionary should have title:Due Date after id. once when first 7 in the dictionary is appended with the values from  list of text strings, the 8the value in dictionary should start to append from 1st again in the right pic. i tried looping using foreach but it never worked. Any help would be appreciated. 

Hi All, Want to open local system path/network path link from APPIAN SAIL form. How to do it? Thanks,

Hi, I need to access process variables in a "record type" object. I need the value of the variables that the active task of the process has in their data inputs. Is this possible? How can I do this? Thank you, Rita Ferreira

Hello, I have a table that contains the document id and some document metadata. I want to display a grid with these data and a link to the document but all documents are not accessible by the logged in user. I want to display only row that refer to a document accessible by the user. I try something like this: if (isnull(todocument(fv!row.docid)), /* do not display */, /display the row */ ) I also test if (todocument(fv!row.docid)="[NO PERMISSION]" but it doesn't work. How can I tests if the user have access to a specific document ? Thanks for your help

Short of creating a constant that contains all valid icons and richTextIcons (which is suboptimal given that icons are updated between Appian versions), is there a way to make icons "invalid icon"-safe?  i.e. Checking if an icon is in the list of supported icons on a given appian version before passing it into icon or richTextIcon? Context We have a (larger, complex) application that dynamically determines which icon to use in a richTextDisplayField. One can be thorough and investigate the root cause of why invalid values are being populated but I would like to be thorough and double-check. Thanks!