General

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

hi,  I have a local variable "array of object" , I need to update value "seenBy" for one field in all array objects, a!flatten(a!forEach( items: local!msg, expression: { a!save(fv!item.id,fv!item.id), a!save(fv!item.isDeleted,fv!item.isDeleted), a!save(fv!item.createdBy,fv!item.createdBy), a!save(fv!item.messageText,fv!item.messageText), a!save(fv!item.convId,fv!item.convId), a!save(fv!item.createdOn,fv!item.createdOn), a!save(fv!item.seenby,concat(fv!item.seenBy, concat(tostring(loggedInUser()) , ",") ), ), } ) ), a!startProcess( processModel: cons!COM_Write_AllMsg_SeenBy, processParameters: { allmsg: ri!allmsg, } ), but the issue is :-  "An error occurred while trying to write to the data store [chatDS]. No values have been written. Details: Could no

Hi, I am trying to use an xpath as shwon below in fitnesse for appian script and it doesnt work, any help is greatly appreciated |click on button|xpath=//button[text()='Modeling']||toggle box |xpath=//*[div[text()='SomeState']

Hi All , I have a Date and Time field in my CDT (type DATE in the Oracle database). This field has a date and a time. I create a query entity rule with the filter: a!queryFilter(field: "recertificationDate",operator: "=",value: ri!recertificationDate,applyWhen: not(rule!APN_isBlank(ri!recertificationDate))) In the database, I have records with the date and time of 4/15/2019 4:05 PM but when I test my rule with ri!recertificationDate = 4/15/2019 4:05 PM, the rule is returning NO records. Any ideas why this is happening?

Hi All, We have just upgraded to Appian 20.4. I am not sure if the issue due to this but facing very strange scenario when using todate() function in an expression. todate("08/01/2021")<=todate(null)  --> this expression ideally should return false, but instead returning true. It was working as expected earlier. Please advise. Thanks and Regards, Diksha

What is the best way people have found to convert 6 Jan 2021 21:19:42 GMT text into date and time?

Objective: copy data from Process model properties and store the old data copy into same table(Multiple of updates done using interface) before new data update. I have "process start form" tab with - Update_Ticket_Interface This interface to update ticket on selecting table row Interface shows details to update ticket. Here, want to copy available data into a variable before form submit/update.  How to copy data from Process Model properties variable tab? Here, i am able to update only one record, not sure how to use process model to get copy of old data to store into same DB. i have process model as, Inputtask-startNode --> Write To Data Store Node -->End node In below screenshot, i There are two variables, PTS_TicketTest(For record Update-working) & PrevData(ForRecordOldDataCopy-GettingNull) PrevData tried to store in another Write To Data Store but getting null data, as PrevData didn't get data. Please let me know if any clarity needed. 

Hello,I'm using Export Data Entity to CSV smart service. This gives me CSV output and the CSV has a column named TransId, this column/field is a varchar in Appian.It may contain text and/or sometimes just integer numbers more than 11 digits.The problem here is when the value of this column is more than 11 digits then CSV by default shows value in a scientific format like 1.12233E+13 until the cell of the CSV is formatted to Integer.Is there a way to get the value correctly by default?(This smart service does not have input to take template unlike 'Export CDT to Excel' smart service).

Hi, I have an application developed in angular and java and have around 6 work flows, i want to implement workflows in appian without distrubing angular ui and java,  is this possible in appian , if possible how can u achieve.

Is it possible to pass the username in a link to site so that the user does not have to key it in, and just provide the password ?