Data Fabric

Hello, I am trying to sign in to the process mining Instance in community Edition I could not able to sign in can anyone suggest how to sign in to the process mining Instance in community Edition. Regards Lokesh D

Hello, I am trying to make use of the new function: a!urlForSite() It seems like a great use case for a!urlForSite() is to pass data to a site page that shows a record list, so that the user can be directed a filtered set of data. As far as I can tell, this can only be done using custom components to create filters, and cannot be used to pass data directly to ootb user filters. I usually try to avoid using custom components as filters because these cannot be saved as user filters and they don't appear in-line with the search field. Am I missing something? Or is passing data to user filters still not supported?  Thanks!

Hi Team, We have multiple sections in the form and user will be updating them in between of time. (Interval of 5, 10, 15 minutes or an hour) User want data to be saved as soon as they enter or select on the form and no save button. I am thinking of off focus save like when user enters data and come out it should be saved in the record/db. Challange is what if they change the data. Can you suggest any other way to handle the requirement considering performance point and no data loss.

Hi, I am trying to write data into DB using record type which is multiple. Process variable had data correctly but when it is writing into db the data is writing as  null though source fields and record fields data type is same and structure is same. Can someone help me on this?

Hi All, We have  recordtype actions configured as dialogs for create and update of record. In the popup UI, the dropdown component not showing the drop-down values on the press of enter key when 508 tool ANDI is enabled. and the buttons (close or create) is not triggering in the case of the dialog format UI. Could anyone suggest what can be the approach to resolve the 508 issues? appreciate the suggestions. Thanks in advance for same. Raj

I have 2 rule inputs one is prevData and another is UpdatedData . I want a rule expression that will compare the two rule inputs and return the different fields and values from prevData rule input . And the I need to add the fields and values to another rule input which will be a input for write record smart service . Can anyone help me with proper steps ,please !

Interface Definition: Expression evaluation error at function a!gridField [line 212]: Invalid field identifier: "#"urn:appian:record-field:v1:f93971d1-a676-475d-bcde-b5eb7ffea268/66d74798-e23e-48d6-8801-b307250c1052"" I am getting data from external system and mapping it into Appian. I am mapping it to appian record since will be storing it using write to record. I wanted to do sorting on all the columns using code below but getting this error when trying to sort:

Hi, Unable to sync the data in records below is the error and also screenshot. Unable to sync due to an error in the Record Data Source during batch number 2 Record Type Sync Alerts Record Type SG PersonDetails Source Type Web Service 1 item available Alert Caused By Unable to sync due to an error in the Record Data Source during batch number 2 The Record Data Source did not apply the batch number correctly. The first two responses returned the same data.

I have a record type named Patient and in that there are columns like Name ,Age and Gender. I need to store the value in Gender as M and F. There is another recordtype named reference and there I have 2 columns such as gender code and gender name .There are 2 records ,one is gender code M for gender name Male and second is gender code F for the gender name female .When I am displaying the record list I need to show the gender values as Male and Female instead of M and F by mapping to the recordtype reference . Please tell me how to configure this .

I have a table with 1:M relationship, as stated in 23.3 I can update with just one write records smart service, how to pass related data there

Hi, everyone! So we have a database table that has 100+ columns. But in Appian, record types have a limit of 100 when it comes to number of record fields. Is creating a 2nd record type sourcing from the same table an appropriate solution for this? If not, what would be the ideal way of doing this? Would gladly appreciate your help. 

Hi All, I am using record type and using record type fetching data in UI and Data source is type using View  and Date Time field is type datetime(6) Example UI: I am facing problem in Data time field when I export and downloads the excel , the date time field in excel file is not showing the time zone similar to the UI. I want to show the datetime field to appear in excel similar as UI . Thanks 

If I have 1000 records that I want to add to the database in smaller chunks, how should I design a process to accomplish this? I have a few potential solutions, but I'm unsure about their performance implications: Implementing a loop: In each iteration, I would send data in manageable chunks. Utilizing an XLSX file: I could create an XLSX file and then use the Excel to Database smart service to transfer the data. Using a stored procedure. However, I need clarification on the most suitable approach in terms of performance before implementing this functionality.

Hello Community, I am using record grid as landing page on site along with record action of create Record. After successfully creating record through the action it is going back to the Grid but is it taking sometime to refresh and show the updated grid. I have updated the refresh interval to 30 seconds which is the least in the options. Is there any solution to automatically refresh the grid after record action or set the refresh interval to least time(5 to 10 sec).

Hello,We have a requirement in our running project that we need to migrate our database(MariaDB on-premise) to MySQL on-premise DB.Currently in our applications we are using CDTs and records and my concerns are- In Appian system, what are the changes we need to do? Is there any impact on existing filters, summary views, and etc. if we change the source of the records? Any impact on existing DSE object? Can you please suggest the impact on any other artifacts in Appian? Thanks!

Hi everyone,we have a database of 3/4 tables, which we have connected via record type relationships. There is an interface as a user input task of a process. It shows a list of elements of the primary table, it has 9 columns, some columns are field of the record type, some columns show the details of the related record types. After scrolling through the first 50 pages (therefore arriving at 500 items) the Memory Circuit Breaker error appears on the screen. Am I doing something wrong? Is it possible that record type paging doesn't manage memory allocation? Thanks, Dalila

Is there a way I can use one record action in two different places with different display names?

Hi all, grid field is showing the error when I am query entity to view the data in the interface, the CDT are of the ARRAY type. when I am removing the filter I am getting this error if I keep the filter I am getting another error. can you please help me with this error.  a!localVariables( local!VerificationDecision, local!listingetails:a!queryEntity( entity: cons!SHA_LISTING_DS, query: a!query( selection: a!querySelection( columns: { a!queryColumn( field:"propertyTypeIdFk", alias:"propertyTypeIdFk" ), a!queryColumn( field:"propertyName", alias:"propertyName" ), a!queryColumn( field:"propertyAddress", alias:"propertyAddress" ), a!queryColumn( field:"propertyDescription", alias:"propertyDescription" ), a!queryColumn( field:"floorPlanName", alias:"floorPlanName" ), a!queryColumn( field:"neighborhood", alias:"neighborhood" ), a!queryColumn( field:"price",

Hi Team, Last night, The record sync got failed but now it synced. -Reason:  The system has failed this sync because it exceeded the 4 hour time limit Is there a way to check why it took 4hours to execute?

I exported my all records from my record type but in excel sheet it is not showing correct date and time for dateTime field , and also there is no timezone in excel sheel, below is the screenshot for the problem, expected time (10/03/2023 PDT)

Hi Team, Sometimes, the data was not available on UI and it is available on DB. What could be the scenarios, would this be a performance issue?

Is there an option to delete an unused action? I was following the tutorial and adding a new action on Record Type. I realized, that I chose the wrong option, and created the action without auto-generated Process Model and Interface.I didn't know how to remove the action, so I thought, that maybe if I remove the empty Process Model and Interface associatedwith the action, it would dissapear. Doing that however only made things worse, as now I couldn't create a new action, due toan error on the existing one (Process Model not found), so I had to put it back in. Now I have two actions, one of which is not needed. How do I delete it?

I have a read only grid  contains 1 column with clickable link, when I will click on the link field then it will suppose to open a grid consist of related data below that row.   How I can achieve it ?

I was doing some User Filters for some not synced Record Types that sources from web requests And noticed that when there are two possible labels with the same text inside a a!recordFilterChoices it raises an error saying that the labels are duplicated even when its selection values are different. But, this behavior is not present on a!multipleDropdownField, it works just fine as shown below: Is it possible to replicate this behavior to a!recordFilterChoices as the label is something that the user can freely change and that change can lead to a more fragile and prone to error system ? Thanks in advance, Best regards [emoticon:c4563cd7d5574777a71c318021cbbcc8]

Hi,I've already used the updatedictionary and update functions with CDT, but how it works with RecordType? Could you show me the correct syntax please ?/* works fine with CDT */ local!dataVehicles: a!queryEntity(...), local!vehicles: a!forEach( items: local!dataVehicles, expression: a!update( data: fv!item, index: { "id", "model" }, value: { 1, fv!item.model } ) ) /* does not work */ local!dataVeh: a!queryRecordType( recordType: 'recordType!Vehicles', fields: { 'Vehicles.fields.id', 'Vehicles.fields.model' }, pagingInfo: a!pagingInfo(startIndex: 1, batchSize: 500) ).data, local!vehicles: a!forEach( items: local!dataVeh, expression: a!update( data: fv!item['recordType!Vehicle'], index: { 'recordType!Vehicle.fields.id', 'recordType!Vehicle.fields.model' }, value: { 1, fv!item.model } ) )