General

so i  have a requirement. here can see for the collateral type and description need to generate two separate documents. but here i have to check for the customer collateral type is their or not if type(451) is present then generate 4 docs in 2 colms.  we need to show the it gird how is in the requirement  can someone plz let me know how to proceed. i have checked for the customer the type is present or not then next steps am not getting

Can someone help with example. How to do batching in Query. I have clear understanding of how it works but need clarity while implementing.  Eg: create a query entity rule such as : a!queryEntity(entity: cons!entity, query: a!query(filters{whatever filters you want},local!pagingInfo(startIndex: 1, batchSize: 100)))after this what i need to do? I need to fetch 7000 records

The expression rule below should return a list of dictionary containing loanAmount and monthlyPrincipal. It gives me a strange Expression evaluation error : with no specific errors. If I change ri!loanAmount <= 0, to be ri!loanAmount <= 28824, it works for some reason. Not sure why and not sure what's going on. This rule has a rule input called ri!loanAmount of type number(decimal) which I am testing with 100000 as a test scenario to make this work.  Any ideas what's going on? If there are any other ways to get this to work without doing recursion, please let me know. a!localVariables( local!principalPayment: 100000, local!interest: 15, local!loanTermYears: 30, local!periodicInterestRate: (local!interest/100)/12, local!periodicInterestRateModified: 1+local!periodicInterestRate, local!periodicInterestRateModifiedToPower: power(local!periodicInterestRateModified, local!loanTermYears*12), local!xx: local!periodicInterestRateModifiedT

I have a requirement where based on condition I need to fetch the table name so am storing it in Data Store Entity Type. Am able to fetch the value, but I need to convert this to table name. Can some one help how to convert it. Do help with code or if we have any function Eg: Am getting value in Process Model in Pv!table: 473c45d0-5c99-4665-a335-f772838ccb37@2232 but I need to display exact table name. Note: table is of type Data Store Entity

I have record type that get its source from data store entity and it has default filter and other user filters how can i query the same data using expression rule ? for example we have fields in the data store entity      startedBy , status , location , department  , empId , addedOn and the rule inputs for the expression rule are searchText , selectedLocation and createdOn this is the default filter  a!queryLogicalExpression( operator: "OR", filters: { a!queryFilter( field:"status", operator: "=", value: 2, applywhen: a!isUserMemberOfGroup(loggedInUser(), cons!SP_MANAGER_GROUP) ), a!queryFilter( field: "startedBy", operator: "=", value: loggedInUser() ) } ) and this is the user filters that i want to use (this for user search )  logicalExpressions:  a!queryLogicalExpression( operator: "OR", filters: { a!queryFilter( field: "empId", operator: "=", value:tointeger(ri!s

"An error occurred while retrieving the data. Details: The data source [jdbc/Appian] cannot be reached or its configuration is invalid. Details: could not extract ResultSet" I keep encountering this error while trying to add some filters to the data retrieved from a query entity. The query runs fine and retrieves all the data, however, when I go to add some dynamic filters to this data I keep encountering this error. I am reaching out to see if anyone from the community has come across the same error and what solution worked for them. Basically trying to add a few specific data filters to a search bar in the application. Any suggestions are welcome. Thank you

Hi, Does anyone know how to convert a document stored in appian to an url? to use it as a dynamic link in a json. Thanks!

Is it possible to build a process report that shows me all processes (and id's) that are showing as error ? i can use the existing report that lives under Perf Monitor to view how many instances have errors - but I want to build a house keeping task that will go back and cancel these cases and for that I need to get the process id's for a named procedure. (date filtered) Alternatively how much impact is there when deleting process instances in bulk. 

Hello everyone I have a requirement to remove the decimal point in the value. For example 15.50 into 1550. Is it possible? 

Hello. I built some process flow logic that's checks if a value isn't null and then performs an action. The value is for a property of a CDT processVariable: Ex: if(  a!isNotNullOrEmpty(pv!requestItem.field),  do something, do nothing) I came across an issue where the flow was performing the action when the value is null (value is verified) I'm debugging in an expression rule and can replicate the issue when the query returns a Dictionary list, and I get the intended behavior when using data[1]. The issue makes sense here since the null checks were originally against the list. However, the process variable isn't a list, its a single entity ("Multiple? is No and verified). So I'm not sure why the behavior is happening. Has anyone experienced this and found a solution?

Anyone know how can I change from this format: "mm/dd/yyyy h:m PM" to this format: "dd/mm/yyyy h:m PM". I only want to switch the order for the day and month.  I have tried the following expression, however this way it doesn´t show PM/AM. a!gridColumn( label: "Fecha Recepción", sortField: 'recordType!{b6fc6108-1f5d-4cbe-9c5c-08da4b1d58f3}CPF Maestro Recepciones.fields.{4fa92044-3c8b-438b-b77e-30bf88efbae3}FechaRecepcion', value: if( isnull( fv!row['recordType!{b6fc6108-1f5d-4cbe-9c5c-08da4b1d58f3}CPF Maestro Recepciones.fields.{4fa92044-3c8b-438b-b77e-30bf88efbae3}FechaRecepcion'] ), fv!row['recordType!{b6fc6108-1f5d-4cbe-9c5c-08da4b1d58f3}CPF Maestro Recepciones.fields.{4fa92044-3c8b-438b-b77e-30bf88efbae3}FechaRecepcion'], datetext( fv!row['recordType!{b6fc6108-1f5d-4cbe-9c5c-08da4b1d58f3}CPF Maestro Recepciones.fields.{4fa92044-3c8b-438b-b77e-30bf88efbae3}FechaRecepcion'], "dd/mm/yyyy hh:mm" ) ), align:

Hi, is there an easy way to know how many times and where a component (for example a!hierarchyBrowserFieldTree) was used in an Application? Many Thanks

load( local!crAppComments_cdt: rule!CR_APP_QE_getCoventsAndConditionsCommentsBasedOnFilters( requestId_int: ri!requestId_int, cif_int: ri!cif_int, sourceName_txt: ri!sourceName_txt ), { a!boxLayout( label: ri!sourceName_txt & " " & cons!CR_APP_LAB_COLLATERAL_COMMENT[1], isInitiallyCollapsed: true(), isCollapsible: true(), contents: { a!sideBySideLayout( showWhen: not( contains( ri!buttonAction_txt, cons!CR_APP_TXT_READ_ONLY ) ), items: { a!sideBySideItem( width: "10X", item: a!richTextDisplayField( align: "RIGHT", value: a!richTextIcon( linkStyle: "STANDALONE", icon: cons!CR_APP_TXT_ACTION_ICONS[2], color: "ACCENT", size: "MEDIUM", caption: "Edit", link: a!dynamicLink(

load( local!crAppComments_cdt: rule!CR_APP_QE_getCoventsAndConditionsCommentsBasedOnFilters( requestId_int: ri!requestId_int, cif_int: ri!cif_int, sourceName_txt: ri!sourceName_txt ), { a!boxLayout( label: ri!sourceName_txt & " " & cons!CR_APP_LAB_COLLATERAL_COMMENT[1], isInitiallyCollapsed: true(), isCollapsible: true(), contents: { a!sideBySideLayout( showWhen: not( contains( ri!buttonAction_txt, cons!CR_APP_TXT_READ_ONLY ) ), items: { a!sideBySideItem( width: "10X", item: a!richTextDisplayField( align: "RIGHT", value: a!richTextIcon( linkStyle: "STANDALONE", icon: cons!CR_APP_TXT_ACTION_ICONS[2], color: "ACCENT", size: "MEDIUM", caption: "Edit", link: a!dynamicLink(

I am getting this error while debugging PM How to resolve this ? 2019-00129/23/20232019-00129/23/20232019-00129/23/20232019-00129/23/20232019-00129/23/20232019-00129/23/20232019-00129/23/20232019-00129/23/20232019-00129/23/20232019-00129/23/20232019-00129/23/20232019-00129/23/20232019-00129/23/20232019-00129/23/20232019-00129/23/20232019-00129/23/20232019-00129/23/20232019-00129/23/20232019-00129/23/20232019-00129/23/20232019-00129/23/20232019-00129/23/20232019-00129/23/20232019-00129/23/20232019-00129/23/20232019-00129/23/20232019-00129/23/20232019-00129/23/20232019-00129/23/20232019-00129/23/2023

I am getting error like Premature End of file while generating Pdf how can i resolve this ? a!localVariables( local!voucherDetails: if( a!isNullOrEmpty(ri!batchNum), null, rule!GAI_getVoucherDetails(batchNum: ri!batchNum).data ), local!batchDetails: if( a!isNullOrEmpty(ri!batchNum), null, rule!GAI_getBatchDetail(batchNumber: ri!batchNum).data ), local!date: today(), local!xmlData: if( a!isNullOrEmpty(ri!batchNum), null, concat( "", "", ri!batchNum, "", "", local!date, "", "", index(local!voucherDetails, "description", {}), "", "", index(local!voucherDetails, "claimname", {}), "", "", index(local!voucherDetails, "fundsource", {}), "", "", index(local!voucherDetails, "fundamt", {}), "", "", index(local!voucherDetails, "invoicedate", {}), "", "", index( local!voucherDetails, "invoicen

Hi Team, When using import CSV to Database smart service, is there a way to update the data after uploading the document Eg: In my excel file, I have 3 columns id, name, updatedon id and name values will be availble in the csv file, after uploading the file and when writing to DB we need to update the updatedon value with the updatedon time.

Hi, When I'm trying to upload a document by using startprocess , I'm not able to get the name using document() function. It's showing error as document doesn't exist/ has been deleted. But the document is present in target folder and docid is present..Let me know if am missing anything:

Hi, have a requirement to short a record field which have integer value how can i do that ?

Hi All, The requirement is that we do get a time value with time zone in a CSV in text format (ex: 12:00 CET), which we read and display on UI. When displaying the time on the UI we need to display it in GMT. With the current datetime functions this seems to be difficult to achieve. Other thing in mind is that maintain a table with time zone off set values for different time zones we get and use it to calculate the correct display value. This has its own issue like day light saving adjustments. But before going into that route we need to find if we can still do this easily programmatically.  Any advice is appreciated. Ex: Time value received in CSV : 12:00 CET on UI we need to display 10:00 GMT

here in richtext editor, on click of save values should be null, but after saving the values to DB again can see the values here.  on click of save values should store to DB and on UI it should not show - how can I achieve this?

Hi  Team,I am having use case where we are using IDENTITY feature available in Oracle in substitute of Sequences. and it is working fine from database insertion. But Appian is still expecting sequences.I went through few of the posts regarding  the same but there is no solution available rather than using sequences.I wanted to know if Appian is upgraded with the similar feature ? Anyone has used any strategy to accommodate the IDENTITY change ?Any feedback help is appreciated.

When designing an interface for a record action, I noticed I am having trouble optimizing the UI for the specific dialog box size, since its width and height are fixed. I think we could benefit from dialog box sizes (large, medium, small) being available options alongside device widths in the preview pane of the expression rule designer.  

Hello,I'm currently utilizing intelligent document processing to extract data from PDFs. However, in line with our client's needs, we are interested in exploring the extraction of text from handwritten PDFs or images. Can anyone confirm if this is achievable through Appian? or any other way.

Hi All, We have developed an application. We have designed UI with front-end technologies and back-end with java,  But UI front-end technologies are not acceptable in Client side, Can we use Appian to design front end interfaces and link with backend java code?