General

Hi Expert, I have made a expression rule which is returning datasubset . For eg: This is my query entity returning data. Col A   Col B   Countcolumn a         b               2 d         e               3 g         h               1               Now i want to repeat row based on count column.How can i achieve following output: Col A  Col B a          b a          b d          e d          e d          e g          h Please help.

Has anyone been able to run FitNesse for Appian with a Password File? http://fitnesse.org/FitNesse.UserGuide.AdministeringFitNesse.PasswordFile Here's what I'm seeing.  All runs use the following command java -jar fitnesse.jar -a "passwords.txt" where the passwords in each file are cleartext or encrypted passwords.txt users.properties Result cleartext cleartext good encrypt cleartext good encrypt encrypt Invalid argument encrypt no user=password line error encrypt no file error cleartext no file error When it's run, the authenticator says MultiUserAthenticator (password.txt) versus PromiscuousAthenticator (users.properties).  But, the above tests seem to indicate that passwords.txt is being ignored completely and FitNesse is only using users.properties. I hope someone can shed some light on this for me.  Thanks

We have a requirement to showcase end users the deployment details like we developers can see in the deployment tab inside designer. Business Users wants to see the incoming deployments for a specific application, time, number of Objects , Object details, object versions etc. Is there any way we can achieve this ?P.S I have installed log reader plugin to read deployment logs but unable to see details

I want to do something like this: CONST MIN_YEAR = 15 int[] yearOptions for int i = year(date)-MIN_YEAR to year(date)+1 { yearOptions.push(i) } How can I do this in Appian?I suspect this need to be an expression rule and the number 15 may change while I'm working on the interface.

Zuuuup, people ? So, I've been developing a process model (not from begin, some other guy started development before me) and, sunddely, everytime I click on the drop with variables, all tabs in chrome with an Appian url rise an error about "out of memory". I'm trying to click on this drop:  Is it something knowed? I mean, may I or someone else missunderstanding some config ? Thanks anyway for your time spent reading my question !

Hello, Does anyone know how can I populate the node input "Custom Cell Values" on the smart service "Export Data Store Entity to Excel" with the result from the query that is performed on this node ? So basically, a query is performed on the DSE, then on the same node is it possible to map an existing template on specific cells with the result of that query?  The same can be accomplished with plug-in "Export CDT To Excel", considering an existing template and populating specific cells with CDT values. So, since this one is deprecated and Appian advices to not use this plug-in, how can we accomplish the same with this smart service ? Any ideas ? Thank you in advance

Input: "MAHESH, Output: {"M","A","H","E","S","H"} how to approach this?

Hi All, I made a new channel in IDP, submitted training documents for specific type. But even after many hours, IDP did not got trained to auto classify my documents. Neither I got any error email. I did this multiple times with different training documents, but every time IDP just shows a message that docs are submitted for training, and I will get an email once they are trained. But I never get any email about that. I just want to ask, is the feature to train documents for auto-classification even available for Appian community edition users? Note: This question was asked about a year ago and did not get any answer yet.

I have to local variables as input 1. List of dictionary : [ [ id:1,value:"abc" ] , [ id:2,value:"bbb" ] , [ id:4,value:"ccc" ] ] 2. List of integers: [1,4]  I want to create 3rd local variable (List of values) by selection value from dictionary where id is present in the List of integers  example :  result ->    List of values : [ "abc","ccc" ]

I am getting error as below on calling Oracle's stored procedure using a!executeStoredProcedureForQuery.  Stored procedure and expression are attached below. Help is much appreciated.

I am trying to add JSON object inside a JSON object but the generated JSON is not in the correct format. The child json is in double quotes.  How can I get rid of these double quotes? Can someone help me with a correct substitute() function command?

Hello everyone, I wanted to share a little advice with you, and hopefully, maybe Appian will also take note and resolve what an abysmal design decision is.Problem Statement:Appian has created the teardown method as a step that runs in the feature file. This is a terrible design. The reason it's a bad design is that the teardown method is what closes the browser and also kills the background Chrome/Firefox driver process. Since it's being invoked as a feature step, this means that if your test fails, the teardown step/method will not be reached. In addition, if you end a test early, it will not be called. The implication of this is that you end up with lots of browsers you have to close manually, and even worse, every time it happens, you have a driver process running in your PC/Mac background, and the more times you do it, the more they add up, eating away at your memory until you have to reboot your PC/Mac. I will show a screenshot of the step I am referring to.  Sol

