Discussion Categories

Hey folks, Been running into an odd situation. Although I am in the groups Database Administrators and Database Editors, I am unable to view or edit (most) Stored Procedures & Functions on the MariaDB. The Appian version the customer runs is 22.2 and I should have all the necessary privileges, but nope.. tried to search for a fix for this but alas, no answer could be found. Has anyone else have had this issue or know how to fix this? Thanks in advance, Matthias 

Hello, can anyone suggest me how to add a new line in appian? Code: user(loggedInUser(),"firstName")& " " &user(loggedInUser(),"lastName")& " " & user(loggedInUser(),"email") The output should be: Beast Hulk green.hulk@avengers.com

Hi,I am using record data ( a!recordData() ) in "data" parameter of the read only grid and I am not able to make the paging dynamic ( should fetch the data/rows from the Record according to the batch size not the whole data), because of this the grid taking too much time to change the paging from one batch to another ( here in the below code pageSize: 10 ). Expected Outcome: Data should be fetched according to the batch size from the record not the whole data and User Filters must also work with the dynamic paging.Thank You.

Hi,For the Receive Message Event, there is an option to receive external external email to trigger to start the process.I understand that we should enable Anonymous User access for this to work. However, may I know the sender should send the email to which email address?

How to get the signed document sent using send document for e-signature docu sign back to appian.

Currently we have option to add a!recordActionField in the paging grid column to display record action. But is there a way to display more than 1 record action in one column? Please suggest.

i have to store some values for short period of time , i don't want  to store in database...is there any way

Is there any method to getting out of the forEach() like any break loop method?

Hi Everyone I want to create a Search box to search for Issue IDs in my Record Type. I found all the Info's on how to do it here: Search and Filter the Record List - Appian 22.3But my problem is, that I just can create User Filters, but don't have the option to create search boxes. When I'm on my Record Type, I just see User Filters. Which is not ideal to filter for Issue IDs, because there are a lot. And, if you believe the manual (Search and Filter the Record List - Appian 22.3) , Search Boxes would be better, because they don't load the data directly, but you can search for it after loading the site.  Does this relate to maybe an old Appian Version that I am note able to see Search and User Filter but just User Filters? Or do I have to "activate" the Search option on Record Types somewhere else?  Thanks in advance for your help and kind regards,  Pascale 

Hello Everyone, I am creating a Web API (GET method) and am using a!queryprocessAnalytics to get some values from a report. One of the column in the report is Asignee and the type/Formatting for this column is 'User or Group Name'. When i test the request i am getting a valid result but with either Group Id or username. I want to first know if the value is User or Group then convert it into First Name, Last name for User or Group name for Group. I tried using find("[",cast(3,value),0) to know if the value is user or group but after knowing i am not able to convert the value to First Name, Last name for User or Group name for Group. Please help me to find a solution for this. Thank you

Pls suggest me a way to go back to the record list view from a summary view.

I just downloaded and imported the https://community.appian.com/b/appmarket/posts/adhoc-collaboration application plugin and couldn't find the below components: ACC_API_compactView ACC_compactTaskDisplay ACC_compactCommentDisplay ACC_API_queryEntries ACC_API_createNewEntry ACC API Create New Entry process model ACC API rule folder Can anyone help me with this?

Hello, Do we have any templates to gather the business requirements for Appian solution ?

Hi, With our client, we could reproduce a curious problem with mobile phones (Android and iOS) : In an Interface we have a parent dropdown (category) that is used to filter a children dropdown.Initially the children list contains all the items because the selection of the category is on -Select- (null). 1.1/ Nominal case: - The first time we select a specific category (let's say -1-), we meet an issue : the children list contains all the items (filter does not work)- Then we select another category (-2-) : all works fine, the children list is well filtered- Then we select again the previous category  -1- : all works fine, the children list is well filtered (18 items with scrollbars) After this, the children is always well filtered (whatever the category selected). If we close the Interface then re-open it, we can reproduce the issue. 1.2/ Alternative case: If we make a test with a category filter that retreives few children items (less than 10, ie : withou

Hello Appian Engineering, Like to suggest : Scenario : When a developer working on any object rules , It could be UI or expression or model Appian always had version from past 12plus years Which is good As we progress it will be good to have save and commit 1. Save basically a developer works whole day in dev and keep saving not to lose his work but that does not mean it’s working and ready for others to use 2. Commit when developer decides it’s ready for checkin and can be used in site other he needs to commit and mandatory to write comments May be a ticket that developer is working against or an enhancement for targeting a particular release Many times we see 100s of versions but more than 75% are just saves of a line change and dev testing how it looks etc and after ten saves developer decides good for real change and closes that piece of work Just compare how eclipse or vscode git integration works Even further shelving concept from Microsoft Having been 12yrs with appi

In Process Modelling: Part 1 of Appian Developer learning can't find the process model name as AX New Vehicle. Please suggest. I am sharing the link of the document: academy.appian.com/

Hi Team, I am having some queries as mentioned below: 1.  Can we create tables in Appian db dynamically ? 2. Can we fire SQL queries to Appian db ? 3. How to maintain the session of a user in a portal? I want to delete some table rows if user session is logged of. Please help in this regard. Thanks in Advance,

Hi all, I just want to ask if I could create a website with appian? or appian just for creating moblie applications?

Hi Team, we got one requirement where the objects have multiple parent child relationship so we created one table and added one column called parentId and it is used to map all the child objects assigned to it. Now we created one record and the requirement is to add a column called child objects and will provide a rich Text Icon with link in that column and on the click of that click we have to filter the data mapped to that parent and we need to capture the sequence of user clicks (Since the parent has Childs and sub Childs). Can someone help me on how to implement this requirement. Thanks in Advance

Hi, I'm trying to add this grid column sort where my data is being pulled from a record,  a!gridColumn( label: "Modified", width: "2X", sortField: 'recordType!Record.fields.updatedDt', value: fv!row['recordType!Record.fields.updatedDt'] ), Now when i try to manually sort on the column getting the error: Interface Definition: Expression evaluation error [evaluation ID = 779f6:4b583] : An error occurred while executing a save: Expression evaluation error at function fn!error [line 114]: Invalid field identifier: "#"urn:appian:record-field:v1:adaa93fd-a839-446b-9a78-c0ea56a7b0d9/a20944d4-cb3d-4847-877e-ce0bf6144e3b"".

this is my simple interface1, i want to create a link or something to open another interface2 (dashboard). I'm trying this, because in sites only its available for 5 pages,    interface 2

here i have add A and B and show it in A+B row....[A+B row is read only] these rows am storing in value_txt field  shown in below so i have add the value_txt data where extensionRefId=4 and 12 and show the value in that integer field which refid=14 i had tried to write like index(fv!item.value_txt, wherecontains(4,fv!item.extensionRedId),{}) but this did not work can anyone help me with this 

Hi Everyone, I have a requirement to combine all excels having each sheet into a single file which contains multiple sheets together. I assume the combine excel sheet plugin will work but I am not getting the output document stored in the folder. Can you please suggest how to use combine excel sheet plugin? Thanks in Advance!!!

We have a business need to create folders to house documents.We plan to do this via a Process Model. In the future, we would need access these folders in order to save documents to them, and to retrieve documents from them. One way to do folder access we saw was to store the Folder ID when generating the folder, and storing that for future folder access. Is there another way to do this? Such as accessing folders via folder names?