Data Fabric

Hi folks , I have a look up  table named "gender" , I want to develop a interface using which i can see,  add add, update , delete values in table without going in the appian cloud directly instead we want to perform this from the interface . For example i have genderId and gender column in lookup table , where there are two entries male with id 1 and female with id 2 , how can we add another gender in the table  directly or delete male row  from the table or update it. I hope you guys understood my query . Thanks in advance. 

For subprocess and start process smart service if we change assignment to :-  This node will be assigned as a task to a person or a group of people We are able to add interface on Forms tab. What is the use of it ? And if we change values in PV, changed values are not getting passed to child process.  Parent process variables have updates values.  But child process has old values. (Not updated in this start process smart service Form ) Find document for reference. [View:/cfs-file/__key/communityserver-discussions-components-files/65/Defect-in-Process-Model.docx:320:240]

I am trying to create a user filter with the results from an expression rule which displays distinct options from my table. I have researched the documentation, and was unable to find any answers with an example.  How do I call the expression rule to populate the options for this user filter based on the results from the expression rule I have created? Many thanks in advance for your assistance.

Hi Champ, I have a use case where I am getting the constnat name (in text) and I have to pass that in Update constant service. But here the issue here is I am unable to pass the constnat name dynamically there. As the name is text type and it's expecting something of constant type. I don't see any option to cast it too. Only way possible here is selecting consttant from the menu ; but I can't do that as it's dynamic in my case.

Using v21.3. I'm fairly new to Appian. While tailing the tomcat log, I see when the ObjectSynchronizer runs, I get the following: ... WARN com.appiancorp.common.ObjectSynchronizer - 1 services were missing users.... ERROR org.hibernate.util.JDBCExceptionReporter - ORA-00001: unique constraint ([constraint name]) violated I am attempting to see the actual sql causing the issue. I modified appian_log4j.properties as follows:from "log4j.logger.com.appiancorp.common.ObjectSynchronizer=INFO"to "log4j.logger.com.appiancorp.common.ObjectSynchronizer=DEBUG" However, the tomcat log file does not produce any additional entries. Is a restart required? Would the debug entries be written to a different file? Is there another logger that needs to be modified? Any help would be appreciated.

Unable to fetch the data from database through a!queryrecordtype in High Availablity environment set up and its always returning null value eventhough data is present in the table. Kindly revert to me if anyone aware of the fix. Thanks for your help in advance!!

When updating a record, using the update related action, the process gets stuck on the write records smart service. I've checked the permissions, and they should be fine. It's worked thus far, however now we can't update anything. The process is not throwing and errors, nor is it providing any useful information. Additionally, this is the error that the user gets:

Is ther any limit for number of columns/rows for using this smart service(Export Data Store Entity to Excel Smart Service). Nothing is mentioned in documntation regarding this limits

Hi All, I'm encountering an issue with syncing data in Service based records. Here are the details: - I have scheduled a full sync, but it only occurs once per day. - The API data can update multiple times throughout the day. so I set up the sync expression rule for multiple daily syncs. However, I've observed the following issue when running the "Sync Records" smart service: - If the API returns fewer rows than the current record, the old data is not being removed after the sync. For example : currently record has 40 rows and now the API returns 15 and I see all 40. Has anyone faced a similar issue or have any suggestions on how to resolve this?

Hi Champ, I have a usecase where I need to pass the milestone which will be dynamic to interface where that is being used in record summry page. Can I do it by someway? Regards, Ghanashyam

