Appian Community
Site
Search
Sign In/Register
Site
Search
User
DISCUSS
LEARN
SUCCESS
SUPPORT
Documentation
AppMarket
More
Cancel
I'm looking for ...
State
Not Answered
Replies
16 replies
Subscribers
7 subscribers
Views
3930 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
User Interface
Grid/Paging Grid. 1. How to display a Grid in Portal Form(Data should be fe
anilkumark
over 9 years ago
Grid/Paging Grid.
1. How to display a Grid in Portal Form(Data should be fetch from database). Assume this Grid name as "Available Companies".
2. There is another Grid which is empty. Assume this Grid name as "Selected Companies".
3. Now I want to select the records from "Available Companies" and insert those records to "Selected Company". After inserting the selected records to "Selected Companies" grid, those records should not be available in "Available Companies" grid.
Can any one help me how to do this. Thanks in advance.
OriginalPostID-148564
OriginalPostID-148564
Discussion posts and replies are publicly visible
0
sikhivahans
over 9 years ago
@anilkumark May I know the Appian version on which you are working currently?
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
anilkumark
over 9 years ago
Appian 7.8
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
sikhivahans
over 9 years ago
Great!! So do you want to achieve the functionality on Portal form instead of SAIL form?
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
anilkumark
over 9 years ago
yeah I want to do this in portal.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
sikhivahans
over 9 years ago
@anilkumark Attached the pseudocode of your requirement. Please go through it and do let me know if you have follow up questions.
Pseudocode.txt
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
harshav
over 9 years ago
Step 1: Assuming you have a CDT of type Companies and you call the data using query rule and save the data in a Variable call all companies,before the UI.
Step2: call the pv in a paging grid using todatasubet(pv!allcompanies,data!paginginfo)
Step 3: select the data and click on button select or save
Step 4 in the output of the UI get the data set of the selected IDs . While returning back use the fifference function and remove the selected set from the all companies variable and show it again. now show the selected set in the Selectec companies paging grid.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
harshav
over 9 years ago
*typo error use difference function
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
sikhivahans
over 9 years ago
@anilkumark Please do proceed with queries on the form if you feel that data changes often. For instance, let's say there are hundreds of active tasks and mean while some more data was added to the company records. Having data in PVs might not help you much here, as PVs in live instances point to data queried long back. And at the same time if your data remains constant for ever or if you don't bother about active instances, persisting data in PVs is recommended. So I would like to suggest to go with query or PV approach on need basis.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
anilkumark
over 9 years ago
@sikhivahan. There are to paging grids ("Grid1" and "Grid2"). Grid2 is empty by default. I have to select some records from Grid1 and that selected records should be showed in Grid2 on clicking button/image. And Grid1 data is fetching from database. How can we move selected records from one grid to other grid.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
sikhivahans
over 9 years ago
@anilkumark May I please know if you have gone through the pseudo-code I have attached in the previous comments?
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
>