Discussion Categories

Hello Community, Do you know how can I get the value from a record user filter? Basically I have several user filters for my record and when displaying them in a interface, I want to have some logic based on the user selection. From the image above, my question is how to get the selected value for Team filter ? Thank you 

Has anyone tried to embed a video player that would play WAV files?  We have a need to do this.

Please let me know how do I pass apostrophe in Inputs parameter  for executestoredprocedure function ocal!sp: fn!executestoredprocedure( dataSourceName: "jdbc/DRO", procedureName: "procCSS_Search", inputs: { { name: "ssn", value: ri!ssn }, { name: "lastname", value: ri!lastName }, { name: "firstname", value: ri!firstName }, { name: "caseid", value: ri!caseId }, { name: "primaryCauseTF", value: ri!primaryCauseTF }, { name: "causenum", value: ri!causeNum }, { name: "oagnumber", value: ri!oagNumber }, { name: "personid", value: ri!personId }, { name: "phone", value: ri!phone }, { name: "casestatus", value: ri!caseStatusCode }, }, timeout: 300 ),

Hi, I am trying to create an Integration object in Appian. How can I make these parameters dynamic based on the environment. I would like to pass different parameters based on the environments like DEV, UAT and PROD. All these environments will have different urls. How can I achieve this.

Hi @all, Is there an easy way to separate out users and groups from a Main Group in an expression rule.  Below are the users and groups coming from a group itself. I want to separate out users from this list and wants to store it. Looking forward for your support, Thank you in advance!

Hi All, here i using Milestone for my App in Summary(view) interface, so based on status value the Milestone Bar should work.  in table, "status" containing statuses: "Assigne", "Approved", "Return" and "Reject", which represent the different statuses of a request. I have the requirement of a milestone where first step should always be "Addproduct", then next possible steps shown are "Approved", by Manager and "Approved" by supplier it will complete. but when shopmanager "Reject" show like. >   similarly, Supplier too, 

Hi all,  I'm creating an interface that records and calculates the working hours for employees, the idea is if the working hours are less than 8 it should display: " Working hours are incomplete " , and if it was less than 0 it should display: " insert your working hours correctly please "  I made this expression, but when the value is less than 8 even it was less than 0 it always display : " Working hours are incomplete "  here's the expression:  { a!richTextItem( if( ri!WorkingHours = "8", "Working hours are complete", if( 8 > ri!WorkingHours > 0, "Working hours are not complete", if( ri!WorkingHours < 0, "insert working hours correctly please" ) ) ) )

Hi, I am trying to export Appian code from existing server and Import to the new server. In the Import process I have encountered with an option "Import Customization File (PROPERTIES)".  Where can I get this file. Do I need to Import separately or will it included in the Exported code. Can someone advise. Thanks.

Hii All, Can anybody help me how  to Implement pagination in Editable Grid?

Hi All, We are facing the errow : A null parameter has been passed as parameter 1 at function a!fileUploadField. Is anyone aware what can be the possible scenario for this error? Kindly advise. Thanks and Regards,Diksha

Hi everyone,  I think the Appian build-in Manage Filters feature is quite handy for saving and setting default features, however I've got some questions that need to be clarified (attach below the photo to not confuse you) 1. Is there anyway that I can check the DB that save these filters? 2. I'm going to add a new user filter into the list of existing user filters, will this action affect the saved filters record, I mean will it delete all saved filters in the DB and empty the My Filters tab (red highlighted ones)? And Is there anyway for me to I test this case when I have no saved filters exist? Thanks for your helps!

Hi team I'm needing some help with getting an interface together to populate a simple table for collecting survey data. I have a list of software titles divided into categories. Each category will be surveyed individually, until we have gone through the entire list of titles - this is to avoid providing our users with a massive task! Likewise I do not want to send through a task for each individual title in a category. Here is the concept model for what I want to do: The survey result CDT looks like this: I have been thrashing around for the past few days with Editable Grids and Read Only Grids, and am experiencing the following issues: With an editable grid I can put a dropdown into the column but I do not know how to generate an individual row for each title. With a read-only grid I can get the individual row for each title but I do not know how o set up the dropdown or equivalent for my users to be able to choose their response I have tried various approaches and

Anyone send me links for performance of record type and how many types? and how to do it?

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!