Data Fabric

Hi everyone. I'm with a problem with a property returned from a a!queryProcessAnalytics from a Report. The Report returns this data:   And I have a problem with a dp0 field that is mentioned on the column configs as the task details: I get that field in this way: And I put all that data in a grid on an interface, but sometimes I get this error: And I show it like this on the interface: Thanks for everyone who can help me with this problem!

Hello Community,  We have a requirement to monitor the maximum number of user sessions on a day in the entire environment. is there any ready made plugin available for this? Im aware that we can use login audit csv file. But this file can give only the number of user logins on a day rather this file did not furnish the details about log out for the same user.  TIA

I want to import the excel sheet data into the table using the Import CSV to Database smart service but I'm getting the outputs that Invalid column name: First Name . Can you help/suggest on how to provide the column names?? Thanks inadvance.

Dear Team, Interface error : document does not exist or deleted error appearing. We have document id with us , todocument(docid) is giving us document name , but the same same documentid when we are passing to document() it is throwing the same error. We are also not able to search document in objects using doc id. Any idea ?

Hi all, I am using a view as the data source for an entity-backed record.  I have a field "Student Full Name" in the view, which I am getting by concatenating "Student First Name" and "Candidate Last Name" using the function concat("studLastNm", ", ", "studFirstNm"). So, for example, in the view and record the student full name will be displayed as "Brewer, Allan".  There are no null or empty values in "Student Last Name".  My CDT for view has primary key.  When I sort the view for "Student Full Name" in the cloud database, the values are getting sorted properly.  But the same in the record gives the following error: The alias [[field=STUDENT_FULL_NM, ascending=true]] cannot be used because it contains illegal characters. The alias must contain only letters, numbers, and underscores, and must start with a letter. (APNX-1-4203-009) Does the record sorting no

Hi All, We have entity backend records based out of DB view and using a!recordData in the grid to display the record list When a user uses a record search bar to search a keyword, we are getting errors ""An error occurred while retrieving the data for "Record Name". Details: unexpected error executing query" . Looking at the logs, we figured out keyword searches against all columns defined view it impacts query execution time. This issue occurred recently as the volume of data increased.   Is there any way to customize or pass a minimum number of the query filter in the record on the search bar? Currently, we are also working on the DB view optimization.

I have a synced record with a database table. I can successfully write new data to the table using the "import excel to database" within a process model. Unfortunately, after uploading new data the synced record is not updating. If I manually sync the record it will update correctly. How do I ensure the data is synced when I upload new data? According to Appian Documentation the record is suppose to automatically sync: "To keep your synced data up-to-date with the source, an immediate sync occurs whenever Appian writes to the source of your data." https://docs.appian.com/suite/help/21.2/Records_Monitoring_Details.html Additionally, I've confirmed that Sync is enabled:  Any thoughts or suggestions is appreciated.  Thanks!

We have a requirement to produce a stacked column chart that displays a count of completed requests split by how many working days they missed the SLA date by (e.g. completed within SLA, competed 1-2 days after SLA, completed 3-5 days after SLA, completed >5 days after SLA). Our table stores both the SLA date and the completed date so we have the data but there doesn't appear to be an easy way to calculate the number of working days between the two (so ignoring weekends and bank holidays). We had initial created a view and used the CASE operator to define a column that categorised each request as Within SLA, 1-2 days after SLA, etc., but this does not take account of non-working days so is not acceptable to the business. A search has discovered several database solutions that rely on creating and populating a calendar table that includes all the days of the year and whether they are a working day or not, but that solution relies on that table being maintained and updated wi

