Data Fabric

Hi Team, I have a requirement where I have to show the list of users who have opened same record in a site. I have record type with 'related actions' to view the record details, my requirement is if user A has already opened the record and if another user B opens the same record, then both of them should be able to see on the summary page that the other user has also opened the same record. We don't need to lock the record rather just display who all are viewing the same record at the same time. Any help is appreciated. Thank you

Hi, I'm using expression in "Source & Default Filters" in RecordType. I can only save expression with 4 criteria but I cannot save it with more than 4. do you have any suggestion. my code is below: a!queryLogicalExpression( operator: "OR", filters: {a!queryFilter(field: "year1", operator: "<", value:2021), a!queryFilter(field: "year2", operator: "<", value:2021), a!queryFilter(field: "year3", operator: "<", value:2021), a!queryFilter(field: "year4", operator: "<", value:2021), a!queryFilter(field: "year5", operator: "<", value:2021), a!queryFilter(field: "year6", operator: "<", value:2021), a!queryFilter(field: "year7", operator: "<", value:2021), } )

Hi, I have record data as shown in the table below :  Id NumbersInText 1 One 2 One 3 One; Two 4 Two; One 5 One; Three; Two 6 Three 7 Three 8 Two 9 One; Three I am trying to aggregate this data is such a way that I can how the report below : NumberInText Count One 6 Two 4 Three 4 Please help me with it.

I am working on bulk file (docx and PDF) handling Application. My plan to use SharePoint for that. I want to know,       1)Is there any other optimal way to handle bulk file other than SharePoint integration that can connect to Appian.       2) While trying to connect to SharePoint, Integration give error, even though Connected system is correctly authorized. Thank you

Hello, I have a process model that is using execute Process Report to retrieve data on task metrics and store in the database. We are seeing an intermittent error where data is not being retrieved into process variables. I thought this may be a timing issue, but no data is being retrieved when the model is rerun and the underlying process report displays the required data. Are there any system logs that can be queried to help me identify the root cause of the issue?

When i'm creating cdt from database i'm facing this issue:- ->After selecting Data source no table or view is there for selection  -> data source (oracle DB)

Hi there, I have one CDT array { {a: 1, b: "R" }, {a: 2, b: "E" }, {a: 3, b: "R" }, } what's the good way to update field b from "R" to "T". tried this, it does not work. a!update(CDT.b, {1, 3}, "T") anyone has the experience dong this? Regards, Lin

Hi All, I have  "Accounts" record(database is the source) in below structure, Account ID Account Name Account Status 28 Test InProgress   I added a "One to Many" relationship with the "Contract" Record,which is in below structure.  Cont Primary Key Account ID Contracts 1 28 A1100 2 28 A2000   Now I want the "Accounts" record list to be displayed in below structure,where the "contracts" column will be my new custom record field,and it should be concatenated like below. Please help me how to make this work. Account ID Account Name Account Status Contracts 28 Test InProgress A1100,A2000  Thanks in Advance!!

Hi there, I have an array local variable here, using a!save(local!array[1], true) does not work. any idea what's the problem? regards, Lin

i'm trying to create a process report report type task , context tasks assigned to group inside the report i set the required group as a context but i wasn't able to see list of tasks of that group, so please guide me what is missing

Hi All, While running the Query entity. Facing this issue.  a!queryEntity( entity: cons!ABC_DSE, query: a!query( pagingInfo: a!pagingInfo( startIndex: 1, batchSize: 10 ) ), fetchTotalCount: false) Exception: Expression evaluation error at function a!queryEntity: An error occurred while retrieving the data. Details: Unexpected error executing query (type: [DECOMITSMNetworkDT11134], query: [queryentity expression], order by: [[Sort[computer_id asc]]], filters:[null]) Is there any log file where i can get more details? Note: Retrieving data from Oracle. Regards, Nishtha Bhatnagar

Hi All, I got a read only view from Oracle where no primary key column exist but In Appian we have to make some column primary key how can I solve this problem. Appreciate your help! Regards Nishtha

