Records

Hi All, i want to hide Readonly Record Grid, in case it's Empty or no data contain. by default it's shows empty grid with message,  Please advise. Thanks in advance. 

Hello All, We observed one issue 1. Parent CDT -> one of the columns type is document 2. We updated the child CDT (added a new column) upon updating the child CDT, the parent CDT filed type changed from document to anytype. Did anyone face the same issue?

Hi there, in a record type, i have two user filters. just put them here as filter1, filter2. just want to dynamically display the drop down options for filter2 based on the selected option in filter1. how to implement it, how to get the selected option value of filter1? Anyone has experience/information please help. regards L

Hi Community I have a case that I need to decrement counter in foreach loop is it poosible ? My code: local!numbers: {2, 12, 14, 22, 32}, local!counter: 100, local!loop: a!foreach(      local!numbers,      /* need here to decrement the counter */ )

Please tell me how can I add a task in tempo, as I wanted to add approval in my task tab.

Hello All, Is there any way we can convert a datatype of column while querying from DB using query entity? Thank you in advance.

Hi all, I hope you're well [emoticon:c4563cd7d5574777a71c318021cbbcc8] I've got a Record pulling information from a SQL database. The Record displays all the relevant information in Tempo along with various filters to choose from (ie: date range, status type, user role). It also displays the 'Export to Excel' button. I'd like to once per week have the Excel document with filters of my choice (eg: status type: Complete + user role: Front Desk) for the last 10000 entries automatically be created, attached to an email automatically, and emailed out automatically. How do I achieve this? I've tried the 'Export DSE to Excel' node in a process model and then a 'Send Email' node. But I'm not sure how to have the 'Export DSE to Excel' node generate a document that has my filter requirements and the nice readable layouts the Record has. At the moment the 'Export DSE to Excel' node is just generating a document with all the ent

Dear all, I need to turn the results of the below query into an array including all "submissionunit"s to further use the wherecontains() formula on that. Could anybody tell me which function to use to create an array in that case? local!datasubset2: a!queryEntity( entity: cons!MR_ABGABE_DSE, query: a!query( selection: "submissionunit", filter: a!queryFilter( field: "submissionperiod", operator: "=", value: local!period ), pagingInfo: local!pagingInfo2 ), fetchTotalCount: false ) Thank you very much in advance! Chris

I want to create a site to collect error records. We will not have access to link it to our internal RDBMS. So, want to know where this data will be stored in Appian and how to do it.? Also, will we be able to fetch data through any query?

I am getting an error   "???errors.invalidParameters???" when attempting to execute a SQL Function. Here is my sQL select statement for my function: SELECT * FROM [dbo].[p3_labor] (   <@inv_mast_uid, int,>)GO a!executeStoredProcedureForQuery( dataSource: cons!POO_P21_Connection, procedureName: "p3_labor", inputs: a!storedProcedureInput( name: "inv_mast_uid", value: 114530 ) )

Hi All, we have expression backed record with multiple user filters. Record list is filtering with userfilters working as expected. where as when we click on the Export to Excel we are ending up with  "At function a!queryEntity: cannot apply a filter with blank field name. please contact a system administrator for additional details" in exported excel sheet. At List level filters are working as expected. Export to excel is not working. when we choose only single user filter that time export to excel i working fine. only issue coming when we select the multiple filters. we are passing the filters using rsp!filters to list view expression rule as a parameter of type anyType. Please let us know is it a known issue or any workaround to proceed. Thanks in advance.

