Discussion Categories

I recently got an error that said this:"The list of records to be saved must not be null or empty: TypedValue[it=3145,v={}] Data: TypedValue[it=3145,v={}] "But how can I identify which field or type its referring to?I assume that "it=3145" is a particular type or field identifier but I don't know how to look it up. I wish it would should an actual name in the error message instead of an ID / "it".

Hi All, I have multiple sections where the user can upload document and for each section we have "add document" button like below, I have to validate for document size if it is more than 10MB,and this validation is for add document button.I am not getting how to validate the document based on index using fv!files. Because of this,if user adds more than 10MB in 1st sec and adds less than 10 MB in 2nd sec,for both section it validates for "Add Document" button. Please help me how to resolve this.

We have a requirement where we display/hide the related actions for a particular record based on the approval or rejection of tasks. We are observing that the even though the record grid data is getting refreshed when we click on the refresh button, but the related actions are not getting refreshed. Please find a sample snippet of the code:- a!gridField( labelPosition: "ABOVE", data: a!recordData( recordType: recordType!SampleRecord, filters: rule!SampleFilterRule() ), columns: { a!gridColumn(), a!gridColumn( value: a!recordActionField( actions: { a!recordActionItem( action: recordType!SampleRecord.actions.SampleAction, identifier: fv!row[SampleMetric.identifier] ) } ) ) }, validations: {}, spacing: "DENSE", borderStyle: "LIGHT", shadeAlternateRows: false, rowHeader: 1, refreshOnVarChange: ri!refreshVariable, refreshAfter: "RECORD_ACTION", showSearchBox: true, showRefreshButton: true(), showExportButton: false,) What can I do to resolve this?

Where to set reply-to in send email smart service?

Hi, I want to send sms to mobile number for authentication. Can anyone know best possible way?

Hi Appian People! I have this code that split the value inside the CDT. So for example I have a CTD: 'type!{urn:com:appian:types}T_Sample'(  name: "Person",   place: "City1,City2,City3"   ) When splitting the value, the output should be like this in an array form: Expected: ["Person"; "City1,City2, City3"] But the actual result I got is:  ["Person"; "City1"; "City2; "City3"] the place where split in different index where it shouldn't be. This is my current code local!splittedCDT:split( stripwith( tostring( ri!cdtVal ), "[] " ), "," ) local!updatedVal: a!forEach( items: local!splittedCDT, expression: replace(fv!item, 0, find("=", fv!item, 0), "") ), Is anyone could help me with this? Thank You ahead.

Can anyone please tell what does value column denotes for row 2 and 3 from the above image(Appian Health Check Report). In row two value is mentioned as 616383, Is that something related to total memory consumed or something else?

Hi, I am using a Navigation (Lightweight) pattern. When the user clicks on the left menu for example 2nd menu item, I am able to load the respective page. But, when I try to save the data on the 2nd menu item page, after saving it is loading the first menu item page. It is not staying in the same page. Any advises here please.

I have an interface with some dropdowns  The idea is the user selects a drop down which then informs the next drop down list.i.e. drop down one changes the list shown in dropdown two - thats fine and working well,The issue I appear to be having is getting the rule input value to change at the same time for the second drop down (values are expression rule driven) it appears to only update a step late for example if the user selects xyz and this is value of 27 then the ruleInput value will not update until the user changes the selected value to say abc with a value of 88 and then the rule input updates to 27!!! My real annoyance with this is the local variables show the correct values which means that for whatever reason this is not being pulled into the Rule Input at the same time!!!I have taken the time to reconstruct this issue without any specifics below: - Rule inputs: "dropOneRI" as in int"dropTwoRI" as an int"problem" as an int a!localVariab

In SQL I would write something like this:SELECT * FROM parent WHERE parent_id NOT IN (SELECT parent_id_fk FROM child)or SELECT * FROM parent WHERE NOT EXISTS (SELECT 1 FROM child WHERE parent_id_fk = parent_id) In Appian expression language I can find children with no parents by finding records with null in the relationship as described here:https://docs.appian.com/suite/help/22.4/fnc_system_a_queryfilter.html#using-a-relationship-reference-in-the-field-parameter The example in the documentation is like so: a!queryRecordType( recordType: recordType!Employee, filters: a!queryFilter( field: recordType!Employee.relationships.teams, operator: "not null" ), pagingInfo: a!pagingInfo( startIndex: 1, batchSize: 100 ) ).data However this is not what I want, I want to find parents with no children.I think it might look something like this: a!queryRecordType( recordType: recordType!Parent, filters: a!queryFilter( field: recordType!Parent.fiel

I know that Appian may not be the best environment for this, but I'm wondering if this is possible. It is possible to create a simple shopping site using Appian? The table design is simple enough: CATEGORY- categoryId- name- description ITEMS- itemId- name- description- price LOOKUP_CATEGORY_ITEM- itemId- categoryId CUSTOMER- customerId- firstName- lastName- street1- street2- city- state- phone- email CART- customerId- itemId I've done this many times before in different languages/environments.This has MANY TO MANY, MANY TO ONE, aggregations and design/ui considerations with this project.I've deliberately ignored the payment portion/part of the project.  

Hi sample Input : {a,b,c},{100,200,300} sample output : a-100,a-200,a-300,b-100,b-200,b-300,c-100,c-200,c-300

I have a condition where i wanted to do null check if either of the IDs are null it shoudn't write to database. I am using this code in task output. remove( wherecontains( or(a!isNullOrEmpty(pv!primaryId)), a!isNullOrEmpty(pv!selected) rule!NV_constructCDT( formId: pv!form.FormId, primaryId: pv!primaryId, secIds: pv!selected, ), )) Do you have any ideas to optimize this implementation? Thank you

Zuuuup, people ! So, I'm trying to execute a process in background when a user does click a button, for example. Wanna execute it without leave the page or open a new one. For now, we're using a startProcessLink and this behavior leads user to a page that goes back to home page. Any idea to manager this situation?

Hi, everyone! I need to import a spreadsheet data into a database table and I'm using Import Excel to Database smart service for that matter with parameters described below: Batch Size = 1000; Data Source Name = "jdbc/Appian"; Database Field Names = {  "EQUIPMENT_NO",  "MATERIAL_TOT",  "SUPERIOR_EQUIPMENT_NO",  "SUPERIOR_TECH_ID",  "CALCULATED_ACTIVITY",  "NEXT_LEAK_TEST_DATE",  "HAL_SERIAL_NO",  "ISOTOPE",  "SORT_FIELD",  "AMI_DOCUMENT_NO"}; Excel Document = pv!sapInventory; Excel Header Names = {  "Equipment",  "Material/TOT",  "Superord. Equipment",  "Superior TechID",  "Calculated Activity",  "Next Leak Test Required Date",  "Halliburton Serial No.",  "Isotope",  "Sort field&qu

Hi all, {1,2,3,8,9,9,9,9,9,80,90,70}, {56,76,54,32}, {20,23,45,54,32,54}, {1,2,3,4,5,6,7}, {11,12,13,14,15,16,17,18}Please suggest how do this using foreach function get output like this, length of array 1 is 12length of array 2 is 4length of array 3 is 6length of array 4 is 7length of array 5 is 8 Thank You In Advance

I need to setup an intergration between UiPath and Appian, and have learned that by using the "Appian Activities" utility and "UiPath Connector" plug-in, the connection between the two could be done. Meanwhile, I also notice that when searching related information through Appian Document, UiPath seem to be associated with RWM to some extent. I would like to confirm that whether I need a RWM in order to finish the setup. Does anyone have any idea about how RWM function within the process indicated as the picture above.

in an a!imageField() is there a way to remove the white border that is put around the image when it's put in the interface? 

Previously we were using a hyperlink as a record link to open up a summary view,as per the  customer's requirement the design has been restructured (not using record and record link)and currently we are using dynamic link as a hyperlink to open up a summary interface.The Problem here is that,when we use appian's inbuilt export functionality, as we are not using the record link as a hyperlink,it is just appearing as a text instead of link.Is there is any other suggestion you would give here in order to get back that link in the exported data?

Hi Team, I am using the below code snippet for the links column and separating multiple links using semicolons.  a!gridColumn( label: "Links", sortField: 'recordType!LA Record Link.fields.links', value: a!richTextDisplayField( label: "Real Links", value: a!forEach( items: split(fv!row['recordType!LA Record Link.fields.links'], ";"), expression: a!richTextItem( text: fv!item & char(10), link: a!safeLink( uri: fv!item, openLinkIn: "NEW_TAB" ), linkStyle: "STANDALONE" ) ) ) ) But when the user is inserting a link with the below texttool link- https://www.google.com/  it is giving an error tool link - https://www.google.com/ is not a permitted URI under the configured security rules and cannot be cast to safeUri. (APNX-1-4198-000). Even the tool record type interface is not working until I delete the record from the database.  We tested multiple cases and found if we write

Hi everyone,  I need to pass a list of INT into a parameter of a stored procedure which should look like this: UPDATE table01 SET updatedDate = now() WHERE ID in (list of ids that I will pass in); However the parameter type only accept INT, not list of INT, so not sure how can I achieve that.  Any suggestion will be much appreciated :)

