Discussion Categories

How I can improve the performance if there is long java work queue in engine performance log. Which one I have to do whether I have to increase application server or increase Ram. Which one is correct?

We are creating new Appian tables in a schema with a large amount of data (approximately 45 million) from Oracle DB. We are experiencing significant delays when connecting to the data source and configuring the record type. After selecting the data source, it takes approximately 4 minutes to load all of the tables in the schema, which I believe is unnecessary. We occasionally get a timeout error. Both the search and browse features work the same when selecting the source. Even if we can select the table and sync it, it takes a long time to switch between the record type tabs during development. Every button click takes some time. I appreciate any suggestions you may have.

Here is a very rough ERD: Each case has many subcases; each subcase deals with a software and each software has a status  I have a Rule Input "dcmCaseID" that is populated with the parentCaseID for the Case entity.When the query is run, I get data for all the subcases that are linked to the case ID The query looks something like this:a!queryEntity( entity: cons!DSE_SUBCASE, query: a!query( logicalExpression: a!queryLogicalExpression( operator: "AND", filters: { a!queryFilter( field: "case.parentID", operator: "=", value: ri!dcmCaseID ) }, ignoreFiltersWithEmptyValues: false ), pagingInfo: a!pagingInfo(startIndex: 1, batchSize: - 1) ), fetchTotalCount: false ).data, I need to modify the query to return only subcases where the software statusID is null. Using a queryRecordType either breaks the process completely, or returns no subcases at all. Any help will be greatly appreciated! Blessings Stephen

In my current project I need to make a element button integrated in a interactive grid visible for screen readers and if it this posible get this code in HTML: " aria-label=”Delete” And, if this action is not posible, what recomends to use in te grid to eliminate an element? Thank you

Hi! I'm trying to achieve this HTML structure in appian text field: <label class="" for="un">Name</label> The main request to get it: The screen readers must be able to read the text into the text (placeholder aren't visible in their opinion) Many thanks!

I'm trying to add a section to your interface that will only display when the user selectsa maintenance request, and will display details for the selected request by repurposing anexisting interface object & this is the code. I'm getting syntax error mentioning "Expression evaluation error at function a!localVariables parameter 3 [line 63]: Invalid list operator 'a!sectionlayout' (expecting comma)" but all Parentheses are closed properly & commas were added as per syntax. How can I fix this ?

Hi , I am getting this error while invoking a related record action ,which is not giving any info what could be the issue. Has anyone faced the same issue before, is there any way to trace it?

Hi All, How can we compare two text values for example "batting" is text1 and "bat" is text2 if batting compare with bat then it should write True. because bat word is there in batting word Is there any logic for this ?

Hi Team, What data type should be used if I want to store the data like this id,users 1, user1 2, user1; {user2,user3} 3, user1; {user2,user3}; user4 Operations: We can remove the users from list input: id, username -> 2,user1 output: 2,{user2, user3} input: id, username -> 3,user3 output: 3, user1; {user2}; user4

If there is a change of DB, how can we deploy the changes made in DB in the deployment stage

