Discussion Categories

How to display pie chart between 2 dates?

Dear Team, We have a column in DB say file_number which have text values example 1;12 , 12;32 We are trying to query records where file_number is "1" using includes operator. With includes in query it is getting all the records which have 1 (1,12,13). We want the search to match exact to 1 only . Any suggestion ? One suggestion we have is to add a character when writing in DB like @1@;@12@ , and when searching pass @1@.

Hi Expert, How can we generate the Excel file from a data subset, Earlier we had the smart service "Export CDT to Excel" under the excel tool plugin which seems to be deprecated now. Thanks, Gaurav Singh

I have a requirement wherein a table with some information in the columns and  one column with link for each data has to be sent as a PDF attachment over an email to a set of users. We see that the table data populates fine but the column with links when using the PDF from HTML smart service populates as a simple text not as a hyperlink.  The syntax we used for the link was "<td style='width:5%'><a href='" & fv!item[recordtype.url] & "' style='color: #0068a5;'>www.google.com</a></td>" When the rule is called the following data appears but the click here is a text not a hyperlink. Any help is appreciated.

I have 2 users . For showing a demo , i want to login  2 different users in 2 different tabs in chrome browser. These users have  different roles /Gorups But when i login another person in another tab , the other tab also changed to it? How shall i show a demo with 2 different persons logged in ?

Here I have a Plan TypeWithin Plan Type Sum Insured (Min Val and Max Val)Within Sum Insured Year Range (Min Year and Max Year)Within Year Range service center (Agency or Garage)1. I should be able to duplicate whole transaction2. I should be able to add multiple Sum Insured (Min Val and Max Val). 3. When I add this, within Sum Insured I should be able to add multiple Year Range 4. Within Year Range I should be able to add multiple service centers ( 1 Agency and 1 Garage)Now with the current code If I add a Transaction, 2 Transactions are getting addedAfter filling details if I add another transaction, all the values getting disappeared from the 1st transaction If I add Year Range I am getting the following error message (An error occurred while executing a save: Expression evaluation error at function a!map parameter 3 [line 328]: Cannot add incompatible operands of type Null and type Number (Integer).) a!localVariables( local!index: 1, local!planType: {a!map(planType: "", index: l

Here I have a Plan TypeWithin Plan Type Sum Insured (Min Val and Max Val)Within Sum Insured Year Range (Min Year and Max Year)Within Year Range service center (Agency or Garage)1. I should be able to duplicate the whole transaction2. I should be able to add multiple Sum Insured (Min Val and Max Val). 3. When I add this, within Sum Insured I should be able to add multiple Year Range 4. Within the Year Range I should be able to add multiple service centers ( 1 Agency and 1 Garage)Now with the current code If I add a Transaction, 2 Transactions are getting addedAfter filling details if I add another transaction, all the values getting disappeared from the 1st transaction If I add Year Range I am getting the following error message (An error occurred while executing a save: Expression evaluation error at a function a!map parameter 3 [line 328]: Cannot add incompatible operands of type Null and type Number (Integer).) a!localVariables( local!index: 1, local!planType: {a!map(planType: "

what is the difference between HTTP connected system and open API connected system

Hi All, I have an interface A and inside this interface i have provided a dynamic link so that when user click on the link interface A will be hidden and Interface B will be showing up. Is there any way to display the interface B in new tab rather than flipping the interface? Thanks in advance

Hello Everyone , Greetings!  I need to assign the form request to L1 team by task . L1 team must be able to look all the tasks got for those . Now how can i assign task for the L1 team and how to check check the list of tasks for L1 people !  Can anyone help me on this , Please  Thanks and regards   Pavan  

I have design a smart service plugin.but during executing if I miss something in configuration,still process is not breaking.I want if plug-in fail process instance should break and error message should display in process details under errors.Please help me for same

Dear Appian Community Team, I am having at a Record's Data Modal using data sync to the SQL database table. I would like to check with the team whether anyone knows whether we can map a Unique Column which is perceived as VARBINARY(16) on Appian Data Modal to ensure data sync successfully when the source code for the SQL is as below. "ABCD" RAW(16) DEFAULT SYS_GUID() NOT NULL ENABLE, In terms of the error: 

Hi all, I am trying to create a user filter wherein the option labels will come dynamically from an expression rule. I am not quite sure how to achieve this. Does anyone know how to do this ? 

Hi Friends, I have a Small doubt, Can we create a plugin using Appian SAIL Code ?

Hi,  I have some questions regarding the creation of new Knowledge Center to replace the existing one for data storage optimisation.  1. What are the differences between Create Knowledge Center smart service and create it manually (New => Folder => Knowledge Center) aside from the security config? And when should user use each method? 2. My application already have a Knowledge Center containing child folders within it, and each folder contains different types of document.  Now I want to amend this Knowledge Center by creating 3 new KC, and reallocate my child folders into these 3 new KCs.  Those child folders are already being used in lots of process models, so I need to be aware about whether the above changes will affect the process models, and what can I do to avoid it?  And how can I move the child folders and documents within them to the new Knowledge Centers? 

i have created a task report and showed in my site navignation menu . I want to show a counter icon near tasks label in the tab ? hows it is possible?

Hello All, We are using a!safelink to navigate the user to other system. The requirement is we want to store that which user clicked on the link and when in audit table, but as in the safelink there are no saveinto parameter so not able to do that. Can you please advise what to do that in this case and any work around we can do to achieve the requirement. Thank you in advance

Hi, I have a start date and end date and the CDT type for the two fields are text. Now I need a validation that the end date should not be earlier to start date I have given one condition as  validations: if(local!endDate<=local!startDate,"End date should not be earlier than the start date",""), it is working fine if the dates are in the same year. But if I am giving the start date as today and the end date as previous year it is not working. can anyone help me with this

Hi, I'm a newbie going thru the Acme Exercise tutorial. I'm building the AX New Vehicle process model following the directions.  When I try to Save the process model I get the following error: There was an error in an expression in Process Model Properties at processName: Variable(s) not found: ri!vehicle.  But everything appears to be in place.  I even deleted the input and re-created it.  What am I missing?

I have a column in the record type of DATE type.How do I create "no of records day of the weak" column chart?

hi, i use 22.3 version i have an condition in text field  in that i want only alphabetical character (A-Z) not numerical or special character how to do that

The API should send a response to the caller and then start a process.  How ? 

When using a record related action, is there a way to send other parameter values besides the identifier to the dialog screen? I want to select several rows from the read-only grid of screen#1 and pass the information of the rows to the dialog#1. Thank you

I am following the Create Robotic Processes with Appian (RPA).  When trying to record browser interaction to automate the manual step of searching bank name and serial number, I am not able to find Chrome and Edge in the select application dropdown.  And I checked the shortcuts of both chrome and edge in the start menu.

I have a record type customers and their orders . For every customer i have multiple orders. Every 7 days , we need to send a reports of all the open orders to each customer via mail There is no UI form to trigger this . This should be a scheduled job . How to design a process model for this .what nodes / smart services to use. I am new to appian .Please help