Discussion Categories

We are on Appian 24.1. I have a process model with a user task followed by a write to a RecordType.  The RecordType keeps track of task performance (i.e. how long it takes users to complete the user task) for long-term trending and reporting needs. An expression rule is called to retrieve the details once the task completes.  This rule uses queryProcessAnalytics to pull the data for the particular task in question (processId and taskId filters).  The report filters for only completed tasks a!localVariables( local!rawData: a!queryProcessAnalytics( report: cons!XX_COMPLETED_ACTIVITY_REPORT, query: a!query( pagingInfo: a!pagingInfo(startIndex: 1, batchSize: 5), logicalExpression: a!queryLogicalExpression( operator: "AND", filters: { a!queryFilter( field: "c8", operator: "=", value: ri!processId ), a!queryFilter( field: "c7", operator

Hello All, I have a requirement to get the document, Currently document is not there in Appian as it is stored in S3 bucket and coming as url to Appian. When user clicks on that url,  document is getting downloaded. But I need that document without user action. Is there any way to do that? Thanks in Advance!!

Hello, I am attempting to convert this into Appian values, but I am having trouble.  What would be the best way to convert this? Here is the raw response from an API: {"response":"{\"requestId\":\"123456\",\"status\":0,\"description\":\"Success.\",\"response\":{\"transactionId\":\"12241094986\",\"payfoneAlias\":\"432432424\",\"phoneNumber\":\"324324324234\",\"lineType\":\"Mobile\",\"carrier\":\"T-Mobile USA\",\"countryCode\":\"US\",\"statusIndex\":\"51\",\"isBaselined\":true,\"score\":1000,\"phoneNumberVelocity\":0,\"portVelocity\":0,\"payfoneTenure\":{\"minimumDate\":\"2024-08-05T23:59:59.000Z\"},\"phoneNumberTenure\":{\"minimumDate\":\"2024-08-05T23:59:59.000Z\"}}}&quo

With CDTs I can do something like this to initialise a CDT with all fields set to blank/nullcast( 'type!{urn:com:appian:types}CustomType', {} ) Is anyone aware of a similar approach with records? Casting {}, null(), or a!map() to a record type just returns null In this use case I won't know the field names to be able to use them. I only have the record type **Edit: Adding more context If the record type has fields A, B and c then each of those fields needs to be set with null/blank (which is what would happen with the CDT). eg the value returned is recordType!CustomType(a: null, b: null, c: null)

Is there a way to get the list of all application objects we have in Appian via expression rule? I want the create a csv file with all objects and their corresponding UUID.

Hi everyone [emoticon:c4563cd7d5574777a71c318021cbbcc8], I have scenario where my data is stored in Map/Dictionary. Now this has to be stored in record.Each field to be mapped with the respective record field.Considering the volume, Is there a way to use the Field Id to map the value.Example: a!localvariables( local!list:{{columnName:"Name",recordFieldId"4567898765"}, {columnName:"Desc",recordFieldId"4567856894"},/* Now the data to be mapped */a!foreach(locaL!list,index(record,fv!item.recordFieldId,null)) )

Hello, I'm currently trying to use the import excel to database smart service within my process model and it's completing but not updating my data store entity.Process model:Start -> User form -> Import Excel to DB smart service -> EndThe file that I input in the form is an excel file and gets saved, and I have also configured the smart service so that the data source is a constant that contains the text which is my datasource: "jdbc/{name}". Table name: {SQL database table name}", excel file: Process variable which is stored excel document. After configuring all of these as followed by a youtube video that showcased this smart service, the data is not saving.I made sure that my column headers(A1,B1,C1) are exactly as stated within my CDT and matches the data type.How would I fix this/do this differently?

Hi Team, currently we are 25.1 appian version in on ON-Premises env. richtext editor is not working as expected in on ON-Premises but the same function working in on appian community edition  Appian community edition screenshot. could you please suggest me if i missed anything. thanks

Hi Team, if I configure the horizontal milestone it looks good like having more length in between values, but have a requirement same style we need to achieve in vertical style  ' but here we can increase length of each value like how we have in horizontal , please suggest me better approach, Thanks

Hi All, I set up the Grid Plus component using the code provided in&nbsp;https://docs.appian.com/suite/help/25.2/grid-plus.html. However, when I try to submit the changes, I receive the following error:&nbsp;&quot;class [Lcom.appiancorp.suiteapi.type.TypedValue; cannot be cast to class [Ljava.util.Map; ([Lcom.appiancorp.suiteapi.type.TypedValue; is in unnamed module of loader com.appiancorp.tomcat.loader.AppianWebappClassLoader @14151bc5; [Ljava.util.Map; is in module java.base of loader &#39;bootstrap&#39;)&quot;. Any suggestions? a!localVariables( local!submitChanges: {}, local!creates: {}, local!edits: {}, local!deletions: {}, gridPlusLayoutField( queryRuleName: rule!RE_queryRule, queryRuleInputs: { recordFields: gridrecordfield( < RecordField > , < RecordField > ), batchSize: 25 }, columnConfigs: rule!RE_columnConfig(), createDataValue: local!creates, createDataSaveInto: local!creates, editDataValue: local!edits, editDataSaveI

Hi Folks, In my interface if i delete anything i want to display a banner says Success!(Image added below) One i click delete as soon as the banner should display and after 5 seconds the banner should hide. how to achieve it. i have gone through with refresh Interval it did not worked as i expected. any plugin or anything&nbsp;&nbsp;

Hi Everyone, I need to get &quot;choiceLabels&quot; and &quot;choiceValues&quot; list from the dictionary as shown in screenshot. Can anyone please help me how to get it?

Hi All,&nbsp;&nbsp; Hope everyone is doing well,&nbsp; I have a requirement, where we are using task reports for assigning tasks in application UI. I need to implement the auto refresh the tasks assigned to the logged in users. Can you please help me understand what the logic would be I need to use. Please find the attached code snippet I have used currently. a!gridField_23r3( emptyGridMessage: "No Assigned Tasks", /*label: "Read-only Grid",*/ /*labelPosition: "ABOVE",*/ data: a!queryProcessAnalytics( report: cons!CTRIS_MY_TASK_REPORT, query: a!query( logicalExpression:{ a!queryLogicalExpression( operator: "AND", filters:{ a!queryFilter( field: "c12", operator: "

Hi All, Has anyone successfully deployed AI Document Center 2.9 on Appian 25.2?https://docs.appian.com/suite/help/25.2/aidc-2.9/whats-new.html When I inspect the new package:&nbsp;AiDocumentCenterv2.9.0.zip, I receive the following error message:The processModel [id= uuid=0005ee34-9c41-8000-0422-7f0000014e7a] was not imported because a required precedent is missing: The referenced smart service [local-id=internal3.rs2_ai_skill_advanced_idp_tools3, name=Advanced IDP Tools] was not found. (APNX-1-4073-000) (APNX-1-4071-006) When I add the &#39;Advanced IDP Tools&#39; smart service to a new process model and check what version is created, I can see that I am running the following version of the smart service:Advanced IDP Tools (internal3.rs2_ai_skill_advanced_idp_tools2) It looks like my Appian instance is running an older version of the Advanced IDP Tools smart service, does anyone know how I can update the Advanced IDP Tools smart service to the latest version? Kim.

Hi, After migrating to 25.1 version, we are unable to download excel from any of the records.&nbsp;The file will be attempting to be downloaded and fails after timeout. Below is the log we found in tomcat file, Caused by: java.lang.reflect.InvocationTargetException &emsp;&emsp;at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) &emsp;&emsp;at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:77) &emsp;&emsp;at java.base/jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) &emsp;&emsp;at java.base/java.lang.reflect.Constructor.newInstanceWithCaller(Constructor.java:500) &emsp;&emsp;at java.base/java.lang.reflect.Constructor.newInstance(Constructor.java:481) &emsp;&emsp;at java.desktop/sun.font.FontManagerFactory$1.run(FontManagerFactory.java:85) &emsp;&emsp;... 233 more Caused by: java.lang.RuntimeException: Fontconfig head is null, c

I am having Appian 24.2 version and the recordtype is having only few records &lt;100 and also few columns &lt;10. When i created the recordtype,&nbsp;it has sync disabed. Export to excel button is visible and aso clickable. But when i click that button, download is keep on happening for full day but dint return excel. This is happening for all record types. Please let me know what might be issue.

Hi! Is it possible to prevent removal of Record Events related to removed record? I want to have an event &quot;XX record removed&quot; but it seems impossible as it removes all events related to given record. Thanks, Damian

Hi All, We have a requirement such that, RPA bot need to open a record details in a web page then, save that details page (webpage) as PDF. We are trying to use keyboard shortcut &#39;Ctrl+P&#39; to open the print window, where there is option to &#39;Save as PDF&#39; but, the robotic task is not able to capture any action in that print window.&nbsp; Could you please tell me how to overcome this issue? I just need to save the webpage as PDF in the bot machine&#39;s download folder. TIA

How to remove the &quot;appian&quot; logo from top-right corner of Site. I didn&#39;t find any option in site configuration.

I&#39;m trying to simulate a double-click-like behavior in a read-only grid using&nbsp;a!gridField_24r3. The goal is to return a selected row&#39;s value when a user clicks on a field grid value twice. I am able to save the value of the grid after selecting&nbsp;it&nbsp;for the very first time by using fv!deselectedRows. Refer below code:a!save( local!previousSelectedRow, if( length(local!currentSelectedRow) = 0, index(fv!deselectedRows, 1, null), local!previousSelectedRow ) ) Now within the parameter &quot;selectionvalue&quot; of&nbsp;a!gridField_24r3, I am trying to manipulate the value it holds with below logic where I put a condition if there is no selection made --&gt; ri!selected will be empty but we have a value store within local!previousSelectedrow then we should get the id of that grid returned. if( a!isNotNullOrEmpty(ri!selected), ri!selected, if( a

Hello, I&#39;m trying to generate a dynamic table in docx. But unfortunately, I&#39;m getting an empty table. Attached below are the screenshots and the XML data that i&#39;m passing. XML Text -&nbsp; &quot;&lt;find&gt;&lt;irish control=&#39;Control1&#39; observation=&#39;Observ&#39; risk=&#39;Risk&#39; /&gt;&lt;irish control=&#39;Control2&#39; observation=&#39;Observ2&#39; risk=&#39;Risk2&#39; /&gt;&lt;irish control=&#39;test control&#39; observation=&#39;test observation&#39; risk=&#39;test risk data 4365475&#39; /&gt;&lt;/find&gt;&quot; Template -&nbsp; Result -&nbsp; Could you please let me know what am i doing wrong here?

Hi All, My requirement is if any error comesup then it has to redirect to the same interface to modify the form and then resubmit the form again . IN the 2nd interface (which is same as 1st) I&#39;m getting the below error .can someone please help.An error occurred while evaluating expression: Error.message:AC!error.body (Invalid index: Cannot index property &#39;body&#39; of type Text into type IntegrationError) (Data Outputs)

Hi everyone&nbsp;[emoticon:c4563cd7d5574777a71c318021cbbcc8], I have a scenario to use ReadExcelByHeaders.&nbsp; But it is throwing me an error:Expression evaluation error at function &#39;readexcelbyheaders&#39; [line 3]: java.lang.NullPointerException: Cannot invoke &quot;java.util.Map.entrySet()&quot; because &quot;expectedHeaders&quot; is null

First Scenario: I have created a &quot;GET&quot; web API in Appian Community Edition and called it through a integration from another Appian environment, but I receive body in the &quot;HTML&quot; format instead of Json and receiving below error. Second Scenario:Whereas, When I create it other way around like creating web API in other Appian environment and calling it from Appian community Edition returns a proper Json value in the response body.&nbsp;Why I am receiving &quot;HTML&quot; value in response body in First Scenario, it is like Appian community Edition doesn&#39;t support web APIs?

Looking for an Appian tutor to get me over the hump for senior by next friday. Was close on first attempt. Please reply if interested.&nbsp;