-
Recently active
Hello all, I uploaded a document in appian, and now I want to create a some rules regarding some fields. For instance I want the blank fields to appear under a certain condition. So I want them to appear if they are automatic tasks, in case they re not i don't want them to show. What's the best practice here
what is the Max limit of creating rule inputs in an expression or Interface?
Hello, I need to know if it is possible to retrieve the SAIL code from an Expression Rule. The requirement is to update the Sail code of an expression rule using the UPDATE EXPRESSION RULE smart service.
Appian seems to have some kind of issues with TIFF or JFIF images, they don't show up in the imagen component, do you know anything about it?, thanksWith PNG or JPG
Hi there, I know I can use any function to check any element is null in an array like this: any(fn!isnull, {0, null, 30}). how to use any function to check if any element is 0? Thank you. Lin
Hi, Could someone clarify my doubt about difference between the usage of the rules APN_isEmpty and APN_isBlank? It would be good if a simple example is illustrated to make it simple to understand. Thanks Faisal
I am trying to pass a 10 digit number (7500882768) as a rule input in my ER and it has to be of integer format only cannot pass it as text or some other format , but it is getting considered as infinity. Is there any way of passing the exact number without it being considered as infinte?
Hi all , I have to generate a table with the help of html . Is there any way to create . Please let me know know the ways
Hi All , I have a query regarding Expression rule .I have DB where isCompleted and IsMandatory fields are there with repect to particular requestID Example: here I want to return only those sites which have isCompleted=1 for all the isManatory=1 in the above example , i must get only requestid =2
Hi all, I have a scenario where I have to send a multiple links in a Google chat in a single message Message format should be like this RequestNo ।। CreatedDate ।। Links 1। Date। Click here And so on How to achieve this Thanks in Advance
can some one tell me on how to create an expression rule to add an array of numbers without suing sum function
Hi Experts, I have 2 filters, one is custom picker EMPID and another is checkbox to "Show current month data", below are the steps i am performing to filter the data: ->Uncheck the check box & then search for an EMPID which is not of current month so that EMPID result shows up ->Now check the "Show current month data" check box & so that the search result cleared off ->Again search for the same EMPID number & no result found shows up in when its checked (Working as expected as its not current month EMPID,) ->Uncheck the "Show current month data" check box & then search again for same EMPID No result found even after page refreshes with "Show current month data" check box unchecked
This code for check the process variable "gap" Boolean is not working. My sample rule is: if( rule!APN_isBlank(ri!gap),if( like(ri!text,"*GAP*"), ri!gap=true(), ri!gap=false()), ri!gap) I need to check if the pv- gap (boolean) is null or empty, then I have to populate the gap as with checking on the like function Else I need to just display the gap (true/ false) as it is which is not null. Problem: Here when I give null/ empty value for "gap", then the true part is executed. It says simply false, even when the like function gives true value (text contains words "gap"). Please help me to execute this scenario.
Hello, I have developed Document Extraction process, the Start Doc Extraction node is working with Google, problem is that it seems the process is not learning. I have summited the same file a few times and each time it is not extracting anything automatically. Any idea if there is any additional setting to be configured in order to remember the manual inputs from previous submits ?
We often use a!update() function to update dictionary values however, it fails when a dictionary has 2 attributes with different font cases (e.g. label & LABEL) In 21.4 I tried using the a!update() function as below: Input: { label:"", LABEL:"asdf", label3:"", label4:"asdf"} Rule: a!update(ri!dict,"LABEL",123) Output: {label: 123, LABEL: "asdf", label3: "", label4: "asdf"} Is there another function that I can use to avoid this? I do not want to recreate the entire dictionary each time someone updates a single value.
Hi All, I am facing an issue both in expression rule and in oracle database but I am confused like what will be the reason for this issue. Issue in expression rule: I just want to query data from database and it runs fine for all task id. But it shows me error only for the task id #141. Issue in Oracle database: When I try to retrieve data in one particular view for task #141 it takes more time(more than 5 minutes) to load even for 2 rows but at last the output comes. But when I try for some other task id it takes time less than a minute even it has 1000 rows. Note : The entity I used in expression rule and the view I ran in oracle database are same. Only for task #141 this issue occurs. We checked process instances, it doesn't show any error. Because of the above issue the users are not able to open the task 141 in site, since it loads for several minutes and then loading pauses then loading disappears. Please help me to sort this issue. Thanks in Advance.
Hi all, i have two question 1.can we select the dynamic operator : for eg : if(1 ri!operator 2,"if true","if false") where operator will belike {">=","<","=",etc..} . which user select from site 2. can apply a query filter on an aggregated column eg: a!query( aggregation: a!queryAggregation( aggregationColumns: { a!queryAggregationColumn( field: "zipcode", isGrouping: true ), a!queryAggregationColumn( field: "caseId", alias: "caseId_count", aggregationFunction: "COUNT" ) } ), logicalexpression: a!queryLogicalExpression( operator: "AND", filters: { a!queryFilter( field: "caseId_count", operator: "
Hi, When I debug a process instance, I can see the value changed of my var in the Process history tab of a Process instances. Example : [unit_id=976, info_data= [quantity=50, fk_line_id=, data=[test1=2, test3=3],[test1=4, test3=6]]] Does Appian provide a native way to convert this string to a String expression ? (replacing "[" by "{", "=" by ":" etc ...) A little java program would make the stuff... but I'm just curious about a way inside Appian (maybe using some json functions). Regards
Hi All, I have a condition where I want to show a user profile photo if it is there otherwise show initials. For Image , I am using a!Image and for Initials I am using a!stampField. Can i use these two together so that if user profile is not present than I can show Initials. Thanks In Advance, Saurabh
I saw that there is a provision for getting multiple values (array) as output from a decision objects. But, how to configure that? Eg. In my decision If I want List of 4 text strings {A,B,C,D} for Input Integer 1, but when I configure output with comma separated values A,B,C,D It is returning a single string "A,B,C,D". Please see screenshot below: Can someone help? Is there any way to achieve this? Or is making hit policy as Rule first the only way possible to get a proper list output from decision? NB: I DON"T WANT MULTIPLE OUTPUT> I WANT SINGLE OUTPUT AS AN ARRAY!!!
Hi All, I tried to fetch data from Database using queryEntity in expression rule. But due to large data in database(6278),it shows me the below error. Could you please help me to sort this issue. Thanks in advance.
We have been using IDP for a month now and we've built up a significant amount of data for our model, now we want to back up our models to another environment so as to have redundancy in case of complete failure on one of the environments, is there any way we can export our trained models for an IDP in another environment?
Hello, I'm reading a record that contains a text field I'd like to have listed in an array. However, the array should only have unique values, so if that text is already in there, I don't need to add it again. I've written this. a!localVariables( local!arrayOfMakes, a!forEach( items: a!queryRecordType( recordtype: recordType!KD VM Vehicle, fields: recordType!KD VM Vehicle.fields.make, pagingInfo: a!pagingInfo( startindex: 1, batchSize: 50) ).data[recordType!KD VM Vehicle.fields.make], expression: if( contains(local!arrayOfMakes, fv!item), null, append(local!arrayOfMakes, fv!item) ) ) ) It returns what I think I need, but it's not unique. Here's part of the output. Further down you would see that it has several entries for the same make. All ideas are appreciated!
Hi All, In my application, I have to use caladddays() function which calculates only the net work days and for daylight boundaries. So for 72 hours, I will use caladddays(ri!date,3) , it works fine.(where ri!date = 1st November 2021,10:00 AM) But the user wants to pass the 2nd parameter by constant and he wants to test for 1 hour by changing the constant value. If I use caladdhours,the outputs are different from caladddays, PFA the below screenshots, If there is anyway to pass hours in caladddays function, can you please help me? Thanks in advance. Regards, Jansi J
Created below table in appian DB Create a CDT and a DataSet. Now I got struck while creating expression rule. Can someone help here. I want to bring id, Name from language table and show the data in a dropdownlist. choiceLabel with "Name" column data choiceValues with "id" column data.
Already have an account? Login
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.