Discussion Categories

I have built an expression rule where I am using a!foreach() and looping through items. Below is the query. a!localVariables( local!var: a!queryRecordType( recordType: 'recordType!rec_type1, pagingInfo: a!pagingInfo(1, 10) ), a!forEach( items: { local!var}.data,  //4 data items from the record type table are that it can iterate on// expression: fv!item['recordType!rectype1.fields.col1'] [1] )) The record type I am querying here has 4 items that I am iterating in using a!foreach(). Now expression gives a single output (specific cell's data from table i.e. first record's col1 value). My expectation was that this would give same table cell data as output but 4 times instead of 1 time. Is it due to the fact that in every iteration fv!item moves to the subsequent item as current array item and therefore cannot give that cell's data as output remaining 3 times since it has already moved ahead to next item.Let me know if I am thinking correctly or is there

Hello, I am trying to set up a data source / connected system in my Community Edition Site. I am running a MySQL Server instance on localhost:3306, but my connection test fails. Am I even doing this right? The username and password are correct, and My SQL says the server is running: Do I have to host the server online to be able to connect? No technical background here, but I'm trying to get it. I would appreciate your help!

Above is what my substitution keys look like. Below is what I am seeing in the PM designer for each key. Some of the keys do appear normally. Below is for the key poss. I have keys which are not underlined that are producing the same behavior. This word document was provided to me by the client. It is a paper form that customers would fill out by hand. p oss Any idea what the issue is? Can anyone reproduce this? I could send a portion of the document to anyone interested.

Hello All, I have a scenario where we are receiving file in one of the path of Appian On-premises Server (Linux). e.g path : /temp/data/file.xlsx or /temp/data/file.txtWe want to read that file from Appian instance (UI) installed on same server. Can any one suggest how I can achieve same. Regards, Vijay

Greetings, I am looking to utilize the Log Reader plugin to read the login-audit.csv files in logs. I noticed the function returns the structure CsvContents, but it is treating my first row as a header when there is none. How do I go about making it so that the first row will be part of the rest of the rows and not as a header?

Hi Experts I have a DB Script in which a column have the French language data(Conversion of English fields name). I import the script but after importing the data, the data is not correct as It is giving question mark(?) for few letters in the French word. Example: complète ( French Word ) ---------> compl?te (After import is complete). I used every default setting such as UTF-8. If is there any solution then tell me in steps Thanks in advance. 

I have updated parent CDT(UK_AWTS_Requests) to add 2 new fields. While creating new version using xsd, I was getting below Info warning for one of the child CDT(UK_AWTS_REF_STATUS) present in it. I ignored above , created new CDT and promoted to Runway. However in Runway all the dependent objects are still referring to older version of CDT. Also all dependent objects are showing ^8 special character. Can somebody tell me what needs to be done in this case.

here am using record to display the grid along for that grid need to add the filters  a!localVariables( { a!gridField( labelPosition: "ABOVE", data: 'recordType!{81e1435a-de76-4bff-8b85-6ae5a581d036}Documentation Checklist', columns: { a!gridColumn( label: "CIF", value: tointeger( fv!row['recordType!{81e1435a-de76-4bff-8b85-6ae5a581d036}Documentation Checklist.fields.{cif_int}cif_int'] ), align: "START", width: "NARROW" ), a!gridColumn( label: "Customer Name", value: fv!row['recordType!{81e1435a-de76-4bff-8b85-6ae5a581d036}Documentation Checklist.fields.{customerName_txt}customerName_txt'], align: "START", width: "1X" ), a!gridColumn( label: "Source", value: a!linkField( links: a!recordLink( label: if( rule!APN_isBlank( fv!row['recordType!

am trying to create read only grid using record type but am getting this error, record type is updated only  

I upload multiple PDF files in the interface. I want to save the files in a folder that matches the name of each PDF file.

Is it possible to direct flow from Write to DSE Smart Service on error?  Ideal scenario would have the DSE node fail, and based on error, flow would continue to different node.  Right now process pauses when DSE fails and email goes out. Is it possible to continue process flow on DSE fail?

Hi, we need to create an integration with JMS on Cloud, being able to send messages to an external JMS Queue or Topic, and starting processes with a receive Message Event This can be easily done in a OnPremise Installation, but according to the documentation, this is not supported on cloud, but most of the cases can be achieved with a plugin from the market, but in the market we only find two old smart services that are only supported in previous appian versions. How can we achieve this requirement if we are working in an on Cloud instance? Regards

Hi, I have a set of Integration object that uses a Connection System (OAuth2: Client Credential Grant).I am testing direct on the Integration object with blank attributes:1. If it use connected system and the API returns 404 (i.e. user not found), the API will always fired twice (not expected). Below are the debug logs:2. If it use connected system and the API returns 200, the API will only fired once (expected). 3. if I remove the connected system and the API returns 404, then it will only fired once (expected).  2023-10-26 07:26:14,981 - { "origin" : "local", "type" : "request", "correlation" : "d782eed85047a462", "protocol" : "HTTP/1.1", "remote" : "localhost", "method" : "POST", "uri" : "https://example.com/path/to/service/07?test=001", "host" : "example.com", "path" : "/path/to/service/07", "scheme" : "https", "port" : null, "headers" : { "Authorization" : [ "XXX" ], "Content-Type" : [ "text/plain; charset=UTF-8" ] },

Hi, Please help me out to populate date and time in fitnesse script |set test variable|start_date             |with|10/13/2023 02:30| |populate field |Start Date|with|tv!start_date| Thanks

Hi  i have a requirement to show only unique index value while using for each how can i do that ? in local!voucher Details have 4 item that is duplicate i need only unique value

Hi all, I need to validate that in a texfield, the user on type characters, I mean (100k, 80k, ect), numbers with text values. if the user enters 10k,20k like in textfield, I have show some validation message,How could I achieve this, is there a special functions? Can anyone help me please on priority?

I have a requirement to add a new field, contained in a record, to an existing process report. In an interface a gridField with filters is used for displaying the task data, but cannot find a way to get this data in a way that makes it available for both new and previously started active processes. Process Report is tasks per process model Process Report is tasks per process model Process uses Records for data management () Requirement to get additional data from the Process into the Process Report Additional data is a value found in the Record Process reports cannot index Records Less than ideal solution has been to add process variables for any data point needed from the record These single data point process variables can then be seen in the process report Process report is displayed in an interface using a a!gridField() Data for the gridField is pulled using a!queryProcessAnalytics() a!queryProcessAnalytics() uses logicalExpressions in an a!query() to filter data Query filters

I have a Process Model which is Called from Web API via Start Process. a!startProcess( processModel: cons!MA_WRITE_TO_DB, processParameters: { getData: local!getData, } onSuccess: a!httpResponse( statusCode: 200, body: a!toJson( { a!map( value: fv!processInfo.pv.value ) } ) ), ) I need to return value from Process Model(so we have used Activity chaining in PM), but due to  Activity chaining its taking too much time.  Is there any alternative way(without Activity Chaining) how i can return the value from PM so that it takes less time

Please let us know if we can get the 'confidence level for Document extraction' similar to the confidence score output for Document classification.

a!gridLayout( emptyGridMessage: "No Claims assigned", headerCells: { a!gridLayoutHeaderCell(label: "Dietary Ingredient"), a!gridLayoutHeaderCell(label: "Claim"), a!gridLayoutHeaderCell(label: "Decision"), a!gridLayoutHeaderCell(label: "Category"), /*a!gridLayoutHeaderCell(label: "Updated Cat"),*/ a!gridLayoutHeaderCell(label: "Keywords"), a!gridLayoutHeaderCell(label: "Comments"), a!gridLayoutHeaderCell(label: "RFI") }, columnConfigs: { a!gridLayoutColumnConfig(width: "DISTRIBUTE"), a!gridLayoutColumnConfig(width: "DISTRIBUTE"), a!gridLayoutColumnConfig(width: "NARROW_PLUS"), a!gridLayoutColumnConfig(width: "DISTRIBUTE"), /*a!gridLayoutColumnConfig(width: "WIDE"),*/ a!gridLayoutColumnConfig(width: "DISTRIBUTE"), a!gridLayoutColumnConfig(width: "DISTRIBUTE"), a!gridLayoutColumnConfig(width: "NARROW") }, rows: {

Hi Team, I need solution for this requirement, please help me on this. We are generating the QR code and attaching to the document and sending to document to external system people through mail. Requirement is like once the external system people open the document and scan the QR code, need to redirect to Appian portal and open the document. Thanks in advance.

Hii All, can anyone help me how to maintaine multiple field level Audit log in appian. 1) like I have field (like firstname,lastname,email,address,city...so on) then I have edited all the fields and submit the form. so How to show in the grid for every action(create, edit, cancel). Below is the grid I want to show audit log like this:

Hi  I have dynamic List of comments. A comment may have one link or more (there is no restriction on the number of links), as an example is shown below. 1. [{color:#4F50FF}ISSUE-120{color}|https://apps.Tsca.com/suite/sites/lowrider/page/home/record/lQBzulQNzBso196rg0E7ESk00riOSRPp8CPq_KH4VquOjcsriDU6l5j_CxkCY3Ckxt7DZght8D6EZ4CtItPtDmx_uQf3vIm9JzMPvW8QmMKoSTzXRo/view/summary] has been updated to the following status: In Review in Tier 1 by Klaus Lewis,  2. [{color:#4F50FF}ISSUE-122{color}|https://apps.Tsca.com/suite/sites/lowrider/page/home/record/lQBzulQNzBso196rg0E7ESk00riOSRPp8CPq_KH4VquOjcsriDU6l5j_CxkCY3Ckxt7DZght8D6EZ4CtItPtDmx_uQf3vIm9JzMPvW8QmMKoSTzXRo/view/period] ,     [{color:#4F50FF}ISSUE123{color}|https://apps.Tsca.com/suite/sites/lowrider/page/home/record/lQBzulQNzBso196rg0E7ESk00riOSRPp8CPq_KH4VquOjcsriDU6l5j_CxkCY3Ckxt7DZght8D6EZ4CtItPtDmx_uQf3vIm9JzMPvW8QmMKoSTzXRo/view/period]  has been updated to the followi

Hi,everyone How to publishing process models as web services.How to configure in WSDL URL  .Need advice and help!!! Thanks

We are building a case management application that support many ad-hoc relationships among different record types. We are using data sync, but anticipate to exceed the 4M row limit eventually. What strategies should we consider for this? The documentation suggests adding source filters, which makes sense; but no longer will all the data be available in the record type. Do we move all queries to a!queryEntity but allow all writes to continue using a!writeRecords? If so, then we'd want to make sure all our record queries are in expression rules so they can be updated to queryEntity.