Hello, I have a rule in which I would like to send a day, month or year as a reference and have it return the corresponding records. This is my code a!queryRecordType( recordType: 'recordType!{5871e10b-6fc1-4f38-a51a-becdd72dcf12}AOC CLAIM', fields: { 'recordType!{5871e10b-6fc1-4f38-a51a-becdd72dcf12}AOC CLAIM.relationships.{f1cf2f3a-4ab2-483a-837d-630a35530587}area.fields.{12767694-751c-4c75-8f60-5c0c1ce095ff}value', 'recordType!{5871e10b-6fc1-4f38-a51a-becdd72dcf12}AOC CLAIM.relationships.{a51767bd-0bc5-405c-9791-69b30b3e44c4}status.fields.{74564548-1877-4eb5-9591-25652490fc06}value', 'recordType!{5871e10b-6fc1-4f38-a51a-becdd72dcf12}AOC CLAIM.fields.{9b248167-138b-46e6-88ce-7c2cc3df93bc}id', 'recordType!{5871e10b-6fc1-4f38-a51a-becdd72dcf12}AOC CLAIM.fields.{bd5d065d-3a84-4456-9b71-26fab0f1ef07}startDate' }, filters: a!queryLogicalExpression( operator: "AND", filters: { a!queryFilter( field: 'recordType!{5871e10b-6fc1-4f38-a51a-becdd72d

Hi, From the below screenshot in the Dropdown filter i am selecting "TEST" where every letter is capital so in the below grid the data has to display only the data which is exactly match the "TEST" filter but it is also displaying irrespective of case insensitive which means data like "test" also getting filtered & displaying the data in the grid. But we want exact match we are selecting in the dropdown filter that data only needs to display in the  grid. Kindly Suggest on this Grid Filter Code: Grid Row Value:

I have Data from an Integration call that is to be displayed in a ReadOnly Grid in descending order for ease of reference. The Local Variable is structured as follows: local!Data.result.body.contactData contactData is an array containing ContactNumbers and each contact number's count of Sources i.e. where the number came from/ number of data providers that provided the number. I want to sort the ReadOnly Grid such that the Initial Sort is based on Count of Sources in descending order i.e. The Contact number with the highest count of sources should be at the top. The Sort info below logic does not work for me a!sortInfo( field: local!Data.result.body.contactData.numberOfSources) Order Descending Any ideas on the correct approach? Thanks for your help in advance.

Hi All,Here is the scenario, I have two databases called AppianHLS and AppianTLS on my MSSQL server respective to two different applications HLS and TLS in Appian. Now, the AppianHLS DB has 3 tables, let's say HLS_table1, HLS_table2, HLS_table3 and a view called HLS_view1 which joins all the 3 tables on some conditions. Also I have a table called TLS_Table1.My requirement is to create a view TLS_view1 in AppianTLS DB which gets all the columns from the view - HLS_view1 and joins with the table - TLS_table1. I have created the view TLS, and the view is working completely fine and showing the data in the database end. Now in the appian application TLS, I have created a cdt for the view and then a record type for this entity. While adding the data source, I have selected the entity and in the data preview, I couldn't see the data and it  is showing that - "Preview currently unavailable due to an error on the source" and when I checked the logs it is showing the exce

Hey appian community, In the highlighted portion of the graph below, I'm trying to figure out how to have the axis formatted for large numbers (Ex. 1000 should be 1,000). The measures used in the charts are already formatted correctly with the appropriate formatValue: Dollar, Integer, etc. The tooltips also display the formatted value correctly. My only issue is the axis of my charts. Please help me out, and thanks for your time. 

I have the requirement to find the difference between two record values of a record type like we do in case of cdts using cdtdifference(). I have the previous value of record type and then new value, I need to populate Audit table using these difference values. Any function like cdtdifference() or any workaround to do this?

Hello, I have a large record type (over 30'000 lines), that I display in a gridfield, with many filters.  Client needs to export this data to Excel, so I allowed him with the "showExportButton: true". Now some newbies think my system can send them the 30'000 lines, and they click the button... several times. This is costly to the system, breaks performance for everyone, to no avail! I think there is no way to hide the "export" button when to many records in my recordData set. Or is there? @Appian, this would be a good feature, wouldn't it? I see the number of lines at the bottom of the page, so it looks easy to the gridfield object to access! Please think about it, or provide guidance to work this around, please [emoticon:6d505171faa4497c85c5ca27290c555d]

Hi everyone, I have a database view that contains a total of 62 fields. Most of the fields are empty except for the first few fields, some fields in the middle of the view, and the last two fields. It is crucial that the order of these fields cannot be changed. I'm creating a process that returns the data from the view to an Excel file. I'm using the smart service "Export Data Store Entity to Excel", but it has a limitation of 50 fields, so I cannot export all the fields to an Excel file. As a workaround, I have tried the following: I split the CDT that points to the view into two CDTs (each with half of the fields of the view) and linked two "Export Data Store Entity to Excel" nodes. The first node generates the Excel file correctly from cell "A1" to cell "AE1". I pass the resulting document as an input parameter to the second node in the "Document to Update" field. Additionally, in the second node, I use the data store enti

Hi I am trying to create a small application related to Internet bill tracker. Here user need to update few details and need to attach internet bill file of the particular month. So in Interface I have added few components like Bill amount, Month of the bill, uploaded by, File upload etc.  To store the uploaded files I have created a folder in my application. I have consider a local variable (local!file) as local file and the value is saving into local!file. While filling the form I am able to upload the PDF and same is stored in that Particular folder. But in Records I'm unable to get option to see that particular file and also Admin need to download the same PDF from the record section.  Please help me to resolve this issue. 

Scenario: I have a record like below: Container Record which has fields like id, caseId, claimsId, providerId and these 3 fields point to primary keys of 3 other records Case, Claim and Provider. Whenever an entry is made in Case an associated entry is made in Container for fields id and caseId Whenever an entry is made in Claim an associated entry is made in Container for fields id and claimId Whenever an entry is made in Provider an associated entry is made in Container for fields id and providerId At any point there would be only 2 column in Container which would have values. On Container we also have added custom fields to fetch other data fields like summary from Case, Claim, Provider and each of these 3 records have summary field We are using realtime custom field using customfieldmatch to decide which related record should be used to get the summary field for the custom field by looking at which identifier is not null. a!customFieldMatch( value: 'recordTyp

Hello, I have create a Process Task Report having as Report Context multiple processes. I used the a!queryProcessAnalytics to retrieve the data, the only problem is if in column "Assigned to" (tp!assignees) if I have multiple assignments (Group1 and Group2 or Group1 and User1) I won't be able to retrieve the tasks based on the loggedinuser and the groups that is member of (having only one assignee it works.) logicalexpressions: a!queryLogicalExpression( operator: "OR", filters: a!localVariables( local!groups: getgroupsformemberuser(user: ri!user), { a!forEach( items: local!groups, expression: a!queryFilter( field: "c1", operator: "in", value: fv!item, applywhen: not(rule!APN_isBlank(ri!user)) ) ), a!queryFilter(

Currently, we have the database time set as GMT which is four hours away from the Eastern time zone. We are running into issues with Time based search and bots processing of cases for a certain day since the server time is different. 1. Is it possible to update database tiezone to EST? 2. If we updated to EST what will be the impact of Existing application?

Hello, I'm getting this weird whenever I pass in the rv!identifier of a record  Here is my related record action below. I'm only passing in the rv!identified which should be stored in the corresponding rule input ri!projectPlanId When I pass a test (i.e projectPlanId = 82) the interface works like I want it to. But when t is passed through the related record action, and test it through the site, the error persists.  is there a typo I missed or am I missing something more complicated here. Isn't the interface supposed to take in the rv!identifier, which I know is a number. Or am I messing up somewhere else? If anyone likes to see snippets of code, I'd be happy to provide some. Appreciate all the help!

How to get access to Process Mining Site in Community?

Hi. I am having issues creating a new recordType with the below code in a editable grid. Things of note 1. mouId is a foreign key in the record. 2.The primary key id is set to autogenerate. addRowlink: a!dynamicLink( label: "Add Risk", saveInto: { a!save(local!data, append(local!data, 'recordType!{3575b740-8740-41f7-83b5-1f1ed66f6a1a}DSC01_Risk'(mouId:ri!mouId,updatedOn:today(), updatedBy:loggedInUser()))) } ), Error code: "Interface Definition: Expression evaluation error [evaluation ID = 8DQ5R] : An error occurred while executing a save: Expression evaluation error at function 'append' parameter 2 [line 116]: Keys must be record field references or record relationship references"