-
Recently active
How to get the duplicates from an array: i/p:{1,2,2,3,3}o/p:{2,3}
I am testing the new version of appian and the AI elements, specifically when I create an extraction model for an invoice, the document appears like this and I cannot map the data correctly. Does anyone know why?
Hello All, Is there a way to know which IDP version installed on my environment? I can see that the application was imported on the 7/8/2020. But other than that, I don't have anything else. Thanks for all the help! Akshar
Hi!I'm trying to filter out record where field 'value' is null, but it only gives the record of the first item, here's the code local!validValues:ri!properties[where(a!isNotNullOrEmpty(ri!properties['recordType!{5ebb976a-556f-4033-b1d7-9e5976ab963d}MM Property.fields.{041a7f43-dfd1-4b07-aaed-48e305712f4e}value']))], Any inputs? Thank you
Hello team, in my application for reporting i use a!exportDataStoreEntityToExcel smart service to download Excel report based on the filters selected. This part is working great. As a new requirement i need to limit the access, the users will be able to download report only for contracts which they created / they approved from sender side / they approved from receiver side. The way i tried to achieve this is to create an expression rule to query the entity, make queries with 3 different filters (when user is created, approver on sender side, approver on receiver side), save the results into 3 separate local variables, combine them into the final local variable which will be then used as the entity parameter in the excel smart service. But i am not able to cast it to proper format, all the time i receive an error message: Could not cast from ICH_V_ContractLineItemsReportCSV to Data Store Entity. Details: CastInvalid. Example: local!variable1: cast( 'type!{urn:com:appian:typ
Hi I have created a constant for storing all the valid file extensions constant : OPP_TXT_VALID_FILE_EXTENSION -> {"PDF", "JPEG", "JPG", "PNG", "DOCX", "DOC", "XLSX", "XLS", "CSV", "TXT"} Now I wanted to implement a validation in fileUploadField wherein I want to check for valid file extensions. For this I am using the contains function contains ( cons!OPP_TXT_VALID_FILE_EXTENSIONS, upper(fv!files.extension) ) Now even for a valid file extension (say PNG) this validation fails But if I use normal array of hardcoded values instead of constant then I am getting the desired result contains( {"PDF", "JPEG", "JPG", "PNG", "DOCX", "DOC", "XLSX", "XLS", "CSV", "TXT"}, upper(fv!files.extension) ) Is there something that I am missing ?
For the automated expression rule testing, currently test results expire after 7 days (as mentioned in the documentation for function a!testRunResultForId). Is this a configuration that can be changed? We can to decrease the retention period to perform an aggressive clean up for this data.
Hi there, There is a section in the PDF file, like below: Is there a way to capture these "checkbox" by using AI skill extraction objects? If the PDF file is protected by password due to the security, would it affect the performance of AI skill extraction? Any suggestion would be really appreciated.
As soon as I type the first character in Appian's Chat-GPT box, the red "Invalid Search String" error displays below, and nothing I type in makes it go away
Hi All, I am having two times saves in 2 variables Eg: 1) 2/5/2023 9:00 AM GMT+05:30. 2) 2/5/2023 8:00 PM GMT+05:30 now my ask is what function we should use in order to get the output like output : 11 hrs or in minuts and also same for dates Thank you
Hi! I´m creating a rule expression to return a value based on the logged in user, and use this value in an interface. In this case, I want to return the value "Proveedor 2" and show it in the interface. But the problem is that, when I try to reference the rule as a local variable, the following is shown. My local variable configuration is: I think the problem is in the test output of my expression rule. When I put it in raw format, the same text which appears in the interface is show (I just want "Proveedor 2"): 1)Image of expression Rule 2) Expression rule output in various formats In this case, I would like to extract just the "Proveedor 2" output. How can I do this?
Hello, I have a problem when entering the credentials to connect with Google Cloud, the private key is not recognized and I would also like to know what information goes in the fields Destination Bucket and Source Bucket
Hi everyone. I hope you're looking forward to the weekend. I am asking for ideas to handle the following scenarios with the decision table feature. Scenario 1: An input is a list of strings with variable sizes. Example input instances: [ "value 1", "value 2", "value 3"] [ "value a", "value b"] The input list of variable sizes is checked against a predetermined set of items to answer the following question. Do the input list items exist in the predetermined set of items? given this input [ "value 1", "value 2", "value 3"] does at least 1 input element contains in { "value x", "value y", "value 2"}? In this case, the result will be true. Question: what is the best approach to solving this scenario? Scenario 2: The following document indicates the following. Leverage existing application reference data: Decisions can use your application reference data (like case statuses) that is stored in constants, database tables,
Read the document saying that Appian can expose Decison via Web APIs. https://docs.appian.com/suite/help/23.2/Appian_Decisions.html Questions - What would an output look like and is it DMN compliant? - Can the other system use a DMN Engine to execute the decision? Thank you.
Hi I have this problem, I have to evaluate 3 things in priority order, which are Temporary -> Permanent -> Default I have to check which one of this a client have in that order, how can i do that?
What type of Document we need to train for the Document Classification in AI Skills. Like the Syntax for the Document which we need to Upload to while configuring the AI Skills Document Classification
I have a use case for AI Skills but it seems whenever i pass any document this happens. For this example im passing a PDF file exported from a word file uploaded to appian, and it is being called by the process model below as a constant. Using the Extract From Document Smart Service doesnt give me an output, when I check the reconciliation all characters are being outputed as boxes, as shown in the screenshot.Checking with the actual document before and after goes through the smart service ( document passed through different variables for before and after ) and it is shown normally. Would want to understand why this is happening and what steps i need to take to rectify this issue.
Hello what is the difference between - AI Skill Document Extraction = https://docs.appian.com/suite/help/23.2/create-skill-doc-extraction.html - Start Doc Extraction Smart Service = https://docs.appian.com/suite/help/23.2/Start_Doc_Extraction_Smart_Service.html ?Thanks
Hello,following the tutorial "Automate Your Business Tasks with AI Skills i created the AI Skill object, but i have this error. I need to receive an help/explanation.Thanks to all.
Hi, I am parcticing with the a!queryRecordType() function and I realized in return one field called identifiers where the primiary key is returned and I would like to know if I could transform it together with the data field into a map where the identifiers values are the keys and the data values are the values. For example: Having: identifiers : {12,20} data : {"first value", "second value"} Transform it into {12: "first value", 20: "second value}
Hi, I need to find the sequences child-father in this table starting with an input id. For example 1-3-9-11-18 or 2-5-6-15-20. I tried using query in forEach loop but without success. Do you have any suggestions about it? id idFather 1 3 2 5 3 9 5 6 6 15 9 11 11 18 15 20
Hi All, Can anyone help me convert this string into date format so that I can inject into data base "20171222" string format is "yyyyMMdd" I need to convert to date format yyyy-MM-dd so that it can be added to database
I'm trying to figure out how I would configure an expression rule to perform a rolling sum by userId. For a given person, calculate how many hours they worked for a rolling 7 days, and if they have exceeded 10 hours then return true. Otherwise, false. My data looks like this: UserID workDate Hours 1 06-03-2022 1 1 06-04-2022 3 1 06-05-2022 1 1 06-07-2022 3 1 06-08-2022 1 1 06-09-2022 3 1 06-10-2022 2 1 06-13-2022 4 2 06-13-2022 7 Given the table above, it calculates from the current date (inclusive) for the last 7 days. UserID workDate Hours Last 7 days response 1 06-03-2022 1 1 false 1 06-04-2022 3 4 false 1 06-05-2022 1 5 false 1 06-07-2022 3 8 false 1 06-08-2022 1 9 false 1 06-09-2022 3 12 true 1 06-10-2022 2 12 (06-03 dropped off) true 1 06-13-2022 1 10 (06-07 to 06-13) false 2 06-13-2022 7 7 false Is it possible to configure a calculation like this in Appian? For all intents and purposes, once they have broken the 10 hour mark a
Hi All, Please help me out of this Error, Error message : Training failed because there are too few files that meet the requirements. Collect and upload more files that meet the requirements to train a model. Which type of templates Should be Upload in AI skills - Email smart Services
Hello, I have a constant of type application and I need to retrieve all of the application groups from it. Is there any way to achieve this? Thank you!
Already have an account? Login
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.