Data Fabric

Hi all, Have you ever encountered an error occurred in executing an Activity Class that goes on saying: "each item within the input "Records" must be a record data type. Received: AS Vehicle". It happens since there is a problem with task "Write Vehicle Record" in the process "New Vehicle:" I am completing Process Modeling 101: Automate Your Business Processes (exercise 10) but used only AX Vehicle (ie Acme exericse app) as a record type in the process model. I mapped the value "=pv!vehicle" for the input of the node and did not use the AS Vehicle (ie Acme Solution app). Any ideas why this happens? Thank you!

How to save the accepted ,reject and inprogress status values to make a pie chart of it?

Hi All, I have created a Process report for the viewing the task but i'm facing  this Error in site landing page, but in the interface looks fine. a!localVariables( a!sectionLayout( contents: { a!gridField( label: "Supplier Tasks", labelPosition: "ABOVE", instructions: "A list of all tasks for the Supplier group", data: a!queryProcessAnalytics( report: cons!IA_SupplierTaskCons, query: a!query(pagingInfo: fv!pagingInfo) ), columns: { a!gridColumn( label: "Name", sortField: "c0", value: a!linkField( links: { a!processTaskLink(label: fv!row.c0, task: fv!identifier) } ) ), a!gridColumn( label: "Status", sortField: "c5", value: a!forEach( items: fv!row.c5, expression: if( fv!index = 2, "

Hey, I am creating a service request management application. In that I'm creating a form for the user to fill and submit to raise the requests. Now while submitting the status of the request would be pending and it would be assigned to respective groups of people who would either accept / reject the request. Next while the status is pending, I'm allowing the user to change the details of the request which he / she had raised, so that mistakes in the request if any could be rectified by the user. Now I want to create a validation for it. The validation is, if the user clicks on edit and submits the form without changing any contents of the request, I should show an error message saying "Something needs to be changed in order to submit". Is there any solution to this, as in any way in which I could do this?      

Hi, Scenario 1: I am facing time difference when I am make a DB(postgre) entry via Appian. I am trying to upload an excel from Appian UI with date field column. The database field name updt_td And crt_ts has default values assigned as current timestamp. On uploading my excel I am not passing the above two fields in excel. My Appian user is timezone is EST. After writing to table the default value of these 2 columns get updated with difference of 5 hrs. for EX: If I am triggering at 24-11-2022 10:00 EST in database it shows 24-11-2022 3:30. this value is generating by default if we give column as null. Scenario 2: If in a DB column I pass the value as Now function from my process Model, then also I get the time as mentioned above(increased by 5 hrs). Scenario 3: if I normally write an insert query in database then it takes take default value which is correct. In short when i am uploading via Appian it is taking wrong time.

I have changed the task display name to dynamic. But it is not showing in task report. How to do it?

Hi, I am connected to a database via Connected System in Appian and not JDBC. When trying to use the Import CSV to Database v5 node in my process model, I am getting the error:  java.lang.reflect.UndeclaredThrowableException I am wondering if you are able to use this node when connecting to a database this way? I have gotten this node to successfully work with a JDBC connection just not when my data source is a Connected System. I am wondering if I am just using the wrong syntax for the data source parameter on the node. I am using the exact name of the datasource I can see when connecting the datastore so basically just the Connected system object name. Hopefully someone can help me on this? Thanks in advance

The data in UI is sorted. Excel's data is not sorted, Is it possible to download data that has been sorted from the records list? and is it possible to take off record name and exported datetime.

hello, while generating a record action in a record type, we have the following error. If we try again many times, finally the action is generated. Can someone give an explanation? Is there some log to consult to understand the problem? Many thanks for your answers. Regards

Hi I Would like to know how we can execute Functions in Postgres from Appian. Can I achieve it by using Execute Stored Procedure Smart Service or a!executeStoredProcedureOnSave.  If these doesn't work is there any smart service or function in Appian that I can use to achieve this functionality. Help is Much Appreciated. Thanks, Srikanth 

Hi All, I am Unable to do Sorting on Columns in Records Data Source is Webservice (Using an Expression rule to fetch The Data). Sort Column is already added in Grid Section of Record. Also i have Tried initial and Secondary Sort option availble in Record Section . Secondary Sort: { a!sortInfo( field: OneDate ascending: false() ), a!sortInfo( field: twoDate ascending: false() ) } Initial Sort:  a!sortInfo(field: dateFieldascending: false()) Its Working only when record Loads for First time For next time when we click on column it is not working.   Thanks in Advance!!

Hello, is it possible to change the position of an action button from left to the upper right corner (as it seems to be the default when pre-viewing a record type). My self-built interface with a read-only grid: The auto-generated list-view (which I like a litte bit more) Thank you in advanceThomas

Hi All, I am getting this error , while retrieving the data form db by using queryEntity  I have verified my datastore and it's also giving an error can anyone please help on it ! Regards, Supriya

Hi All, I received the below error email and also saw the error when I opened my record, I checked the sync history of the respective record, it shows the below message, When I checked the particular process, it is completed successfully - this process deletes the data for the particular task(on click of cancel in front end UI by user) from all tables including the table used for this record. This issue is automatically resolved after few minutes, but the business saw this error when they opened the record, so they are asking for the justification which I am not getting what to do here. I can see ,they have canceled many task(10 task approx. ) ,then they created a new task, cancel will trigger the process model which deletes the data from DB, So I am wondering here ,in Database at the same time if we do delete as well as write new data then it will fail during immediate sync? Could you please help me to find out the root cause of this issue .Thanks in Advance !

Hi Team, I want to connect to an Oracle 19c Cloud Free Database. I have tried configuring it in the Admin Console >> Data Sources. But no luck, Can some one help with a sample connection string  for cloud connectivity ? Also let me know if i need to enable anything from the cloud side, for now am able to connect SQL Developer with the cloud wallet file. Thanks, Sunil Mohan

How to group the reports in Tempo Reports tab. Need to create links in left panel and based on the selection, list of reports should display in the right panel. Please let me know

Hi folks, I need Audit multiple database tables by using creation of generic stored procedure. Could you please help me on this? Thank you.

What would be a good way to aggregate data records (or data record types) to display in a list? Appian supports the aggregation of record types in charts - I wonder if there is an easy way to display aggegration results in tables.

I encounter with the question "join performs on 3 table and each table has many rows and queries, it returns many responses". live data not required and 2 hours refresh allowed?? which option we use and why?? options:--store procedures or materialized view

Is There Any Smart Service For Download DDL scripts In Appian

When I am trying to save a filter on the record, getting the below error, or if there are any existing saved filters on the record, the same erorr is being generated and blocking the users to perform any actions on the record. Has anyone faced such kind of issue

In version 21.4,   Export To Excel button is exporting only 1000 records from data base view where we have more records in DB view.  And also the number of records data shown in the grid is not same as the data exported into excel. what could be the issue ? How can we resolve this issue ?

Need help to design & create records for below requirement, Each day 1 parent file and 8 child files will be loaded into DB table. Each child file will be having separate columns except foreign keys. Consider fileReferenceId and dataId are foreign keys. I have to display parent file data on landing page and provide link on dataId. Once user clicked on any of the data Id, user will be redirected to new page where records from child table needs to be fetched & displayed using dataId and fileReferenceId. My Approach:  Create entity backed record using parent table. Whenever user click on dataId  , using 'fileReferenceId ' decide which child table needs to be called from 8 tables. Using 'fileReferenceId and DataId' display returned data on interface. Could you please suggest another approach to avoid so many DB calls. Is it possible to create separate record for each child table and link in the parent record. Thanks, Hemant.

I am new in Appian application development. Can any one please help me to know how can I get and use the Import CSV to Database smart service? Should I use any Plug-ins? If yes where from I can get it? I searched for it but did not get it.

Hi, I made changes to the View (added a column to the view with datatype = text). Added the same definition to the CDT by adding new column with datatype=text. When i try to verify the datastore, it is giving me the below error The data source schema does not match the type mappings: Wrong column type in Appian.p_my_view for column fs_structure. Found: text, expected: VARCHAR(341) (APNX-2-4056-000). see below for CDT definition and view definition. There are other column exists in the view with text and it doesnt complain. any help is appreciated.