Records

I want to calculate number of working days between two dates (record field) and use the output as a custom field in the record. Getting stuck while trying to use calworkDays in a!customFieldDateDiff function. Can anyone please help

Simple explanation: I want to quickly see all of the objects belonging to the current application on one scrollable sheet of sorts (Spreadsheet, Interface, TXT, etc). Complex explanation: I can't seem to find any way to utilize readcsvpaging / readlogpaging with any of the system logs to get ALL of the application objects. I can muster up a list of Interfaces, Expression Rules, Integrations, Process Models, etc. but not ALL objects. It's already hard work to parse these individually (not that it isn't done), but I would like to know if there's a way to do this in the Community Edition / Paid Edition respectively. If anyone can provide a solution, or needs more information, I'd be happy to divulge further. Attached is a sample of retrieving information of one object. Utilizing UUID / Name, I am able to find a good amount of object information, but this does not cover all application objects. Thanks, Jacob

I  have created tables in dev but i don't have the sql scripts of those tables .is there a way to retrieve those sql scripts

Hi! I'm having trouble trying to modify this list of maps (which I get from a!queryRecordType with an aggregation). local!Grades: {a!map(Group: "A", Excellent: 0, Good: 0, Regular: 0),a!map(Group: "A", Excellent: 2, Good: 0, Regular: 0),a!map(Group: "B", Excellent: 0, Good: 0, Regular: 2),a!map(Group: "B", Excellent: 0, Good: 2, Regular: 0),a!map(Group: "C", Excellent: 0, Good: 2, Regular: 0),}, The aggregation does not allow me to get each Group in only 1 row, because I need to "count" the grades by category (Excellent, Good, Regular) I would like to display that result in a read-only grid and am trying to prepare the data before displaying it there (as I read in some other suggestions). The result I am trying to obtain is this: local!Grades: {a!map(Group: "A", Excellent: 2, Good: 0, Regular: 0),a!map(Group: "B", Excellent: 0, Good: 2, Regular: 2),a!map(Group: "C", Excellent: 0, Good: 2, Regu

 [mention:89ec515a02ff4fa28317edeb40cf0a4d:e9ed411860ed4f2ba0265705b8793d05]  [mention:f5e81b8502fa4e77ad12697686a4fc56:e9ed411860ed4f2ba0265705b8793d05]  [mention:b45a4f6a20b14a008e4e0ec732a8bf98:e9ed411860ed4f2ba0265705b8793d05]  and [mention:126a676c85024855948336691b0a7b92:e9ed411860ed4f2ba0265705b8793d05] will be there - come ask them your questions live!

Hi Export Data Store entity to csv smart service cannot work expectedly. Export Data Store entity to csv smart service only 50 columns can be used. I have more than 50 columns ,so i want to select desire column . but got error and cannot fix error.pls help !! Thanks

Hi I am having 2,60,000 of data in MS SQL Server. How can I bring all the data from MS SQL Server and store it in Appian Cloud database.

I have created a Document Name filter for documents uploaded to the current application I'm working on. However, based on how documents are set up in Appian, I am only able to retrieve the document name through Appian's Document ID. I am using a!pickerFieldDocuments() to filter by documents, but the issue is that when I type in the document name it only pulls up results based on what the document name starts with. I would like the document name filter to use partial name searching instead so that instead of having to know what the document name starts with I can just type in any text included in the name to pull up the results. But I am finding this rather difficult to do using Appian's Document ID to retrieve the document's name property. Does anyone know how to resolve this? Thanks.

Hi, I have created a user filter in record type. But user filter not displaying on frontend except list and default search is displaying. Can anyone suggest?

Unable to write to the source due to system error. Error Details: INSERT command denied to user 'dbadmin'@'%' for table `dbo`.`CM_AUDIT` Facing Above error when trying to insert data to CM_RECORD Table  After Creating Trigegr using below SQL code CREATE TRIGGER `Audit` AFTER INSERT ON `CM_RECORD` FOR EACH ROW BEGIN INSERT INTO dbo.CM_AUDIT (COMPLAINT_ID, ENTITY_TYPE, CREATED_BY, CREATED_ON) VALUES (`CM_RECORD.COMPLAINT_ID`,`CM_RECORD`, SUSER_SNAME(), GETDATE()); END

I'm using the Deployment API, specifically to import a package. In the documentation, there is no reference on how to add a package to a specific application. It's unclear then why it displays the following error: ``` INFO Inspecting the package 'Test.zip' of the external deployment.ERROR Failed to find an application [uuid=424242placeholder2424] for the external deployment [uuid=424placeholder42424]. ``` Any ideas on how to resolve this?

Hi  I want to save another column with value same as the primary key. how can i do that Thanks

I have changed a cloumn from varchar 300 to text, in dev its working fine and If I try publishing the datastore its fine in Development Environment but after deployment in SIT Environment it is giving me error on the same column while I tried publishing datastore. Database Configuration XSD Configuration

Hi All, We have a Entity based record, in which multiple views were manually created. Requirement is to set some dynamic icons or text as the name of the Views. I have tried the below code to show an icon but the output is not as expected. Appreciate any suggestions on this. Thanks in advance. View name coming with attributes as:

Hi All, I have one requirement where a entity backed syncd record list is configured with initial sort on created date column to show the latest cases first. Now they want to change this sort to change and show the oldest case first when they apply any record filter. For example: I selected a record filter to show only Open cases, then the sort of the grid should change to show the oldest case first. Any idea how we can achieve this?

Hi Champs, I want to create basic user dynamically through coding. Can that be possible? Regards, Ghanashyam

I am using write to record smart service in my process which is breaking when I start this process with a basic user who has a viewer permission on record (and that user can successfully view record details on screen). I am writing into SCC Case record without any events. Also, when I change the assignment of the node to whoever designed the process, then the process works as expected. Can you please help me with this issue ? Error The input "Records" refers to an invalid record type. The record type does not exist, has been deleted, or the user does not have sufficient privileges to access the data. Logs 2023-11-20 10:31:56,000 [ajp-nio-0.0.0.0-8009-exec-773] ERROR com.appiancorp.process.engine.UnattendedJavaActivityRequest - An error occurred while executing activity: id=268442382, classname=com.appiancorp.process.runtime.activities.WriteRecordsActivity com.appiancorp.suiteapi.process.framework.ActivityExecutionException: The input "Records" refers to an invalid

if( 'recordType!{3a147a0e-d35e-4fa0-96f7-d91590fdf68d}NZP Maintenance.fields.{b3c7019a-c216-42e6-b725-b7c67abec412}requestType'="Medical", rule!NZP_DASH_MaintenanceSummaryView(maintenance: rv!record), rule!NZP_DASH_MaintenanceSummaryViewForPen(maintenance: rv!record) )

Hi, Getting error "Preview currently unavailable due to an error on the source" while retrieving the data from DB View with Record Type also Expression Evaluation Error while querying with QE. Verified that view has a column wherein unique values are present and same is used as PK in CDT. Only thing is, this view's load time is approx. 20.17 seconds.    Anyone can suggest what would be the solution for this.

I was working to add a row in an editable grid that uses record types. I kept getting errors with indexing when I tried to use append in the add row link. I found a solution by saving a value into the list as shown: This seems hacky, but it works. Does anyone know of an easier or better way to do this?

HI Team, I am configuring the record list and i have 2 columns completed by and completed on, I wanted to show these columns only when user selelect user filter completed, How can i pass record filter value to showwhen

Problem: When applying a!toJson on a record type, record fields of type user will be converted to JSON objects. When casting the JSON back to record type, it fails to convert the user object (dictionary) to User type with error: CastInvalidCould not cast from Dictionary to User.  Example recordType!Test(id: 1, createdBy: "user 1") - createdBy record field is USER type a!toJson on the above will return a json object with nested createdBy object: {"id"=1, "createdBy": {"id":"username1"}} a!fromJson returns a dictionary with createdBy as a nested dictionary: {id:1, createdBy:{id: "username1"}} casting to recordType!Test will throw error CastInvalidCould not cast from Dictionary to User. Changing the record field type from user to text would eliminate issues in JSON conversion, but it takes away the ability to use record security rules by user fields. Another workaround is to flatten out a

Hi  I am using a!recordData to show data in my gridField  Now I have a requirement of implementing a button wherein If I click that button all the data should be selected ( i.e. the ids of all the records should be saved into a local variable ) But now I am not finding a way to index the recordData at once  Can anyone help me in this ?

Hi all,I have defined a process variable in a process model with CDT type. It is working fine in all environments. Now I am adding some new fields into the CDT and published the datastore. Its working fine in dev. When I moved these changes to higher environment( just moving the CDT and scripts and not the process model where the pv is defined as CDT type), its not working as expected. The newly added fields are not present in the CDT type process variable in the process history while debugging and the pv datatype shows with ^ symbol. Can anyone help with this?