Data Fabric

How can i check what value appian returns?

Hi all, For context, I'm trying to display a record type "Files" which as of last week has hit the memory threshold (800,000+ records). The record type is still legacy. When I try to access the record via Tempo > Records > Files, I'm displayed with  "The Requested Record Type Is Not Available An error occurred while retrieving the data for "File". Details: Unexpected error executing query ...." I've tried a few approaches but the most noteworthy one is  :  1) Updating the default filter criteria to only show Files that were created the last 2 years. The problem with this is if I need to access something older than the 2 years I won't be able to. In short, I just want to limit the Record List view to maybe 200 records but the data source having access to all 800,000+ records so that I can still have a functioning record that can display the appropriate views when accessed individually. Thank you.

So I have a process where a user uploads a .csv or .txt file with numbers. Those numbers are then extracted and ran through various validation checks. When a user uploads it in a .txt file, no issue. When it's a .csv file, the very first value, a fn!char(65279) is always added before it, so it's failing the validation check. Like so: When I copy the expression and paste it into the rule input of my validation expression rule, that first number always fails the validation check. But if I remove the fn!char(65279), it passes and works. A quick google search showed me that this is some sort of whitespace character. So I tried adding trim() to the variable that hold each individual extracted number, but that doesn't appear to make a difference. Does anyone have any idea? To either prevent that char from being extracted with the data, or to remove it after extraction? Thanks for any help.

Ran into an issue where any writes to record A were failing because record B had a sync issue. Record B was the Event Type Lookup for Record A, which was why record A writes were failing. The error in our logs is below: It sounded like the issue here: (+) Appian Community, however the difference was that our scheduled daily sync for record B passed just that same morning. No updates were made to record B, and no new data was added to record B recently enough to cause the issue. In addition, while there was a warning icon next to Sync History for record B, there was no history of any failed syncs, and once I manually synced, the error and issue went away. I'm not sure what happened how to go about checking what kind of invalid data popped up. Anyone ran into this before? TIA

What is the main difference between a!queryRecordType, a!queryRecordByIdentifier and a!recordData. When to use a particular one?

I'm setting the Record-Level Security and I have this Expression: if( a!isUserMemberOfGroup(username: loggedInUser(), groups: cons!MIN_Administrator), /* Show all records */ null(), /* Show only records that belong to the particular company*/ a!queryFilter( field: 'recordType!{5608cfad-fc67-4a81-93b5-722c9b55f2c5}MIN Test API.fields.{d1b51e83-1de8-430a-8d7c-e6e433601ad4}company', operator: "=", value: "*CompanyNameAsAParameter*" )) If the current user belongs to the Administrators group, they'll see all records; otherwise, they'll only see those whose "company" field has a specific value ("*CompanyNameAsAParameter*"). This value will vary depending on the logged-in user. Is it possible to pass this parameter from the interface, or is there a workaround?

I have a Record Type with a large data. When I add it to a Site I can see all the records but I want every user see only their related data using a particular field ("user"). I'm using the showExportButton and showSearchBox properties and if I filter the RecordType I lose them. Is there any way to filter the data for every user and continuing using all the parameters of the Record Type? Thanks!

As you can see, I'm creating a new Record Type from a Webservice. I get de data properly. But when I try to sync the data in the Record Type I get the following error: Type could not be inferred due to inconsistent types for field(s): discountPercentage I think the format is ok. Do you why I getting the error? As you see bellow in the Expression Rule commented code, I map the fields formating the decimal fields but I don't to do so because I would map all the fields. Any idea to solve it? Thanks!

Hi  I have related records : Purchase Orders - item code, qty Items - item code Pricing - item code, price, effectiveDate An item can have multiple prices so there is a 1 to many relationship. I am wanting to use the custom record field on the Purchase Order record to calculate the cost of the Purchase Order ( Purchase Order. qty * latest pricing for the item) I have an expression rule that returns the latest price for an item however the custom record fields does not allow us to use expression rules. Also, since an item can have multiple prices, I am not able to get the latest price from just using the . notation from the related records. I need to have the cost in a custom record field , as I need to aggregate the cost by supplier. Please advise on a way to achieve this. Thanks

Hi, I'm using email to trigger process model. By setting public events in process model, I'm able to get data into process variables. When I'm trying to write it Records, I'm getting below error. The input "Records" refers to an invalid record type. The record type does not exist, has been deleted, or the user does not have sufficient privileges to access the data. I understand that record types doesn't have permissions. But how to provide permissions is what I need know. Thanks in Advance. Thanks, Sadhu Surendra

We have a record with a large complex Security Expression defined in Record-Level Security. When querying this record using an a!queryRecordType, the query takes ~1,500ms (90 rows, ~ 16 columns) When querying using a!recordData in a gridField, the query takes over 13,000ms To make the test fair, we have have kept just 1 column in the grid showing the ID of the record, and have not defined any sorting, no filters are applied for either query When the record level security is turned off,  a!recordData in a gridField takes 253ms to run. What might be causing a!recordData to perform so much worse when record level security is turned on?

