Data Fabric

Is there an integration available for Appian and Alteryx? The goal would be to use Alteryx functions on the Appian record data.

Hi, I am facing an issue where I want to add all the value of a column and display it on the top of the gridfield, The source of data is a recordType (Adding the code down below), Please help me with this. { a!textField( label: "Sum Of Values", labelPosition: "JUSTIFIED", value: a!currency(isoCode: "USD", value: 0), readOnly: true ), a!gridField( labelPosition: "COLLAPSED", data: 'recordType!{b43afdfb-93b4-4d94-9708-ffa71f87754a}MWM Test', columns: { a!gridColumn( label: "Value", sortField: 'recordType!{b43afdfb-93b4-4d94-9708-ffa71f87754a}MWM Test.fields.{2682c5c7-76eb-4a9a-abf5-d409f2bc3f80}budget', value: a!currency( isoCode: "USD", value: fv!row['recordType!{b43afdfb-93b4-4d94-9708-ffa71f87754a}MWM Test.fields.{2682c5c7-76eb-4a9a-abf5-d409f2bc3f80}budget'] ), align: "CENTER", width: "NARROW" ) }, pageSize: 100, selectable: true, selectionStyle: "ROW_HI

text - "CM: Nick Hunt ECE: Fred Wang General Contractor: Villamar PM: Rick Chan RF Designer: Eric Chan ", output- CM: Nick Hunt  PM: Rick Chan RF

hey hi  all,  I am facing an issue with the expression rule that extract the data subset from the task report which in turn, I need to showcase the tasks for the user action to perform the tasks but i unable to fetch the right data from the expression rule    from above code snippets and snap shot i want extract only "REVIEW PROCUREMENT REQUEST" which is dynamic display name but it show the node          name in the expression rule even though it takes it show the display in the task report. thanks in advance!!!                                                                                                                          &

Hello everyone, I have configured a Task report and use this to resume a User input task from My task list. When I resume the process from process instances then I am able to resume, but when I click on the task from My task list, it is showing "The Requested Task Is Not Available The task may have been deleted or completed by another assignee". What will be the possible solution for this error?

We created a CDT called "Extraction_details" in Appian, which contains 36 fields such as "effective date," "agent name," "company name," and others. For each field, we provided an array, resulting in the automatic creation of corresponding database tables. Now, we are trying to create a view for these tables to display all the related data for a single "extraction_Id". But we are getting repetitive rows and data is being multiplied which is causing us more issues. This is related to the query https://community.appian.com/discussions/f/general/35170/need-to-export-process-variable-data-in-a-pm-to-a-formatted-excel-sheet by [mention:7da09a91ebba452c82a6b899cb44d590:e9ed411860ed4f2ba0265705b8793d05]  Is view creation possible?? If so can anyone guide us with it.Thanks in advance,

Hi Folks. Can anyone suggest how to add record action only as a page on site navigation bar? I believe it's only has a option to add record list. Please suggest. Note: I am asking this because there is need to show popup on click of button or navigation menu. Thanks 

I am working in my record type display interface.  One of the fields in our data contains an email address with the name of the person in this format: Bilbo Baggins <Bilbo.Baggins@TheShire.org> I need to extract the string between the < > and display that string as a mailto link in my results.  How do I write this, or if it's not possible to write this, how can this be achieved based on the data as it is? Many thanks in advance - 

Hello! We are using the submenus of the Appian sites (which only accept interfaces). We have a logic where, depending on the role of the user that accesses, when clicking on the submenu of the site you will see one thing or another: Role A: You will see a list of customers (through a record). So far so good, we can put the record list in an interface Role B: You will see directly the detail/view of your customer. Having only one customer associated, we want to avoid the double step of seeing the list of customers (where only yours appears) and click this customer. What we want is that when you click on the submenu, it takes you directly to the detail of this customer (similar to the functionality of a!recordLink). Do you know if there is any option to do this? Thanks!

I have a requirement to pull parent record and its related records. these are 1-many relationships, and 1 related record contains more than 10 rows. I cannot user a!queryrecordbyidentifier as i dont have identifier passed. this is based on date filters.  Any suggestion on how to pull more than 10 relatedrecords under the queryrecordtype() function. I am able to get all relatedrecords without using RelatedRecordData but i am not able to apply additional filters on relatedrecord data. Ex: I want request 1 data, and all the statuses of request 1 from status table which is in 1-many relationship. I only want active statuses that are more than 10 rows, for that i tried to use RelatedRecordData but limit is 10 though it only returned active ones as needed.a!queryRecordType( recordType:recordtype!parent, fields: {}, filters: { a!queryFilter( field: createdon, operator: "between", value: { startdate,enddate }, applyWhen: and(

Hi All, I am getting the below error "An error occurred in executing an Activity Class" at Write to data store entity smart service and not getting more details about the error. Below is the configuration for the smart service. Can you help me in finding the issue? Thanks in advance

Good morning, I need to create a source filter in a record to retrieve those modified in the last half hour. I tried using the now() function, but you mentioned it’s not valid for this type of filter. Does anyone know another way to achieve this? Thank you very much.

Hi folks , I have a look up  table named "gender" , I want to develop a interface using which i can see,  add add, update , delete values in table without going in the appian cloud directly instead we want to perform this from the interface . For example i have genderId and gender column in lookup table , where there are two entries male with id 1 and female with id 2 , how can we add another gender in the table  directly or delete male row  from the table or update it. I hope you guys understood my query . Thanks in advance. 

For subprocess and start process smart service if we change assignment to :-  This node will be assigned as a task to a person or a group of people We are able to add interface on Forms tab. What is the use of it ? And if we change values in PV, changed values are not getting passed to child process.  Parent process variables have updates values.  But child process has old values. (Not updated in this start process smart service Form ) Find document for reference. [View:/cfs-file/__key/communityserver-discussions-components-files/65/Defect-in-Process-Model.docx:320:240]

I am trying to create a user filter with the results from an expression rule which displays distinct options from my table. I have researched the documentation, and was unable to find any answers with an example.  How do I call the expression rule to populate the options for this user filter based on the results from the expression rule I have created? Many thanks in advance for your assistance.

Hi Champ, I have a use case where I am getting the constnat name (in text) and I have to pass that in Update constant service. But here the issue here is I am unable to pass the constnat name dynamically there. As the name is text type and it's expecting something of constant type. I don't see any option to cast it too. Only way possible here is selecting consttant from the menu ; but I can't do that as it's dynamic in my case.

Using v21.3. I'm fairly new to Appian. While tailing the tomcat log, I see when the ObjectSynchronizer runs, I get the following: ... WARN com.appiancorp.common.ObjectSynchronizer - 1 services were missing users.... ERROR org.hibernate.util.JDBCExceptionReporter - ORA-00001: unique constraint ([constraint name]) violated I am attempting to see the actual sql causing the issue. I modified appian_log4j.properties as follows:from "log4j.logger.com.appiancorp.common.ObjectSynchronizer=INFO"to "log4j.logger.com.appiancorp.common.ObjectSynchronizer=DEBUG" However, the tomcat log file does not produce any additional entries. Is a restart required? Would the debug entries be written to a different file? Is there another logger that needs to be modified? Any help would be appreciated.

Unable to fetch the data from database through a!queryrecordtype in High Availablity environment set up and its always returning null value eventhough data is present in the table. Kindly revert to me if anyone aware of the fix. Thanks for your help in advance!!

When updating a record, using the update related action, the process gets stuck on the write records smart service. I've checked the permissions, and they should be fine. It's worked thus far, however now we can't update anything. The process is not throwing and errors, nor is it providing any useful information. Additionally, this is the error that the user gets:

Is ther any limit for number of columns/rows for using this smart service(Export Data Store Entity to Excel Smart Service). Nothing is mentioned in documntation regarding this limits

Hi All, I'm encountering an issue with syncing data in Service based records. Here are the details: - I have scheduled a full sync, but it only occurs once per day. - The API data can update multiple times throughout the day. so I set up the sync expression rule for multiple daily syncs. However, I've observed the following issue when running the "Sync Records" smart service: - If the API returns fewer rows than the current record, the old data is not being removed after the sync. For example : currently record has 40 rows and now the API returns 15 and I see all 40. Has anyone faced a similar issue or have any suggestions on how to resolve this?

Hi Champ, I have a usecase where I need to pass the milestone which will be dynamic to interface where that is being used in record summry page. Can I do it by someway? Regards, Ghanashyam

Hello, I have a rule in which I would like to send a day, month or year as a reference and have it return the corresponding records. This is my code a!queryRecordType( recordType: 'recordType!{5871e10b-6fc1-4f38-a51a-becdd72dcf12}AOC CLAIM', fields: { 'recordType!{5871e10b-6fc1-4f38-a51a-becdd72dcf12}AOC CLAIM.relationships.{f1cf2f3a-4ab2-483a-837d-630a35530587}area.fields.{12767694-751c-4c75-8f60-5c0c1ce095ff}value', 'recordType!{5871e10b-6fc1-4f38-a51a-becdd72dcf12}AOC CLAIM.relationships.{a51767bd-0bc5-405c-9791-69b30b3e44c4}status.fields.{74564548-1877-4eb5-9591-25652490fc06}value', 'recordType!{5871e10b-6fc1-4f38-a51a-becdd72dcf12}AOC CLAIM.fields.{9b248167-138b-46e6-88ce-7c2cc3df93bc}id', 'recordType!{5871e10b-6fc1-4f38-a51a-becdd72dcf12}AOC CLAIM.fields.{bd5d065d-3a84-4456-9b71-26fab0f1ef07}startDate' }, filters: a!queryLogicalExpression( operator: "AND", filters: { a!queryFilter( field: 'recordType!{5871e10b-6fc1-4f38-a51a-becdd72d

Hi, From the below screenshot in the Dropdown filter i am selecting "TEST" where every letter is capital so in the below grid the data has to display only the data which is exactly match the "TEST" filter but it is also displaying irrespective of case insensitive which means data like "test" also getting filtered & displaying the data in the grid. But we want exact match we are selecting in the dropdown filter that data only needs to display in the  grid. Kindly Suggest on this Grid Filter Code: Grid Row Value: