General

How to define the expression rule for site accent color? what should we consider for decisioning? As per the system,  The accent color is used to highlight key interface elements. Avoid grayscale colors (black, white, and gray) that are similar to colors used for interface elements and green/red that are similar to colors used to indicate positive/negative values If I want to conditionalize the colors for links, grid row highlight, etc, how should we define the conditions?

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

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

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?

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 All, I am aware that this error occurs when the time taken to fetch the data exceeds the threshold. We get these errors randomly for multiple expressions which use query entity on different tables/views but not frequently. I am afraid it may become worse when data present in DB increases in terms of rows. Can you please suggest some of the best options to mitigate this risk or avoid these errors, at Appian end, DB end or Server end? Thanks.

Hi team, We are getting below error while trying to open record summary view via record link. Can anyone tell me where the issue could be? Record is expression backed record. We tried testing individual rules and they gave proper output. Expression evaluation error at function a!recordBodyWrapper parameter 2 [line 55]: Invalid symbol found (comma) (APNX-1-4205-003) Let me know if additional information is needed. Thanks, Akshar

Hello community members, can you help me with the syntax for a array of CDT? i tried: 'type!{urn:com:appian:types}EBLE_Test'( {item: 1, checked: true, item: 2, checked: false } )

Hi all, I need to filter the data based on dropdown which have a value {"P","NP"} from Date field , if dropdown value is P then i need to filter all not null dates value in grid and if it NP then all null value in date field . is there any way to achieve the requirement, a!queryFilter(field: "dates",operator: "=",value: ri!dates)  

Is it possible to develop plug-ins on an Appian cloud instance or an a local developer instance is a must have ? 

a!richTextDisplayField( value: a!richTextItem( text: { a!richTextIcon(icon: "camera"), " " & ri!translationBundle["uploadpictures"] }, link: a!startProcessLink( processModel: cons!LDA_PM_UPLOAD_PICUTURE_MYASSIGNMENT_SCREEN, processParameters: { buttonAction: null, dispatcherAction: null, driverUsername: null, notifyDispatcher: null, tmsLoadId: null, tripAssignmentDetailsId: index( ri!tripAssignmentDetails, "tripAssignmentDetailsId", {} ), uploadPictureMyassignment: null } ) ) ) Hi c