Data Fabric

Can we add icons or images on Record Title?

Can we add icons or any images on Record Title?

I'm trying to invoke the a!save() function when an interface loads. Is there any way to save a value into a rule input of an interface without any user interaction?  I've noticed this statement on a forum somewhere "Rule Inputs and local variables in an Appian Interface can only be updated as a direct consequence of a user interaction.". What I'm wondering about is if there is any way to mock user interaction to force a save into the ruleinput? My value is saved in the localVariable. Any suggestions would be greatly appreciated. Jan

Hi Everyone, There is chart as shown above and the requirement is to have the labels displayed beside the count which is being displayed over the graph as shown below for reference. Can anyone please let me know ow can this be done? Note: Record data was used to populate this chart

Hello, I'm trying to write a record event with specific data of the changed record, using record event as an audit table, but I'm not sure how to get the data of a specific record when I'm writing multiple record in the same node, there is any clue on it?

Hi Everyone, We have a requirement to remove the unwanted data i.e., the data without value or zero value from the mouse hover as highlighted below from the chart. Can anyone please help us and let us know how this can be achieved? The highlighted values from the above screenshot shouldn't be visible to the user. Note: Record data is being used to populate this chart  

Hey everyone, when i was doing the step by step i encounter this problemand because of this i cant find the AS_VEHICLE table to continue the exercise.Can someone help me please?

Hi, I've one scenario where i need to display data as per the filter selection, and in filter i have a date range field where user can selection up to 2 years range and data would be displayed on grid as per the filter selection.please suggest best way to do display data on grid and to export data on excel.I am using record type, and i have a date column at backend.

"I'm encountering an issue with updating an array in costAdjustments. The current code is setting the LengthOfMonth field to 6 for all items in the array, but I only want to update specific entries." a!save( local!newEstimates2, local!newEstimates2: a!forEach( items: local!newEstimates, expression: a!update( fv!item, "costAdjustments", a!forEach( items: fv!item.costAdjustments, expression: a!update(fv!item, "LengthOfMonth", 6) ) ) ) ) This isn't exactly what I need. What I want to do is loop through newEstimates and pull data from local!uniqueContractPeriods, which contains three rows of data with the fields: period, periodType, startDate, endDate, noOfMonths, and noOfDays. When the contractPeriodNum in costAdjustments within newEstimates matches the period in uniqueContractPeriods, I want to update the LengthOfMonth in newEstimates with the value of noOfMonths from uniqueContractPeriods. Below is the code I&#3

"I'm encountering an issue with updating an array in costAdjustments. The current code is setting the LengthOfMonth field to 6 for all items in the array, but I only want to update specific entries." a!save( local!newEstimates2, local!newEstimates2: a!forEach( items: local!newEstimates, expression: a!update( fv!item, "costAdjustments", a!forEach( items: fv!item.costAdjustments, expression: a!update(fv!item, "LengthOfMonth", 6) ) ) ) ) This isn't exactly what I need. What I want to do is loop through newEstimates and pull data from local!uniqueContractPeriods, which contains three rows of data with the fields: period, periodType, startDate, endDate, noOfMonths, and noOfDays. When the contractPeriodNum in costAdjustments within newEstimates matches the period in uniqueContractPeriods, I want to update the LengthOfMonth in newEstimates with the value of noOfMonths from uniqueContractPeriods. Below is the code I&#3

what is the difference between Record type and Data Store entity, I am having a really hard time understanding the difference between them, and when to use each one , a real-world examples would be great 

I want to select and soft delete multiple records from the read only grid and updation of DB should be done through process model called in related action. 

Hi community, How we can database table for application in appian version 24.3 as previously we get the cloud database .Now there is no cloud database please help us on this

I have 2 record types, totally Sync, with a relationship One Event to Many Instructions, properly related, as I have a custom record field in Event about a sumatory of an Instructions field which is correctly working... But then, when I query the Events,I retrieve nothing using: local!instructions: local!events[recordType!Event.relationships.instruction]. So I've tried to fill the relatedRecordData field in the query of events but it keeps retrieving nothing, null data. local!events: a!queryRecordType(... relatedRecordData: a!relatedRecordData( relationship: recordType!Event.relationships.instruction ), ... ), local!instructions: local!events[recordType!Event.relationships.instruction.idInstruction], How can this be? Maybe Security, how? Is it just not the proper way to retrieve its data?Thanks in advance

