Data Fabric

Hello, I have one main dashboard that displays a readonly grid which has as datasource one expression rule in which i have a a!queryProcessAnalytics. In the grid that I display I'm using a!processTaskLink(). The problem is in case an action is taken on one task where it should return back to the same user, it won't be displayed in the grid anymore (most of the time), only after they refresh the page. I would like to avoid the refresh button on the page and I have also tried with refreshVariables and it doesn't work. Any ideas how I can refresh first the grid and then display the page without being necessary to refresh the page? Thank you!

Hi,  I am working on exporting a record grid to excel. I am getting an error message while using Export Data Store Entity to Excel Smart Service.  Filters field must be of type QueryFilter or LogicalExpression (APNX-1-4505-019).  I am using a script task to get the values and passing into the filter node input.  What could be the problem here? Can anyone help me with it? Thanks   a!queryLogicalExpression( operator: "AND", filters: { a!queryFilter( field: "partNumber", operator: "includes", value: pv!partNumberFilter ), a!queryFilter( field: "supplierId", operator: "=", value: pv!supplierFilter ), a!queryFilter( field: "manufacturerId", operator: "=", value: pv!manufacturerFilter ) }, ignoreFiltersWithEmptyValues: true )

Hi Team,I have a CDT in the below format :  id , item id, field name, field value, field seq no where id is the primary key. Eg of values : 1, 1,  Name, Alex, 1 2, 1, Age, 45, 2 3, 1, DOJ, 2022-04-05 08:56:00, 3 4, 1, Designation, Engineer, 5 Field values in the above CDT are taken from user input in a form. I have another CDT in below format :  id, item id, value 1, value 2, value 3, value 4, value 5, value 6I want the field values from 1st CDT to be saved to value columns of second CDT as per field seq no. Like for the above example of CDT 1, my CDT2 should return :  1, 1, Alex, 45, 2022-04-05 08:56:00,  null,  Engineer,  nullHow can we achieve this in Appian? Our first preference would be achieving this either in an interface or expression rule. We use process model in back end so we can use that also.Appian version 21.1 Any suggestions would help us out.

Hello, I am looking for a way to convert an Svg to Appian Document/PDF. I receive the svg code of a chart through a web service and I am planning to show it in an interface with the plugin Interactive SVG Map Component. Is there a way to insert this svg chart in any type of document (PDF, HTML, DOCX) which will then be downloadable? Thank you for your time.

Need to increment serial number in read only grid as to use in first column. If some of the entries been get deleted then the serial numbers be like,, 1,2,3,4,5.....

I have this task report and i am getting empty values for the fields shown above . How can i update my portal report with values from process model?

Hi all, I'm fairly new to Appian and having trouble filtering a record type.  The field I'm trying to filter by is a boolean. When it's approved, the field changes to 1, if it's denied, changes to 0. But if it's neither approved nor denied, the field is null. I need to filter out all the fields with a null value. I'm currently using the guided configuration and have tried = null, = a!isNullOrEmpty(), <> {1, 0}, and a variety of other methods but none seem to be working. I'm currently working to see if I may need to write it in expression mode instead, but any help or guidance would be appreciated. Thank you!

Hi,   While querying a record data using a expression rule invoking a!queryRecordType from a Timer event results in the "ERROR:EVAL:@reason=Assignment in invalid location" error and Pauses the Process instance. The expression rule seems to work fine from other places like a script task. Please revert back if any solution is found for this or facing similar issues. -Marimuthu S

I have access to an external mysql database. I am able to connect using: command line in linux, windows, workbench, etc. Also no issues with the IP from the caller. When I try to create a Connected System using MySQL datasource definition it always fail to connect. But if I change the DataSource to MariaDb it all works fine, even if it is a MySQL Database. 1

I have created a service backed record having data source as integration. The record data source expression is returning around 500 records but when I try to access it through tempo record it is giving me expression evaluation error that batch size is 100 but largest colum value is 500. Can anyone suggest me how can I set pagination for my record type to get all the data receiving from integration in order to resolve this issue.

when we use the  a!recordActionField function, on the interface by default we are getting tooltip same as the Display Name of the record action. Is there any why to remove this tooltip?

