Data Fabric

Is process  & task reports the component that requires extensive coding ? Is there a component available to make it easy for moderate techies to create great reports low-code way 

Hi, fairly new to appian and I'm trying to use type! to get the type value of a string array. I'm currently using typeof({"A", "B"}) which is working, but seems very clunky. I'm sure there's a better way. Any help? Thanks!

Hi, I would like to inform you that I am using Import Excel to Database smart service. I have able to insert data to database successfully but it is always inserting 1000 rows (the default value of Batch Size) though I have set the Batch Size to 40. It is inserting 960 rows extra with 0 or null values along with the valid 40 rows. Can anyone please help me regarding it. Following is the screenshot: Is there any link of proper documentation for Import Excel to Database smart service? Can you please share the document link with me?

Hi Community, I need to replace the XSD file of certain CDT to retrieve its data from different Data store. My XSD file: <xsd:schema xmlns:xsd="">www.w3.org/.../XMLSchema" xmlns:tns="urn:com:appian:types:TFO" targetNamespace="urn:com:appian:types:TFO"> <xsd:complexType name="TFO_REF_CRS_Status"> <xsd:annotation> <xsd:appinfo source="appian.jpa">@Table(name="CRSStatus")</xsd:appinfo> </xsd:annotation> <xsd:sequence> <xsd:element name="id" nillable="true" type="xsd:int"> <xsd:annotation> <xsd:appinfo source="appian.jpa">@Id @GeneratedValue @Column(name="PkCRSStatus_Id", nullable=false, unique=true, columnDefinition="INT")</xsd:appinfo> </xsd:annotation> </xsd:element> <xsd:element name="name" nillable="true" type="xsd:string"> <xsd:annotation&gt

I am working on an app to lookup tracking numbers from a vendor portal.  I get an excel file everyday that I have uploaded into Appian using "Import Excel to database." What I need to do now is walk through the table line by line and pull the Order Number, pass it to the RPA tool to input into vendor site, retrieve the tracking number, and write it back to the column in the table.  Whats the best way to tackle this?  a loop function in the process model? a loop function in the RPA? any help would be greatly appreciated.  Thanks.

I have a text of pv value like { "user" = "ABC", "class" = "EFG",.....} this and i want this to store into cdt to the related names [ user : "ABC", class : "EFG"]

We are currently working on a POC and need your help/guidance on below questions 1) User submits a request on the UI and it is logged into various DB tables (Appian MariaDB) and we will have another approach to load this data into the Appian Database directly - consider these are some sort of reference data. Now we need to expose this data via a Web API and consumers can call this API 3 million times a day. Need your help to validate the scalability or any performance impact of the Appian Web API if we have such requests ? 2) Is there any way where we can modify the CDT and publish the Data store automatically?  3) Is there any way where the decision objects can be modified automatically ? (instance where decision need to change for a particular row, and business user can do that without any development effort)

