Foundation

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!

Hi, Could you tell me how a filtered RecordType grid (placed inside an interface) can be refreshed please ? My RecordType data are retrieved from the a!recordData() function, and is filtered on the field "deleted" (all rows are visible if delete = "false"). I have a button that calls an Expression Rule to update the underlying table to set the "deleted" field of the selected row to "true". (I use the WriteToDataStoreEntity Smartservice). After the table is updated in database, I have click to click on the "refresh" icon of the RecordType to see that all is working fine : the lines are hidded. How would you refresh the RecordType, without a manual user action please ? (I intentionnaly do not use any process model for this example)

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 } )

load( local!carriers: rule!CAS_getPayeesAndCarriers( getOnlyCarriers: true ), a!gridField_19r1( totalCount: ri!processData.totalCount, columns: { a!gridTextColumn( label: "Last Updated", field: "c12", data: a!forEach( items: index(ri!processData.data, "c12", {}), expression: todate(fv!item) ) ), a!gridTextColumn( label: "Assignee", field: "c13", data: a!forEach( items: index(ri!processData.data, "c13", {}), expression: if( isusernametaken(tostring(index(fv!item, 2, null))), rule!CAS_formatUserName(userName: index(fv!item, 2, null)), null ) ) ), a!gridTextColumn( label: "Carrier Policy ID", field: "c6", data: index(ri!processData.data, "c6", {}), links: a!forEach( items: index(ri!processData.data, "c5", {}), expression: a!processTaskLink( task: fv!item ) ) )

Hi, I've created a simple RecordType based on a MySQL table, and when editing the grid list (tab List), I have added a new column that does not exist is the underlying table (ex : "total" that is the sum of fields "nb1" and "nb2").  When using this colum in a Grid of an interface, why does the "Recordtype!Vehicles.Fields.total" is not available ?  Does the Fields object contain only the fields that exist in the underlying table ?

Hi Team, I have a grid Layout which is having couple of fields. But one search field "Classification" is not working as expected. Please find my below code. Code: a!gridLayout( label: "Legal Entity Overview", totalCount: local!entitySize, headercells: { a!gridLayoutHeaderCell( label: "Name" ), a!gridLayoutHeaderCell( label: "Tax Identifier" ), a!gridLayoutHeaderCell( label: "LOB" ), a!gridLayoutHeaderCell( label: "Classification" ), a!gridLayoutHeaderCell( label: "Region" ), a!gridLayoutHeaderCell( label: "Country" ), a!gridLayoutHeaderCell( label: "Reporting Type" ), a!gridLayoutHeaderCell( label: "Client Institution ID" ), a!gridLayoutHeaderCell( label: "Milestone" ), a!gridLayoutHeaderCell( label: "Deadline" ), a!gridLayoutHeaderCell( label: "Completion Date" ), a!gridLayoutHeaderCell( label: "Reportable Status" ) }, columnconfigs: { a!gridLayo

Version : Appian 20.3. I have a process with 2 Event Receivers : "External_Escalaion" & "Escalation". I have a User Input node which escalates, sending  a message to destination called "External_Escalation" (in the same process). I would expect to receive the message only on the "External_Escalation" node, however it triggers the other as well. Any clues ? 

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 ? 

Hi, I would like to remove an item from a list, depending on a field (here, the condition is : when the "checked" field is false, I need to remove the item) : /* Set to null the unchecked Vehicles items */ a!forEach( items: ri!vehicles, expression: if (rule!SHARED_IsFalse(fv!item.checked), a!save(fv!item, null), a!save(fv!item, fv!item) ) ), /* Remove the null items */ a!save(ri!vehicles, reject(fn!isnull, ri!vehicles)), 1/ How would you code it in a single instruction please ?  (with a foreach and a remove ?)2/ From a SaveInto of an interface the code above works fine, but now I'm trying to execute it from an Expression Rule. So, how would you code this instruction "a!save(fv!item, null)", as a!save cannot be used in ER ? I've tried to use the function updateDictionary(), but I do not see how to set an item to null (I can just set some fields to a null value). I'm sure the answer of the first question can make the

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?

We are using out of the box task notification emails and one of the influential users doesn't like the GMT origin time zone on the notification email. I've looked in regional settings per user, looked at the emailheader.html and emailfooter.html system objects, and in admin console, but cannot find a way to localize time per user on these notifications. I'm concerned the only alternative is to eat the system task message and pass along a custom email to the group.  Is this true, or is there something I have overlooked? Thanks for any insight!