General

Hello,  When I press a button right now it generates a excel file but I want at the same time to generate the excel file and also execute stored procedure, is there such a way, with one click of the button ? a!buttonArrayLayout( a!buttonWidget( label: "Excel", saveInto: { a!exportDataStoreEntityToExcel( entity: cons!BBO_OpportunitiesReportExcelDataStore, documentName: "Excel Export " & now(), saveInFolder: cons!BBO_ReportsFolderPointer, onSuccess: a!save( local!exportDocId, fv!newDocument, ), /*This displays an error if there is an issue executing the the save*/ onError: a!save( local!errorMessage, "Error Exporting File to Excel" ) ), a!save( local!staussave, true ), } ) ) And this is the stored procedute code:  executestoredprocedure( dataSourceName: "jdbc/Appian", procedureName: "deleteOppExcelData" ),

Hello community, I would like to rename some fields in a CDT to match the naming used in the JSON input. When I began to build the naming wasn't clear yet.Offcourse I can map the data, but like it better if the naming in the CDT match the naming of the input.After I changed the name, I noticed that the name is not updated in expressions.I probably have to manually rename in code referring to the old name.But when I try to remap in the process model the old name still appears in the node and I am not able to select the renamed field.the situation is like: CDT.oldName changed to CDT.newName but I am able to select CDT.newName. Kind Regards, Erik

Hello,  Is there a way generated Excel file with Excel File tools inside Process to be automatically downloaded for the user once the file is generated ?

Hi  Let's see I have a filter, it gives you fromTime and endTime. and I have 4 time point which is:    00:00,   9:00,    13:00,   17:00 The text number I give to those block as  "00","09","13","17", now, base on the filter's fromTime and endTime, if my fromTime = 00:00 and endTime is null, it should return me {"00","09","13","17"}.         if my fromTime = 07:00, endTime is null, it should return me {"09","13","17"},         if my fromTime = 09:20, endTime is 13:20 , it should return me {"13"}, How should I do the if condition smartly to achieve this, thanks!!!!

I need to send mail to multiple people based on selected location.. lets say: I need to send mail to people based on selected location. There are multiple location (A,B,C,D) There mail needs to be sent to 4 people: (M1,M2,M3,M4). If i select Location A then a mail should be triggered to that location only and all  4 people should receive mail for that particular location. Can someone help with the logic 

Hi All,         i have a requirement to create custom picker for populating country code based on the country name or country code entered. for eg: if i enter USA then it should show 1 and if i enter  1 then it should show all the codes containing 1. My doubt is will custom picker allow user to search from multiple data subsets(name and code).i have checked the documentation ,there it is mentioned using only single data subset. kindly provide your suggestions if possible with any examples. Thanks in advance. Pradeep.B

I want to store the value of 'Monitoring Day' text field into rule input. Please find the below code I am using: a!textField( label: "Monitoring Day", labelPosition: "ABOVE", value: text(ri!monitoringDate,"dddd"), saveInto: a!save(ri!monitoringDetails.monitoringDay,save!value), showWhen: not(isnull(ri!monitoringDate)), required: false, readOnly: true, validations: {} ), It is not storing value in ri!MonitoringDay.

Good morning, Is there a way to re-assign a task that has been accepted by an user for other user? For example, user A accepts the task, but user B (a kind of admin/supervisor) needs to assign the task to other user I know that if user A assigns the task to user B, this could be possible, but that is not usefull for us, we need user B has the direct option to re-assign Thanks

Hi All, How to get ids as{7570,6645} from multi-file upload expression: {fn!todocument(7570), fn!todocument(6645)}? Answer: toInteger() is it possible to store array as {7570,6645} in DB column docID? then retrieve to display uploaded dox list on UI. Answer: using another table to store ids in each row

The multidropdown field now has the ability to search for specific items within the list of options. I noticed it's quite fast at finding what I'm looking for even with a list of 1000+ items. I would like to know how the search it's being implemented to achieve this level of performance. The reason why I'm asking is because I would like to try to implement it inside a custom picker if possible. The implementation I have is the same provided by Appian with a foreach loop and checking every item against the provided search. However this stalls with large amounts of data. I know I can just replace the picker with the dropdown since it does the search for me and I have done that. But I would still like to know if there is a way to have that nice search inside the picker for future reference. Thanks in advance.