Hi all.. What is the best way to show more than a few record types? For example, lets say an application has below record types and related record types. Organization Customer Address Product Flyer Point Programs Point Credits Discounts Orders Order Items etc. etc. I'm just making up record types that may be related to each other in some imaginary business Now, given that Appian has 5 tab limit on a Site, how do we expose these many entities in a site if I have to?

Hello All, We are having 1 record which is having relationship with others record also. We are getting the data from the record by the function a!recordData( ) and displaying on the interface. We are having different buttons for child interface on the selection we filter on the basis of the different status related to the button clicked by the user we are fetching the data from the record. The requirement is to show the number of records with the button label. Anyone who have used some function by which we can directly fetch the number of filtered record and can display. Thanks in advance

Hi All, Not able to fetch data from Oracle getting above error. Please guide how to solve. Regards Nishtha Bhatnagar

After related action in report it refresh only 5 data in grid.suppose i have 16 row in grid after record action it reflects change in 5 rows only for all row i need to refresh manually. suggest some resolution for that.data is comming from data store entity.

Que. You are configuring a record type and utilizing data sync. Appian does Not have access to the source database table, and will not make updates. which data Sync  is appropriate?  is it  1)Daily Sync 2)hourly Sync 3)Immediate Sync 4)Manual Sync

short lived record centric process are preferred over long running processes , why?

I am creating a text file with the multiple pipe delimiter data. H|Header1|Header2|Header3D|Column1|Column2|Column3D|Data1|Data2|Data3D|Data4|Data5|Data6D|Data7|Data8|Data9T|Trailer1|Trailer2|Trailer3 In the above format "H" means Header, "D" means Data and "T" means trailer I am fetching the data and using the expression rule to create the data in the above format. Then using Text Doc From template smart service to pass the Header, Data and Trailer separately in the smart service. Right now, I am performing test with 200 rows it is working fine but in the UAT the data will be around 25000-30000 rows of data. I am thinking it can create the performance issue.Can anyone suggest me the best approach by which I can get the expected data format with good performance, Thanks in advance

I have added 5 fields in backend database that is oracle db , now I have downloaded the existing xsd from the cdt, updated the xsd by adding the five columns, got this error while trying to create new version from XSD

Hi, I want to implement  a functionality, wherein I am displaying a button, and on click of that buttton, I am letting user to download a file containing data from the database. I am using exportDataStoreEntityToCsv() smart service to achieve this. But it is a 2 step process, and I am not quite sure how to integrate the download functionality in the button.  Can anyone help me in this ?

Hi Team, I am working on the record history of my Appian application.  I created a new table with a similar column in application addition with Modifiedby, Modifiedat, and Operation in order to see create/update and delete history of the application record. Along with the db table, I have created a record type and data type. I have done the entity mapping successfully in the datastore. Now while I am updating the code in create/update/delete interface, I am unable to fetch the data. Below is the code snippet I am updating in submit button to save the record simultaneously in history table as well. buttons: a!buttonLayout( primaryButtons: { a!buttonWidget( label: "Submit", saveInto: { a!save(ri!record['recordType!{031f0b84-9549-4b3a-942c-a8fd3d0dfa62}NH_Handover_History.fields.{b5d840ba-2408-425d-b829-510414356ac2}serialnumber']), a!save(ri!record['recordType!{031f0b84-9549-4b3a-942c-a8fd3d0dfa62}NH_Handover_History.fields.{d7f705b2-c020-47c9-95c4-cbe0e6df18a2

Hi, I want to implement  a functionality, wherein I am displaying a button, and on click of that buttton, I am letting user to download a file containing data from the database. I am using exportDataStoreEntityToCsv() smart service to achieve this. But it is a 2 step process, and I am not quite sure how to integrate the download functionality in the button.  Can anyone help me in this ?

Hii,   I have created a read only gird and added my record. So, now I would like to use record action for multiple rows at a same time. Eg. I my grid for now I could able to approve only one row at a time , but now I need to approve them Bulk.

I would like to rename the source field name for a field in one of my record types ('source field name' is the field in the database table, holding the record type). In the record type, screen Data Model > Configure Fields, I am allowed to change the record field name (the field name visible in Appian), but the source field name is readonly! In this particular case, I would like to change "workzonecaseid" to "WORKZONE_SAGS_NR": Here's the current situation in MariaDB: