It’s Here. Colombo Agile Conference 2013

Folks from 99X Technology strikes again, starting the year 2013 with a promising event for software professionals. This time let’s talk about bringing the flexibility of Agile methodologies in to software development. The Colombo Agile Conference 2013. The next version of successfully held Colombo Agile Camp last year and one of the most requested too. More information regarding this event can be found at http://www.colomboagileconference.com

The organizers promises on bringing most experienced software professionals in country together at this event. We are also expecting to see the presence of two foreign speakers with a proven track record in Agile practices, join hands with 99X Technology to share their knowledge with the local IT community.

Agile and Me

I personally was introduced to the Agile practices as I join with 99X Technology and without a doubt has solved many concerns I had as a Software Engineer. Agile process is the one of the key trumps of 99X Technology, which has driven the company to an immense growth during the last few years. Hence experiences with Agile which these folks has to share will be unmatched and will definitely help you to deliver faster and profitable results.

So hurry up. Reserve your seat now!

Tickets are priced at 2500.00Rs and will be sold over tickets.lk ( I will update the event link when I have it.) While it’s being published if you want to reserve a seat do let me know.

I hope to see you at the event. And if you managed to attend don’t forget to say Hi 🙂

Filtering Items Based On a Multiple Choice Lookup Field

This turn out to be a very simple solution in the end, although I spent sometime to figure it out. Since Google searched did not helped me, thought if sharing this small tip with you all.

Problem

The solution was developed using SharePoint Designer and no custom coded solutions. There is a SharePoint document library called “Referece Documents” and a SharePoint list with a called “Devices”. A single Reference Document can be for multiple devices. To achieve this, there is a multiple choice lookup filed called “Related devices” in Reference Documents library, which looks-up for data from Devices list. Now the dashboard page needs to filter related Reference Documents when selecting a Device. Both Device list and Reference Documents are listed using a out of the box Data View Web Parts (DVWP). So I need to add a Web Part connection between Devices and Reference Document Webparts, and implement the filter based on Related devices column.

I could not find a way to achieve this using available option in SPD. So the obvious option to tweak the CAML query section and somehow query Reference Documents based on Selected Device.

Solution

First setup a Web Part connection between Reference Documents Web Part and Devices Web Part. With this you can create a new Parameter (“SelectedDevice”) in Reference Document Web Part with selected device. Now you need to alter the CAML query section in Reference Documents Web Part to following.

<Query>
    <Where>
        <Contains>
            <FieldRef Name="ReferencedAsset"/>
            <Value Type="LookupMulti">{SelectedDevice}</Value>
        </Contains>
    </Where>
</Query>

Note tags <Contains> and <Value Type=”LookupMulti”> Which dose the trick of querying the Reference Document related to the SelectedDevices which is passed as a parameter via Web Part connection.

I think other parts of the query is quite self explanatory and I will leave it up to you. However if you have questions don’t hesitate to ask in the comments section below.

See you soon.

hasangaa

I’m Hasanga Abeyaratne, aka Has. I live in sunny lands of Sri Lanka. I’m a software engineer by profession, currently working on helping people to work together, smartly.

This blog will mainly focus on things I do at work, which are SharePoint, Office365, User Experience, User Interface design, HTML, CSS, JavaScript, WordPress, Agile, .Net and Mobile apps. I will also share information on my occasional speaking engagements as well as other life events.

Thanks for reading. Hope to see you soon again.

Take care.
Has