Hello, I need an Export to Excel button to get an Excel file from the data in a grid (getting a report). I have tried to do it from different perspectives: -I've tried to do it using CDTs (using the respective Smart Service tools Appian offers) wether it was in an Interface (in order to be able to download it there and then) or in the Process Modeler -I've also tried the SQL to Excel plug in node (due to the data being the output of a stored procedure), once again in the Process Modeler (as far as I'm concerned, I haven't found a function with the same goal. The closest I got was with the first option, but due to the changing nature of the project I am at the moment, the CDT I was using soon became obsolete and since then I've been trying to get around using one again without success. P.D.: I'm using Appian Community Edition due to not really knowing the advantages of becoming an Appian partner/customer. Thanks for your time, Francisco

Hi Appian, I have a use case to create a CDT for an oracle table. The id is configured as below, I am trying to create CDT with not specifying the sequence using JPA Annotation @GeneratedValue ( please find example 1 XML) when I do this the datastore doesn't publish. When I tried to publish my CDT with Example 2 CDT then write to db calls fail with error : ids for this class must be manually assigned before calling save().Curious to know if we can create a CDT with no sequence and make the inserts work from Appian ? Oracle Code for ID: "ID" NUMBER(38,0) GENERATED BY DEFAULT ON NULL AS IDENTITY MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER  NOCYCLE  NOKEEP  NOSCALE  NOT NULL ENABLE,  Example 1 XML: <xsd:element name="id" nillable="true" type="xsd:int"> <xsd:annotation> <xsd:appinfo source="appian.jpa">@Id @GeneratedValue @Column(name

Hi, We have a process that calls a stored procedures to modify some data records. These data are used by a SYNC Record Type in the application. To make synchonize and refresh automatically the RecordType from the Appian application, we added in the process a Smart service (Write to Datastore Entity) that updates a field of the concerned records, this works fine. Now, we have a stored procedure that cleans the DB (deleting a lot of rows of many tables). So how would you tell to Appian that the data have been deteled ? (the Record types still display the same data because they did not have been synchonized)

Hi  Can we dynamically pass a value to the Userfilters in a GridField if we get data using a!recordData Scenario is we have a drop down in a screen where user select the status. based on that record data should be displayed Thanks in advance

Hi,    I have a requirement that  in the related action ,visibility   if the user not in the group then need to have a message that you don't have permission to have this related action else user can do related action.   But i want this action to be done without clicking on related action (by default depending on user). Please suggest any  solution for this.  Thanks & Regards, saidivya Minna

Hi, My entity is a sql server view. The first field is a nullable varchar.  When this field is null  or a zero length string , it appears in the created file with double inverted commas and not blank. All subsequent fields return nulls or  zero length strings correctly  as blanks ie ""|value1|||value2value3|value4|||value5""|value6|||value7 If  I create a UTF-8 csv file manually in excel with the first column as blank, it does not add double inverted commas, which is what I would expect ie |value1|||value2value3|value4|||value5|value6|||value7 Has anybody had a similar issue ? Thanks  

 i have performed  calculation of some status staying  in  grid  and that is changing on everyday basis i am not storing that value in any database . and that status calculation is happening and dependent on many field . how can i apply sorting when dependency of that data is not on any particular field.

Hi, Why It's taking longer time to save the data into the database. Regards, Supriya

We've been trying to send a customer id from one interface to another but haven't figured out a way to do it without using process model. Is there any way to do it without using process model?

Hi!!! When we create a database and define there the relationships between tables using FOREIGN KEY... REFERENCES... all the systems can automatically retrieve those relationships and represent them, but Appian does not do so. Why Appian do not reflect the relations in the Record Types? If we define ONE relationship 1:N in a database, there are indeed two implicit relations: a relation from 1--->N and another form N-->1. Why Appian adds a direction for the relations? Is there a reason for that or any type of advantage to define specifically a direction for a relation? Thanks.

whenever we click on record link in grid it defaulted take to summary view page . Can we implement changes like when we click on record link it would get defaulted  to related action page instead of summary page?

Hello, I have one main dashboard that displays a readonly grid which has as datasource one expression rule in which i have a a!queryProcessAnalytics. In the grid that I display I'm using a!processTaskLink(). The problem is in case an action is taken on one task where it should return back to the same user, it won't be displayed in the grid anymore (most of the time), only after they refresh the page. I would like to avoid the refresh button on the page and I have also tried with refreshVariables and it doesn't work. Any ideas how I can refresh first the grid and then display the page without being necessary to refresh the page? Thank you!

Hi Team,I have a CDT in the below format :  id , item id, field name, field value, field seq no where id is the primary key. Eg of values : 1, 1,  Name, Alex, 1 2, 1, Age, 45, 2 3, 1, DOJ, 2022-04-05 08:56:00, 3 4, 1, Designation, Engineer, 5 Field values in the above CDT are taken from user input in a form. I have another CDT in below format :  id, item id, value 1, value 2, value 3, value 4, value 5, value 6I want the field values from 1st CDT to be saved to value columns of second CDT as per field seq no. Like for the above example of CDT 1, my CDT2 should return :  1, 1, Alex, 45, 2022-04-05 08:56:00,  null,  Engineer,  nullHow can we achieve this in Appian? Our first preference would be achieving this either in an interface or expression rule. We use process model in back end so we can use that also.Appian version 21.1 Any suggestions would help us out.

Need to increment serial number in read only grid as to use in first column. If some of the entries been get deleted then the serial numbers be like,, 1,2,3,4,5.....