Data Fabric

Hi, I have a pie chart that displays the 'label' & 'data' outside the pie chart. I want to display the 'label' outside the pie chart and the 'data' inside the pie chart. Is there a way to do this?

I'd like the employee ID to auto increment and populate automatically whenever a new employee is being added to the record.

Hi, Recently we deployed a new application to Production environment. It's working fine. The screenshot But facing DB connectivity issue every 37 minutes we are getting this error. Can anyone please help me regarding this DB connectivity issue?

Hello, when a record type has a (1,n) relation, Appian supports some aggration for those related records ( 'Create Custom Record Field' --> 'AGGREGATE RELATED RECORD FIELDS'). The avaible aggregation functions seem to be dependend on the data type of the 'AGGREGATE RELATED RECORD FIELDS' - in any case, I'm looking for something like FIRST_OF (LAST_OF) so that I can get the first record field(s) of related data records (which are string based). Maybe a small example: (Author)  <-- (Books) (an author can have many books) Should be presented in a list author number of books book title (first) book release year (first) Scott Lynch 6 The Lies of Locke Lamora 2006 ... What would be a good way to achieve this? Thank you in advance Thomas

How can I apply an order or sort to the values shown in a picker field? I am using a a!pickerFieldsRecord on a single record type Employees (ID, First Name, Last Name) but would like to sort it by first name.

Hi, I want to know how to create " Functions" & "Procedures" section in custom Database not the in-built APPIAN one. We have created our own custom DB for our APP  Using Appian 22.3 Regards Bihitak

Hey Guys, i just want to write a rule expression. wrting(create) data to the database using record type. the record type is already synced with the database. I can not figure it out. i also tried using Write to record smart serice but  i keep getiing error that i can not use record type.  how is something so easy so difficult to find solution. please help. i just need a a expression structure for writing data to the database using record type

I am currently having issues while working with a one-to-one nested cdt design (without reference data).  I have simplified this problem by creating the following 2 tables: CREATE TABLE TEST_PARENT(parentId INT PRIMARY KEY AUTO_INCREMENT,parentName VARCHAR(50)); CREATE TABLE TEST_CHILD(childId INT PRIMARY KEY AUTO_INCREMENT,parentId INT,childName VARCHAR(50)); ALTER TABLE TEST_CHILD ADD CONSTRAINT FOREIGN KEY(parentId) references TEST_PARENT(parentId); While trying to publish the nested CDT TEST_PARENT with the following configurations: I am receiving the following error: The repeated column error does not make sense to me as the columnName defined in the second screenshot is the foreign key column on the child table which is pointing to the parent.  I am struggling to get this to map properly and get around this error and would appreciate any assistance.

HI I have a requirement to export more than one lakh records into excel sheet. challenges:      -> Data is coming from a view having multiple joins.( Facing performance issue at production)     -> So we followed appian records approach, but export to excel button is getting disabled when record count is more than one lakh.     -> As the records count is high, we are not interested to go stored pro and staging table approach Any advice is helpful

Expression evaluation error [evaluation ID = a6b59:bf472] in rule 'ofm_repairsection' at function a!buttonWidget [line 222]: An error occurred while executing a save: java.lang.IllegalStateException: A Value should not be the result of activation What exactly this error mean.....

the

I'm trying to open a summary page in site by using a hyperlink from dashboard and I'm getting the following error "An error has occured The field [e40--------] does not exist.(APNx -1---)"

I am facing issue in apian, as I need to get the data which is present in cloud data base store to my appian process modeler in CDT form of every data, how to do that could you suggest your ideas on it  mainly i need to get the data which is present in cloud data store to into my  appain  ui  inteface . every data which is present in cloud data store (table) need to come one by one in array form . 

Hi everyone, How to query in appian Not between in these date from oct 1 to oct 5, I would like to show data that not between on these date?

