Records

Hi Experts, I have implemented readOnly grid with RecordType as a datasource. Search options was only working for the the columns which I have configured in the gridField, so for search to filter on all the columns I have added all the columns of the cdt/table as gridField column with showWhen as false. Will it be having any impact of performance? I tried to lookinto the performance matrix of the UI but in both the cases performance is almost identical. Q: Question that I have up in my mind is weather the performance will get deteriorated with the increase in amount of data pulled through record or will it behave as it is ? Q: Since all the data is already coming through record , showing it in grid will have considerable impact on performance or not ?

Hi guys. I'm new to complex queries with records and I've got a question about how to execute a query based on records when there is no key based relationship between two tables. Imagine a situation where there are two tables 1. Executed jobs table Jobs       Id Summary Employee Hours Timestamp 1 Pipe change johnb 3 10/12/2022 12:34 2 Cleaning andyw 5 08/12/2022 10:22 3 Installation johnb 2 03/12/2022 09:12 4 Destruction johnb 4 02/12/2022 18:34 2. Hourly rates of employees Rates         Id Employee From To HourlyRate 1 johnb 01/02/2021 30/11/2021 12 2 andyw 01/03/2021 31/01/2022 8 3 johnb 01/12/2022   14 4 andyw 01/02/2022 31/12/2022 11 5 andyw 01/01/2023   14 In result I need to list executed jobs with their cost. But the join between these tables is based on employee name and timestamp of job fitting into rate of employee at job execution time. Using SQL I could perform a join on multiple fields

THE primary key is generated automatically when data is stored in database. Now how to display primary key when the data is forwarded further to supervisor?

Hi Team,I have uploaded a document from the interface. Now I want to call the record and show the documents in file form like this  and also wants to add view more button option, for example in the beginning   there are only 5 documents files that are visible now I will click on view more button and more files which are uploaded will be visible on interface. Please tell is it possible to apply all these, if yes, how? Thanks in Advance

Hello, I want understand how the data is retrieved when we use chart with grouping. For charts In data we give recorddata (retrieve the data with filters) and then it is grouped using primary or secondary grouping(column charts) I want to know if internally. the whole data is retrieved and then grouped or the data is grouped and retrieved? If the data is retrieved and then grouped , then i can use local variable and save the recorddata() and then give the data to chart for grouping. if i do this whole data is stored in local variable.  if im using a drillable grid then i can reuse it. But to reuse this data i need to again filter this with the selected (data clicked on) grouping.  1. I want to know if internally. the whole data is retrieved and then grouped r the data is grouped and retrieved? Can i load data in local variable as shown below pic. 2. If its the earlier, then given a recorddata how can i then filter it to get only few rows out of the whole? belo

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

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

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