Records

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

can we create a foreign key while creating cdt from scratch?

Hi,  I created a record and using the same as a data source for the grid. But when I apply filters on the grid. I see below issue. Can someone help me understand, what I'm missing here?

Hello!! I have tried to connect azure postgresdb to the appian connection system. Created a postgres db in azure , and used that connection strings to connect pgadmin and with Data source connection system. I can able to connect the server with pgadmin client, but test connection failed with Connection system. Getting the below error(Test failed). unable to find the logs to trace the issue as well. Kindly help me in resolving the issues.

Hi Readers, Scenario : I Have 4 database tables and some columns in the tables are as below and all the table are related as below(One to many Relation) TableA: ID-A, Cluster-ATableB: ID-B, VM-B, ID-ATableC: ID-C, Node-C, ID-BTableD: ID-D, Instance-D, ID-C I have created a record with TableA and added the relationship with other records. Now, I want to display all the tables combinedly in an interface (The Interface should be combination of all tables) Could any one please let me know can we do that, if yes Please give some insights that how can can we do that ??

Hi. I'm a novice so as much help as possible would be appreciated! I have managed to work out how to extract the data I want via an API, however, there's too much of it and I get a memory error when setting the batch size to -1. Smaller batches work fine, so:1. How do I loop the code below so that it returns smaller batches (1000)?2. How do I merge these batches back into one file as would happen in a single call to the endpoint?Thanks in advance, Adriana!localVariables( local!entities: a!queryEntity( entity: cons!TDW_REVIEWERS_ANSWER_DS, query: a!query( selection: a!querySelection( columns: { a!queryColumn(field: "respondedDate"), a!queryColumn(field: "schemeId"), a!queryColumn(field: "answer"), a!queryColumn(field: "comment"), a!queryColumn(field: "reviewer") } ), logicalExpression: a!queryLogicalExpression( operator: "AND", filters: { a!queryFilte

Hi All, Is there any Upper limit of Maximum records which we can export in the Export Data store entity to excel smart service. If so what is the limit. we are having around 200000 (2 hundred thousand records). Can i export all the data into the data store entity at a single shot. TIA Harsha [emoticon:c4563cd7d5574777a71c318021cbbcc8]

Hello everyone! We are trying to understand how to manage the cloud database security in our Appian Cloud instance. We will have multiple teams working each one on the applications of its own area, and we don't want everybody to see all the tables of Appian. We were thinking about telling developers to ask the administrators to create a different db schema for every application so that every developer could see only the tables of the applications he was working on. However we read the following sentence in the following page of the documentation. "The majority of your data should be stored in the default "Appian" schema. We recommend that you only create additional schemas when your applications need data segregation and isolation." https://docs.appian.com/suite/help/21.4/appian-cloud-database-administration.html#appianprocesscreatenewschema Why does Appian recommend to store the majority of the tables in the "Appian" schema, which is visible to all t

Hi, After reading the Appian document, I did not see any way to call a stored function (stored procedures only are callable). Can you confirm me this fact please ? (If I can't call such a function, I will use a stored procedure with OUT params as a workaround) Regards

Team, Without using document viewer , we want to open a document when clicking on document link in a grid either same screen as a popup or different tab . Is it possible in Appian ?

Hi, I'm looking a reliable way to deal with concurrent DB access. So I have few questions. First, I would need to use many sequences (like Oracle) for a same table. So I've created a "counter" table to handle this :Table counter(sequence_name, sequence_value) ex: "sequence1" -> 10 "sequence2" -> 12 "sequence3" -> 56 Now I have a "contract" table in which I need to store one of the counters value in a field : Table contract(id, sequence_number, name)  How would you do, to ensure these operations are atomic ? seq = SELECT sequence_value FROM counter.sequence_value WHERE sequence_name = "sequence1" UPDATE contract SET sequence_number=seq WHERE id=100 UPDATE counter SET sequence_value=seq+1 WHERE sequence_name = "sequence1" Goal : If two different users update two different contracts at the same time, each contract must store a correct and different seq number. I was thinking about doing that such of code in a whole PL/SQL (stored proc) using such a

Hii All can anybady help me i want to cancel my application form until unless review by HR and Keep updating status in related action whether HR has seen or not? this is summary view of candidate details and this is my cancel candidate details process

Hello, I put you in context. I have a related data model and there are student and grade entities. These entities are related by a record. The problem I have is that I want to create a new grade through a related action and automatically assign it to the student. I can't do this because in the related actions list you cannot pass the id of the student to which the created grade will belong as a parameter. Any ideas to pass the student id to a related action? number is the student id

Hi, all I'm relatively new to Appian and I need a bit of help. I have an interface that displays a read only grid.. I use a record action which runs in a dialog box. Once the record action is run, the grid refreshes and displays the data that has been entered. I have a "Submit" button which I would like to hide whilst the read only grid has no data to display. Any advice would be helpful. Thanks Stephen

I have created a simple table in the same database as aavehicle and I created a data model for the table along with CREATE and UPDATE record actions.  When I add a new record using the CREATE record action and associated UI, the data does not appear in the record List until after I run a Data Sync.  When I UPDATE a record using the UPDATE record action and associated UI, the changes are reflected immediately in the record List.  I have scrolled through all pages of the list and confirmed the new record does not appear.  If I query the database BEFORE running the Data Sync, the new record is in the database.  Any ideas why this may be happening?

Hi Readers, I have created a record as below, and there are 9 users using the application, and there are 3 groups  For supposeusers are: u1, u2, u3, u4, u5, u6, u7, u8, u9Groups: All users, Administrators, App1Users, App2Users  All users group is a parent group. Users in App1Users group are: u1, u2, u3, u4, Users in App2Users group are: u5, u6, u7Users in Administrators group are: u8 and u9  Use case: When users u8 or u9 login They should  be able to see all the records entered by all members who are using the application.When users u5 or u6 or u7 login and see the records they should be able to see only the records which are entered by their group membersWhen users u1 or u2 or u3 or u4 login and see the records they should be able to see only the records which are entered by their group members What i tried: I have used loggedinuser() function it helped me see the records entered only by the logged in user only; i failed to write an exception in the filt

I am trying to pass the value of a process variable into my expression, and the expression is also used in the process model. Please, see attached image: The rule - drxxxxStoredProcedureDirDepAggregatedPaymentForDate looks like this: executestoredprocedure(  datasourceName: "jdbc/ABC",  procedureName: "dbo.procCtePaent",  inputs: {    {      name: "date_param",      value: ""    }  }).result[1]

Our store procedure on DB returns me list of Dictionary and it has over 50 columns. Before I return this to user in gridfield how to get subset of columns from that List of Dictionary? In other words i need new list of Dictionary with  just a few columns. for example  extract columns {"Amount", "id"). I'm using version 20.1