OrientR3S3 - Filtering on SupplierPartCatalog

Get the Supplier with the Minimum Catalog Price for a Part

Initialize

index_1.gif

index_2.png

index_3.png

index_4.png

Find References for Entities, Attributes and Items

Get Model

index_5.png

index_6.png

Get Entities

index_7.png

index_8.png

index_9.png

index_10.png

Find Part Item that has prtID=998

From the Model Find prtID Collection

index_11.png

index_12.png

From prtID Collection Find Datum with the Value 998

index_13.png

index_14.png

Solution 1

Filter and SortBy Catalog Tuples

Filter with prtID=998 and SortBy catPrice

index_15.png

1082 998 7.95 200 03/03/2014 00:00:00 FALSE
1081 998 11.7 400 10/09/2014 00:00:00 TRUE
1083 998 12.5 FALSE
1084 998 48.6 200 20/12/2014 00:00:00 TRUE

Filter Part Tuples

With prtID=998

index_16.png

index_17.png

Filter Supplier Tuples

Catalog Tuple with the Minimum Price for prtID=998

index_18.png

index_19.png

index_20.png

index_21.png

With supID

index_22.png

index_23.png

Solution 2

Filter Catalog Collections

Filter with prtID=998

index_24.png

#54:0 #54:1 #54:2 #54:3
#60:7
#65:10 #65:14 #65:5 #65:9
#66:1 #66:2
#67:0 #67:1 #67:2
#68:0 #68:1

index_25.png

1081 1082 1083 1084
998
12.5 48.6 11.7 7.95
400 200
20/12/2014 00:00:00 03/03/2014 00:00:00 10/09/2014 00:00:00
TRUE FALSE

Filter Catalog Tuples

Find Minimum Catalog Price for prtID=998

index_26.png

index_27.png

index_28.png

index_29.png

index_30.png

index_31.png

Catalog Tuple with the Minimum Price for prtID=998

index_32.png

index_33.png

index_34.png

index_35.png

Filter Supplier Tuples

With supID

index_36.png

index_37.png

Filter Part Tuples

With prtID=998

index_38.png

index_39.png

Projection

index_40.png

index_41.png

index_42.png

index_43.png

Created with the Wolfram Language