Hi All, We have below requirement, please read and assist me on this. We have 2 Event data:                                1. Request Event data                                2. Task Event data We need to merge above 2 dataset and show details in a single page with using Event Timelines patterns/components. Can you please check and assist how we can achieve? When we are taking Event Timelines patters with selecting records type then, we can select only one record type as a time under Event Timeline components but we need to take both records type and then make the relationship on script level. Please provide solution for achieving above. Thanks in advance. 

I'm developing a Help Desk application and need to create a column chart for priority. When a priority is clicked, its ID should be stored and passed to a drilldown grid but the current code is displaying the ID as the label instead. a!grouping( field: 'recordType!HD Request.fields.priorityId', alias: "priorityID ) If I use 'recordType!HD Request.relationships.priority.fields.value' directly in the field, it throws an error. Any suggestions on how to display the label name? Thank you!

Hi All,We faced one issue during deployment to production. We have an API which triggers a process model and we are saving into database using write to records. Yesterday we added a new column to that record and it was getting deployed. During that deployment window, we received some cases via API. Details were getting written to database but while trying to query data, no data was being retrieved. The record was being updated and sync was occuring during that time. This is the first time we are facing such issue. Has anyone faced similar issue? Any reason this might have occured??

I have the local variable called "encargo" to get a single record from a RecordType filtering by an id key. I want to get all the fields of the record type. Is there any way to tell it to the "fields" parameter or have I to list all of them instead?: local!encargo: a!queryRecordType(  recordType: 'recordType!{47dcd902-6450-48f5-944d-06c0f19d2df1}Encargo DSAppian',  fields: {    'recordType!{47dcd902-6450-48f5-944d-06c0f19d2df1}Encargo DSAppian.fields.{85cdc5be-fc56-425c-9ec2-f9e617124992}id',    'recordType!{47dcd902-6450-48f5-944d-06c0f19d2df1}Encargo DSAppian.fields.{48d20aa7-6bfb-42ac-9ea0-0396fafa7ffd}fechasolicitud'  filters: a!queryFilter(    field: 'recordType!{47dcd902-6450-48f5-944d-06c0f19d2df1}Encargo DSAppian.fields.{85cdc5be-fc56-425c-9ec2-f9e617124992}id',    operator: "=",    value: ri!id  ),  pagingInfo: a!pagingInfo(startIndex: 1, ba

Felw amount fields i have created as DECIMAL in Database, but it got mapped as INTEGER in Appian record. How to get decimal as a datatype in Appian as well? What should be the source field datatype to achieve this?

The Appian product works with its own database in which it stores its internal process data or Record Type synchronization, right?So, if we want to have a database in which we store, for example, Master or audit data, is it advisable to use the Appian databaseor create another one for the project we are developing?Thanks.

Hi all. I'm starting a new app and I have big dilemma because I don't know if is better to use CDTs or Record Types. I won't connect directly to a database to get/post records but I'll connect to a webservice to do so. You have to keep in mind that the records can be added/modified/deleted from Appian calling webservices or from other non Appian applications. So, If I use Record Types, I'll get the refreshed records without sync every few minutes? Has anyone experience about this topic? Thanks in advance.

Hi Everyone,I have a table with one column type as JSON datatype and using to save the data through write to records. Now I have to export this table data into excel file and share it everyday so I have created a CDT for that table.In CDT it is defaulted to text even I have given longtext datatype. Now there is an issue with the data as the database table have more than 4000 characters the CDT is not allowing more the 4000 so my data into excel is not exceeding more than 4000 characters.Please suggest how to handle this or any alternate better approach.

Can I create Service-Backed_Record with POST API which returns data on input parameter, How differently it works from GET API. What could be the possible I may face if I use POST API for Service-Backed_Record.

Muy buenos dias  estoy realizando el curos de APPIAN y el comunity no me esta dejando crear nuevos recorda Type ya no aparece esta opcion como antes en la imagen adjunta les muesto como apareceia antes y como esta apareciendo ahora  Alguien me podria ayudar por favor ?  quedo super atenta 

HI. I attempted to do a rather large import of an application over our PP environments version. I looked over a record that had some Record Related Action name changes to it. Testing it afterwards, only half of the related action name updates took on import.  I confirmed the record was modified on import. Has anyone ever had this happen before?  I have no way to deploy proper changes due to this.

Yesterday I created a record from a Record Type list action. I can see the record in the database and when I open the Record Type View I see the record as well. My doubt is why I can see the record if the last sync was last month. As far a I know, when you use a Record Type it is necessary to sync the data. Is there any way you can configure an automatic sync or sometrhing like that? Thanks.

Hi All, I am working on a scheduled workflow where I have to check for existing active instance and if it is still active without any errors, I can skip my run. If it is errored out in any node, I can proceed with the current flow. I checked in https://docs.appian.com/suite/help/23.2/Process_and_Report_Data.html and can see there is a possibility to get the details only if the instance is Paused by Exception.Anyone have any workaround for my case?I am thinking if there is a possibility that Appian is showing the status as "Active with Errors" and Error count as "1". There should be some report option available to get the same data. Right?Anyone have any idea how to achieve this?

Please suggest  how can we calculate years given by days using record types