Discussion Categories

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?

I have a data type for a SQL view TOS_CMS_VW_ClergyTitleStatusTypeDSE.  It contains fields describing various clergy members.  I want Clergy Id and Clergy Full Name in a lookup on an interface.  ClergyID is an integer and ClergyFullName is a text field. I created a constant for the data type and I am not trying to create a expression to pull the two fields I want for the dropdown, ClergyID and ClergyFullName. a!queryEntity(  entity: cons!TOS_CMS_VW_ClergyTitleStatusTypeDSE,  query: a!query(    selection: {      a!querySelection(columns: a!queryColumn(cons!TOS_CMS_VW_ClergyTitleStatusTypeDSE.clergyId)),      a!qyerySelection(columns: a!queryColumn(cons!TOS_CMS_VW_ClergyTitleStatusTypeDSE.clergyfullname))    },    pagingInfo: a!pagingInfo(      startIndex: 1,      batchSize: 500,      sort: a!sortInfo(        field: cons!TOS_CMS_VW_Cle

i have date column in database  it holds the values like  01/02/2024 06:29 GMT+00:00 17/03/2023 17:59 GMT+00:00 but i have to fetch only date which is equal to today date how can i achieve that

When we use Builders in interface , It will create Interface with rule inputs of given CDT or RecordType , I'm really curious to know how they creating variables dynamically(My guess is that they are running some java code in background) . As far as i know we can't create rule inputs dynamically ,If not correct me. Is there a way to create rule inputs of desired type dynamically??. I created a replica of Builders using functions like keys and runtimetypeof(), But i used local variables in value and saveinto parameters. I want to replace it with proper rule inputs.

Hi Good AfternoonIs there a way we can use a card as button to navigate to a page like we do on the desktop with a!safeLink().The link it self will probably open a browser in the mobile, but I want to redirect inside the mobile app.

Hello everyone, I need a bit of help for an accessibility task in Appian. I require a parameter that identifies an element as a <nav> tag and an Aria-label type parameter when viewing the code of the 'Site' in the HTML console. I've tried with parameters like 'accessibilitytext' and 'helptooltip' but it translates to <div> and without that essential parameter, 'Aria-label.' How can I achieve this?

Hi! I was trying to pass a local variable values (editable grid in which you can add several rows) to a process model, so that I can use the Write Records Smart Service At first, I did it this way: But I would like to know how to transfer this and save into my record (probably best way via process model) The entire code is: a!localVariables( local!grid, { a!sectionLayout( label: "LÃ%ADneas Factura", labelIcon: "list-alt-solid", contents: { a!gridLayout( label: "A continuación, incorpore las lÃ%ADneas de factura correspondientes y pulse el botón de creación", headerCells: { a!gridLayoutHeaderCell(label: "Factura"), a!gridLayoutHeaderCell(label: "Pedido"), a!gridLayoutHeaderCell(label: "Proveedor"), a!gridLayoutHeaderCell(label: "Material"), a!gridLayoutHeaderCell(label: "Precio Unitario"), a!gridLayoutHeaderCell(label: "Cantidad"), a!gridLayoutH

Hi, I have a requirement to create a dynamic table in pdf , now i am using plugins DOCX from Dynamic table  for this how to create rule can anyone suggest, thanks

Hi all, Is there a way or a plug-in that allow us to expose some appian functions? Let me explain the scenario: We have an application that is highly configurable, at some point we need to give a group of more experienced users the ability to be able to assign certain values to certain fields, besides being able to assign static values "1", "2", "3", "TEST", "EXAMPLE","OK" ,etc (for say something), we want to give them the ability to use functions to calculate differently the values using functios like Sum(), AVG(), etc. or for calculations with dates AddDays(X), today(), etc. Is there any way to expose those functions that we use in SAIL in some way to the end user? Thanks in advance for your help

A cancel button has to save one rule input and one local variable value. If we click on the button once only the rule input changes but the local saving happens only after 2 nd click. If we remove the rule input then it is working. But we need both ri and lccal variable to save its respective values at the first click of button. PFA for the code snippet. Help me on the solution a!buttonWidget( label: cons!PHSREC_BTN_LBL_CANCEL, style: "NORMAL", value: 3, saveInto: { local!currentPage, a!save(ri!buttonAction,cons!PHSREC_BUTTON_ACTION[6]) }, validate: false, showWhen: local!currentPage = 1 ),