I have stored data in so many rows for same date in editable grid. Now I am trying to display this data as read only grid in another interface row-wise. But I am getting data of only one row and not all the rows. The code related is inserted below:  a!localVariables( local!newGridRow: 'type!{urn:com:appian:types}Monitoring_Roster'(), local!addRow:'type!{urn:com:appian:types}Monitoring_Roster'(), { { a!gridLayout( label: "Monitoring Roster for: "& text(ri!monitoringDate,"dddd") & " " & ri!monitoringDate, labelPosition: "ABOVE", headerCells: { a!gridLayoutHeaderCell( label: "Monitoring Slot" ), a!gridLayoutHeaderCell( label: "Monitoring In Charge" ), a!gridLayoutHeaderCell( label: "Comments" ) }, columnConfigs: { a!gridLayoutColumnConfig( width: "DISTRIBUTE" ) }, rows: { a!forEach( items: local!newGridRow, expression: { a!gridRowLayout( contents: { a!textField( label: "Monitoring Slot", labelPosition: "ABOVE", placeholder: "--- Select a Value ---", choiceLabels: cons!Testing_TIME

Hello, I have created one CDT and it's first column is auto generated primary key and the same CDT is used to store the column values of the editable grid. I have used the below code: Here "Slot Id" is primary key of CDT stored in the newGridRow local variable. I don't want to display this primary key column as editable grid column but want to store the value of this primary key along with the remaining editable grid columns in the database table. I have Write to Datastore Entity smart service. It is adding the new row to the database table with auto incremented primary key but not adding the values of other columns of editable grid in the table.  Please help me. 

Requirement: Sore uploaded docx ids array in DB column and get array to display uploaded list on UI. 1.Upload Multiple doc and get all docs array ids in local or ri variables, how to achieve? <-- 2.Is this correct approach to store multiple docx ids as array in DB column and retrieve from DB Using Appian documentation i was able to download multiple document from an array of {docid1,docid2,docid3} 3.How to convert? from  Appian multi upload stores i.e. {fn!todocument(6645),fn!todocument(7570)}  to expected {6645,7570} <-- 4.How to store/retrieve this docid array in DB ? how to  design DB with integer array? 5.May be I am wrong in above approach please let me know best approach to achieve above?

Hi All, For day to day issues and and severe issues in Appian which logs are frequently visited or looked upon? Could someone tell me the names and locations of the same with details information on the important logs? Thanks Faisal

Hi, Am getting this error:" : An error occurred while executing a save: Expression evaluation error : Attempted to run a second smart service, but only one smart service can be run per expression evaluation".  Can someone help out how to sort  this out. I have read other documentation it was asked to use another smart service in Process Model, but in my case there is only one process Model and the interface has been called in Start process ...so basically how to use. I hve attached the code. Thanks saveInto: { rule!Abc( cdt_Abc: local!cdt_Xyz ), a!save(local!viewButtonAction, "VIEW"), a!startProcess( processModel: cons!APPIAN_PROCESS_MODEL_MAIL, processParameters: { Notes: ri!Notes, sendTo: local!sendTo, }, on

We have initiated a process model by email and we get an error when the expression runs, the error says we dont have enough privileges.While looking at the executions, we see that the process model was executed by the user "GUEST".How can we solve the error?

Hi,  Using FitNesse, I want click records actions "Create New Job" I am trying to click on the Related Action using "Click on link" and "click on record related action "but it doesn't work. Any suggestion?  Thanks,

hi Team  We would like to embed Bing in APPIAN. Let me know the way to do it. Thanks  Arundhati

Hi, I have a CDT based on a view I built on the Appian MariaDB database.An expression rule (say, rule!GetAllData) pulls from the corresponding DSE through a simple queryEntity, retrieving all results.In an interface, I have a local variable defined as the rule result:local!data: rule!GetAllData()I also have a refresh button, with a dynamic link supposed to refresh the content of the variable, viaa!save(local!data, rule!GetAllData()) The weirdest problem happens: when clicking the link, nothing changes. Appian seems to somehow cache the results of the rule. Note that the records in the query differ between refreshes, so Appian maintains cached records that do not exist in the view anymore!I have verified this from the interface designer, inspecting the value of local!data.Even this does not solve the problem:{  a!save(local!data, null),  a!save(local!data, rule!GetAllData())}Even if I comment out the second line, click the link, verify that local!data is set to null, decomment

Hi, I am calling a startprocess smartservcie on submit button click in my interface. and i have set the submit as true for that button. So here before getting the response from smart service, interface is moving to next node in the process model. I want to get the response and based on response need to validate the interface. If no issues, then need to move to next node in the process model. Process model is starting asynchronously so i think whatever i am performing in onSuccess of srtartProcess, is not happening before submitting the interface. Any suggestions on this please.

I need to create a Unique ID in View which is not available in Table. I searched many places but all told to use row_number. Even though i tried but its throwing an error: Have used this  SELECT Row_number() OVER(ORDER BY `locationName`) AS `RID`, Note: `locationName` is available as column and have used in the view that have created   Can someone help out with workable code

In DB i have table  with columns firstnam,emailid and lastname data, I want to show in Dropdown firstanam,lastname and after selecting dropdown value want to query same table to get emailid  Step 1: get firstname and lastname to concate and store in array for dropdown purpose local!fn:{index(rule!PTS_QueryUsers(local!selectedDept),"firstName",{})}, local!ls:{index(rule!PTS_QueryUsers(local!selectedDept),"lastName",{})}, local!user:if(isnull(local!selectedDept),{},union(apply(fn!concatenate, merge(local!fn, local!ls)),apply(fn!concatenate, merge(local!fn, local!ls)))), Step 2: Show firstname and lastname to concate and store in array for dropdown purpose a!dropdownField( label: "Assigned Name", labelPosition: "ADJACENT", placeHolder: "Select User", choiceLabels: a!forEach( items: local!user, --> FirstNam,LastName expression: fv!item ), choiceValues: a!forEach( items: local!user, --> FirstNam,LastName expressio

Hi Team, I am getting list of user or groups from a ER like below Now I want to convert this User object to username/name or email. Or easy language I want to fetch user details from this object  Please help me I tried user() but it gives parameter error maybe user() accepts username not user Please Help

Hello, I have a requirement where i need to show a pop up warning message when user accidentally clicks on Summary tab when actually they are in Related Actions tab performing some operation (e.g. updating).

How do you check if variable is a list? Assuming that the variable is a local variable