AI and Agentic Automation

Hi experts, We have been able to establish connectivity to a HANA database successfully. The HANA stored procedure is expecting the values to be passed, enclosed in single quotes - 'Value1, Value2'. A query like below works perfectly fine. SELECT * from DB_SCHEMA.VIEW_NAME('placeholder' = ('$$list_name$$','Value1,Value2')) However when I try to pass this list as a parameter, I am getting an error. SELECT * from DB_SCHEMA.VIEW_NAME('placeholder' = ('$$list_name$$',{parameter})) Has anybody integrated with HANA DB before and has a reference to how we can achieve this by passing dynamic values via parameter with the main criteria being include parameter values in single quotes?

Hey Guys, We are trying to use recordsChatField component in the interface but it is giving the below error. Any help will be appreciated.

Hi All, I have recently utilized the AI skill where I have used it as Document Extraction. Once the Extraction is done I am able to publish the AI skill and utilize it in my Process Model. I am also able to extract the data. I now used the Reconciling SMart service and able to Map certain fields which are not picked by the AI skill. Now How do i train my Model to pick those fields going forward for the Next set of Documents.? Basically How do I retrain my Model. Thanks  Harsha [mention:a11f77a729fb4db2af76b09948583328:e9ed411860ed4f2ba0265705b8793d05] [mention:31db00b785704865b14e5d9b9bef3863:e9ed411860ed4f2ba0265705b8793d05]  Really appreciate your help in this.

I would need to run two wherecontains within this dictionary array, for example to get a country with a POPULATION greater than 1,000,000 and an AREA greater than 150. how can I proceed with two wherecontains? thanks

Hello all, I have a question that I think it should be easy but I cannot figure it out, and also I cannot see any response in this forum. If I have a a!forEach within another a!forEach, is there a way of refering to the items of the outer loop, within the first loop? Example to understand with non real data:  I have two lists: local!text: {"1111 - GREAT", "1000 - BAD", "5600 - MEDIUM"} local!words: {"GREAT", "MEDIUM"} as you can see, "text" is a list of text, and each string contains a code a "-" and a word. I want to create a nested loop that returns a list with the codes only when the words contained in the list "words" are in the list a.In this particular example: {"GREAT", "MEDIUM"} because "GREAT" is included in "1000 - GREAT" and "MEDIUM" is included in "5600 - MEDIUM". I woud like to iterate though every item of list &quo

Hello All, Is there a way to pass system message to Appian Records chat to set the tone to the interactions? To be more specific, I want to display a value as chat response that is dependent on a column of the record type instead of displaying the exact value from the column. I am able to achieve it using prompts, but I cannot expect users to write this prompt every time they interact with the bot. 

I have a field in my form named as description. The description contains value of paragraphs spanning over a couple of pages. While training the model, I selected the data to be extracted from multiple pages by selecting the continue drawing option, but when the model was put into practice, it fetched the data from only one page. Even in the Reconciliation Task, I cannot select data from more than one page. Is there any workaround available for this issue?

Hello Everyone, I am using text() or any  function in type!{urn:com:appian:types}Test'(). But it seems not working. Can anyone suggest how I can do this? Thanks

Hi Team,  I have a used case, where an employee goes to a specific option on a website and clicks on the upload button, as we know once the upload is clicked file explorer pops up, and then he chooses a document > and clicks on submit. I am trying to automate this so that robot can pick documents one by one and submits them. I know clicking buttons is easy with interactive elements of the browser but once the Upload button is clicked the file explorer is opened, and I am not finding any way that robot can interact with File Explorer and selects that document from some location. I looked at the documentation of File system action https://docs.appian.com/suite/help/20.3/rpa-8.0/modules/file-management-module.html and I cannot find anything relevant so please help. Best, Khaiser

II want the result of this expression rule to be in the below format or the highlighted format in the editor. currently I am passing name and comment from one CDT ,now along with this 2 fields  I need to pass the colleagues array with add array with in the colleague array. I have created other new  CDT for colleague array with id , typeid and addcolleague array in it ,how to call it in the expression rule to get the result in the below format . Please adviseHow can I get this result in the below format ,can someone please adviseExpected RESULTa!toJson ({ "name": "string","Comment": "string",Colleagues:{ {"TypeId": 1,addColleague: {"email": "string","displayName": "String","eFlag": false,"dFlag": false,"ProviderID": 2,"idFromProvider": "string"   }}}})

Hi Team,               In my application i am using one expression rule that fetches the data from database view,and that database view fetch the data from 4 tables and each table have different number of records(646183,2185098 ,159583,166000) , however when i go to database and open the view it's working fine but when comes to expression rule it's not working  Note: Previously we didn't face any issue as we didn't  had much records  and it was working well for load testing we inserting lakh's of records now it's not working. Could you please suggest me a solution. Thanks & Regards, Prasad.