Update #1: I still wasn't able to get this working with a!recordActionField(), but instead I included it by adding the Related Action shortcut on the view configuration. This seems to be a bug with the User Record Type. Update #2: Passing the UUID with the user() function as the identifier was the solution! Thanks Dan. I created a custom view for Appian's User Record Type (the same record that displays when you click on your user icon and go to "Profile"). I have a related action that takes the user to a custom form to update some details. When I trigger the related action using a!recordActionField(), the following error is thrown and the process does not start: An Error Has Occurred The specified User related action does not exist or you do not have permission to view it. However, when I trigger the same related action by visiting the out-of-the-box "Related Actions" view on the User Record, it starts the process successfully

I need to get process tasks by groups of particular appilication , Thus if I have a process report for L1 group show below . while fetching thoese report to interface i am getting Error  The error says passing empty values . the cons i am calling for process report is attached below , what changes should i do now?

Hello Everyone,I am making bill splitter app I have one cdt where I am having friends field as an arrayz. so in database 2 table are getting created for it one is normal cdt values and other table is for friends array. I am not able to use that value in process model please help me with I am new into appian can you please tell how to resolve this issue

Hi All,  We are connecting to a particular schema through connection details in database and its getting successful. When we are trying to connect data source with same connection details from Appian, the schema is shown different and in Appian selecting schema while creating Data type is disabled. eg. Connecting to Schema in DB is "ABC". but after creating Data source in appian and creating CDT, Schema is shown as "XYZ" and not selecting schema is disabled. Any suggestion on how to connect to a correct schema by making any change in connection string? Thanks in advance.

There is a requirement where i need to parse csv/exel file and insert data into database. But the problem is number of columns can be different each time. I have tried to use available plugins but it's not working. Thanks, Hemant

In column chart the label above the column shows a number. The problem is for the empty one it shows zero and I want it to show nothing for Zero. How to do that.

Hi All, I have inserted the interface code, comment field line :152, here how can we pass the ruleinput to value and saveinto parameter.? thanks in advance. a!localVariables( local!griddata: 'type!{urn:com:appian:types:IA}IA_asupplier'(), local!selection: ri!addProduct.status, local!comments, a!formLayout( label: if( ri!Manager = true, "Approval for Product", "Add Product Details" ), contents: { a!sectionLayout( label: "", contents: { a!columnsLayout( columns: { a!columnLayout( contents: { a!dropdownField( label: "Product Name", labelPosition: "ABOVE", placeholder: "--- Select a Value ---", choiceLabels: cons!IA_ProductName, choiceValues: cons!IA_ProductName, value: ri!addProduct.productname, saveInto: ri!addProduct.

I'm trying to set up a record action to launch from a record list interface. It appears almost everything is working, but when I hit the button I get an error in the interface. The error message corresponds to a previous issue I had where the rule input (the record I want to modify) was null. Therefore I suspect it's not getting properly passed, and I called the identifier field wrong. What should I be using here?

Hi, Recently I have deployed a new application to Production environment. But facing DB connectivity issue.Please find the screenshot for reference: After creating the Data Source at Admin Console it shows Test Successful.Please find the screenshot for reference: and when I verified the Data Store, it is successfully connected to DB.Please find the screenshot for reference: Now the application starts working finePlease find the screenshot for reference: After some time I tried to login it is showing same error.Please find the screenshot for reference: I'm repeating the same steps to avoid the error. Please help me in clearing the error. Thank you.

Hi,Recently we deployed a new application to the Production environment. But facing DB connectivity issues.Please find the screenshot for reference: After creating the Data Source at Admin Console it shows Test Successful.Please find the screenshot for reference: and when I verified the Data Store, it was successfully connected to DB.Please find the screenshot for reference: Now the application starts working finePlease find the screenshot for reference: After some time I tried testing the UI and it is showing the same error.Please find the screenshot for reference: I'm repeating the same steps to avoid the error.Please help me in clearing the error.Thank you.

Hi, Recently I have deployed a new application to Production environment. But facing DB connectivity issue.Please find the screenshot for reference: After creating the Data Source at Admin Console it shows Test Successful.Please find the screenshot for reference: and when I verified the Data Store, it is successfully connected to DB.Please find the screenshot for reference: Now the application starts working finePlease find the screenshot for reference: After some time I tried to login it is showing same error.Please find the screenshot for reference: I'm repeating the same steps to avoid the error. Please help me in clearing the error. Thank you.