Discussion Categories

Tried using the Log Reader Plugin but it does not read logs from all servers. Any suggestion is appreciated. Thanks 

Hi everyone, I need to build a team dashboard for managers and directors, where the team data is stored in a single record type. This data includes fields like username, personal number, manager's personal number, and email ID. I’m currently passing the email ID to fetch the personal number of a user, and then using that personal number to find the manager's personal number in order to get a list of employees under that manager. This process is repeated for up to five levels, as directors report to managers and each manager can have multiple employees under them. However, after implementing this approach, the performance of the UI has slowed down significantly. Can anyone suggest a more efficient alternative to improve the performance while maintaining the same functionality?  Below is the code for your reference. 

Hello Everyone, I need to build a team dashboard for managers and directors, where the team data is stored in a single record type. This data includes fields like username, personal number, manager's personal number, and email ID. I’m currently passing the email ID to fetch the personal number of a user, and then using that personal number to find the manager's personal number in order to get a list of employees under that manager. This process is repeated for up to five levels, as directors report to managers and each manager can have multiple employees under them. However, after implementing this approach, the performance of the UI has slowed down significantly. Can anyone suggest a more efficient alternative to improve the performance while maintaining the same functionality? Below is the code for your reference.

Hi Everyone, We have a editable grid with dropdown fields, second drop down(Evidence category) choice values purely dependent on first dropdown (Therapeutic area) selected value.I have configured the code like this but getting the above error. Can you please help me a!sectionLayout( label: "", contents: { a!gridLayout( label: "", labelPosition: "ABOVE", headerCells: { a!gridLayoutHeaderCell(label: "Therapeutic Area"), a!gridLayoutHeaderCell(label: "Disease State"), a!gridLayoutHeaderCell(label: "Evidence Category"), a!gridLayoutHeaderCell(label: "Evidence Need"), a!gridLayoutHeaderCell(label: "Priority"), a!gridLayoutHeaderCell(label: "IEP Code"),

Hi Everyone, We have a editable grid where we placed 2 drop down values. Second dropdown choice values and choice labels purely dependent on first drop down selected value.But we are getting the error. a!dropdownField( Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0 label: "Therapeutic Area", Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0 placeholder: "---Please Select---", Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0 choiceLabels: index(local!therapeuticArea, "name", {}), Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0 choiceValues: index( Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A0Â%A

Hi Appian Community, we have one application for which development is completed and planning to migrate it to new UAT instances,  Already have created many records configuring data source in admin console by name like "jdbc/ApnDev001" have plan to create new data source with the name of "jdbc/Appname" in new UAT instance,  while doing to observed that we need to change data source for existing records causing field UUID get changed, and this leads to huge changes at application level wherever we have used these records. Is there any way we could fix this issue (rename or create new data source) without major changes. any form of guidance would be welcomed, Please help.     Thanks,  Shree Krishna tiwari    

Hi Team, I have written query record type with filters to get the records which are reviewed one year back. Filtering based on field "reviewedOn".Currently when i am testing this rule, getting records those have "reviewedOn" is null. How to eliminate these records which have "reviewedOn" is null.Attached Query and output for your reference:Please suggest if any solution available to fix this.a!localVariables( local!lastOneYearReviewedAttestations: index( a!queryRecordType( recordType: 'recordType!{7e2fbae0-0b6b-4c59-9981-8ea4fef6165c}Attestation', filters: a!queryLogicalExpression( operator: "AND", filters: { a!queryFilter( field: 'recordType!{7e2fbae0-0b6b-4c59-9981-8ea4fef6165c}Attestation.fields.{9cc9f1c8-8b6c-4200-94d0-b992949d4303}reviewedOn', operator: "not null" ), a!queryFilter( field: 'recordType!{7e2fbae0-0b6b-4c59-9981-8ea4fef6165c}Attestatio

Hi All,We have an application which will receive various details from an external system including primary keys for documents which are used for retrieving documents from another system. We receive these details via an API and a task is created for the user to process the same. When the task is being processed by the user, the external system might update the data again which includes adding or removing documents. Since the task is opened by the user, he will never know whether some update has happened to the task or not. We thought of using some refresh variable but it does not seem to be a viable solution. Also it might lead to performance issues since the number of users and number of tasks will be high. Is there any way to handle real time updates and show them in UI?? Any suggestions would be helpful 

hello I'm new to Appian and i have a task to generate a pdf from word template i used DOCX From Dynamic Template smart service then PDF From DOCX i checked every thing but the document isn't generated i will attach the xml code and the word template [View:/cfs-file/__key/communityserver-discussions-components-files/62/Stationery-Request-templete-test.docx:320:240]   here is the xml generated  <orders><createdBy>sliman.izz</createdBy><createdOn>4/7/2025 3:50 PM GMT+02:00</createdOn><items><orderDetails itemName='test' itemCode='54' requestedQuantity='100' receivedQuantity='50' notes='not done' /><orderDetails itemName='test' itemCode='45' requestedQuantity='20' receivedQuantity='10' notes='not done' /><orderDetails itemName='test' itemCode='85' requestedQuantity='50' receivedQuantity='50' note

1. Synchronous Start Process - Here, documentation says, we get the output of the process variable from child process to the parent process. 2. Activity chaining in Sync start process - Here the documentation says, Chaining through a synchronous Start Process node means the original process will wait for other process to complete before continuing. Any activity chaining in the started process is not connected to the original process, so a broken chain will not return process variables to the original process. process variable will be returned to the parent process or not?. Please clarify 3. start synchronous process using start process vs sub-process As per this, if the parent child relationship isn't followed, how we are able to get the output variable as mentioned in point 1 documentation? If the Activity chaining in the parent and child are independent, why does the parent process waits for the child to complete? As per point 2, it s

In new 24.4 we have Synchronous and Asynchronous option for Start Process smart service . Then what's the difference between Subprocess Synchronous and Asynchronous things ?

Hi Everyone, I am handling the task assignment through database tables. But when two users will click simultaneouly on the link which will start the process model. How to ensure that only one user should be given the task.

Hi Team,I have One Requirement that isi want to display data in read-only grid from records and that data i want to download in CSV Format also if i want to upload new data i want to upload in CSV format,if it is possible please help me with it,those import and export options i have to display in buttons.

We have a form with multiple collapsible sections, and in some of these we also have subsections. When user clicks on submit, there might be errors in the subsections that are not visible to the user because the parent section does not have the "This section contains errors" warning. I've come to discover that it's because other subsections don't have any errors. Here's an example where this happens: Here both the parent and child show that there are validation erros. The moment I add a section without validation errors, the warning disappears on the parent:   I feel like this should not be the standard behavior and is something Appian should fix on their end. The only workaround I can think of is to have validations at section level, on the parent section. But that would display a red message box on the section that for me is not desirable. Any help here is appreciated.

Hi All, There is a requirement to a get document from the third party system, Can someone suggest a way what is the best way to get the document from the third party system? Below is the implementation that I know, Apart from these any plugins or any other things? 1. Third party systems will return url where the file is located. As soon as user clicks the document can be downloaded into the local system. 2. Thir party systems will return the document in binary format and Integration can convert binary to document from the respsonse.   Apart from this Do we have any other way to get the document from the third party systems? My Next question is  If other systems want to post a document into appian, how exactly web appi will configure it, how the request hader document format will be? Thanks in Advance!

Hi, In our Application, we read an email box and for each email - we should check if it has any attachments and uncompress them. We have a requirement from business to uncompress zip, eml, msg, rar files upto 3 levels in depth and extract data and attachments. Is there a plug-in to achieve this? Any help here would be appreciated. Thanks, Keerthi

Well, how am I supposed to reference the properties of this query in another process model? It is a dictionary, however I cannot reference a dictionary in a process model, so would it be supposed to convert the query to a map or what? By the way, it contains some wierd properties like c0, c1, c2...dp0, dp1, dp2... How could I cast this dictionary into a map then? Thanks in advance

I'm currently exploring all the possible ways to insert record in a record type (for e.g. StudentDetails is my Record Type) but I have String fields as process variables. one way I know is (i) Gave Input Variable of StudentDetails type and in Script task Output  mapped the values from process variables  and used write records.

Hi Everyone, Is there any smartservice or utility in appian to convert docx files to pdf ?

Consider a scenario where we have two entities: Books and Chapters, with a one-to-many relationship (i.e., each book can have multiple chapters). I currently have a read-only grid that displays records based on the Book entity. One of the columns in this grid is called "Chapters", which displays all associated chapters in a bulleted list. Since a book can have more than 10 chapters, I'm currently fetching all chapters into a local variable and indexing them based on the Book ID to display in the corresponding grid row. This approach works fine for now. However, I'm concerned about performance if the chapter count increases more than 5000 Does anyone have suggestions on how to handle this scenario more efficiently?

Team, want to check on these 2 aspects, which we are attempting to leverage in our Appian solution implementation.   1) We are building a solution to retrieve specific data using XPATH from an XML and mapping it to a target location.                 We will be using the "xpathdocument" function in Appian to fetch the value from XML.   2) We will also be leveraging the below function to obtain our XML. i) Convert the json data we have into an Appian object ii) Then convert the Appian object into XML.   --- something like this ---   local!apoPbj: a!fromJson(ri!ipJson)   local!xmlObj: toxml(local!apoPbj, true, "xml") --- something like this ---   3) Data will be fetched from XML using the 'xpathdocument' method as we mentioned above.   This looks working good when tested. Question: 1) But I see currently "xpathdocument" method supports only

Hi all, We have a requirement to have custom fonts on specific interfaces... I read through the documentation and understand that this is not an OOTB feature. Admin console typeface will also not solve this issue as the fonts will be applied across all applications and cannot be referenced in specific components. How can we add custom fonts to specific interface components? Is this able to be done via a plug-in or some other means?

Hi All, we have Content Tools plug in version of 1.11.1 in that we are using function called generateuuid() in our application but recently content tool upgraded with new version of 1.3.0 in that generateuuid() function is not available. could you please suggest any one have alternative functions for this.   Thanks!

Hi, I have a task with a requirement for a robot to be able to skip captchas. I have installed Chrome extensions for the bot to skip captchas, but that extension does not work on some types of captchas, as it does not skip text captchas and requires that text to be typed correctly. I have tried to follow the image recognition steps taking into account the calculator's number recognition practice (Tutorial: Use Image Recognition (RPA)), but it fails me as it is not able to recognize it. Could someone help me or can you think of another alternative regarding bypassing captchas?Thank you very much.

Hi All, We are getting below error in tomcat logs but unable to find out the root cause since process ID is not there. Please suggest how we can rectify this? ERROR com.appiancorp.storedprocedure.fn.ExecuteStoredProcedureFunction - Error executing stored procedure for data source [jdbc/businessds] com.appiancorp.storedprocedure.exceptions.MissingInputsException Thanks, Amita