Discussion Categories

i have this {a!map(memberId: "test ui "), a!map(holdReason: "test ui "), a!map(description: "test ui "), a!map(summary: "test ui ")} wants an out put like a!map( memberId: "test ui ", holdReason: "test ui ", description: "test ui ", summary: "test ui " )is this possible ??

While i am practicing, i created a record type and when i am trying to generate record event types , i am getting an error " You must have edit access to at least one of the applications this record type is in to generate event record types ". I read a similar content and checked the following, but there were no problems. ・Record Type is added to any Application. ・There are not Missing Precedents. I can generate record event types about 8 days ago, but I can't do it 5 days ago.  I saw an article saying that it was automatically resolved so I left it alone, but it hasn't been resolved yet. ・Similar Content community.appian.com/discussions/f/data/35375/generate-record-event-type/137648 If you know, I look forward to your reply.

We deal with sensitive documents and for the sake of security, we are looking for a way to upload docs directly from Appian UI to S3 instead of temporarily saving it in Appian folder and deleting it later. 

I have this statement as the SQL statement on a Query Database node:UPDATE `ThisTable` SET `Status`= ac!closedStatus WHERE `TableId` in (ac!ListOfTableIds) ac!closedStatus is an Int, ac!ListOfTableIds is a list of ints. When I run the process, the Query Database node errors with this error: There was a problem executing the SQL query. SQL Message : class [Ljava.lang.Long; cannot be cast to class java.lang.Long ([Ljava.lang.Long; and java.lang.Long are in module java.base of loader 'bootstrap') I know I've gotten "IN" working on query database before, I just always forget the trick. Does anyone know it?

Hi , I have a scenario , where if a request is rejected by a user , the same request cannot be delete by the same user who rejected it . a!buttonWidget( label: "Delete", icon: "times", value: cons!Deleted[2] saveInto: {ri!buttonAction} style: "DESTRUCTIVE" showwhen: and( ri!readonly = false, loggedinuser() = ri!maker ---- this is just a rule input with type text a!isNotnullorempty(ri!rejectedby) ), disabled: if( ri!rejectedby = loggedinuser(), true, false ), validate:false Can anyone please help me with it . Thank you in advance.

We are facing multiple production incidents due to objects at different versions in all different environment.  Can any one please suggest what is the best governance practice we should follow to avoid these issues. Here, Appian support team make direct changes in Production objects mainly constants according to the incidents raised but they are not moved to lower environments. hence, when developer take changes from lower environments, it overwrites the production object, causing issues.  There are multiple heavy applications with more than 500 objects. How to keep all environments in sync? 

Hello, my team and I have used the new AI skill for an email classifier and we have several questions regarding the process.For some context, we need the AI to classify emails into three groups, lets say A, B and C. To train the AI we uploaded: for group A around 139 eml files, for group B around 103 eml files and around 70 for group C.Once it was "trained", it said it had an accuracy of 100% and it  concluded there were no errors in the training process nor the actual classifying process, but as seen in the picture, it seems the model was  only trained with few of the files we uploaded for each group.  We were a little surprised when we took a look at the metrics since 1- they were extremely successful and 2- the ai didn't use all the files we uploaded from each type. We still went ahead and tested it with new emails, 1 from group A, 2 from group B and another 2 from group C. The results showed all emails but one were classified as group A, and the

Hello everyone, I’m working with an interface grid that is prepopulated with different documents. There's also an "Add New" button that allows users to upload additional documents to the grid. Requirement: Users should be able to upload new documents. They should also have the ability to replace the prepopulated documents with new ones if they find an issue. When a document is re-uploaded (i.e., replaced), the old document should be replaced with new one, and not saved. Essentially, we want to fully replace the old document with the new one. I’ve read in previous posts that the target attribute on the a!fileUploadField component, when set to a folder, creates a new document in that folder. If set to a document, it’s supposed to replace the existing document by creating a new version. However, I’m encountering issues with this approach. Here’s the code I’m using: a!fileUploadField( target: if(

We have an expression rule that has not been modified since 2017. The developer who wrote the rule originally is no longer with the company. This rule is executing without error in our DEV, UAT, and PRODUCTION environments. However, when I go to the rule in Appian Designer, it's throwing an error, saying there is an undeclared local variable. Indeed, there is an undeclared local variable, and it is referenced multiple times in the rule. However, this rule is somehow working, otherwise we would see dozens of errors in Production on a daily basis (according to the rule's Performance Trends, it's hit several hundred times a day). How is this rule able to work correctly when it's called in Production, but becomes a problem when it's being modified in Appian Designer. It's worth noting that the rule is called by an Interface that (again) has not been updated since 2017, and still uses "load" and "with" instead of "a!localVariables" - and

The excel sheet contains some blank rows to divide the sections which I can't change, how can I skip these blank rows when reading from excel sheet. I see this readexcelsheet() function in other post seems it can decide which row to start, is it deprecated?

we are using chartcolumn in our application. Can we increase the X axis and Y axis labels. currently appian provide XAxis Style, YAxis style options are "NONE" and "STANDARD". please let me know if we can make these labels bold and italic/underlined. Thanks

I got 2 of this. one is Intergrate Designer and one is API Web designer. I already configured all the parameter and the endpoint seem the same from 2 of them. I use test request and both of them return success (200) but only Web API designer post data to database while Intergrate Desginer doesn't. Integration Designer :  Web Api Designer: Can anyone know what is the issue and how to resolve this one.

Hi, I am trying to call a process from parent process model but the start form in child process does not open and flow just pass through it. I tried with activity chaining or used subprocess but nothing worked. One way i know to change the process start form to task based form but wanted to check if there is any other way without it? Parent PM: Child PM:

I have a read-only grid that pulls the data from record type . I am trying to enhance the feature to add an update link to the page to enter new rows and thats needs to be updated in the Table .  Is there a way to achieve this without a CDT ?                                                                                                                      (or) Is there a way to update a table from the interface without a CDT?

I keep getting this issue, at first I was able to resolve it by going on the missing precedents page and granting all missing precedents but now there isnt anything missing. 

I have a case study for Employee Onboarding Applications , where I have different roles Like who will be acting on the Task based on the previous user's input . I want to make this as Record Centric Application and Tasks should also come from Database . Also for Individual records , it will show the status of the record in a Grid . How can I achieve this using Appian's Best Practices ? TIA .

I got 2 of this. one is Intergrate Designer and one is API Web designer. I already configured all the parameter and the endpoint seem the same from 2 of them. I use test request and both of them return success (200) but only Web API designer post data to database while Intergrate Desginer doesn't. Integration Designer :  Web Api Designer: Can anyone know what is the issue and how to resolve this one.

Hi all, We're running out of disk space on our cloud environment. Appian Support has identified that the main culprits are our Knowledge Centers. They can't however identify which specific Knowledge Centers are the largest. We have over a hundred though so it may just be an accumulation of them all. But anyway, I need to find all their individual sizes and am hoping someone knows how to do this without manually checking each Knowledge Center's properties? An option I'm trying is:  a!localVariables( local!knowledgeCenter: cons!ABC_KNOWLEDGE_CENTER_PROPERTIES, a!forEach( items: local!knowledgeCenter, expression: { creator: knowledgecenter(fv!item, "creator"), dateCreated: knowledgecenter(fv!item, "dateCreated"), description: knowledgecenter(fv!item, "description"), id: knowledgecenter(fv!item, "id"), name: knowledgecenter(fv!item, "name"), numberOfDocuments: knowledgecenter(fv!item, "numberOfDocuments"), size

we have column wise grid users wants it in row wise grid how can we implement 

when I click on the red triangle error, it reads the following: Syntax error Details: Expression evaluation error at functiona!isNullOrEmpty parameter 1 [line3]: Invalid index operator 'hash' (expecting comma).

Hello, I need to add text to a PDF file and save it to a rule input or local variable. Is this possible in Appian? Any suggestions would be appreciated. The a!documentViewer() function allows adding text, but it doesn't save to a local variable or rule input. There's also a pdfAnnotations() plugin that lets you add text, but it requires creating an Adobe project and specifying a domain, which doesn't accept HTTPS. Assistance on this matter would be helpful. I am attaching a screenshot of the Adobe domain issue. Thank you in Advance. Hari Lakkam.

Hi, I have a requirement where I need to find the count of how many times a keyword appears in a PDF. How can this be done?

Hello All, I need to create a Scheduler which marks all the existing records under in table against column Is_observed = 1 at the end of each year starting December 31, 2024. Is this good to go?

Hello, I want to show percentage or numbers on pie chart instead of showing up with the legends. Can anyone please help me in this?  Also move the legends to bottom of pie chart. Currently it is showing up like this:  Attaching screenshot for reference: I want to replace with this:

I'm looking for some best ideas to support read only access to prod. I'm leaning towards create dev/qa as basic user and add to designers group and view only application specific groups then remove designers from DB Editors which allows dev to access both DB and designer in read only mode. Any drawbacks or any articles/ ideas to do it in different way? Appreciate your time! Thanks