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
9 replies
Subscribers
7 subscribers
Views
3177 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
General
Fetching less number of rows
bhanuprakashm
over 7 years ago
I am using one query rule for fetching records from DB.While execute the select query in DB it displays 9 records but when execute the query from appain it displays 3 records..
i dont know where I am doing wrong
please help me
rule!queryrule(pv!text,a!pagingInfo(1,-1))
OriginalPostID-246233
Discussion posts and replies are publicly visible
0
chandu
A Score Level 2
over 7 years ago
did you check whether the query rule has configured any condition? Are u executing the same condition in where clause of the select query in DB?
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
bhanuprakashm
over 7 years ago
yes.. i am checking same condition
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
bhanuprakashm
over 7 years ago
one more thing, if using a!paginginfo with ascending true it displays last 3 records or display first 3 records
I faced very weird behaviour
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
ashman
over 7 years ago
Hi Bhanu,
Could you please check whether you have given unique value as a primary key..I too faced the same behaviour when I test the rule.After changing the primary key,I got the results as expected.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
chandu
A Score Level 2
over 7 years ago
Can we pass pagingInfo to Query rule?Could you please let us know how can we do that?
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
rodgraham
Certified Lead Developer
over 7 years ago
The field that you've got @Id in the xsd,are they all unique values in the database? As I recall In a query rule it'll only return unique rows.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
rodgraham
Certified Lead Developer
over 7 years ago
@chandrasekharg - if you create a query rule, when you call it there's an optional parameter of type pagingInfo, which if passed would return a datasubset
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
chandu
A Score Level 2
over 7 years ago
@rodgraham. Thank You :)
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
bhanuprakashm
over 7 years ago
@ashman,@rodgraham.. thanks for you inputs..now its working fine
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel