Data Fabric

Hi, In the process model I am not able to get all data as the output. To replicate the issue please find below details The process details Could you please help me in this

Hi! I have made a process in which my Invoice Lines (Record 1) are set with the status "Billed" in the end, after passing multiple logics. Now, I would like to query the Purchase Order Lines (Record 2) from my process model and set their status to "Billed" too. In this case, I have to apply the following conditions: 1) The Purchase Order ID is the same as the used in my process  2) The materials of the Order Lines are the same as the ones created in the process I have been trying with the query database smart service (update-set-where) but it gives me problems when trying to filter by a more than one string (materials) How can I afford this "update" in my process? Which smart services do you recommend me to use?

I have a process variable of map type and i am getting data like below array.How can i cast this to map.{id=1, Name=,class=12, sub=, }

Hi All, I created a process report and one of the column definition is a record field(pv!record.orderNumber)  and am not able to see it in report. When i check in documentation, I could see as below But when i try to query using a!queryProcessAnalystics, the field is still showing blank for me. Am i missing anything? Thanks in advance!

I have a rule rule expression which returns a datasubset in which the data has repeating rows. Since the data is coming from a view in mysql backend, I want to handle this in appian by getting only unique rows and remove all duplicate rows while still maintaining the paging. The data should be unique for 'stateroomRequestId'. I have tried using union but it does not work with datasubsets and only data a!queryEntity( entity: cons!BUS_ENTITY_REQUEST_VIEW_DETAILS, fetchtotalcount: ri!fetchtotalcount, query: a!query( selection: if( rule!APN_isEmpty(ri!selection), null, a!querySelection( columns: a!forEach( items: ri!selection, expression: a!queryColumn( field: fv!item ) ) ) ), aggregation: ri!aggregation, logicalexpression: a!queryLogicalExpression( operator: "AND", logicalexpressions: ri!logicalexpressions, filters: { ri!filters }, ignorefi

Hi All, I currently have 3 tables, managers, employees, and a third table for foreign keys managers_employees where I have a primary key, a foreign key to the managers table and a foreign key to the employees table. When I'm trying to write to the DB I'm having an issue with the employees foreign keys since they can be multiple employees but they all belong to the same manager. So for example my tables should look like this: managers table:  ID name 6  Alan, Nus Employees Table: ID Name 10  Kim, Perez 11 Luz, Asos managers_employees table ID  Manager_key   Employees_key 1        6                       10 2         6                       11 When I'm doing this in my process model in a script task after writing to the employees table, I'm not able to retrieve the employee

Hi all, Is it possible to add cusomField1 to 10 into record type user ? My first approach was adding a custom record field but user function cannot be used inside. Any idea ? Regards  Jean-Alain

Hi! I have a summary view with a read-only grid (from Record 1). When I run my process model, I make a query (type "UPDATE" and "SET") to change the status of one of the fields, and I need the read-only grid to update After I run the process model, the value of the variable in my Record Type (Data Preview) changes succesfully... But it does not change in my read-only grid (based on this record I have shown in the last image). To make it "update", I have to go to "Sync Options" --> Start Full Sync manually. After doing this, the read only grid updates. Y tried to use the refresh button of the read only grid but doesn´t work, only full sync What can be happening? Thanks a lot!

Brief Summary: I have a CDT with near to 500 fields that holds some values and just to mentioned I am not using any nested CDTs. I'm using that CDT inside an interface to hold values. I am worried if the application could face any issues in the future if it grows larger. I would like to know even if I have more than 500 fields, is it safe to use that CDT in the application or is it causes any issues in the future. Note: I don't wish to proceed for partial CDTs by breaking the entire CDT into sub-CDTs. Please list down what kind of issues my application may face, if any, down in the comments. Please help me clearing this and I would be gratefully for your help, Thank you.

Hi! I have a site page created from a record list (invoices) When I click in one of the Invoices Id, I access to a summary view (interface), in which I created not only additional information of the record "invoices", but also a read-only grid from another record (Invoice Lines). My problem here is that, if I try to eliminate the record (related record action) from this interface, it does not occur anything and the following error appears I suppose it is caused because of the read-only grid generated in the interface (if I add no editable grid, it works fine). How can I solve this and being able to delete the invoices with the read-only grid inside?

I have to aggregate data based on a column. With aggregate will I get all the Data if the DB contains > 20,000 records. How to achieve it

Hi! I was trying to use a query to obtain a value from a database. Concretely, I want to return the value of a custom record field, with some conditions/filters (the Purchase Order ID should be equal to the one used in the process, and the Status of the Invoice should be accepted). All of this are conditions based in the same record type. I had to use the custom record field (total invoice price, Record 1) to obtain the sum of the price of each invoice line (Record 2).  As I said,  I have not only source fields in my records, but also custom record fields. The problem here is that I can´t refer to the custom record field (pointed in red in the last picture) via query, because that fields are not shown in the database (cloud console). And the querys directly point to the database.  So, what would you recommend me in order to get the value of the custom record field? Is it possible to add the custom record field to the database, in order to make it possible to

Hi All, I have a scenario where i have to populate related action in one of the column in read only grid. For instance, the row with identifier 1 i will populate related action for identifier 2 in that specific column. The issue am facing is that even though i can open that related action with identifier 2, the name of related action is still showing like related action of identifier 1, Note: Am only facing this issue when am using a!recordData as source but I could get desired result when am using a!query record type.You can try this scenario making one value in column as a!recordActionItem(action: record action, identifier: fv!identifier+1 Please suggest if am missing anything here. Thanks in advance!

Hi! I´m having a problem related with data. The data in my record preview does not suit with the data in the cloud database. When compare my site (page created by a record list) and the admin console, it seems to be OK, but the record data preview is not equal. What can be happening? 1. Correct Data (Cloud Database) 2. Correct data (record list page of my site) 3. Incorrect data (the problem is that the second "idPedido" value is one that should not exist, I used it in previous ocasions but was deleted). It should appear idPedido = 2 It seems like the "Data Preview" is saving previous idPedido that were deleted What can I do? Thanks a lot *Extra: I added another row and same occurs. When I click in the table source (record-->data model --> edit data source), it also appears OK, but still wrong in the preview. I uploaded a pic in order to see it in an easy way

Hi All, I have a site which has home page. On Home Page we have a grid populated from Record List, when a user clicks on a record link it takes user to record summary. On record summary, we have record action which opens in the Dialog box. The requirement is that when user clicks on a button on this dialog box, he should be taken back to the Home page in the same window. Is this possible? any workaround or suggestions?

We are creating new Appian tables in a schema with a large amount of data (approximately 45 million) from Oracle DB. We are experiencing significant delays when connecting to the data source and configuring the record type. After selecting the data source, it takes approximately 4 minutes to load all of the tables in the schema, which I believe is unnecessary. We occasionally get a timeout error. Both the search and browse features work the same when selecting the source. Even if we can select the table and sync it, it takes a long time to switch between the record type tabs during development. Every button click takes some time. I appreciate any suggestions you may have.

Hi , I am getting this error while invoking a related record action ,which is not giving any info what could be the issue. Has anyone faced the same issue before, is there any way to trace it?

Hi all, I wanted to know about the best option for a query in static data on database. which would be the most optimal performance: "queryRecordType" or "queryEntity"?

Hi there, could anyone know when configure the "Export Data Store Entity to Excel"/"Export CDT to Excel" smart service, "Save in Folder" can only be set as the folders in Appian platform. Is it possible to export to the application user's local computer? Best regards, Lin

When we use Builders in interface , It will create Interface with rule inputs of given CDT or RecordType , I'm really curious to know how they creating variables dynamically(My guess is that they are running some java code in background) . As far as i know we can't create rule inputs dynamically ,If not correct me. Is there a way to create rule inputs of desired type dynamically??. I created a replica of Builders using functions like keys and runtimetypeof(), But i used local variables in value and saveinto parameters. I want to replace it with proper rule inputs.

Was the issue with Appian being unable to select the scheme in SQL server for recorded types/data stores resolved in 23.3?   Is there an ETA when this issue will be resolved.   This really slows down development on my team and makes appian much harder to use if you are pointing it to a database that has multiple schemes on it.  

Hi All, Scenario is we are connected to a PostgreSQL that has a custom data type, from which we we're able to create a CDT on Appian end and manage to verify it on our Data Store. for the custom data type on Postgre, we transform it to a text and it went well. However when doing a specific query to that specific field, thats where the issue persist. Can you advice on this? Data on Postgre Error when doing a query on the specific field

Hi! I have an interface in which the user can add new Rows. When the user clicks the "Completar creacion pedido" button, the values stored in my local variable are correctly passed to my rule input "recordLineasPedido".  I leave here my structured code: a!localVariables( local!LineasPedido, { a!sectionLayout( label: "LÃ%ADneas Pedido", labelIcon: "list-alt-solid", contents: { a!gridLayout( label: "A continuación, incorpore las lÃ%ADneas de pedido correspondientes y pulse el botón de creación", headerCells: { a!gridLayoutHeaderCell(label: "Linea Pedido"), a!gridLayoutHeaderCell(label: "Pedido"), a!gridLayoutHeaderCell(label: "Proveedor"), a!gridLayoutHeaderCell(label: "Material"), a!gridLayoutHeaderCell(label: "Precio Unitario"), a!gridLayoutHeaderCell(label: "Cantidad"), a!gridLayoutHeaderCell(label: "Importe Total"),

Hi All, We trying to connect to an external connection from another system. Though we are already connected, the tables we are looking for is not there. Upon checking, there are more than 2 schema available on their database, the schema that the tables we want is not the one showing on the recordType "choose database table" instead the other one. Additional Info, when creating a CDT and verifying it on Data Store, other schema and its table cant be map ( "no match table found"), however its verified for all tables under the schema that is appearing on recordType "choose database table" Can you advice if this support is on Appian Admin, or is it on the external side system to make the correct schema adjustment to be selected as default. Thanks

I want to redirect user to my interface instead of summary page. How can we achieve it? Below the screenshot from where currently i am redirecting user to record summary page but now i want to redirect user to interface.