What should I type in the expression editor in order to set initial value to a record as shown in the pic? I have tried typing the first couple letters but it seems that the Applian does not recognize them as affiliated functions of a record.

I'm currently trying to implement RPA to get the title, URL, etc. of each news from the news list on the news site.My RPA was able to get the information I wanted and store it in an array.However, the information cannot be saved in Appian's DB in table format. I would like to store the contents of the array that holds the acquired information in the pre-created CTD. Since the Appian document states that it is not possible to directly store data from RPA to the DB, I will implement RPA which creates a list of data saved by CDT etc. and returned this list to the process model. If you have better idea, could you tell me about it?

As the subject line says, I've noticed recently that default in Data Input fields in different smart service nodes, the "Save Into" fields are now disabled, and this is not how the behavior worked in the past. I'm creating this thread here today because I finally noticed a place in our system where this is a bit of a blocker.  There are nodes where this was configured in the past and is now not even changeable. As you may be able to tell from the above screenshot, the "new process variable" control is NOT disabled here (but the output-selector dropdown arrow is, even though you can't tell visually).  Clicking on New PV allows you to save that input's value into that new PV, but then that output target is stuck and not changeable again (unless perhaps by adding a redundant new PV again). This really seems like a bug - if this was an intentional change then I certainly don't remember seeing any announcement for it, or mention in any of t

Hi all, I'm dabbling with some "serious" QueryRecordType interface use for the first time in a bit, and for the first time I'm attempting to use the built-in Aggregation. My use case: a simple one, basically showing a grid sorted by frequency of use of a potentially repeating column.  I'm using Aggregation Fields and grouping by that column, while doing a "count" in a measure.  When I run this a!queryRecordType() in an expression rule it works beautifully.  I notice: it returns an a!map() data result rather than a DataSubset. Then I try to plug it into a Read-Only Grid and things start going a bit haywire. If I try to use it as you normally would use a RecordType source, the grid errors with a complaint about returning List Data.  If I try to run the query in a Local Variable first, it doesn't quite work right, because with the local variable not resolving as a DataSubset, the grid doesn't quite recognize what info I'm try