Records

Hi, In the below Summary view of a RecordType, I have a document ID which has been uploaded using fileUploadField.  I have this saved in the database.  Now, while showing the details, I would like to show the document name instead of id. Can someone help on this. When I tried like document(ri!employee2.coverletter, "name"), nothing is displaying.

Hi, I am getting below pink error. The data is being fetched from a view and its an intermittent issue. Need your suggestion on this.

I just started trying to use Record Sync and Relationships and wanted to sum amounts from another table that have a many-to-one relationship with an Id in the main record type. However, I only want to add rows that are  isActive = 1 or by some other kind of categorization. Is this doable with a custom expression ? Since the template doesn't have any filtering options.

Is there any way we can use related record type field or expression rules while creating custom record field in a Record type with data sync on? When I am creating a new custom record field and trying to write my own expression, it's not allowing me to use any expression rule. Also I am not able to use any field from the related/mapped records.  It is restricting me to create user filter based on custom record field. Any help would be appreciated. Thanks in advance.

I'm looking for a way to make it possible to page through a list of records from the view of a single record - that is, to add in BACK and NEXT buttons at the bottom of a single record view rather than returning to the list to reselect the next. I understand from previous posters that this may be possible if you can access the list's index of the selected record, then decrement or increment into a local variable so your BACK and NEXT buttons will take the user to the correct record. I have saved the queried list of records to a local variable. How does one access the index values of the records in that variable? Should I instead work from a read-only grid? fv!item will give me the entire record but no value I can reliably decrement or increment to get its neighbors, and fv!identifier will give me its unique identifier, but as records are constantly added and deleted that is also unreliable.

I have this expression rule : a!localVariables( /* Loop checks against passed in value of type to pull values from specific requirementActivity match */ a!forEach( items: ri!requirement.requirementActivities, expression: if(contains(fv!item.type, ri!activityType), 'type!{urn:com:appian:types:UW}UW-Requirement-Activity'( key: fv!item.key, type: fv!item.type, creatorId: fv!item.creatorId, creatorFullName: fv!item.creatorFullName, createdDate: fv!item.createdDate, commentText: fv!item.commentText ), {}), ), ), And I'm using it in my interface : a!localVariables( requirementsResponse: rule!UW_GetRequirementsByCase_RDS("SomeKey"), local!requirements: { a!forEach( items: local!requirementsResponse, expression: a!map( type: fv!item.name, status:fv!item.status, orderDate: fv!item.createdTimestamp, orderRe

Hello!  I am working with an API response from BigQuery, I get the data to be on the record type from my input rule, however when I try to sync, it keeps getting an error as shown below  So, I'm not able to work with this record because of the error, I checked this article https://docs.appian.com/suite/help/21.3/configure-record-data-source.html and it seems like I have to modify the batch number rule but I'm not sure how to do it (like what I have to put in there) or if that is even the issue. My response gives a 632 record only so it is less than 1000, and I assume I shouldn't have to do sync in batches as is less than 1000, but still the error comes up, have you encountered this error or do you guys have any input on how to solve that?

I'd like to store the value  ri!available using this code a!integerField( label: "Available Racks", labelPosition: "JUSTIFIED", value: if(isnull(ri!bicycleInfo.stationId), "",rule!PEDS_QueryStationStatusInfoByStationId(id: ri!bicycleInfo.stationId).availableRacks ), saveInto: ri!available, refreshAfter: "UNFOCUS", readOnly: true, validations: {} )

Hello All, In the filter parameter of a!recordFilterList(), I wanted to pass multiple query filter in order to filter the dropdown list using a!recordFilterList(), per the documentation I do not see any feasible way to do it. Kindly suggest a way out Thanks & Regards Girish Katti a!recordFilterList( name: "Name", options: a!forEach( items: local!completeList, expression: a!recordFilterListOption( id: fv!index, name: if( exact(fv!item, local!name), " ", fv!item ), filter: a!queryFilter( field: 'recordType!name', operator: "includes", value: tostring(fv!item) ) ) ), allowMultipleSelections: true() )

I have created a view and it has data in it . I am creating cdt and trying to map that into DS but it is not hapenning showing error "One or more of the data entities cannot be mapped to the table structure in the selected data source. Please choose an option for creating the necessary tables or select a type that matches the existing tables.   (More Info)" More info "The data source schema does not match the type mappings: Missing column: a_id in Appian.report_isr_budget_study (APNX-2-4056-000) " .

HI, I am trying to create a process with 2 nodes: call an integration + write to db The integration returns a Result.body - this variable is available in the next node....Example of body (json) body (Dictionary) orders (List of Dictionary - 272 items) Dictionary orderNumber5105251(Number (Integer)) operatingUnitId1030(Number (Integer)) operatingUnitName"GEMSAM_OU_LNR_GEMS_LUNAR"(Text) contractAmount4600(Number (Integer)) status"B"(Text) purchaseOrderNumber"1681345522"(Text) customerNumber"131441"(Text) customerName"WOODLAND MEMORIAL HOSPITAL"(Text) deleted0(Number (Integer)) ....   bookedDate11/1/2021 8:23 PM GMT+00:00(Date and Time) initDate11/1/2021 7:59 PM GMT+00:00(Date and Time) customerContractAmount4600(Number (Integer)) Dictionary orderNumber5104156(Number (Integer)) operatingUnitId1030(Number (Integer)) customerNumber"5455"(Text) customerName"SOUND"(Text) .

