Records

Hi all, I'm fairly new to Appian and having trouble filtering a record type.  The field I'm trying to filter by is a boolean. When it's approved, the field changes to 1, if it's denied, changes to 0. But if it's neither approved nor denied, the field is null. I need to filter out all the fields with a null value. I'm currently using the guided configuration and have tried = null, = a!isNullOrEmpty(), <> {1, 0}, and a variety of other methods but none seem to be working. I'm currently working to see if I may need to write it in expression mode instead, but any help or guidance would be appreciated. Thank you!

Hi,   While querying a record data using a expression rule invoking a!queryRecordType from a Timer event results in the "ERROR:EVAL:@reason=Assignment in invalid location" error and Pauses the Process instance. The expression rule seems to work fine from other places like a script task. Please revert back if any solution is found for this or facing similar issues. -Marimuthu S

I have access to an external mysql database. I am able to connect using: command line in linux, windows, workbench, etc. Also no issues with the IP from the caller. When I try to create a Connected System using MySQL datasource definition it always fail to connect. But if I change the DataSource to MariaDb it all works fine, even if it is a MySQL Database. 1

I have created a service backed record having data source as integration. The record data source expression is returning around 500 records but when I try to access it through tempo record it is giving me expression evaluation error that batch size is 100 but largest colum value is 500. Can anyone suggest me how can I set pagination for my record type to get all the data receiving from integration in order to resolve this issue.

when we use the  a!recordActionField function, on the interface by default we are getting tooltip same as the Display Name of the record action. Is there any why to remove this tooltip?

Hi Readers, i have queried a record but getting some unrelated data which need to be ignored would like to know how can we do that in this i just need that number 12, only the number need to be displayed, tried .data at the end which gives the list of records Same in this as well i just need the calculated value only to be displayed.

HI How to Pass record type filter selected value to rule input of other expression rule. Example: Status :NEW is selected in the record type filter in the interface . Need to pass this value to other expression rule.

Hi All, I have created a Data Type and added test data. If I delete a row from the table in appian cloud database, where can i find the logs for that deleted row. I can able to see the deletion activity under <Appian--home>systemlog->audit->rdbms. but not the actual row data. But after deletion , i want to recover the deleted row in appian.  is there any way to recover?or is there any logs available? Kindly help me on this.

Hello Appian and community  Is there a way or allowed to connect cloud appian mariadb with a IDE like dbeaver or a mariadb supported workbench etc. If so please let me know  can we just use this JDBC? or other way  driverClassName="org.mariadb.jdbc.Driver" url="jdbc:mariadb://myinstance.appian.community:3306/Appian?useOldAliasMetadataBehavior=true" or any video if someone has will be helpful Thanks

I want to save the value for Ownership % field (last column) in the below image, as absolute values, i.e (Number/100) E.g. If a user inputs 46.00 in the Interface Dashboard, the database would store it as 0.4600 If there any workaround to achieve this?

Hi    In my interface we are having on filed as time (Text field). User will enter time in a format 00:00 AM/PM .while storing to DB its store as it is .Need to save this value in DB as UTC can we have any function to convert or how we handle this in save into.

I am creating a paging grid with selection that is based on a recordType! in my environment. My interface is set up to follow the paradigm in https://docs.appian.com/suite/help/22.1/grid-with-selection-pattern.html#[line-1-54]-define-local-variables-and-grid-data but with the "data" parameter in the gridField obtained via recordType. Code below: a!localVariables( local!selection:index(ri!selectedStuff,"id",{}), local!selectedRows, /*this is what i need to populate*/ .. a!gridField( data:recordType!Foo, selectable:true, selectionValue:local!selection, selectionSaveInto:{ local!selection, a!save(local!selectedRows,append(local!selectedRows,fv!selectedRows)), a!save(local!selectedRows,difference(local!selectedRows,fv!deselectedRows)), a!save(ri!selectedStuff,local!selectedRows) } ) ) In my use case, I want to be able to pre-populate my local!selectedRows so that the grid can be pre-selected coming into the screen. This is an entity-backed record, an

Hello! I have a process model which gets the user name and current date to create a log of users and the last time they logged in (Writes to Data Store); this works however I am ending up with multiple records for each user and I wanted to set this so it only creates unique users and captures the most recent login date for existing users.Currently the user Id is simply an integer and each time user details are captured a new record is created with a new integer - I have an expression rule which I can use to query the username (known unique field) and return other details ("userId", "Date" etc etc) I was hoping to check this and if a user "exists" in the Record Type only update the date.Any ideas at how I can update the process model to do this?? I was initially thinking/hoping I could run the expression rule from the process model(not sure how?!) then have an XOR gate to check if userId not blank then create a new user record in data store else p

Step1: I have a record type backed by a Webservice. My expression: local!integrationResponse.result.body.rawData returns list of dictionary as below: List of dictionary - 4010 items Dictionary - Region "" (Text) - State"" (Text) When I tested data source, I got below error in record type: The Record Data Source did not evaluate to a DataSubset. Received: List of Dictionary. Step2:  I modified my expression as todatasubset(local!integrationResponse.result.body.rawData). Now the record type displays 4010 empty records. May I know how to resolve the dataset returned to match the datatype of the record.

Added a field to a database table.  The CDT based on the table does not have the new field after running SYNCH. Not sure of the correct way to accomplish.  If need to  Download XSD, make change manually, and then Upload XSD, what is the process to upload XSD and apply it.