Hello, a!localVariables( local!number: todecimal(370737340900000.00), /* Replace this with your input number */ local!chunkSize: 7, /* Define chunk size (7 digits) */ local!divisor: 10 ^ local!chunkSize, local!chunks: {}, /* List to store chunks */ local!x:a!forEach( items: enumerate(ceiling(log(local!number)/log(local!divisor)) + 1), /* Arbitrarily large number to iterate through */ expression:{ local!iteration:enumerate(ceiling(log(local!number)/log(local!divisor)) + 1), local!chunk: mod(local!number, local!divisor), /* Get last 7 digits */ local!number: round(local!number / local!divisor, 0) } ), /* Reverse the chunks list to maintain the correct order */ reverse(local!chunks)) I want to achieve try to split the big decimal into 7 digit numbers, I want the result in the "local!x" {8765431, 7373409, 370} I hope the question is clear, let me know how to achieve this.

Hello Everyone, There is an issue in Write Records Smart Service Its not giving as output with/of primary keys in the Output section    It works for a record which takes single value as input but not working for array pv!   Please ping if anyone has faced this issue before, We,ve tried everything but nothing is working Thanks in advance.

Thank you very much for your continued support.I would like to display only completed instances in the process report.I checked "Completed" in the report filter settings and saved it. However, I'm experiencing an issue where the process instances displayed include ones with a status of "Active", or only the status "Active" is displayed.Does anyone know the cause of the problem or have any hints on how to solve it?I would appreciate your help.Thank you in advance. いつも大変お世話になっております。プロセスレポートに、完了済みのインスタンスのみを表示したいです。レポートのフィルター設定で、「完了済み」にチェックし、保存しています。 しかし、表示されるプロセスインスタンスにはステータス「有効」が含まれる、あるいはステータス「有効」しか表示されないという事象が発生しております。問題の原因、あるいは解決のヒントをご存じの方はおられますか？皆様のお力をお借りしたく存じます。よろしくお願いいたします。

In a Process Model I have added an Execute Stored Procedure and configured everything very well, in Data in the data source I put the constant with the connected system, in the name of the procedure I put the correct one and I configure the 2 input variables of the procedure, save and it is published fine and when it is executed it returns the error: ERROR: insert_in_din_tbl_tests(character varying, integer) is a procedure Hint: To call a procedure, use CALL. Position: 15, I understand that by default the Execute Stored Procedure executes with CALL without any prior configuration, but rather it executes it by default, so I don't understand how to arrange my execution.

Hi Everyone, Is there any way to export data in local variable to excel? The Actual Requirement is 1. I have created some custom columns in Record Type 2. Generated an expression using Aggregation and stored the data in local variable 3. Created a Grid Report using the local variable 4. Now I need to enable download excel option for the data available in local variable But Appian is not allowing to enable showExportButton: true(), and getting below error. Thanks in Advance

Hi Guys, I have a requirement where the user has to fill in around 5000 characters in a paragraph field, is it possible to store 5000 characters to the database ? 

Hi  I am using Import Excel to  Database Smart service and for Datasource I tried to make connection using Connected System .I called the CS in constant using  CS as its type .But in Import excel smart service , Datasource is defined Text type .Is it possible to give DB connection url string as Text and pass it in constant and then use it .If yes then what is correct connection url string?

this kind of output my SP giving me, and I have used print statement of SQL to print this output,  but when I call SP with the correct input Parameter then it's not returning the result.

Hi All, I'm getting the below errror from the recordtype Can you please help me to find the rootcause for this issue Expression evaluation error [evaluation ID = 4JPG0] at function a!recordList: An error occurred while retrieving the data for "NV_CaseData". Details: Record type is marked as synced, but its data has not yet been synced or its existing synced data has been invalidated. Contact your system administrator. (APNX-1-4198-000) Thanks, Udhaya

Are there any limitations for record actions like how many record actions we can create .

I have asked two developers about the best approach for data management in Appian. One usually uses Datastore Entities and other uses Sync Recordtypes. But, I have seen that there is a third configuration where a RecordType is related to a Datastore Entity (this disable recordtypes relationship). Which best approach is my dilemma. I have heard recordtypes limitations related to database (some datatypes capacity limits) schema, 2 millions rows storage limitation and sync issues. I haven't found documentation about best practices for data management. What do you recommend? Some prefers CDT others Recordtypes.