tag:blogger.com,1999:blog-6831292026292542607.post239007901654466102..comments2023-04-11T08:05:39.253-07:00Comments on Avinash: CAML Tips n TricksAvinashhttp://www.blogger.com/profile/12901530400733922399noreply@blogger.comBlogger7125tag:blogger.com,1999:blog-6831292026292542607.post-73095966047070262902015-06-14T03:47:27.238-07:002015-06-14T03:47:27.238-07:00Great Blog : I have Shared your Blog on my Blog.
...Great Blog : I have Shared your Blog on my Blog.<br /><br />http://expert-sharepoint.blogspot.com/2015/06/caml-query-tips-and-caml-query-best.html<br /><br />If possible please stay in Touch.Sharepoint Guyhttps://www.blogger.com/profile/14212089541805785513noreply@blogger.comtag:blogger.com,1999:blog-6831292026292542607.post-47348593086574723932012-06-04T00:31:29.856-07:002012-06-04T00:31:29.856-07:00hi sir,how to code about setvar mathod format and ...hi sir,how to code about setvar mathod format and batch format. I am not getting the way..<br />how do we write setvar script..?<br />plz revert me..deepakporwalhttps://www.blogger.com/profile/17011780002332477178noreply@blogger.comtag:blogger.com,1999:blog-6831292026292542607.post-74466337340584288722009-05-04T04:53:00.000-07:002009-05-04T04:53:00.000-07:00Hi,
You can get the column name and its value by:...Hi,<br /><br />You can get the column name and its value by:<br /><br />string startID = splist.Items[100].ID;<br />string endID = splist.Items[110].ID<br /><br />~ AvinashAnitahttps://www.blogger.com/profile/15289896139708682775noreply@blogger.comtag:blogger.com,1999:blog-6831292026292542607.post-35462180573402703052009-05-04T02:27:00.000-07:002009-05-04T02:27:00.000-07:00thanks for your help. But this will not suffice if...thanks for your help. But this will not suffice if some of the IDs are deleted from the List. I need to find for eg 21st to 30th records irrespective of their IDs then what should be the approach.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-6831292026292542607.post-23856044239124979442009-05-04T01:37:00.000-07:002009-05-04T01:37:00.000-07:00Hi,
Assume you are displaying records based on ID...Hi,<br /><br />Assume you are displaying records based on ID (as an example).<br />Now you want to directly fetch records between 100 and 110 (10th paging).<br /><br />You can write a SPQuery that will use "Greater than or Equal to" (Geq) and "Less than and Equal to" (Leq) operations to fetch in-between records.<br /><br /><br /><br />string strQuery = "<Where>" +<br />"<And>" +<br />"<Geq>" +<br />"<FieldRef Name='ID' />" +<br />"<Value Type='Number'>100</Value>" +<br />"</Geq>" +<br />"<Leq>" +<br />"<FieldRef Name='ID' />" +<br />"<Value Type='Number'>110</Value>" +<br />"</Leq>" +<br />"</And>" +<br />"</Where>";<br /><br />~ AvinashAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-6831292026292542607.post-60591094458181806972009-05-04T00:47:00.000-07:002009-05-04T00:47:00.000-07:00Hi Avinash,
Thanks for providing such a useful in...Hi Avinash,<br /><br />Thanks for providing such a useful info. Just one more suggestion required. I require to implement custom paging. In this if user is currently on 1 page and he clicks directly on 10 th Page, then how would i fetch record. I have explored the related propertires of SPList i.e. RowLimit and ListItemCollectionPosition.. but these suffice only when user clicks pages in continuation like 1,2 3, 4.. How should i jump these pages.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-6831292026292542607.post-42911035928415028982008-12-13T11:02:00.000-08:002008-12-13T11:02:00.000-08:00Excellent Avinash!!! Thanks for this quick and acc...Excellent Avinash!!! <BR/>Thanks for this quick and accurate info!<BR/>Prabhash<BR/>www.skysoft.net.inprabhashhttps://www.blogger.com/profile/11989332246176305119noreply@blogger.com