Data Fabric

Hi, I have a cdt that stores a list of document ids that were uploaded, how can I display all the files using document view? Do I need to use a!foreach() or is there another way?

I'm currently trying to add a Pie chart into a reporting page.The report is doing a record type query and simply pulling back IdItemsThe issue is my Items are an array The DB table looks like  1 Widget 2 Widget / Whatsit 3 Whatsit / Dohicky i would like my pie to show a slice for each item, but at the moment I'm getting a slice per item (so 3 in total)How can i split the data so i have a slice for widgets (2 items), a slice for whatsits (2 items)and one for dohicky (i item)

I have record which has " created on "field. I wanted to filter all records that is created for this year. But when I try to convert the created on field to year for comparison. It shows error.  Expression evaluation error at function a!queryRecordType: Could not cast from Record Field to Date. Details: CastInvalidCould not cast from Record Field to Date. Details: CastInvalid Any help is appreciated

I am a beginner with Appian. In the interface, I input values for each field of a record type and save them to process variables. In the process model, I want to reference the same record, subtract a specific field from the corresponding process variable, and perform the following actions: If the result is 0 or below, I want to send an email without changing the value.If the result is 1 or above, I want to save the calculated result in a process variable and send an email.Can you guide me on how to achieve this in Appian?

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.

What's the best way to have a process report that filters for all processes that have hit the end node and its blue. Basically, this sub process was kicked off by a parent wrapper process. The parent would kick off this sub process, the user would go to the first interface, we had a timeout mechanic where if the user didnt take action within a set time, it expired and hit the end node. However, going to this end event did not end the parent process and now the process is staying open. We have since fixed this and made this End Event node a terminate node, but in our process dashboard now, theres 10,000+ processes that are stuck in active status because the node was not properly terminated and the parent process is keeping it alive. This is taking up memory in the system, and I want to try to identify all the processes where this happened so I can delete them. Is there also an easy to way mass delete these process models once I have a good report that only includes them? Our

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?

Hello, Need a dashboard screen in Appian which shows the daily schedule runs on whether they run successfully or there was a failure, and show relevant logs messages to help debug issue in case of failure to load data into Appian from third party OR failure during downstream integration. Any thoughts? How can I implement? Thanks

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

Hi TeamI have an existing report, "All Tasks", which is an ARF file, of course.I am able to configure filters on the report to customise the report.My requirement is to show the report in a UI so a team lead can see what tasks have been, by whom, whether it is complete, and the duration of the task. Downloading the report and converting it to Excel is not an option - the requirement is to view the report on my site.I have an interface with a read-only grid that returns exactly the information required.Is it possible to add filters to a report backed UI?If so, how do I go about it?Thanks and blessings Stephen

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, I Need to Generate a new excel document using Export Data Store Entity to Excel Smart Service. How can we generate a new document with headers colored ?? Can we add color to a cell using Parameters: custom cell position and custom cell values, if yes how??

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