Discussion Categories

Hi All, My scenario is to filter the below view column in appian expression rule using the two rule inputs of "date" dataype(startDate,EndDate), We can see in screenshot, the  column is of text and its in concatenated way, is it possible to filter this from appian? Could you please help me on this. Thanks in Advance.

if( isnull(ri!type), {}, a!forEach( items: a!queryEntity( entity: cons!POINTER_TO_DSE, query: a!query( filter: a!queryFilter( field: "type", operator: "=", value: ri!type ), pagingInfo: if( isnull(ri!pagingInfo), a!pagingInfo(1, - 1), ri!pagingInfo ) ), fetchTotalCount: true ), expression: if( ri!type = "Text", updatedictionary(fv!item, { textField: true }), if( ri!type = "Decimal", updatedictionary(fv!item, { decimal: true }), if( ri!type = "Date/time", updatedictionary(fv!item, { dateTimeField: true }), if( ri!type = "Integer", updatedictionary(fv!item, { integer: true }), if( ri!type = "Date", updatedictionary(fv!item, { date: true }), if( ri!type = "Boolean", updatedicti

Hi All I have a related action at record summary dashboard, when I initiated related action, I am able to see interface mapped at User Input task, but when I fill and submit the form, I observed two things, 1) I am getting not authorized message at UI. 2) My process instance is getting paused at write to datastore node. I checked process instance data, process variables having proper data to store,

Has anyone worked the GET method "deployment-management/v1/inspections/" to inspect a deployment package, through API Rest? It gives me the following error: But when running the "Get Deployment Log" with the same uuid, if it works Will I be doing something wrong? Thanks a lot

Hi i have written code like this to get a grid it's a editable grid and for this now when i click add row then complete grid has to be added  how can i write logic for it can anyone help on this  a!gridLayout( labelPosition: "COLLAPSED", headerCells: { a!gridLayoutHeaderCell( align: "LEFT" ), a!gridLayoutHeaderCell( align: "LEFT" ) }, columnConfigs: { a!gridLayoutColumnConfig( width: "DISTRIBUTE", weight: 5 ), a!gridLayoutColumnConfig( width: "DISTRIBUTE", weight: 3 ) }, rows: a!forEach( items: ri!crAPPContractExtension_cdt, expression: with( local!SingleREFContractExtension_cdt: index( ri!crREFContractExtension_cdt, wherecontains( fv!item.extensionRefId_int, ri!crREFContractExtension_cdt.id_int ), {} ),

I am having a editable grid in that  I am adding a rows and in sometime I deleted some of the rows then the values depending upon it needs to be updated For eg. I am having a field in editable grid called marks and total. If I deleted a one row(marks) Then the total needs to be updated after deleting

So basically in site I'm getting all the data from db whre as i have only one field where use input task is req. And that is a date field I need to input the date from site can anyone help me with this?

Hi, I have a requirement where I need to get the total no of documents created last month in the environment. I have added all the document folders in a constant and tried to fetch the documents count but I'm getting an error as "The passed parameter(s) are of the wrong type. Received the type List of Folder." a!localVariables( local!document: folder( cons!DMF_DOCUMENT_FOLDERS_LIST, "documentChildren" ), sum( a!forEach( items: local!document, expression: todate(document(fv!item, "dateCreated")) > today()-30, ) )) Can anyone please help me.

I am using a editable grid in that there are six columns (column1,2,3,4,5,6) after adding rows to that columns I want add a row at the end for column3,4,5,6 only for calculating the total value. Is that possible in editable grid

I have a list of dictionary with 3 Keys in it I want to add a new Key:Value in all the rows so there will be 4 keys after that.

Hello,Is it possible to send a summary of the test history to the email? (can be in txt or excel format).Thanks.

Hello,Does anyone know if there is a way for fitnesse to fetch data that are inside an excel file and then declare and use it in the input parameters in the tests? Thank you.

Hi,I've been assigned on creating a dashboard which includes showing all the Logs that are executed in the integration..As we can see.. once put check on the integration object the "Enable HTTP request/response logging for this integration object" and we clicked on test request in the integration, it is saved is the system logs>perflogs> http-request-and-responses As for my task, I need to get details from it and save it in appian DB. For POST method:I've managed to get a workaround on this by going to the PM's that were used to execute post integration and just added "write to datastore" in the flow for storing it in the DB. For GET method:I can't seem to find a way on when get integration is executed. I've used smart service also like a!startprocess etc. added in the handler of the get method and it just won't work since we cant run smart service on get method.Do you guys have any suggested workaround for getting the Integ

Hello, I have data like the picture bellow. The type of the data is Any Type(List of Dictionary), It shows that List of Dictionary has 2 items, but, when I use the count() function it returns "1". How can I count the "Any Type(List of Dictionary)"

Any integration function there to over come this challenge 

Hi All  here the use case was selecting particular Id(Product Id) in record list, than it will show all the relavent records in Summary view and In the grid will list out all the Related suppliers(data) only in grid, { a!sectionLayout( label: "Section", contents: { a!columnsLayout( columns: { a!columnLayout( contents: { a!textField( label: "ProductName", labelPosition: "ADJACENT", value:ri!product.productname, saveInto: {}, refreshAfter: "UNFOCUS", readOnly: true(), validations: {} ), a!textField( label: "Productdetails", labelPosition: "ADJACENT", value: ri!product.productdetails, saveInto: {}, refreshAfter: "UNFOCUS", readOnly: true(), validations: {} )

Hi, How can I print the numbers between two numbers. Eg: Number 1 = 1, Number 2 = 5. Expected output 2,3,4 Kindly help. Thanks in Advance

Hi All, I am facing the below error in my process model. I checked the inputs and outputs setup, everything looks fine. I am not getting where the issue is. Could you please help me to resolve this. Thanks in Advance.

Hi I want to filter my data by the field: "provienceID" (image bellow)  in my integration I create a rule input (number integer) The idea is, when I change the test values in the expression, I test with 1 and the result will be all my data with the "province ID" with value 1. I use this expression in query parameter section, but it doesn't filter by the values that I want, it gives me all the values For example for "province ID" with value 1 must show me just 15 fields a!query( filter: a!queryFilter( field: "provienceID", operator: "=", value: ri!provinceID ), pagingInfo: a!pagingInfo(1,-1) )

Is there any way to identify common objects between two or more application. We have more than 30 unused applications and many(more than 2000) unused objects. We are planning to delete all the unused application and the objects which are part of those applications. So we need to delete the objects in bulk, but there are some used objects which are part of those unused application. For this I need to find the used objects in unused application by giving the active application name. Is there any way to do this?

Hi everyone, I am new to Appian and facing challenges in using customFieldPicker, we need to implement: Do we have any Field where user can search for exiting list of values from database, and if value(text column in our case) is not there in the list then whatever value user has typed in can be written to DB on the form submission. Later the value will become part of the list. We implemented it like this: We have one table having 2 fields- id and text only. The ER we created is attached below: We are unable to save the value. Please let me know what I am doing wrong. Thank you!

Hi All, I'm trying to add multiple choices to the choose function dynamically. My interfaces are dynamic , I tried displaying interfaces dynamically using a!forEach() but failed to achieve. choose( local!selectedTab, interface 1, interface 2 interface 3, . . . . .interface n ) Thanks.

loan application flows to the Manager to process it further. The manager has 3 sub-ordinates to whom he assigns the applications for further processing. Requirement#1: As a manager, I should be able to configure the percentage allocation for each staff members. Requirement#2: As a manager, I want the system to auto assign the ingested cases(requests) to the staff members in the configured percentage. where to start and what to do to implement this .. like can anyone please guide step by step for this 

Hi everyone, What are the types of CDTs that can be created, other than the pull-down list on the CDT creation screen? I know text, date, Number and Document. Thank you.

Hi, everyone I want to know Appian case study. Is there a page on the Appian website where I can see the results of Appian case study? Please tell me link. Thanks,