Foundation

what does rv!identifier is ? when and how to use it. Please give me an example.  I am not able to understand in the documentation

Hi all, I Need to display static value in the text field and same value should save into one more variable , Please advise. load( local!getTexfieldValue, { a!textField( value: "abc", saveInto: { a!save(local!getTexfieldValue,save!value) },),a!textField( value: local!getTexfieldValue,)}) Regards Pallavi N

Hi, I'm facing a performance problem on a queryEntity.The query is done on a DSE mapped to a view in an external SQL Server database.When connecting to the DB through a client, a SELECT query with a couple of WHERE conditions takes less than 5 seconds, but when done through the queryEntity, it takes more than 10 seconds and causes a timeout in Hibernate. The environment is in cloud, so the timeout can't be overridden.I'm looking for ways to debug this discrepancy in timings.Here's the code (in reality there are 5 filters). I tried setting fetchTotalCount to false to improve performance, the result does not change. a!queryEntity( entity: cons!EXTERNAL_VIEW, fetchTotalCount: true, query: a!query( pagingInfo: topaginginfo(1, - 1), logicalExpression: a!queryLogicalExpression( operator: "AND", ignoreFiltersWithEmptyValues: true(), filters: { a!queryFilter( field: "field1", operator: "=", value: ri!value1

Hello Everyone, I had a requirement that I had a requirement of transactions like (to transfer amount to one account to another account) I am able to do the transactions in Interface but How can I save that Values to the particular field in another record. Can anyone help me with this? Thanks in ADVANCE a!localVariables( local!result, a!formLayout( label: "Transaction", contents: { a!columnsLayout( columns: { a!columnLayout( contents: { a!floatingPointField( label: "Available Balance", labelPosition: if( ri!readOnly, "ADJACENT", "ABOVE" ), value: ri!COB_Applicant.kycid.transaction.availableBalance, saveInto: ri!COB_Applicant.kycid.transaction.availableBalance, readOnly: ri!readOnly, disabled: false ) } ), a!colu

My users want an email link in a UI, that when clicked opens Gmail.com in their browser, and if signed in to Gmail already, opens a draft email window with the email address from the link.Currently I am using safelink, and it opens the default mail application on the user's computer.  However, they want it to always go to gmail.com regardless of the default mail app. Is this possible?Here is an example of the code I am usinga!safeLink( label: "example@example.com", uri: "mailto:example@example.com" )

Hi All, We have requirement where we need to reassign a task from One user to another user in Bulk? How we can achieve this in 18.3 Version? Any help will be appreciated. Regards, Sarvesh

Hi Team, Could you please help me in converting the following code into Foreach() if( isnull( local!region ), if( rule!APN_isEmpty( tostring( index( local!userlist.data, "regionId", {} ) ) ), if( rule!APN_isEmpty( tostring( index( local!userlist.data, "lobId", {} ) ) ), if( rule!APN_isEmpty( tostring( index( local!userreg.data, "regionId", {} ) ) ), {}, local!distuserregname ), null ),

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