Records

Hi everyone, I have a simple process model with a single node configured as Write Records Smart Service. This process model is used to update the status of each record in a process variable which stores a list of multiple ABC Client records. The ABC Client Record has the following fields: clientid, name, status. In the corresponding Event History record I have a field for comments where I want to have the following information: "Status of " & recordType!ABC Client.fields.name & " was changed to " & recordType!ABC Client.fields.status but I don't know how to configure it properly. When I try to capture the event history for each of the records in the list separately, I encounter an issue with the standalone Write Events feature of the Write Records smart service. I can not find a way to individually reference items in the records list being updated (i.e. just like we do in the a!forEach function when

Hello, I have added new columns in the views and updated CDT and published data store. However, when trying to update the record type I'm getting below error. Note: The updated fields are reflecting in edit list after resetting the list but getting error in preview.  Expression evaluation error at function a!gridField [line 51]: An error occurred because the record types source is currently unavailable, or the query reached a timeout or memory limit.

We would like to use Smart Service to delete records from the DSE (Data Store Entity) and create records according to the input received from the screen.In this case, will the Delete and Write transactions be separated?For example, if Write after Delete fails for some reason, I would like the Delete transaction to rollback. Please let me know if there is a way to execute Delete and Write in the same transaction on Smart Service.

Not able to create a new Record Type from scratch in Community Edition I am unable to create a new Record Type with a new database table i.e. not getting "I want to start from scratch" option. Is it a known restriction or a bug? Community Edition: Standard Tier: Please let us know your inputs if any.

I created a view in SQL to calculate the age of a person.  MariaDB is formating the age field as a bigint(21).  I am connecting an CDT to this view and I need to know what the columnDefinition would be for a big integer.  I tried INT and BIGINT and that doesn't work. @Column(name="Age", columnDefinition="INT") I even tried to cast the calculated field as an integer in the SQL statement, but that did not work either? CAST(TIMESTAMPDIFF(YEAR, `CM`.`ClergyDOB`, CASE WHEN `CM`.`ClergyDOD` IS NULL THEN CURDATE() ELSE `CM`.`ClergyDOD` END ) AS INT) AS `Age`,

Here is the Problem There is a excel which having the data i want to create a store procedure that read the excel data and save this data to temp table. after that it save the data to main table. and after save into the main table, SP now truncate the temp table. can anyone write the code of SP and tell me how to use this SP in process model Thanks

Hello,  I'm facing the following task - I need to be able to generate a unique sample from a table/view. A couple of notes: This is a large table, about 25 million rows This table will need to be filtered first, then sampled To filter, this table will need to join on other tables, which is why I'd like select the random sample from a view instead of the table The random sample would need to pull from a relatively uniform/normal distribution (basically not skewed) This random sample will need to pull from live data - there cannot be a 1 day delay or anything This table is a CDT in appian, due to point 1 DB system is Oracle I don't just need a list of random numbers, but I need a sample of random PK IDs These are the things I've tried/investigated: SAMPLE() I'm not able to get it to sample on a View, it throws some sort of primary key error. People have also reported that SAMPLE pulls from skewed distribution of data and I'm hoping for something more u

While i am practicing, i created a record type and when i am trying to generate record event types , i am getting an error " You must have edit access to at least one of the applications this record type is in to generate event record types ". I read a similar content and checked the following, but there were no problems. ・Record Type is added to any Application. ・There are not Missing Precedents. I can generate record event types about 8 days ago, but I can't do it 5 days ago.  I saw an article saying that it was automatically resolved so I left it alone, but it hasn't been resolved yet. ・Similar Content community.appian.com/discussions/f/data/35375/generate-record-event-type/137648 If you know, I look forward to your reply.

I have a read-only grid that pulls the data from record type . I am trying to enhance the feature to add an update link to the page to enter new rows and thats needs to be updated in the Table .  Is there a way to achieve this without a CDT ?                                                                                                                      (or) Is there a way to update a table from the interface without a CDT?

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

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?

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.

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 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 ?