Hi, I would have a question about a refresh aspect. I have an interface (let's call it "Form A") displaying many sub interfaces depending on many conditions. In one of theses sub-interfaces, there is a RecordType grid and for each line I've set a RecordAction (called "Edit row") that triggers a process. (The user has to make few clicks on different components to see that grid)  When the user clicks on this row RecordAction, it triggers the process which displays a start form Interface (let's call it "Form B"). This "Form B" interface has 2 buttons "Cancel" and "Save" (I've set submit = true for each one). When the user clicks on the Cancel button, the process simply goes to the end node (XOR step decision is used). If the user clicks on Save, the process store data in DB and end the node. My question is :  When I click on the cancel button of "Form B", how may I do, to havin

In my Appian cloud database, I need to figure out what type to list for my resume upload field. In my database I have a blob so what do I use in Appian? I cant use a text....

Hello All, I have added readable grid into an interface and linked the record to this interface which will provide me all the fields of the record. In the record user filter option available part of the a!gridfield. In the record I have enabled set showSearchBox to true which provides us with a global search option. But I have a requirement to add filter for text field for example, Iike CustomerName The version I'm using is 21.2, any alternative way to achieve this? Thanks & Regards Girish

How can I remove accent (replace special character) from the text  Input: "Cámara" Desired Output: "Camara"

Hi all, I have created a entity-based record type which is based on a view.  I have created a user filter in the record based on a!recordfilterlist function. The user filter does not give correct result.  The field on which I am using the filter has null values in the view.  Can someone help me to fix this ussue? Thanks in advance.

Hello.I am creating a column chart that shows me the companies created in a period of time, this part is done. But now I need to create an average line in the report that shows me the average number of companies created in a year. It is possible to do it in Appian, I am new and I do not know if it can be done. 

While creating record type, why we create additional views except summary view in record views?

Hello Everyone, I am using below pagingInfo , gridcolumn , and pagingSaveInto in my interface where Approval Date is of datetime type local!pagingInfo: a!pagingInfo( startIndex:1, batchSize: -1, sort: a!sortInfo(field: "APPORVAL_DATE") gridColumn( label: "Approved On", sortField: "APPORVAL_DATE", value: fv!row.APPORVAL_DATE ) pagingSaveInto: local!pagingInfo  If approval date is between 7/1/2021 and 7/12/2021 then  Expected result to be sorted by Date ie. 7/12, 7/11, 7/10, 7/9, 7/8, 7/7 and so on but sorting is not applied to the grid and resulting data is random sequence like 7/11 7/12 7/1 7/2 and so on. Thank you for suggestions in advance.

 Hi all,I want to sync data from my database view to record type but it is not visible. Other object from database that is table is visible. Can someone confirm that this is Appian limitation so that I can ask my DWH to create table with data from that view?Thank you.

I have a record for cases I have been creating in my app.On record grid when I click on caseIds a process model is invoked and flow is taken further.I want to create for url for different records based on user need. For general records with summary view I am aware of the steps.How do I create for this scenario where I dont have summary view/related actions;just record grid with each id invoking new process. Early response is appreciated thanks!

The following "Generate Summary" is missing from my record view. Is this something that isn't included in version 21.1? 

Does "Report Builder wizard" which is available as a template at the time of creating new Interface, can also be available at a site for the common users so that they can build custom report and download the same at excel format as per their personal requirement? If yes, I shall be grateful, if anyone can please explain how it can be implemented.

Hi All, Does anyone knows how to add custom record field in new record 21.2 with below scenario? Custom field need to add on single DueDate record field.  1. Groups based on Date difference does not work here since it required to two date fields.(Start and End date) 2. Own expression having limited functions to use(Why there is limitation on using functions while creating custom record field? Will it be changed in next upgrade?) My scenario would be like this.(Below is SQL statement) IF( TO_DAYS(`CASE`.`DUE_DATE`) - TO_DAYS(CURDATE()) > 0, 'Before Due Date', IF( TO_DAYS(`CASE`.`DUE_DATE`) - TO_DAYS(CURDATE()) = 0, 'Due Today', IF( TO_DAYS(`CASE`.`DUE_DATE`) - TO_DAYS(CURDATE()) < 0, 'Missed Due Date', 'N/A') ))

Can the query data size could be more than 1 MB, if yes, how to find out exact size in appian ? 

Hi, We are facing the below error while trying to execute the expression rule to fetch data from data base table: An error occurred while evaluating expression: listofIDtodelete:rule!abc(cons!xyz) (Expression evaluation error in rule 'abc' at function a!queryEntity [line 5]: An error occurred while retrieving the data. Details: Memory threshold reached during output conversion (rule: [queryentity expression], type: [DataReportDT7042], threshold: [1,048,576 bytes], objects successfully converted: [131,071])) (Data Outputs) Please provide your help regarding the resolution of this issue.

Hello, The data in my database is of form yyyy-mm-dd. While filtering data, I want to ignore the year. How can I do it? Thanks.