Appian Community
Site
Search
Sign In/Register
Site
Search
User
DISCUSS
LEARN
SUCCESS
SUPPORT
Documentation
AppMarket
More
Cancel
I'm looking for ...
< Back to user profile
prais1852's Likes
RE: How to validate user input with MS SQL Table ?
Krishna Chaitanya
1)Then write a query entity which fetch the PR table which has rule input PR No,with query filter a!queryFilter( field:"PR No", operator:"=", value:ri!PRNo ) 2)pass the user entered PR number for the above rule 3)if that rule returns data then…
over 6 years ago
Discussions
User Interface
RE: How to validate user input with MS SQL Table ?
Rama Thummala
prais1852 , In your form, 1.Write an queryentity expression rule with PR No. rule input. In query entity add a filter to fetch matchings records with the given rule input. 2.Take local variable or rule input. 3. Update the variable in interface…
over 6 years ago
Discussions
User Interface
RE: How to show MS SQL Server table values in Record List ?
sravanis
Yes, the solution suggested by santoshd378 is correct and I hope this solution helps you. Thanks, sravani.
over 6 years ago
Discussions
Data and Records
RE: How to show MS SQL Server table values in Record List ?
santoshd378
Hi Purp1852, Create a view which returns the data from 3 tables in your database, and then use query database smart service to retrieve the data from view. Now create a CDT with the same number of columns then publish the CDT to data store, now you can…
over 6 years ago
Discussions
Data and Records
RE: How to create conditional checkbox ?
Mike Schmitt
Since it sounds like you're in 17.2 and have a!forEach available, I'll switch my example over to a 17.2 layout real quick. In this updated version i've added one new LOAD variable, which at first is an empty set, but which we will populate with an array…
over 6 years ago
Discussions
User Interface
RE: How to create conditional checkbox ?
Mike Schmitt
Some of the advice you got in your previous thread would likely be beneficial here as well (for example, someone suggested reading up on the SAIL recipes), but I will take a shot at this new use case. You haven't given much info on what you would want…
over 6 years ago
Discussions
User Interface
RE: How to configure Query Database ?
sergeiz
You can use other tool to get correct jdbc connection to your server and verify it works and then put it into your smart service call.
over 6 years ago
Discussions
General
RE: How to configure Query Database ?
sergeiz
In the link I provided the MS SQL connection format is <machine_name>:<port_number>;databaseName=<database_name> The error tells that it cannot connect to host SAPDATADB on port 1433. The first thing you should check that this host:port is accessible…
over 6 years ago
Discussions
General
RE: How to design dynamic form ?
Jason Ruvinsky
I recommend taking a look through the SAIL Recipes in the documentation - they do a good job at going through many different interface use-cases, and explaining how to build them.
over 6 years ago
Discussions
User Interface
RE: How to design dynamic form ?
aloks0189
You can make the use of if() function over choiceLabels and choiceValues of Checkbox and use the same if() to show or hide an another checkbox, when the value gets selected from previous checkbox. For better explanation, if you can share the SAIL…
over 6 years ago
Discussions
User Interface
<