Data Fabric

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:

I want to create a date filter with the following options. 1. This month 2. Previous month 3. This Year 4. previous Year.

Hi Gurus, The Appian documentation (https://docs.appian.com/suite/help/22.4/record-type-relationships.html )states: If you use a process model to delete a Customer from the database table, any Orders referencing that Customer would have an invalid foreign key. Therefore, the database will either cause the delete operation to fail and nothing will be deleted, or it will delete both the Customer and all Orders associated with that Customer. If the delete operation fails, no sync is needed because data has not changed. If it succeeds, Appian will immediately sync the deletions from both record types. We defined a one to many relationship in the record type and a cascading delete in the database (mariadb) however data in the Orders table is not synced, do I miss something here? Btw not having a cascading delete in the database leaves the Orders records orphaned. Any ideas?

I am creating a Summery View based on a record with multiple one to one relationships that I want to use to display data in the view as well. However, I can't get the data to show up in the view by just referencing the relationship (although the relationships, and their associated fields, do show up as options when selecting the record field to be used). I can use a!queryRecordType to successfully access the data, but I don't want to have to make a query for each relationship if I can avoid it, since there are about 24 relationships and that would probably have an impact on the performance. I have created a local variable that just tries to call data from a relationship, but all it returns is null. When I change it to call data from the source record it work perfectly. I have also verified that there is data in the row being called, and the relationship works properly when used in the record type (shown in the second image). Below is the local variable that is mentioned above,

Hi Team,When I am trying to edit record type > Edit Record List>Image Columns.Below steps:the Image column by following the steps below: ● Under Columns, click Image. ● Under Display Value, click Display Options. ● Select Document Image. ●Under Display Value, click Image. ● Under Images, click Document Image. ● Under Document, click a!EXAMPLE_DOCUMENT_IMAGE(), and clear everything in the Expression Editor. ● Enter the expression: if(isnull(fv!row[recordType!AX Vehicle.fields.vehicleImage]), a!EXAMPLE_DOCUMENT_IMAGE(), fv!row[recordType!AX Vehicle.fields.vehicleImage]) Getting below error: Error Evaluating UI Expression Expression evaluation error at function a!gridField [line 51]: A grid component [label="null"] has an invalid value for "columns". A grid column [label="Image"] has encountered an error. Expression evaluation error at function a!imageField [line 55]: Invalid Content IDDue to this error record type is not loading, if i am not adding image column

I'm  trying to store array of files in database since it does not picks blob as a datatype any work around would be much appreciated.

How to display pie chart between 2 dates?

Dear Team, We have a column in DB say file_number which have text values example 1;12 , 12;32 We are trying to query records where file_number is "1" using includes operator. With includes in query it is getting all the records which have 1 (1,12,13). We want the search to match exact to 1 only . Any suggestion ? One suggestion we have is to add a character when writing in DB like @1@;@12@ , and when searching pass @1@.

Dear Appian Community Team, I am having at a Record's Data Modal using data sync to the SQL database table. I would like to check with the team whether anyone knows whether we can map a Unique Column which is perceived as VARBINARY(16) on Appian Data Modal to ensure data sync successfully when the source code for the SQL is as below. "ABCD" RAW(16) DEFAULT SYS_GUID() NOT NULL ENABLE, In terms of the error: 

Hi all, I am trying to create a user filter wherein the option labels will come dynamically from an expression rule. I am not quite sure how to achieve this. Does anyone know how to do this ? 

I have a column in the record type of DATE type.How do I create "no of records day of the weak" column chart?

As an example, in Javascript I can do this:var test = {a:1,b:2} test.a = 'changed' console.log(test)and it will output this:{a:"changed",b:2}Because I mutated the value in key 'a' of the test variable.How do I do this in an appian expression?Trying this:a!localVariables( local!test: {a:1,b:2}, local!test["a"]: "changed", local!test ) Gives me this error:Expression evaluation error at function 'localvariables': A variable is incorrectly defined. Parameter: 2. Expected syntax: localvariables(local!a, ..., expr) or localvariables(local!a:10, ..., expr) So it seems you can't changed a key of a variable in an expression. Is there another way to do this? It seems like such an elementary operation...