General

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?

I have a table with a legacy identifier and a current identifier. I want to query the table, by first check the current identifier for a match, then fall back to the legacy one. Is there a good way to do this with Appian queries? I cant really do what i want with or and and logical expressions.

I have the below mentioned throwing the mismatch error. pls guide a!forEach( items: ri!Addresslist, expression: reduce( a!update, fv!item, merge( { "AddressId", "ReferenceId", "Type", "CreateBy", "CreateDate" }, { if( fv!item.AddressId = ri!primarykey, null, fv!item.AddressId ), ri!Dependent[fv!index].AppianUserId, "Permanent Home Address", loggedInUser(), a!defaultValue(fv!item.CreateDate, now()) } ) )) Expression evaluation error at function a!forEach: Error in a!forEach() expression during iteration 4: Expression evaluation error at function 'merge' parameter 2 [line 14]: Invalid index (4) for list: valid range is 1..3

Got 'Appian was not able to authenticate with the API Key provided' error when call an integration, but the api works fine in postman with same url and headers what could be the cause?

Hi team, Is there any possibility to export CDT data to a multi sheet excel, without erasing the formulas given in the excel template? i have configured some dropdowns and data validations in excel. when i try to upload using smart service i can able to export data to excel in multiple sheets but the dropdowns and formulas defined are gone. I can understand this is how it works. But is there any other way like to use external services with appian to achieve this result? Any help will be really appreciated. Thanks in advance. 

Hi guys I've gone and entered data fields into the All Case Types setup rather than in just my own case type. No actual data has yet been entered into any of the other case types and (thankfully) this is in ou Dev environment.I know the names of the tables that have been created and can access them in the cloud database. If I simply delete the tables and sync the record types, will this fix the issue? Failing that, if I go into each record type, remove the relationships and then sync, would that work? Is there a way to delete and/or edit fields from within the Case Management app without hacking the system? I need an urgent response to this please.Thanks and blessings Stephen

Hello, We are using the send File Over SFTP node and we have a doubt if we set the following attribute to true, would it take the user and the pass defined in the third party? We do not have a private key. We ask this question and we do not test it directly because in the development environment we cannot and we have to promote the environment to be able to test it but not to go up blindly, if someone had fought with this it would be of great help. A greeting and thanks in advance

I have an integration that calls an api which downloads document from external system. How can I implement a link that user can one click download the document that is returned from that api? like documentDownloadLink(), but I guess it can only be used for downloading documents that are stored in Appian? My requirement is that user don't want Appian to store the documents copy, so I can only call the api to get the document

Document preview field not giving the document preview, showing the following error. By clicking one the link in the error the document can be downloaded successfully. How can this be fixed

Hi All,We want to know how Appian licensing works. Lets say the current license is for 3 applications and 50 users. So what happens if we have built more than 3 applications and onboard more than 50 users. Also what does this 50 users mean?? Does it mean number of users who can access appian concurrently or only 50 users can be onboarded? Does onboarding more users/applications cause any performance issue to the overall application?

Dear Appian Community,Working on the Step-by-Step # 5 exercises, after have completed the Edit Record List section, I saw the image displayed for all records was the generic image, I opened the Cloud DB and confirmed the Image column in table AA Vehicle is Null. Could you please let me know how can I fix this issue? Maybe running a script to load the content of the table again or something like that. Any help would be greatly appreciated.Thanks in advance,Jose Castellot

Map mailList of Text String - 3 items "test@gmail.com:1"(Text) "test2@gmail.com:3"(Text) "test3@gmail.com:3"(Text) period"01/2024"(Text) Map mail "test4@gmail.com:4"(Text) period"01/2024"(Text) above is the result of expression rule i want to remove mail  and make value like test@gmail.com as key and numbers that are after : as value  and leave period as is  Map "test@gmail.com:1"(Text) "test@gmail.com:1"(Text) "test@gmail.com:1"(Text) period"01/2024"(Text) can i get result as this 

In what scenario i can go for MNI?how to configure it??could anyone help me out on understanding it clearly.

I have changed authentication type to OpenID connect  in Connected system. when I'm trying to deploy it to other environment I don't see any keys to change in Property file .Can someone please help .can I deploy it directly without property file?

I am trying to understand when the appian save data type should be used, reading the documentation I do not see a clear example of use. Can someone tell me if they use it and when? This is the associated documentation https://docs.appian.com/suite/help/24.4/using_interfaces_in_appian.html#creating-reusable-custom-components docs.appian.com/.../Appian_Data_Types.html

i have this query to run in database table to export some data,but its throwing an error like this: #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'LIMIT 0, 25' at line 45 below is the query: SELECT DISTINCT ITS_MATTER_NUMBER, REQUEST_DATE, REQUEST_TYPE, REQUEST_STATUS, CUSTODIAN_NAME, CUSTODIAN_WWID, JNJ_MATTER_NAME, JNJ_MATTER_NUMBER, COLLECTION_VENDOR, RECEIVER FROM ( SELECT DISTINCT ITS_MATTER_NO AS ITS_MATTER_NUMBER, TO_CHAR(CREATE_DATE,'MM/DD/YYYY') AS REQUEST_DATE, REQUEST_TYPE, CFA_DM_ED_REQUEST_HDR.STATUS AS REQUEST_STATUS, CUSTODIAN_NAME, CUSTODIAN_WWID, JNJ_MATTER_NAME, JNJ_MATTER_NO AS JNJ_MATTER_NUMBER, CFA_DM_ED_COLL_VENDOR.COMPANY AS COLLECTION_VENDOR, CFA_DM_ED_PROD_RECEIVER.COMPANY AS RECEIVER FROM CFA_DM_ED_REQUEST_HDR LEFT OUTER JOIN CFA_DM_ED_PROD_RECEIVER ON CFA_DM_ED_REQUEST_HDR.REQUEST_ID = CFA_DM_ED_PROD_RECEIVER.REQUEST_ID_FK LEFT OUTER JOIN CFA_DM_ED_COL

Appian Community Team, I have a Site which 5 Interfaces in it. Please see below screenshot for reference. If I want to add KPI, where should I add it? Is it to all individual interfaces or should that be added onto the Site Page? If its on the Site page, can you guide me here please. I am new to Appian and I am open for suggestions here. Regards, Mahesh

Appian Community Team, On the Appian Home Page, I see Reports in the Menu. Can you please fill me in with details on what that is for? How I can have some of my Site Reports appear under Home Page Reports Section? I am new to Appian, I have developed a Report in Interface using PieChartField, can I have that Interface appear under Home Page Reports Section? I have provided screenshot for what I am referring to on the Home Page. Regards, Mahesh

I'm having an issue where the browser data loss popup shows up when I click on a a!safelink from a form. The link is configured to open a mailto window in a new tab, so no data loss should be occurring. I'm wondering if there is a way to disable this popup somehow, my assumption is no, but I wanted to check here and see if anyone had any suggestions.

Just a question regarding the exact location and order that variable data is saved in.  I have noticed that saving a variable in a child interface that was passed into it as a rule input also changes the related local variable in the parent interface, which is normal functionality that is explained in several tutorials.  However I also noticed that saving a set of identical SAIL code into a local variable and then changing another local variable results in no change.  For example if a dropdown option like this were selected it immediately resets the variable, local!madeFromCDT, back to the default:local!madeFromCDT: cast( typeof(type!("arbitraryType"), {abitraryField: null}))), local!sailInterfaceDropdown: a!sideBySideLayout(     item: rule!nestedDropdownfield(          choiceLabels: local!listOfYesNo          choiceValues: local!listOfYesNo     &n