Foundation

Fitness Testing : How to write test script to validate grid field level validation messages through fitness I wanted to test fitness required field validation for a grid row and grid validation message. Please guide me with the cheat sheet code. 

Hii,   In the process of moving the log files from Appian to AWS cloud watch, I found a way i.e to possibly download the .csv and .log files in bulk amounts and then move them to the Aws S3 Bucket. So to do so I found a function in the SFTP plug-in, "queryappianlogs()" but not sure what are the parameters to pass like the SQL statements. Can you please help me to sort out this one, this allows me to download fixed to 1000 rows.

I'm in the appian designer and I'm trying to sort my datasets by description. Normally if you use an underscore "_" as the first character, entries with the "_" as its first character will appear at the top of the list when sorting alphabetically. Not with Appian however  Anything with an "_" as its first character sorts to the bottom of the list, not the top. Example  Any NameBny NameCny Name_ny Name Why? No one else seems to do it this way. I've worked with dozen of applications and none of them sort the "_" character last like this.  Is this a bug or is Appian taking a page from MS' playbook and assumes that it knows better than everyone how sorting should work? How can I fix this or find a work around? I don't want to resort to using 1, 2, 3... in order to force my descriptions to sort properly.

Hi Team, I have a requirement to execute an expression rule by its UUID/Name. The UUID/Name of the rules to be executed will be saved in the DB, during the runtime the system should read the UUID/Name and execute the rule corresponding to it. Thanks in Advance !

I have a doubt in the parameter "Disabled".  I have a form with some fields. For one of the field (Customer) I can select values via 2 options ( one from the dropdown and other is the text field) . These values are stored in dropdownCustomer and textCustomer field.  I want to disabled the button if some fields are blank in my form. My doubt here is, for the customer field, there will be only one value present either the dropdown or the text field.  If I check a!isnullorempty(dropdownCustomer), it maybe null but the other one textCustomer might hold the value. so, I need to check if any one of the field (dropdownCustomer or textCustomer) has a value, then I don't want to disbale it. Can someone please help here.  disabled: or( a!isnullorempty(field1), a!isnullorempty(field2), a!isnullorempty(dropdownCustomer) )

We have created a document upload UI similiar like Image right as user wanted it like that.It has folder>subfolders or option to add one> document are uploaded. I have used for each to show hierarchy of folder then subfolders and file upload.issue is When i want to upload document to a particular subfolder it is populated in others subfolder file upload as value field is same for all.So I want to upload different douments in different subfolders(as we do in our PC) and should be able to save them.I have tried a!map but it does not support append.

Hi, I would want to ask how can I use the related fields (record relationship fields) in a process model. Now I´m passing a null value The relation appears in the "Write Record Inputs" And these are the outputs: Then, I have a XOR to put conditions to the related fields, but I think I´m not passing the values well because the logic is not working. 

Dears, My requirement is to fetch the files from the Network Shared folder (\\shc-abc\xyx\) . Do we have any smart service to get the files from shared folders? Thanks in advance.

I am aware of the custom picker feature that functions as a predictive text input. However I want it to have the capability to select a value if it already exists, and if it doesn't exist, allow the user to input a new value.(Similar to Excel). This is necessary to prevent the creation of duplicate entries in a field. Can you provide suggestions on implementing this functionality while avoiding performance issues in the interface

Hi All, I have an Map operator which contains key value pairs as  {eventId:6,actualsId:1,planId:2} i saved it in a process variable in a script task and then when i tried doing the value as  pv!map.eventId it is saving the value as 6, if i do index(pv!map,"eventId",999) it is saving as 999 instead of 6. Not sure what is the issue. Any one faced such kind of issue in process model. Please Note : I tried this in Process model not in rule. In rule it is working fine.

I still got this error "The number of tasks per node  (Node name) would exceed the limit of 1000" after setting MNI as below:  Could some one help clarify the use of the highlighted tick box please? I thought it is to replace the looping if there are more than 1000 instances for the process node?

After querying a record, I am trying to access a value from a related record, but the value is not showing up. It just returns null. I checked my Record Lists to confirm the expected values are there. Ex. Record one called Activity Status has a many to one relationship with record two called Activity. Record Activity Status has the status of the activity for each user with a foreign key called ActivityID that references the Activity record. Record Activity has the name of the activity. Ex row for Activity Status: id 1, activityID 2. Ex row for Activity: id 2, name: "running" My record query returns the ActivityStatus with id 1 and activityID 2, which is stored in local!data. I am trying to get the activity name with local!data[recordType!ActivityStatus.relationships.Activity.fields.name] Does anyone know why this does not work?