Hi community, I want to use choose instead of nested if to display status text in different colors. I tried this expression and it throws this error A grid column [label=“Status”] has encountered an error. Expression evaluation error at function 'choose' [line 58]: Invalid index (1) for list: valid range is empty. choose(wherecontains({fv!row[aRecord.status]}, cons!STATUSES)[1],"SECONDARY", "SECONDARY", "SECONDARY", "POSITIVE", "NEGATIVE", "STANDARD") what am i doing wrong here? Kind Regards, Erik

a!update(data:fv!item,index:{"backupBy","backupOn"},value:{loggedInUser(),now()}),  is not correct, how to do it?

Has anyone found a workaround for passing a dynamic value to a Record Source Filter?

Hello community, Is there a way to filter in a query on a text field with date time other then changing the datatype.e.g. a field lastUpdated with text datatype has a value 8/22/2021 2:55 PM GMT+02:00.If the filter is configured like: filters: { a!queryFilter( field: "startDate", operator: "<", value: "9/22/2021 2:55 PM GMT+02:00" it works fine if the month in the value is a one digit.it fails if the month in the value is two digits e.g.: "10/22/2021 2:55 PM GMT+02:00" Is it possible to convert/alter the startDate value before applying the filter, or add a column to to the result with the date time converted to date time. Kind Regards, Erik 

Hello All, I have constant with holds distinct values of usernames. The constant USER_GROUP has the values {gamma, beta, alpha} Earlier we had a sort() function which would sort the data for us, but this function is no longer available. In documentation I see only a!sortInfo available which is useful to sort the data from DB and I cannot use any utilities as well for sorting the data. So can anyone suggest an alternate way to sort the data in a constant to {alpha, beta, gamma}  a!localVariables( local!sendingName: getdistinctusers(cons!USER_GROUPS) local!sendingName ) Thanks & Regards Girish Katti

Can we add tooltip/hoover for related Action button??

Issue   Hibernate Error from WriteToDB Smart Service in a process even though new row is successfully inserted to the underlying Oracle Table. There is no underlying oracle error. Error  - ( I have renamed CDT & Datstore & JavaClass Names  )   An error occurred while trying to write to the entity "PARENTCDT" [id=5933241b-7d12-4cd4-a2e3-6854e5d4b895@2558, type=PARENTCDT(id=4480)] (data store: DATASOURCENAME). Details: org.hibernate.id.IdentifierGenerationException: ids for this class must be manually assigned before calling save(): ParentClassNameDT8243 Data: TypedValue[it=4480,v={<null>,,,,,,<null>,<null>,<null>,<null>,,,,,,,<null>,<null>,<null>,,,,1,<null>,,<null>,,,,,<null>,,<null>,<null>,<null>,<null>,,<null>,<null>,<null>,,<null>,<null>,<null>,,<null>,<null>,<null>,}] Details   This error started

Hello! I am having a hard time trying to understand how to put or format my response from bigquery to create records and filter views easily.  So far, I know you can only connect to bigquery via API, using GET method you can get this response So I get the response, that part is fine, then I noticed Appian takes whatever that comes in the body, as the values to use as columns, however, in this case, the values I need, are into the subsection 'rows' I was able to access that by using .body.rows but that takes me here  which as you see, does not come with column names, so Appian is not able to understand how to put that data into the record type. Now, I was able to use the input rule on the response, to map to a dictionary and it works: But then, I get this error on the record type  How can I use my response to be a dictionary, on the record type so that I can work with filters and sync and so on, if my response is coming like that?

Hi, I would like to confirm if there's an audit functionality in database record. For example, a user SQL updated the data in one table via backend, is there an audit in the database itself where we can see what/when/who made the changes backend? Thanks in advanced!

Hello community! I am trying to create a filter view for my record which is a service backed record, I am not sure If I even did the process correctly as I followed the tutorial described here https://docs.appian.com/suite/help/21.3/Service-Backed_Record_Tutorial.html and it helped me getting some things done, I have now created the filters but the thing is, my data is coming from BigQuery, and this data comes in JSON but does not have the table schema, instead it comes as f(for field):[{v(as value:"Argentina",v:1,v:Jon...}] So, I had to do a dictionary then convert into data subset by using todatasubset Now, I have the data displaying on the service backed record as it can not be used as normal record, and I have been able to create the filters , but when I go to the site and I try to select any of the options, it does not work, it loads like it is going to change something, but it doesn't as you can see on this screenshot As you see, the filter should give me record

Hello, Now, I am making an application with an existing Oracle DB.However, in the existing DB, the number of columns in the two tables is 64 and 69, which is more than 50. (I know that if the number of fields (columns) exceeds 50, CDT is not created, and it was not actually published in the Data Store.) If it is for the purpose of inquiry, creating a view table would be good enough. But to insert, you have to insert into an existing table rather than a view. If you cannot change the existing DB, how should you configure it? Thank you.

Hi All, We want to have read and write access directly to Appian cloud database from our external system.  Is it possible through Enhanced Data Pipeline. Is there any other way possible?

I would like to upload CSV files directly form MariaDB to a specific location on Google Drive (for big extracts). Is MariaDB configured (any default plugin) to perform this kind of a smart service, if yes, do we need to create a service account on the domain to perform the OAuth 2.0 auth?

Hello, I am using readexcelsheet() to read an Excel File with multiple sheets. I have used functions mentioned below in the excel sheet. CONCAT(), TRANSPOSE(), SHEET(), CELL() Upon using this function I am getting some errors. please  I don't understand why the readexcelsheet() is trying to read/evaluate formulas.  Shouldn't it only read Data(output of the formula) ?? If readexcelsheet() is not expected to support files having above mentioned functions, please suggest an alternate way to use those functions.