General

Is there a way to identify the objects with more than certain lines or sort objects by lines count or characters count?

I have a requirement wherein I need to download multiple files (say 30 files) at a button click to the local system I have seen posts to try Zip plugins to add documents to zip and unzip the same. Please can someone suggest a way on how i can achieve that on a button click the files are downloaded to my local system. The number of files are dynamic.

While sending the email, some of the text is getting removed and receiving only partial text. Below is the html text: <p><span style="font-size: 10pt;">Dear colleagues,</span></p><p style="text-align:start;"><span style=""><span windowtext="" 1.0pt;mso-border-alt:none="" 0in;padding:0in;mso-ansi-language:en-us'="" style="font-size: 10pt;"> </span></span><span style="font-size:10.0pt;"></span></p><p style="text-align:start;"><span style=""><span windowtext="" 1.0pt;mso-border-alt:none="" '="" style="">Please note that the EU approval by CHMP Positive opinion has been granted on 05 December 2024 for </span><span style="">KEYTRUDA (pembrolizumab) for variation EMEA/H/C/3820/II/016 which removes the instruction &quot

I have a following Use case- 1- Need to extract 40+ MB data from different system as per Ondemand request from Appian Interface 2- Dump this data into some staging table residing in Appian Business Database schema and perform operation afterwards Which solution will be most usefule in terms of Scalability and availability 1- Use SQLtoExcel plugin? will this support to get the dump into excel via User on demand request 2- Export Datastore entity to Excel? will it support 40+ MB data or will it be timed out? Any other approach we can adopt? Here major concern is On Demand request for processing the data via Appian Interface.

Hi All, We have a requirement, where we have to import excel file data into Appian database stage table. Once data is loaded into stage table we have to validate the date format for date columns whether the date is invalid or valid using query entity or any custom function. In-valid records should be removed and only valid records be there. Can someone help us with this kind of scenario in Appian how we can avoid the in-valid date rows in Appian.  Regards, Dheeraj G

Our Security team is looking to roll out the Island browser: https://www.island.io/ Has anyone used this browser and still been able to develop in Appian Designer? Thanks, </jason>

I have a requirement in which I need to create a webapi which will create users in appian.In webapi,we are providing the userid as an input and with that Id I need to invoke a processmodel which will create user in appian and add the user to respective groups.Iam a beginner to api ,so need  guidance for this.Appreciate if anyone can help on this.

we are using common application that having common objects and these objects are being used across 3 more applications.during deployment of other 3 applications, we are facing issues dependency on common application and as per the business requirementto reduce the dependency from common application what is the best approach and how we can remove the dependency.we are looking for a solution of this issue and wanted to understand the impact on it.Please suggest on this if any leads.