HII, I am getting an error when executing PM like :The entity name must immediately follow the '&' in the entity reference. i am using docx from dynamic template plugins[View:/cfs-file/__key/communityserver-discussions-components-files/62/DocTemplate.docx:320:240] I have attached my doc template  and code if( a!isNullOrEmpty(ri!appId), {}, a!localVariables( local!application: rule!GAI_getApplication(applicationId: ri!appId).data, local!fiscalYear1: local!application['recordType!{5f640b2a-afca-4569-92d3-9e2938c52816}GAI Application.relationships.{abdf1474-5557-4307-87ca-cebf6144aab0}gaiOpportunity.fields.{8140c1d1-fe02-45b1-b6bc-53f76502fad9}fiscalYear'] - 1, local!fiscalYear2: local!application['recordType!{5f640b2a-afca-4569-92d3-9e2938c52816}GAI Application.relationships.{abdf1474-5557-4307-87ca-cebf6144aab0}gaiOpportunity.fields.{8140c1d1-fe02-45b1-b6bc-53f76502fad9}fiscalYear'] - 2, local!fiscalYear3: local!application['recordType!{5f640b2a-af

i am trying to update constant with same data type. it shows below error com.appiancorp.suiteapi.knowledge.Community cannot be cast to com.appiancorp.suiteapi.rules.Constant can you provide me the format for updating a constant using screenshots can anyone provide the solution please

Hi! I have created an interface which allows the user to create PO Lines (shown below). The information is saved in a Record Type ("CPF Lineas Pedido"): Additionally, I have a previous interface in which the user fills "global" or "header" PO fields, like the id, supplier, total price, etc. This values are saved in a different record ("CPF Pedidos") In my site, the user can see the record list of CPF Pedidos (the basic fields). And, when they click in one of the PO, a summary view appears with the information of the PO Lines. In order to do this, I added to the summary view a read-only grid, filtering by PO. Now, I would like to bill each PO. For this, I created a related record action "Facturar Pedido", which initiates a process model and has another two interfaces: 1) Interface 1: Header fields of the invoice. The fields of the PO such as the PO identifier, supplier... must appear automatically (extracted from the PO information/ rec

Hi all, I wanted to know about the best option for a query in static data on database. which would be the most optimal performance: "queryRecordType" or "queryEntity"?

Hi there, could anyone know when configure the "Export Data Store Entity to Excel"/"Export CDT to Excel" smart service, "Save in Folder" can only be set as the folders in Appian platform. Is it possible to export to the application user's local computer? Best regards, Lin

I'm working on a module called Query your Data. It's asking for hands on practice. Generate a Record Type Selection Query. It asks me the following: But the Query Your Data App is not available on the Appian Designer page. What can I do about this or did I miss buliding that somewhere along the way?  Numbered divider  Generate a Record Type Selection Query For this exercise, imagine you are an Acme Auto developer. You need to create a query that returns a list of vehicles. That list must include all Vehicle record fields and the cost field from the Maintenance record type. The query should only show the data property. In your Appian Community Edition environment, navigate to your Query Your Data application. Since you're creating a selection query, you will use the query editor to generate this query. Complete the following tasks and check them off when complete. Review the Check Your Work section when done or if you get stuck.

I am attempting to connect to my RDS Postgresql database and cannot get that connection working through Connected Systems. There is mention of opening a support case and having a driver created but whenever I use the Open Case button I get a 401 error. I haven't seen this mentioned, but is that not an option for the community edition? If that is the case, is my only real recourse to import the data to the appian database?

Hi all, I currently have a process model that uses a HTML template to send a list of users, but since my list is saved in a process variable it eliminates any breaks between the names of the users. Write now when I sent the email the list looks like this: name1; name 2; name3; name 4; name5; and so on. But I would like to display the list in a vertical format so is easier to read for the person who is receiving the email. I have tried an expression, scripthml, but nothing seems to work. Does anyone know how can I over come this? maybe editing the template? but I dont think appian lets you iterate over a HTML template.

Hello, I'm preparing to take a certification exam, and I'm struggling to find a use case that would help me better understand functions reduce() and merge(). Can you help a brother out?

Hi! I made a request one day ago in order to recover my appian site. When I enter in appian community, I see the following information; When I click the "Check status" button, nothing happens. I received a no reply email which said that there would be a delay in my request, but I would like to ask how much time will pass until I can recover my site (or what is the "standard" amount of time), and how can I follow the status of my request. Thanks a lot!

How to write expression rule  and word template if i have a requirement to generate dynamic table in pdf i am using docx from dynamic template and doc to pdf plugins i have to generate two dynamic column  1.Documents 2.Description  THANKS

Hi All,  What is the best practice/Appian recommended naming convention for database tables and fields? Previously the database table created by Appian were all lowercase, now in latest version, all (tables and fields) in upper cases. Is there any reason they changed it to upper case? For most databases, recommended naming convention in stored procedure is to keep the key words as upper case and fields in camel case/pascal case and table name in pascal case Please let's know your thoughts/recommendations. SG

When we create a new Record Type, Appian automatically generates a SQL script that can be run (either automatically or manually) to create the database table. It always uses UPPERCASE for both the table and field names. My question: is there a default setting somewhere that can be overridden so Appian instead uses lowercase names for tables and fields when generating the SQL script for us?

Hi All, Is there any way to get the logged-in user's  Site URL? We are using multiple sites in my application and I Just to confirm which Site user is currently logged In. Thanks in Adavance. Regards,

Hi, I am using doc extraction smart service by AI skill to extract the data from pdf , I have multiple files to extract and reconcile . Is there any way to assign all reconcilation tasks in a singel node?