Hi Readers, i have queried a record but getting some unrelated data which need to be ignored would like to know how can we do that in this i just need that number 12, only the number need to be displayed, tried .data at the end which gives the list of records Same in this as well i just need the calculated value only to be displayed.

HI How to Pass record type filter selected value to rule input of other expression rule. Example: Status :NEW is selected in the record type filter in the interface . Need to pass this value to other expression rule.

is making reports using stored procedures is good practice or using expression rule ?? which is best and why?

Hi All, I have created a Data Type and added test data. If I delete a row from the table in appian cloud database, where can i find the logs for that deleted row. I can able to see the deletion activity under <Appian--home>systemlog->audit->rdbms. but not the actual row data. But after deletion , i want to recover the deleted row in appian.  is there any way to recover?or is there any logs available? Kindly help me on this.

Hello Appian and community  Is there a way or allowed to connect cloud appian mariadb with a IDE like dbeaver or a mariadb supported workbench etc. If so please let me know  can we just use this JDBC? or other way  driverClassName="org.mariadb.jdbc.Driver" url="jdbc:mariadb://myinstance.appian.community:3306/Appian?useOldAliasMetadataBehavior=true" or any video if someone has will be helpful Thanks

I want to save the value for Ownership % field (last column) in the below image, as absolute values, i.e (Number/100) E.g. If a user inputs 46.00 in the Interface Dashboard, the database would store it as 0.4600 If there any workaround to achieve this?

Hi    In my interface we are having on filed as time (Text field). User will enter time in a format 00:00 AM/PM .while storing to DB its store as it is .Need to save this value in DB as UTC can we have any function to convert or how we handle this in save into.

I am creating a paging grid with selection that is based on a recordType! in my environment. My interface is set up to follow the paradigm in https://docs.appian.com/suite/help/22.1/grid-with-selection-pattern.html#[line-1-54]-define-local-variables-and-grid-data but with the "data" parameter in the gridField obtained via recordType. Code below: a!localVariables( local!selection:index(ri!selectedStuff,"id",{}), local!selectedRows, /*this is what i need to populate*/ .. a!gridField( data:recordType!Foo, selectable:true, selectionValue:local!selection, selectionSaveInto:{ local!selection, a!save(local!selectedRows,append(local!selectedRows,fv!selectedRows)), a!save(local!selectedRows,difference(local!selectedRows,fv!deselectedRows)), a!save(ri!selectedStuff,local!selectedRows) } ) ) In my use case, I want to be able to pre-populate my local!selectedRows so that the grid can be pre-selected coming into the screen. This is an entity-backed record, an

I want to generate this sample report using the export to excel but they include the  column name in the DSE The format of the report will be like this

Hello! I have a process model which gets the user name and current date to create a log of users and the last time they logged in (Writes to Data Store); this works however I am ending up with multiple records for each user and I wanted to set this so it only creates unique users and captures the most recent login date for existing users.Currently the user Id is simply an integer and each time user details are captured a new record is created with a new integer - I have an expression rule which I can use to query the username (known unique field) and return other details ("userId", "Date" etc etc) I was hoping to check this and if a user "exists" in the Record Type only update the date.Any ideas at how I can update the process model to do this?? I was initially thinking/hoping I could run the expression rule from the process model(not sure how?!) then have an XOR gate to check if userId not blank then create a new user record in data store else p

Step1: I have a record type backed by a Webservice. My expression: local!integrationResponse.result.body.rawData returns list of dictionary as below: List of dictionary - 4010 items Dictionary - Region "" (Text) - State"" (Text) When I tested data source, I got below error in record type: The Record Data Source did not evaluate to a DataSubset. Received: List of Dictionary. Step2:  I modified my expression as todatasubset(local!integrationResponse.result.body.rawData). Now the record type displays 4010 empty records. May I know how to resolve the dataset returned to match the datatype of the record.

Can Convert to Excel read the specific row and Column?

I want to export a multiple data using the expression rule, Can export to excel export that data? for example 0001, abcd, ads, sda0002, abcd, ads, sda0003, abcd, ads, sdaTotal of 0003 

Added a field to a database table.  The CDT based on the table does not have the new field after running SYNCH. Not sure of the correct way to accomplish.  If need to  Download XSD, make change manually, and then Upload XSD, what is the process to upload XSD and apply it.