I am working on the creation of an API and using two approaches for doing the same thing, first code snippet includes the code which is working fine without any issue whereas if I try to minimize the code and by placing request creation in a different expression I get error error "The jsonText parameter was not valid JSON." a!localVariables( /*code throwing error*/ local!jsonRequest: a!fromJson(http!request.body), local!value: rule!ASQ_CreateRequestStructureForSfdc(jsonRequest:local!jsonRequest), a!writeRecords( records: local!value, onSuccess: a!httpResponse( statusCode: 200, headers: { a!httpHeader( name: "Content-Type", value: "application/json" ) }, body: a!toJson(fv!recordsUpdated) ), onError: a!httpResponse( statusCode: 500, headers: { a!httpHeader( name: "Content-Type", value: "application/json" ) }, bod

Hi team, Is there a way to submit with enter button of keyboard? Thanks in advance and regards.

Is there a way to delete all the instances of a sub process upon completion when called from a start process smart service node in a parent process ? We are facing performance issue of high memory usage in one of the process in our application. The current design is, there is a parent process where the list of not completed tasks are retrieved and a sub process node (configured as MNI) where the notification emails are sent to the task owners. In order to improve the performance we are planning to replace the synchronous sub process with a start process smart service. But the challenge we are facing is how to delete the sub process instances once it is completed? Since the child process is a common object used across other process in the application, we have the restriction of updating Automatic Process Clean-up 'Delete processes 7days after completion or cancellation' option in the Data Management setting. In other process of the application we need to retain the instance for

Now,I'm learning Appian Service Backed Record Types following Appian tutorial video and reference links. ・videowww.youtube.com/watch ・linkdocs.appian.com/.../Sync_Records_Smart_Service.htmldocs.appian.com/.../Sync_Records_Smart_Service.html I have implemented it as shown in the attached screen, but it is causing an infinite loop. If anyone knows, please provide the details of how to implement it correctly.

Hi Appian Community, I'm facing an issue where the email content is being sent with only partial text, and some parts of the HTML text are getting removed. Below is the HTML text I’m using for the email body: html Copy <p><span style="font-size: 10pt;">Dear colleagues,</span></p> <p style="text-align:start;"><span style=""><span windowtext="" 1.0pt;mso-border-alt:none="" 0in;padding:0in;mso-ansi-language:en-us'="" style="font-size: 10pt;"> </span></span><span style="font-size:10.0pt;"></span></p> <p style="text-align:start;"><span style=""><span windowtext="" 1.0pt;mso-border-alt:none="" '="" style="">Please note that the EU approval by CHMP Positive opinion has been granted on 05 December 2024 for </span><span

I am trying to import the newly released Case Management Studio application package, but getting below precedent missing error while inspection for most of the record types from package. The content [id= uuid=_a-0000e9ae-873e-8000-9baf-011c48011c48_97439] was not imported because a required precedent is missing: recordField [uuid=SYSTEM_RECORD_TYPE_USER_FIELD_username location=Expression Rule Definition] in record type [id=1 uuid=SYSTEM_RECORD_TYPE_USER] cannot be found. (APNX-1-4070-005) (APNX-1-4071-006) The username field is available in the User system record of the Appian environment where I am trying to import the application and it is upgraded to latest 24.1 version.There are other fields that are not available in the User system record and I am getting missing precedent error for those fields as well. Those fields are: SYSTEM_RECORD_TYPE_USER_FIELD_firstAndLastName, SYSTEM_RECORD_TYPE_USER_FIELD_isServiceAccount Attaching screenshots of fields available

Hi there,  We have a loop to constantly check an expression rule until it returns true. On each loop we have a 30 second timer to wait. All the other nodes were able to be setup to delete previously completed instances, but the timer node doesn't seem to have this option, which means the loop is breaking when it hits this node for the 1000th time. Is there any way around this? Thanks, John

I am experiencing issues across all my Record Types in Appian. Below are the details of the errors: When access any Record Type, I receive the following error: The data source cannot be reached or its configuration is invalid. Please contact your system administrator. There is an option to "Change Source Configuration," but upon accessing it, no modifications can be made and says: Editing the source of the record type will break all configured relationships.You do not have access to the configured data source. You can choose other data sources and tables, but you will not be able to select the original table again. When trying to access the Data Preview of the Record Types, another error appears: The System Has Encountered an Error HTTP Code: 500 APNX-1-4198-000 Error Evaluating UI Expression Expression evaluation error [evaluation ID = 2DENF]: Array is expected as second parameter, but received: . Additional Information: These errors seem t

Hi,I have a situation where I have 2 groups, one is an administrator group and the other is a basic user group.There is a basic user action to submit a comment and upon submitting, an email will be sent to the members of admin group and basic group.Now while a basic user adds comment and submit it, there is a process error which says - An error occurred while evaluating expression: =toemailaddress(  a!forEach( items: a!groupMembers( group: cons!HS_ADMIN_GROUP,      direct: true,      memberType: "USER"    ).data,    expression: user(fv!item, "email")  )) (Expression evaluation error at function a!groupMembers: Expression evaluation error at function 'a!groupMembers': Insufficient permission). FYI - Process model security --> Admin group - administrator access, Basic user group - Initiator access.Can someone help me fix this issue.Thanks in advance

Hi, When we give empty related record in place of ri!array in below code it should give me true as a result but instead it is giving false if( Â%A0 fn!isnull(ri!array), Â%A0 true(), Â%A0 length(ri!array) = 0 ) Here local!lrrfRec is the record and rgracslblLrrfSelectedCountries is the related record. We are passing this in place of ri!array. Please correct me if I'm missing something in the above code.

i have an editable grid and in single row i have checkbox and textfields, i need to make textfield readonly false based on selected option in checkbox in that particular row. Please let me know if any workaround available for this

Hello, I'm trying to generate document from XML code, I'm able to get the expected data if the data was single dictionary, but i have a requirement to generate document for a list of data items. I have already seen many of the community posts, I followed the same pattern to generate doc using xml code, but I'm getting an error, says that syntax error in template. Please let me know what i have done wrong here. ERROR: Syntax error in template "fr.opensagres.xdocreport.document.docx.DocxReport@3ad77c4f!word/document.xml" in line 4, column 1468:Encountered "\" \\b @before-row</w:t></w:r><w:r><w:rPr><w:noProof/></w:rPr><w:t>${d.@name}</w:t></w:r><w:r><w:rPr><w:noProof/></w:rPr><w:t>[/#list] \\b @after-row</w:t></w:r></w:p></w:tc><w:tc><w:tcPr><w:tcW w:w=\"", but was expecting pattern: <ID> I have shared the XML code and t

Hi All, Is there any way we can count the pages of the uploaded document? It can be PDF, Excel, Docx, etc.  I know the document viewer field has been provided by Appian, on the preview we only can display PDF. I am looking is there any way that we can show all format documents in new tab or can count the no of pages of the document. Thanks.

Hi,  When trying to convert the DOCX from the Template it is not retaining the Font Color while using DocX from dynamic template Smart Service. Below is the template Format with the Font ColorDoes anyone have the solution how to retain the Font Color

I´m starting the process for Debugging and it gets stucked in the Script Task, with the green box. I click refresh and it does not change anything, still the green box.  Please let me know if I can do anything else to fix it. Thanks in advance!

Hi Team, I want to give access to all users to comment and view on case summary page in workspace, However want only managers/Admin to act(complete) on the cases(Tasks).Please help me to achieve this functionality. Thanks in advance 

I am using Appian 24.3.  I saw Appian has AI test case generation feature and I want to take a try,  What I expected: What I actually got: Is there any setting I missed?