Discussion Categories

I am having difficulty utilizing the "Connected System" and connecting to the Appian DB. I have verified we have a Maria DB and that the database name is Appian.  I think I have the server name correct, but not 100% sure. Would the server name be the same as the appian website.... companytest.appiancloud.com:3306? I know it is already available as a Data Type "Topcat" but I am trying to execute a stored procedure on the DB. Thank you

Hi, I have two applications and the respective sites for those applications for now. In future these count of applications may grow. Now, I got a requirement that I have to provide a common interface which user can use to navigate the respective site based on the application groups user belonging to. Some users may have access to both sites and some users have access to a single site. Can someone advise how and the best way to handle the situation.  Thanks in advance.

I am looking for suggestions on the best and fastest way to query data that has about 50,000 rows of data.  My use case is data collection for inventory purposes where an operator will use a handheld device and scan and item_id barcode, the application retrieve a description and then they can scan a qty.  The reason for the retrieval is to verify a good part number, also to occasionally verify the barcode to the product.  The data currently resides in a SQL database.  We are on Appian 22.3 Cloud.

Hi! I created an interface with cardChoiceField, which allows me to choose one of multiple subinterfaces (via rule!), which I created before. These subinterfaces have a dropdown which value is assigned to a local (to subinterface) variable.  The problem is that when I choose a value in the dropdown it doesn't change the local variable simultaneously - to see the "refreshed" interface, I have to switch to other subinterface, and then turn back to the original. In that case I obtain the subinterface I want, with refreshed variables. Is there any way to do this without switching to other subinterfaces?  I understand that it could be solved using rule inputs, but I would like to know how the interaction with local variables in reusable interfaces work

I have an editable grid containing two drop-down columns with other editable columns as well. In grid, one drop-down value is mapped with another drop-down value. I need to put a validation that if that particular mapping already exists in DB then show mapping already exists only on click of submit button. Let's say in DB values in one row are: A (drop-down 1)    B (drop-down 2)       C (Text field)               1                             2                            xyz         Then if user enters the same mapping of A and B, i.e. selects A as 1 and B as 2 in UI, then show mapping exists. User can add multiple rows in editable grid through add row button and multiple mappings in grid can be added. It should be able to check for all rows and th

Hi, I have a requirement to provide just a link to download a standard file (File uploaded to a folder which is there under KnowledgeCenter) What is the best way to do this. When I review the Appian document I found this.   a!documentDownloadLink( label, document, showWhen ) Now, to the document parameter, how can I provide a path of the document?