I am trying to upgrade appian records to utilize v 21.2 features. Data source, list, sync has been done up without errors.However, when I passed in rv!records into the SummaryView interface (old), when I go into the list and click into the appID, i will be faced with this error - An Error Has Occurred ???APNX-1-4205-046??? (APNX-1-4205-046). Or will i have to refactor summaryView to utilize dot notations? I kinda tried it but its not really working as well. Do let me know if you require more information? a!localVariables( local!serviceArea: â`œxxxâ`%9D, rule!SummaryView( refAppId: rv!record['recordType!{xxx}Applications Upgrade.fields.{xxx}pid'], owner: rv!record['recordType!{xxx}Applications Upgrade.fields.{xxx}owner'], assignedTo: rv!record['recordType!{xxx}Applications Upgrade.fields.{xxx}assignedTo'], status: rv!record['recordType!{xxx}Applications Upgrade.fields.{xxx}refStatusId'], isMyGrantRecord: true(), recordType: cons!MGP_CMN_RT_APPLICATIONSUPGRADE

Hi, Have multiple user filters configured in record. User filter values are not getting refreshed on user interaction. Scenario: User selects filter1 from dropdown and then selects filter2 to filter on two different fields. Issue: If user selects filter1 from dropdown, record list displays the subset(datasubset1) filtered by filter1 but filter2 still shows all the values in the dropdown.  Ideally filter2 should show only the values from datasubset1. Is this default Appian behaviour or is there any configuration which needs to be done? Regards, Vikrant Bhardwaj.

Hello. I have multiple Reports that are Task Report Types by process model. While the report itself returns data, a!queryProcessAnalytics() returns no value for data. I'm not sure how to make or update the connection. Thanks.

Hi, I have a grid, where in a dynamic link will be there. If i click on the link, the selected row should be passed as parameter to another process model. In the 1st process model, i have added process variables. if i click the link in grid, nothing is happening.  how to achieve this?

I have a dropdown component and a record-based read-only grid on the interface. My requirement is to refresh the user filter value based on the dropdown values.   I am using Appian 20.4 version

Hi! I have the FAQ record type that has a related record type Answer. https://www.screencast.com/t/YBLj0uEs When trying to update an existing FAQ, have this in the context expression https://www.screencast.com/t/xV2KlFZU52Y but nothing is getting attached in the Answer field in the interface. https://www.screencast.com/t/xi5hw978bsK When testing the answer parameter part separately, i get this result with Text field present and correct, but can't figure out how to attach it to the interface form for editing a FAQ https://www.screencast.com/t/YMzR0SFxNi New to using record types and, especially, their relationships. Hope to get some guidance! Thanks!

a!localVariables( /* Query the parent */ local!Employee: a!queryEntity( entity: cons!TOC_EmployeeEntity, query: a!query( selection: a!querySelection( columns: { a!queryColumn(field: "Employeeid"), a!queryColumn(field: "Departmentid"), } ), pagingInfo: a!pagingInfo( startIndex: 1, batchSize: -1 ) ), ).data, /* Query the many-to-one child */ local!Department: a!queryEntity( entity: cons!TOC_DepartmentEntity, query: a!query( selection: a!querySelection( columns: { a!queryColumn(field: "Departmentname"), a!queryColumn(field: "Departmentid"), } ), pagingInfo: a!pagingInfo( startIndex: 1, batchSize: -1 ) ), ).data, a!gridLayout( label: "EmployeeDetails", /*instructions: "Seleccionados: " & local!selected & local!selectedItems,*/ headerCells: { a!gr

Hi team, I am unable to write the data in data store entity. Data is getting stored in process variable but when I am trying to store the same process vaiable data into appian db, only auto-generated key value and a new row is getting stored and not the whole data which I am trying to store. Please help me in this regard. Below is the process model- For fetch data from API, I have the following configurations as shown in the screenshots below- I am getting the data as list of texts as you can see in the above screenshot. I have created a CDT from the table. Table and CDT structure can be seen below-    I have created a process variable which can be shown in below screenshot- Below are the screenshots showing the Write To Data Store Entity node configuration   Now after running the process, the value in the process variable is not getting saved and not in table too. However in the table, blank rows are getting added with a auto generated incremental i

I have created a view by joining two tables in my database. I have added the view into the appian datastore,  when i click on save and publish, im getting the below error.

i have configured custom record field in the vehicle record,  but unable to see the same in record list view

Hi Everyone, I am new to Appian and development in general, so, thank you for taking the time to help! In the Query Your Data Lesson 6_E1, we are asked to create a aggregate query in order to display vehicles by make.  I am able to display the results, however, the results in the drop down menu show the alias and also the entire results in brackets.  I am trying to have the drop down menu only display the vehicle makes. Expression Rule: At the beginning of the lesson in the solutions, it says that I am to use a local variable function and gives this as an example or maybe even as the solution: However, when I tried to wrap the previous code in the function and then index it through .data, I get an error.  So, then I just duplicated my previous expression rule and basically used this exact code and still get an error.  Can someone help me understand indexing everything after the .data and what I am missing?

Hi Everyone,  I've got a CDT that has an Id as a Primary Key and then a Numeric field that is a reference to a previous same-cdt entry id. Starting from an ID I need to back-track all the way to the first "father" entry. All should be done using Expression Rules.To give you an example I would like to start from contract ID:4 and backtrack all the way to ID 1 (that has no father id) I managed to achieve the backtracking with a process but I can't make it work with a reduce() or a forEach() function. Has someone found something like this in his history? Best regards, Luca.

We have a table with below fields we want the output with same firstName, lastName and phoneNumber with different city Table Result can we achieve this by a single DB query without writing any views/sps...

I have scenario as below - Country List Country Code Field Name France 1 Country_Field Germany 3 Country_Field USA 4 INTAKE_FIELD EUR 2 INTAKE_FIELD I have to populate a column in generated excel which must contain values after translation based on selected value of Field Name in mapping with Country List and Country Code. Output file must generate column like below - 1 4 13 27 89 5 7 8

Hello There, Could someone please let me know if there is any plugin which we can install to mariadb, which shows me queries Appian application is firing. We have received notification from database that there are lots of queries firing as cross join and it should be fixed by index. We have checked indexes and mostly indexes are in place. Therefore any tool or any help which help us fixing this issue would greatly be appreciated. Thanks

Hi, I am trying to save data in appian db which I am getting from an api call. API is : https://run.mocky.io/v3/ac936aeb-6ae5-46e1-ab38-b953ab3ac2a5 [Below is the body that I am getting after running API call in Appian] [{ "FXRateMicroservicesSuite1": [{ "FXR": [{ "FXRateGET": ["test step 1", "test step 2"], "link": "FXRateGET.com" }, { "FXRateMiscellaneous": ["test step 1", "test step 2"], "link": "FXRateMiscellaneous.com" }, { "FXRatePolicyServer": ["test step 1", "test step 2"], "link": "FXRatePolicyServer.com" }, { "FXRatePOST_DELETE": ["test step 1", "test step 2"], "link": "FXRatePOST_DELETE.com" } ] }, { "Script2": [{ "Test cases": ["test step 1", "test step 2"], "link": "Script2.com" }] } ] }, { "FXRateMicroservicesSuite2": [{ "FXR2": [{ "FXRateGET2": ["test step 1", "test step 2"], "link": "FXRateGET2.com" }, { "FX

After the data sync in Records the data is in cache to retrieve swiftly. Where can we see that data after the data sync in records to compare with the previous data sync?

The Appian Documentation below does not explain how to prevent the updating of an existing value. I want to bring in new data, but if the primary key already exists, then I want to retain some of the old data while updating other values. I tried doing something like: if(isnull(rule!Query_Existing(pv!data.PrimaryKey)), "new data", "old Data") and save into the field And the rule above passes the primary key and searches for the "old Data". The rule works by itself, but when I do this if statement, I get a null pointer exception.  Appreciate any help on this. https://docs.appian.com/suite/help/21.4/Write_to_Data_Store_Entity_Smart_Service.html Updating an Existing Value The data that you write can update an existing record when a primary key is properly configured for the entity and provided by your node input. Saving a New Value Saving a new value for an existing record does not merge the records, the old record is overwritten.