Discussion Categories

Hi, We have a code where a view data we are showing in a grid and user have to download the report but while downloading user is getting following error: In the code we are using a user filter on a varchar field because of which there is data issue. Interface Definition: Expression evaluation error [evaluation ID = 325b2:2a9f5] : An error occurred while executing a save: Expression evaluation error at function fn!createfilterfromrecord_appian_internal [line 24]: The passed parameter(s) are of the wrong type. Received the type com.appiancorp.common.xml.JaxbConversionException: error converting typed value TypedValue[it=1980,v={ASSESSMENT MI REPORTs,Assessment Report in MI Reporting,Qm7Kig,{81,,10d2b745-9e94-474d-928a-c623c6e7ca8a@_a-0000eccb-82f8-8000-9c64-011c48011c48_16707690,0},#"SYSTEM_SYSRULES_recordGridField

I'm having trouble generating process objects in the "Compose your application plan" screen. When I click "Generate Process" in the Process tab, it shows loading but then nothing happens - the tab remains completely empty and no process is generated. And because process tab is empty I'm unable to generate objects from composer Has anyone encountered this before? What could be causing this issue? Appian Version: 25.4

Hi everyone, When I exported data using "Export Data Store Entity to Excel" from a proprietary Excel workbook that contains formulas, the Excel formulas get corrupted. Is there any limitation on the Excel workbook version that can be used with "Export Data Store Entity to Excel"? I am using Excel 365. Symptoms: (1) Formulas are shown as text and no longer calculated, for example:_xlfn.VSTACK({""}, _xlfn._xlws.FILTER(category!J2:J1001, TRUE, ""))IF(A9=0,,SUM(A9:B9))(2) Japanese phonetic (furigana) information appears in the same cell.

I have found information regarding a 5MB limit when my Appian application uses an Integration Object to call another API hosted on an external system. However, if my Appian application is exposing a WebAPI, so that an external system can make a GET request to my Appian application, is there a size limit on the JSON payload that my Appian WebAPI can return to that external system?

Hi Team, I want to make three axis graphs in Appian, so is it feasible in Appian? 

In UI I have option to add data using addRowLink. Once I select one name consider h1, then I click on addRow then there I can write any alphanumeric code and I am storing that in backend. but if I am selecting multiple names(2) then if I click on addRowLink 2 new row boxes are being displayed. In UI even if I select multiple names only one row should be displayed and in backend the code should be updated for all selected names. no submit button is available in that interface saveInto: { a!localVariables( /* Build one new row per selected partyId (no duplicate prevention) */ local!newRows: if( a!isNullOrEmpty(local!selectedInsuredId), {}, a!forEach( items: local!selectedInsuredId, expression: a!localVariables( /* Find the index of this party to resolve its applicationId */ local!idx: index(fv!item, wherecontains(fv!item, local!insuredParty['recordType!{f953bbb6-0363-40ce-afe7-4fd0315e1fc0}UWG Party.fields.{19291ea5-16a7-4ddb-9fc9-dbd77b0f9b3e}id']), null() ), /* Construct a new UWG MIB

I have a multiselect dropdown with names h1, h2 and there respective ids are 123,456. the interface is to update the codes in site.But when I am selecting both values from dropdown and adding the code, code is not getting added for both the values. It is only getting added for the first value(h1) which I selected initially in the dropdown(h1)

Service backed records sync configured .  Sync by Identifier Expression configured  Webapi configured  when external system hits appian webapi it gets synced with identifiers and able to see it on Records -> Data Preview But issue is we are not able to see it on Grid while configuring it using a!recorddata. And also sync data not showing up on view records list (default records preview) 

Dear community, Asking for help is easy, but only one side of the coin. Giving a great answer is the other, and not that simple. In our recent podcast episode, we discuss what it means to give great answers, and what it needs to make this a satisfying experience for everyone. In case you are not happy with the answers you get, or how questions are asked, maybe our conversation gives you some inspiration. Appian Rocks Podcast Episode 13: How to Get Your Questions Answered Let's rock the digital transformation, together! Cheers, Stefan.

Hi Team, I am starting the process model by triggering us start form, once a user click submit button in the interface ideally all the role input data should be transferred to process variables. But in my scenario one of the Rule input data is not transferring to the process,When is the click a submit button the data is getting saved in a role input properly ri: emailBody(Text)But the same data is not being transferred to the process model please refer the images below pv: emailBody(Text)

Hi, We have an a!documentViewerField component to display a PDF document, but the problem is that it shows editing options to download and print it, and we have been asked to disable these options. Is there another component that allows PDF documents to be viewed in read-only mode, only displaying the document without allowing it to be downloaded or printed? Or is there a way to configure this from Appian? Thanks These are the actions that can be performed on the PDF file. This is component we use

Hi everyone, If the AI extracts a value from a document that does not match any of the values provided by my Option rule (Expression Rule), what is the expected system behaviour? The Setup: Options Rule: An expression rule returning {"Access", "Avenue", "Beach", "Court"}. Extraction: The AI correctly extracted the value "Access". The Problem: Even though "Access" is in my list, the instance status is "Extracted with Errors". The Error Message: "The following contain invalid values: streetType" My Question:If the extracted value matches the Options rule exactly, shouldn't the status be "Extracted" (Success)? Why is it flagging a match as an invalid value? There is no issue with extra space or formatting issue.

We have an a!documentViewerField component to display a PDF document, but the problem is that it shows editing options to download and print it, and we have been asked to disable these options.  Is there another component that allows PDF documents to be viewed in read-only mode, i.e., only displaying the document without allowing it to be downloaded or printed? Or is there a way to configure this from Appian?

I have a webAPI which will receive the document from external system in binary format, but for file size around 25 MB, the API is taking more than 25 seconds.Is there any way we can increase the API performance by reducing the time taken by it?Thanks in advance.

In "monitor" section there is a "go to customizable report" link. I tried to filter them based on the name. I tried (see below the print-screen): -Name like "Daily" -Name like "Daily%" What exactly is the proper way? I need to filter all reports that start with "Daily". The above 2 didn't work. Any idea? Thank you so much.

Hi, the grouping is not working as expected in bar chart when i am using a!recorddata. I am working on PST time. So, any record which is created after 4 PM PST is grouped as the next day. Let's say I have 2 records, one at Feb 12, 3 PM PST and another at Feb 12, 5 PM PST. When I apply a filter for Feb 12, the bar chart actually shows me data of two dates, Feb 12 and Feb 13. The record which is created at 5PM PST is grouped to Feb 13. It is most likely due to the time difference(8 hours) between gmt and pst, as I can clearly observe any record after 4 PM PST is grouped to the next day. Is this behaviour expected? Please suggest me a solution.

In http response I am getting IDs and codes. Each id will have multiple codes. now i need to store the code with respective Id in table. How to do it?

Hi, I am wondering if there is a way to check whether the value stored in a local variable is a record type instance, so that I can use the a!keys() function to retrieve the list of fields and then index through it. Unfortunately, the code below returns a unique UUID for the record instead of something generic like "Record Type" that I could check against using a simple if condition. typename( typeof( ABC Comment( id: 1, comment: "test" ) ) ) Also, if anyone knows an even better solution to check not only for record types but for any type that can be accepted by the a!keys function (e.g. record type, map, dictionary etc), that would be great. Thank you!

Hi All, Asynchronous Start Process smart service runs as synchronously because sub process has activity chaining. Our question is old Start Process smart service runs synchronously as there is no option in earlier version, but newer version also runs same way then we have to Async sub process in that case. Any reason for this issue? Using on premise Appian with 25.2 Thanks!

Hi, I am using Community Edition and  following the Appian Developer path. In for Step-By-Step # 10 I am getting expression error while adding the reusable component on a interface/form.  I followed all the steps till this section and all works good. As per Step by Step #10, Guide I am trying to complete the following steps. as soon as I click ok, above expression error message displayed.  Any suggestions to fix this ? 

I know about Appian queues, etc related to multibot configuration. However when I compare how UIPath queues work  (in a reFramework configuration we first load data in the queue - using what we call a "dispatcher" - and each record is locked during processing using what we call a "performer") and I compare this with Appian queues I have a feeling that there is something that I miss. Can somebody provide more details about it? Thank you.

Hi, What is the most efficient way to retrieve data from a large table (more than 4 million rows) in Appian? When I use queryEntity to fetch data from this table, it takes a long time to execute, which negatively impacts Appian’s performance. How can I improve the data retrieval process? My current approach to solve the issue: I split the data retrieval into smaller batches. Specifically, I: Created multiple records that point to the same source table. Used the foreach function to query each record in batches of 5,000 rows. Used the union function to combine the results from each batch. Used the union function to combine the results from each query record. Then, combined the results across all the records to get the complete dataset. I’m concerned about future system complexity.Do I really need to create multiple records and change the system design just to retrieve all the data from a large table? Or is there a better, more efficient way

I have an interface where collecting the information & storing in record type.  Then sending this record type rule input to process model to store in db using write records  However before that write records node, I need to update a few of the fields of the record type.  I have tried to update the fields using the following expression, however the data which got from interface is becoming null and record type is updating only with the expression values. Can any one pick it up and shoot it?

How do you implement a try/catch in Appian RPA no code environment? Thank you.

Hello Community, I don't know if I'm searching the wrong terms to find answers in the documentation, so I'm going to lean on the community for some insight into my situation. Background:  We are dealing with a rehosting scenario transitioning from Appian Cloud to another environment configured differently.  I am unable to make changes to the new cloud space environment.  I can only work redesign of our app.  In Appian Cloud, we were the only system in our cloud space and utilized JDBC to connect to the underlying MariaDB.  The new environment is a shared space.  The use of JDBC is causing issues with the other tenants interfering with our data and tables.  We have been asked to transition to the use of the connected system object.   Questions:   1.  The database was set up in Appian Cloud by a different resource.  When attempting to build a new Connected System to our MariaDB, it's requesting a username an