I have a grid with dynamic column names and static columns. Ex :  Here EmpSub's will varies on each instance.Need the word document format to get the dynamic columns syntax in word document. Able to get the rows data from the CreateDictinoary function but need the exact format to write in the word document. Thanks in Advance.

Hi, I need to find out if a given date is in the last week of the month.  For example 27th of March 2023 is in the last week of the March month.  How can I achieve this?  Please give me the suggestions. Thanks and Regards, Brinda Sateesh

Hello everyone,We are trying to make sure SAML users, if idle, logout after 60 minutes. But for some reason the timeout is set to 20  minutes. After going through the documentation I have seen Admin console> Appian >session time out is suppose to fix it but it doesn't seem to work in my case. Any idea where to start?

I have a scenerio.The below mentioned example rule should repat based on the local variable local!a each input. localvariablesa( local!a: {"A","B","C"}, local!b : {"X","Y","Z"}, a!forEach(items: local!b, expression : rule!getTestData(input1 : ri!employee, input2 : local!a[1])[fvIndex], rule!getTestData(input1 : ri!employee, input2 : local!a[2])[fvIndex], . . . . rule!getTestData(input1 : ri!employee, input2 : local!a[n])[fvIndex], ) )

Hi, I have a scheduled process that executes multiple SQL scripts.The final of these scripts recreates triggers dropped in the first script. Since triggers can't be created in a Stored Procedure; I am unable to use the Execute Stored Procedure smart service and, due to the scripts complexity, use the Query Database smart service. Is there another way this can be executed from the process model? Thanks

I'm trying to  extract  a  big amount of question from a  PDF file that has around 1000 pages  and the section  where we find all those questions. The program is doing it  we can run  the process an everiything is fine but suddenly  the appian server  shows the 503  error   even though we are not running the process i split the pdf  in  batches of 30 pages  every time a 30 page batch   is evalueated and the  questions are extracted we save the   questions found in this  variables and this sub process die and  go  to the main process  and do the same  thing till  we get to  have all the questions and sections   the  time for this process is about 10 minutes in doing all of this operations. how can we minimize the high load of the site ?  the Appian team told us that the aplication server was killed by their automation. After

In a pipeline : as an input I have a parquet file I'd like to do row by row of the parquet file (foreach ?): make a call to a soap xml api according to result call : = if ok store the result (xml file) in a blob container. = if not ok store the result in an azure storage table. I've already done such a thing with an azure webjob would it be makable (rather simply) with azure synapse analytics ?

We have a n export scheduled to ran daily for billing , when Microsoft has outages and task fail we do not get any alert for the failed export job and we cannot even see event logs. How can we create alert for any failed export or job not received in the billing export container We haven't tried anything as yet , since MIcrosoft Engineers couldn't help us .

Hello Community, Does anyone knows how to read data from a docx file in the same way we can do for PDF files? I read that is possible to convert docx files to pdf and maybe accomplish this, but not sure. Please let me know if you have some ideas how to accomplish this. Thank you

Hi, is it possible to receive multiple messages on one Receive Message Event? I need to use Receive Message Event to stop the process flow until all the fields of multiple entities are populated, so I have a Send Message Event on each asynch subprocess that sends a message to my main one that the fields have been populated. There is also an Expression Condition on Receive Message Event that checks if all entities have populated values. If it's possible to receive multiple messages, does the condition get validated each time it receives a message? Thanks!

How to set date-time format into : "jul 8 , 2021 9:35 AM" from using Date-time 

i have few doubts can someone clear me the doubts? i want to write the exam for L1 so which exam i have to take? here i found these, but not sure which is exam is for which level if i want to write L1 and L2 exams at a time then, which exams i have to register for and take?

First Create Function To Calculate Sum called : Calculate_Sum a!localVariables( if( ri!monthName null, sum( todecimal(index(ri!months, { ri!monthName }, 0)) ), sum( todecimal(ri!months.jan, 0), todecimal(ri!months.feb, 0), todecimal(ri!months.mar, 0), todecimal(ri!months.apr, 0), todecimal(ri!months.may, 0), todecimal(ri!months.june, 0), todecimal(ri!months.july, 0), todecimal(ri!months.aug, 0), todecimal(ri!months.sep, 0), todecimal(ri!months.oct, 0), todecimal(ri!months.nov, 0), todecimal(ri!months.dec, 0) ) ) ) Now Create Form in Grid to calculate and call the sum function: a!localVariables( local!invalidIncome: ("Please insert valid income value."), local!DuplicateIncome: ( "Duplicate value. Please check and delete if duplicated" ), local!CurrentRow: 0, local!TotalRow: 0, local!monthDetail: a!map( jan: null, feb: null, ma