Hi!  I have created an editable grid so the user can add new rows and fields manually (invoice lines). My next step is to make a validation to assure the fields match with fields in another previous interface (invoice header). The validation runs OK if I put an static condition (f.e. = "Prueba 1") but I have trouble when linking to a previous record field (the relationship between records is created and runs OK). Even though the first input of the previous record and the second input (actual interface) are the same, Appian recognize it as they are different values. The code I´m using for the validation is the following: validations: { if(fv!item['recordType!{b83ae990-aa66-4847-b974-1e1e40019294}CPF Maestro LÃ%ADneas Factura.fields.{14eaacbb-19fc-41e2-aea2-3ec9b3322722}idFactura'] = ri!recordLineasFact['recordType!{b83ae990-aa66-4847-b974-1e1e40019294}CPF Maestro LÃ%ADneas Factura.relationships.{fca16b27-3afd-4932-a545-53d4160413d1}maestroFactura

Hi everyone,  I have an interface that contain a submit button to submit a request, that when the submit button is clicked, it will start a process model by a!startProcess() in a!save(). After clicking the submit button, I want that process model to not run until 21:00 that day. How do I set the timer event to achieve that result? The button will be clicked every day, and I want to delay that day's process instances until 21:00 each day, not just 1 single day. I'm not sure how to define the date and time yet. Could any one help? Thank you!

Hi All, I have to apply character limit on text field like it will only show 5 digits after decimal and before decimal "n " number  ex. if we enter 1234.123456789 , it will show and store only 1234.1234567 thanks in advance

I have a use case where I should navigate from my interface to another application and should  create an object and after saving the changes, once it is saved it should again redirect back to interface

Can we increase maximum no of schema in maria DB allowed from 50 to 60 or any another number?

Hi Suppose  I'm Working in a application  i.e  X and i have to redirect to another application(using safe link) name i.e Y, if i create a object in second application i.e Y then i have to redirect back to previous application i.e X is there any way to do this ?

I am trying to save data in the submit button from CDT from interface into another array CDT where i use a!save(ri!big_cdt.subset1, a!foreach( items:ri!samll_cdt, expression: {fv!item.subset1}))... this way i am filling multiple values so that i can write array CDT into a datastore as multiple rows in an single attempt using write to data store in the process model. but, i get this error in the interface "Interface Definition: Expression evaluation error [evaluation ID = 2ce92:fe3b0] : An error occurred while executing a save: java.lang.IllegalArgumentException: Cannot derive list type from List of Text String in which to store data of type List of Variant" not sure what i am missing ?

Hi All - Anyone have any way to handle the validation message "The value provided is not an integer." in the Integer field?I would like to have the custom message for users when they are entering some Alphabets in the integer field. Instead of the above message.  Note: I don't wanted to use the text field with the regex validation rule to check if any alphabets were entered

Hi! I created an interface with an editable grid so that the user can add invoice line information and new rows. When clicking the button of confirmation, the rows must be saved into a record ([]). The interface runs in a perfect way when I test it (all the values I write are stored in local!data) , but when I try to add it to the process model an error appears :  Image of the error related with local variables (local!data): To create the interface I followed the steps of an Appian tutorial ("Write or Delete Records using an Editable Grid | Editable Grids, Part 2"): https://www.youtube.com/watch?v=z0FF9aCZRBE In the tutorial, we store the inserted values in a local variable (local!data), to end passing the information to the record. I leave here the code: a!formLayout( label: "Crear Nueva Factura (2/2)", contents: { a!localVariables( local!data, { a!sectionLayout( label: "Información de LÃ%ADnea de Factura", contents: { a!gridLayout(

Hi everyone, I ran into the following problem: I have a job model that downloads files from an S3 bucket and stores the downloaded documents on a constant in document format. I would like to know if by clicking on the image given by the a!documentimage function from an interface, it is possible to start the process that downloads the file to me and then actually see the download of the file. What I do now is use 2 buttons, one to start the process model to store the document in the constant and another one to download the file from the updated constant into the a!documentimage, but I would like to combine the two and use just one click. Thanks in advance.

Hi All, We have a requirement of uploading 500 rows at a time. Out of 500 instances i see few instances are failing with the below error. a!queryRecordType [line 2]: APNX-3-4300-001: Connection pool drained - too many concurrent requests: org.apache.http.conn.ConnectionPoolTimeoutException: Timeout waiting for connection from pool) (Data Outputs). What could be the reason of failure though the data is being fetched from the cached data of a record type? Thanks in Advance !!

Pdf load in component plugin html fails to load but gets loaded with the following iframe gets refresh. Please let us know what is blocking in SAIL to get this refreshed or loaded?

I am trying to export to the word doc, the spell check of the exported doc as we open is disabled. It isnt showing red underline under the misspelled words. Does anyone know how we can solve this as we open the doc?