Hi all, I want to add multiple customer data into Database table named tbl_Customer. The requirement is like customer has 4 fields (ID, Name, Department, DOB), there is a grid, I want to add these records, if user want to add new rows, so he can do, and finally want to save these customer details in database table. And each customer will have a primary key. Kindly help me with this requirement. Steps wise soln would be highly appreciated. Thank you in advance! Regards, Shubham Kumar

Hi Team, I am showing all required data element in the "Summary" tab and I am providing required related actions on top right of the Summary page. Now, I have a scenario like, when he user clicks on the "ASSIGN TO ME" related action, there is no form where user interacts. I have to save logged in user details in the database. I know like, whenever we are handling with related action, we have to select a Process Model and generally we will assign a start form in the process model. This is how we will handle most of the scenarios. But, in this case I don't have any screen/form where fills the data or do anything. If user clicks on the "ASSIGN TO ME" related action, I have to save his logged in user name in the database against selected record. Any advises please.

Hi there, I have a record type, want to show the time date either is null or earlier than today. Could anyone here how to combine these two filters together?   a!queryFilter( field: 'recordType!{30a8a442-d786-4e84-a096-714b5ce3577a}CPD_peng_test.fields.{countedTime}countedTime', operator: "is null" ) a!queryFilter( field: 'recordType!{30a8a442-d786-4e84-a096-714b5ce3577a}CPD_peng_test.fields.{countedTime}countedTime', operator: "<", value: todatetime(today()) ) regards, Lin

Hi, My requirement is to add search in Records. Eg- I have 2 Dropdowns for Country and State. The Dropdown country has list of all the countries and the dropdown State has list of all States for all the countries. If i select Country as "India" from dropdown then the list of all the states of India should appear in States dropdown. This search is possible in interfaces,but my requirement is to have  similar in Record. Thanks in advance

Hi Readers, I have a scenario where i need help to complete. The scenario is i have 2 record types they are which are related as one to many relation Below are the two table table: Table_A and Table_B which are related by CLuster_ID one to many relation ship Table_A: Number of records in table_A are 4 Cluster_ID(PK) Cluster_name 1 Cluster-1 2 Cluster-2 3 Cluster-3 4 Cluster-4 Table_B: Number of records in table_B are 8   VM_ID VM_Name Cluster_Name 1 VM-1 Cluster-1 2 VM-2 Cluster-1 3 VM-3 Cluster-2 4 VM-4 Cluster-2 5 VM-5 Cluster-3 6 VM-6 Cluster-3 7 VM-7 Cluster-4 8 VM-8 Cluster-4 Here table_B is used as the final interface to view the data, hence i have used record link to get the summary view for both table on VM_name and Cluster_name For VM_Name the summary view is working fine for all the records but for summary view for cluster_name in table_B its working fine for only 1st four rows and for the rest of the rows getting error as below s

We are trying to clean up unnecessary documents in our Appian instance. We would like a way to do this process but also have a way to recover the files that we delete if we need to roll back. Is there a process we can go through to backup Appian documents on the backend? We are on-premise. I am concerned that when they are deleted on the front end, then the metadata will be gone from the meta-database and they cannot just be put back in the backend folder system. Thanks

I am using an integration to grab a bunch of numbers from an external source. Most of the numbers are fine, but some are exceptionally large or small to the point that they come in in scientific notation. Examples include:   2.2141276E - 5 and  2.1383022233807285E11 Both of these numbers give me separate errors. For the first, I'm getting an "invalid double value", which I seems to be due to the spaces in there so I need to I guess strip the spaces, despite it not being a string? I think one way or another I can find a way to deal with that. But the other error I get is when actually writing to the database. I keep getting an "Out of range value" error despite having set the db field to accept 20 digits. 

Hi Readers, I have 4 database tables with which i have created 4 record types and added relation ships in it. cluster, vm, server/node, application  All the record types are related as below. now after this to get the overview i have created an another record type and linked with the other record types to create a grid view with all the columns present in all the record types. everything worked fine till here  Individual summary view is working fine i.e., summary view of Server_node record view is working fine, But the summary view when clicked from the overall view which is created from the last record type i am getting error as below,  there is a column named nodes which has records node_1, node_2, node_3,...... node_12 the values are created with record link  the summary views are getting jumbled when clicked on node_1 i am getting error as  when clicked on node_2 i am getting the summary view of node_1 when clicked on node_3 i am getting the summary view

Hi,  Could you please help me creating an interface where I can query for deactivated users. The interface is to start a process to reactivate the user. So far I have tried two methods unsuccessful: 1. User picker field only returns active users.  2. Record picker field on RecordType 'User' does return all users in the search field, but when I select one I get a uuid as a result. I haven't found a solution to return this uuid back into a User type. Please find my code here below.  a!localVariables( local!user, a!formLayout( label: "Heractiveer account", contents: { a!pickerFieldRecords( label: "Record Picker", labelPosition: "ABOVE", recordType: 'recordType!{SYSTEM_RECORD_TYPE_USER}User', value: local!user, saveInto: local!user, validations: {} ) }, buttons: a!buttonLayout( primaryButtons: { a!buttonWidget( label: "Heractiveer", icon: "check-circl

Hi everyone I have to build someting liske this  I have already tried using tab + read-only grid, but I lose the sort function and a scroll bar appears for each grid, the result is not very nice to view. Could you please give me any suggestions? Is there a plugins doing this? Is possibile to modifiy colums color at least? thanks