Foundation

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 everyone, I have this in an interface: But if the user, types an invalid "NIF usuario", the validation message we have, makes the components misaligned: Internally, its a sidebyside with 3 items, all inside a column. THX!

Hi Guys, I am using Appian trial for practicing but Unable understand how to create menus on home/default interface and this interface need to inherited by all other interfaces. I appreciate any help.

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

I have few process models which are timer-based and are started every day at a certain point in time. The issue I am facing is there are specifically some nodes like: One script task in the parent process model Few discrete script tasks in some of the sub-processes called from the parent process model One sub-process node Ond De-activate user node in one of the sub-process The issue is that, they are not running automatically which they are supposed to run. This is happening only with some specific nodes which I've mentioned. I've compared the configuration with the other similar nodes in the process models which are running fine but couldn't find any difference which may lead to this issue. To run these nodes, I have to specifically right-click on the concerned node of the running instance and click on Start. Post that, it goes through properly. Any help on this would be great!

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

I am attempting to config the node and it works great when I use the subject, but the subject will change except for "RE:" in front of it.  When I attempt to set it up with ToEmails or To Names it never kicks off. Thoughts?

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

Hi, I found in an existant ER code this kind of multiple condition: if(cons!TEST = "1", "VALUE 1", cons!TEST = "2", "VALUE 2", cons!TEST = "3", "VALUE 3", cons!TEST = "4", "VALUE 4", cons!TEST = "5", "VALUE 5", "" ) That seems to works fine, but when I put this condition in an interface and click on "DESIGN MODE", I obtain this error:    "Cannot load Design Mode : The function ’’if’’ [line 275] has 3 parameter(s), but instead passed 11 parameter(s)." Where is the truth ? 

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

When I click on "add request url value" It takes me to a random row that it in that data already. But I want it to take me to a new and clear row.  addRowlink: a!dynamicLink( label: "Add Request URL Value", value: { CRETD_BY_USER_ID: loggedInUser(), CRETD_TMST: now(), },

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

For my service integration, i have to send the request in json format. I am converting my nested CDT into json format by using a!tojson function. Here the issue is my service has some optional input parameters and when i am passing null for those parameters, a!tojson is converting them to "" (double quotes). My service is not accepting the "", i should pass Null. a!toJson(  'type!{urn:com:appian:types}_testCDT'(    name: "ram",    age: Null,    place: ""  )) json looks like : { "sampleName"  : "Test", "Organization" : { "Name" : "TestName", "Branch" : "" } } here Branch value should be Null instead of "". Thanks in advance.

Which version for BPMN Appian use? 

Hi all, Does anyone know how or have examples of creating a line chart with the time on the x-axis and the date on the y-axis? Looking to see the number of requests that come into the queue for an application based on time of day and date. Thank you.

Im trying to write a expression rule where there are two ri variables , one ri variable has type list of users and other ri variable is of type list of numbers. something like below ri!users: {"abc","def"} ri!numbers: {1,2,3,4,5,6,7} i have a use case where i should need to receive list of dictionary in below format { user:"abc", number:1 }, { user:"def", number:2 }, { user:"abc", number:3 }, { user:"def", number:4 }, { user:"abc", number:5 }, { user:"def", number:6 } . . . etc

Hello community, I have the following scenario, I have a array of student details. It has fields like student id, subject id, question paper id. I want to group by subject id and update the question paper id in the array. Given Array 1: {student id: 100, subject id: "S1", question paper id:   }, {student id: 200, subject id: "S2", question paper id:   }, {student id: 300, subject id: "S1", question paper id:   }, {student id: 400, subject id: "S2", question paper id:   } {student id: 300, subject id: "S1", question paper id:   }, {student id: 300, subject id: "S3", question paper id:   }, Array 2: {Q1,Q2,Q3} Array 3 : { S1,S2,S3} Expected Output: {student id: 100, subject id: "S1", question paper id: "Q1"}, {student id: 200, subject id: "S2", question paper id: "Q2"}, {student id: 300, subject id: "S1", question

Hi, Initially when clicked on submit button where validate is true, this will validate and show messages like "Enter a value" for each field. Now when i again click on the another Cancel button where validate is false, then the validation is still showing  " Enter a value" should be disappeared. which is not happening now.