HI all,  am new to this, please tell me how to give paging size of 2 in a grid and has to show "<<" like this so that another records has to show pagingInfo: a!pagingInfo( startIndex: 1, batchSize:2 i gave like this but showing 2 in agrid, but no arrow marks <<    like this i should show 1-2 of somenum > >> kindly edit?/modify the code  Thanks in advance

Hi, have created one rule which called from process model. but it does not return any value. need to filter values from pv. The rule has index and where contains

Hi, I have configured a data source and TEST CONNECTION also showing "Test successful". Now, when I try to create a Data Type with the option "Create from database table or view", it is not listing any of the tables or views from the SQL database. Please, let me know if any one of you are having any idea on this.

Hello, I am trying to represent the following structure using maps in Appian (for those familiar with C# or Java ... something equivalent to Dictionary<int, List<Object>): So the list looks something like this: { {    taskId: 100,    dependsOnTaskId: 101  }, {    taskId: 100,    dependsOnTaskId: 121 },  {    taskId: 101,    dependsOnTaskId: 123 },  {    taskId: 103,    dependsOnTaskId: 0 },  {    taskId: 123,    dependsOnTaskId: 5 }, } A task Id might have none or multiple unique dependencies (there are many other constrains but at this point I will just focus on the most basic structure) After processing this list, I would like to have a map as follows: { { taskId :100 dependencies: 101, 121 }, { taskId :101 dependencies: 123 }, { taskId :103 dependencies: }, { taskId :123 dep

Hi everyone, How to check all of the document if exist. I query all of the data have Document Id and I want to check all of that using in the single query

Hi every one,  I'm having a text string as example:  {"Status":"Active","updatedBy":"lynn123","hasAccount":false} What I expect to have is:  Status: Active updatedBy: lynn123 hasAccount: no  I think for replacing comma with a line-break, char(10) might work, then I will substitute false with "no". But for the rest of characters {,},"", I'm not sure how to remove them all at once. I checked documentary for a!stripWith or a!reject and I think they don't work with a list of characters.  Hope I can have some suggestions from you, Thanks a lot!

blank row in the cdt has to be added in the interface 

Hi  my question is can we store the values in local variables- yes we can, but can we select those values which are stored in local variable and get data from db?  so these values want to store in local variable  this is selectable row can get the data by selecting the row with that row data which is stored in local variable?

what might be my mistake

whenever i click on add row it's coming with selected  what mistake i have done here?

I want to use various methods given on this Documentation page. Can someone please tell step by step procedure to achieve this. Thanks in Advance.

whenever i click on add it's creating blank row in in RI, but no in the interface 

Hi, I have a use case where I need to redirect a user to a StartForm  when user clicks on the link in the email. I'm able to generate this StartProcessLink (Pm has specific process parameters that needs to be sent as  well) successfully when I try to execute in an expression rule but when I try to call this expression rule in ProcessModel's Script Task to get the output, it is returning a null value, any suggestions on how to approach it? Note: We cannot Trigger a Pm and keep it active as we do not know the time frame of when user would be working in it. It can range from a day to a month Any suggestions appreciated.  Thanks in Advance. 

I began noticing this around 22.2, plus or minus - if you're editing an interface with the expression editor box open, clicks on or near the left edge of the interface (such as checkboxes, etc), actually click inside the expression editor box, leading to some unexpected and fairly frustrating run-arounds.  I've verified that this seems to be present in Chrome but not Firefox, and i've verified it on the computer of at least one other designer. When opening the Inspector and using the "select an element" tool, I can visualize what I can only assume the culprit actually is - there is what seems to be a pretty severe overlap of the expression editor text area, encroaching into the left edge of the preview interface: In the above screenshot, if I click my cursor anywhere in that green margin (even when it's clearly over the "First Name" text box), it causes the cursor to land in (and move) the expression edit box.  If I have a read-only grid wi

Hello, new with Appian here. We have an account number text field on an interface screen. We would like the format of the entered values to follow this format "00-0000000". I built a rule to display that format, but it only works AFTER the field has lost focus. I also tried refresh after keypress. It didn't seem to work. Is there a way to have the "-" appear while a user is typing in the value? In this case it would show the "-" after they have typed in the first two digits and continue as they finish the rest of the digits. "12-" for example. Thanks

I want to delete one or more rows, but I have to select all the rows and it just deletes only one row. { a!gridLayout( headerCells: { a!gridLayoutHeaderCell(label: "", align: "CENTER"), a!gridLayoutHeaderCell(label: "Precio de Colocación", align: "CENTER"), a!gridLayoutHeaderCell(label: "Número de TÃ%ADtulos", align: "CENTER"), a!gridLayoutHeaderCell(label: "Importe", align: "CENTER"), a!gridLayoutHeaderCell(label: "Casa de Bolsa", align: "CENTER"), a!gridLayoutHeaderCell(label: "Tipo de Registro", align: "CENTER") }, columnConfigs: { a!gridLayoutColumnConfig(weight: 1), a!gridLayoutColumnConfig(weight: 2), a!gridLayoutColumnConfig(weight: 2), a!gridLayoutColumnConfig(weight: 2), a!gridLayoutColumnConfig(weight: 1), a!gridLayoutColumnConfig(weight: 1) }, rows: { a!forEach( items: ri!colocacion, expression: { a!gridRowLayout( contents: {

Hello. I'm creating an interface but I have a problem because I want select a checkbox for every row I wish to delete. I select the first one, but when I select the second one the first one is unselected. { a!gridLayout( headerCells: { a!gridLayoutHeaderCell(label: "", align: "CENTER"), a!gridLayoutHeaderCell(label: "Precio de Colocación", align: "CENTER"), a!gridLayoutHeaderCell(label: "Número de TÃ%ADtulos", align: "CENTER"), a!gridLayoutHeaderCell(label: "Importe", align: "CENTER"), a!gridLayoutHeaderCell(label: "Casa de Bolsa", align: "CENTER"), a!gridLayoutHeaderCell(label: "Tipo de Registro", align: "CENTER") }, columnConfigs: { a!gridLayoutColumnConfig(weight: 1), a!gridLayoutColumnConfig(weight: 2), a!gridLayoutColumnConfig(weight: 2), a!gridLayoutColumnConfig(weight: 2), a!gridLayoutColumnConfig(weight: 1), a!gridLayoutColumnConfig(weight: 1) }, rows: { a!forEach(

I have a process that gets a Doc ID to be deleted from the database. Before attempting to delete the doc, I would like to check if it exists in Knowledge Center? How can I do so? See below highlighted node where I need to add this "Check". Docs to be deleted node returns a list of Documents. Check needs to search for IDs as an array, if not found, remove from array.

Hi All, Sometimes if I click on particular action in tempo, it shows me the below error, I am not getting what is the reason behind this error. Could you please let me know the reason behind this.