We had a decimal value in text format in local!value variable as below But converting it to decimal is rounding off the value as below But I want the exact value in decimal data type as we need to send this value to an external system that doesnot accept text format. Is ther any way that I can sent exact value in decimal format without rounding it.

Hi Experts, I need your help! I trained an AI skill to extract data from PDFs and the model is trained with 91%recall. In the process model I am getting an error: This operation is not supported in Extract from Document node. Need your help in this regard. Unable to identify the cause of the error.

If it's CDT rule input, we can give "{}" simply to provide test values. For recordType! rule input, how to provide value?

So I was practicing new skill of document Extraction , but I am stuck at one place while I am trying to run a script task for code below  so I am targeting value to isValidate variable as my all values is true then too isValidate Variable is showing false and I checked my XOR decision too but I guess something is wrong with Script Task can anyone pls suggest me best Practice For this [emoticon:c4563cd7d5574777a71c318021cbbcc8] and I am using Cdt    

Hi All, I am using a date time component inside the interface. But it also accepting the special characters if we enter manually. After submitting, it is displaying the system date. Eg: I gave 12/06/2024* 5:00 PM. After submitting it is displaying system date and time. Is there any way to restrict the user entering the special characters inside a date time component or show any validation message based on some condition.  It would be very helpful if I could able to achieve Thanks

While using Data Extraction can we extract Company logo's / Images for a given document?

Hi All, Anybody can please me for regexmatch code IPv6 Ip Address. I an using this regex code "^([0-9a-fA-F]{0,4}:){7}[0-9a-fA-F]{0,4}$" Using above code this scenario: a) :2551:FFFF::3333:4566:3456:0 is also vaild but I don't want to start IP address with any special character. Some of the example below that I want to match regex code valid and invaild like: a) :2551:FFFF::3333:4566:3456:0 (Invalid) b) 1001:2551:FFFF:255b:1222:3333:4566:3456 (valid)     1001:2551:F:255b:1222:3333:4566:3456 (valid) c) 1001:::255b::::3456  (vaild) d) 1001:::255b:::456: (invalid) I need a regex match code which passed all the above mention examples. Thanks  

Hi Guys, I would need to get one list of dictionaries and not two lists of dictionaries? how can I proceed? I expect: this result  Now my code is like this: how can I fix? a!localVariables( local!data:{date(2023,10,10),date(2024,10,10)}, local!country:{"ITALY","USA"}, a!forEach( items: local!data, expression: a!forEach( local!country, { DATA:local!data, COUNTRY:fv!item } )) )

Does Email classification AI skill considers attachments as a defining factor? I tried but it did not work.

Hi Folks, I am using Appian AI Skill to extract the data from a pdf document. I uploaded multiple documents in the same batch and some of the documents are failing and giving the below-mentioned error.  Did anyone face the same issue or any insights into it? Your help is much appreciated.

thank you always.I would like to ask you some questions about Appian's features.Where can I create the "query rule" displayed in the object list? I don't see any options for creating a new object.Is this a legacy thing?I apologize for the basic question, but thank you for your understanding. いつもお世話になっております。Appianの機能についてお聞きしたいことがございます。オブジェクト一覧に表示されている「クエリルール」はどこから作成できますか？ オブジェクトの新規作成の選択肢には見当たりません。これはレガシーなものなのでしょうか？初歩的な質問で恐縮ですが、よろしくお願いいたします。

Hi All, Good day! The Record Chat element is only fetching details from the principle record type but not from related record types, even after specifying the relatedRecordType.relationship field. Any help/suggestion is appreciated. 

Hi All I am getting the error with reject function so please let me know what causing this error .  [Expression evaluation error at function 'reject' [line 39]: Incorrect number of parameters for function; expected 1 parameters, but found 0 parameters.] a!localVariables( local!group: index( rule!CDM2_findUserGroup(loggedInUser()), 1, {} ), local!escalatedTo: if( a!isNullOrEmpty(local!group), {}, index( a!queryEntity( entity: cons!CDM2_DSE_INQUIRIES, query: a!query( aggregation: a!queryAggregation( aggregationColumns: { a!queryAggregationColumn(field: "escalatedTo", isGrouping: true) } ), logicalExpression: a!queryLogicalExpression( operator: "AND", filters: { a!queryFilter( field: "groupId", operator: "=", value: local!group ) },

I have a list of Ids I need to check wheather document is exists or not - isobjectexist function is not availble in the community is there any alternate function please help me