Praveen Code

Alternative approach with fluent queries.cs

			var client = new VersionOneRestClient(V1_REST_API_URL, USERNAME, PASSWORD);

			var results = client.Query("Story")
				.Select("Name", "Status.Name", "AssetState", "IsDeleted")
				.Where(
					Or(
						Equal("Name", "Story 1"),
						NotEqual("AssetState", 64)
					)
				)
				.Retrieve();

			foreach (dynamic story in results)
			{
				// Debug.WriteLine($"Story OID Token: {story.OidToken}"); // TODO: fix this part
				Debug.WriteLine($"Name: {story.Name}");
				Debug.WriteLine($"Status: {story["Status.Name"]}");
				Debug.WriteLine($"AssetState: {story.AssetState}");
			}
			
			/** Alternative syntax ideas:
			
			// Using chained Or after an operator:
			var results = client.Query("Story")
				.Select("Name", "Status.Name", "AssetState", "IsDeleted")
				.Where(
					Equal("Name", "Story 1").Or(NotEqual("AssetState", 64))
				)
				.Retrieve();
			// Using extension methods:
			var results = client.Query("Story")
				.Select("Name", "Status.Name", "AssetState", "IsDeleted")
				.Where(
					"Name".Equal("Story 1")
					.Or(
					"AssetState".Equal(64)
					)
				)
				.Retrieve();
			**/			

Praveen SDK Code.cs

V1Connector connector = V1Connector
                            .WithInstanceUrl("http://localhost/VersionOne.Web")
                            .WithUserAgentHeader("AppName", "1.0")
                            .WithUsernameAndPassword("admin", "admin")
                            .Build();
                        IServices services = new Services(connector);
            
            
                        IAssetType storyType = services.Meta.GetAssetType("Story");
                        IAttributeDefinition nameAttribute = storyType.GetAttributeDefinition("Name");
                        IAttributeDefinition statusAttribute = storyType.GetAttributeDefinition("Status");
                        IAttributeDefinition asseteStateAttribute = storyType.GetAttributeDefinition("AssetState");
                        IAttributeDefinition isDeletedAttribute = storyType.GetAttributeDefinition("IsDeleted");
            
                        Query query = new Query(storyType);
                        query.Selection.Add(nameAttribute);
                        query.Selection.Add(statusAttribute);
                        query.Selection.Add(asseteStateAttribute);
            
                        FilterTerm isDeletedFilterTerm = new FilterTerm(isDeletedAttribute);
                        isDeletedFilterTerm.Equal("true");
            
                        FilterTerm isClosedFilterTerm = new FilterTerm(asseteStateAttribute);
                        isClosedFilterTerm.Equal("Closed");
            
                        OrFilterTerm isDeletedOrIsClosedFilterTerm = new OrFilterTerm(isDeletedFilterTerm, isClosedFilterTerm);
                        
                        query.Filter = isDeletedOrIsClosedFilterTerm;
            
            
                        QueryResult result = services.Retrieve(query);
            
                        foreach (Asset story in result.Assets)
                        {
                            Debug.WriteLine(story.Oid.Token);
                            Debug.WriteLine(story.GetAttribute(nameAttribute).Value);
                            Debug.WriteLine(story.GetAttribute(statusAttribute).Value);
                            Debug.WriteLine(story.GetAttribute(asseteStateAttribute).Value);
            
                        }