How do i Fetch This in Collection?

Please Help me Experts in the Collection to get Length Column. I am Getting only First Value in SQL Query.
Thank You.

Code:

[#Collection: Pending Purc Orders]
     Compute: StorageforLengthh : $$CollectionField:$StorageforLength:1:InventoryEntries
    ;Search Key          :  $Name
    Fetch               : Name, OrderDueDate, FinalBalance, GodownName, TrackLedger, BatchName, BilledQty, +
                          OrderPreclosureQty, Rate, Discount, Amount, OpeningBalance,Parent, BasicPackageMarks, StorageforLength, StorageforLengthh

    ParmVar     : pvAccountName          : String : $$AccountName
    Parmvar     : pvPartyLedgerName      : String : If $$IsEmpty:($$BaseOwner:$PartyLedgerName) then $LedgerEntries[1].LedgerName Else ($$BaseOwner:$PartyLedgerName)
    ParmVar        : pvFirstPartyLedgerName : String : IF @@IsRejIn OR @@IsRejOut Then $$BaseOwner:$PartyLedgerName Else  $.LedgerEntries[1].LedgerName
    Parmvar     : PartyLedVchmode          : String : $..LedgerName

    ;; For Specific Voucher Types,source object is from primary owner (Report Voucher)
    Option                : InPendingOrderwithFltItem       : @@TrackEnabledVchType

    ;; For Other than specific Voucher Types, source object is from stock item allocation report.
    Option                : InPendingOrderwithoutFltItem : Not @@TrackEnabledVchType
   
    Option                : GatherTrackInStr              : NOT @@IsOutwardType AND NOT @@IsInwardType

[#Collection: VCHPo]
   
    Parm Var            : pvStockItemName : String : $StockItemName

    Title               : $$LocaleString:"List of Orders"
    Sub Title           : $$LocaleString:"Name", $$LocaleString:"Due On", $$LocaleString:"Balance"
    Source Collection   : Pending Purc Orders
    Fetch               : Name, OrderDueDate, FinalBalance, GodownName, TrackLedger, BatchName, BilledQty, +
                          OrderPreclosureQty, Rate, Discount, Amount, OpeningBalance,Parent, BasicPackageMarks, StorageforLength, StorageforLengthh

    Filter              : ForNotAppl,TrackOfItem

    Format              : $Name, 8
    Format                : $BasicPackageMarks, 8
    Format                : $StorageforLength, 8
    Format                : $StorageforLengthh, 8
    Format              : $OrderDueDate, 6      : Universal Date
    Format              : $FinalBalance, 8      : Base

    Client Only         : Yes
    Keep Source            : ().        

 

Use Collection Field by Key Function Instead of Collection Field Function

 

Not showing Sir, Please Guide.
[*Collection: Pending Purc Orders]

Fetch : Name, OrderDueDate, FinalBalance, GodownName, TrackLedger, BatchName, BilledQty, +
OrderPreclosureQty, Rate, Discount, Amount, OpeningBalance,Parent, StorageforLength, StorageforLengthh

Compute:StorageforLengthh: $$CollectionFieldByKey:$StorageforLength:$Name:InventoryEntries
Search Key:$Name
ParmVar : pvAccountName : String : $$AccountName
Parmvar : pvPartyLedgerName : String : If $$IsEmpty$$BaseOwner:$PartyLedgerName) then $LedgerEntries[1].LedgerName Else ($$BaseOwner:$PartyLedgerName)
ParmVar : pvFirstPartyLedgerName : String : IF @@IsRejIn OR @@IsRejOut Then $$BaseOwner:$PartyLedgerName Else $.LedgerEntries[1].LedgerName
Parmvar : PartyLedVchmode : String : $..LedgerName
;; For Specific Voucher Types,source object is from primary owner (Report Voucher)
Option : InPendingOrderwithFltItem : @@TrackEnabledVchType
;; For Other than specific Voucher Types, source object is from stock item allocation report.
Option : InPendingOrderwithoutFltItem : Not @@TrackEnabledVchType

Option : GatherTrackInStr : NOT @@IsOutwardType AND NOT @@IsInwardType

 

Do it Like this

[Collection: InventorySearchKeyColl]
Source Collection :.
Walk: Inventory Entries
Compute:UDF:$UDF
Search Key: $VoucherNumber

[Collection: Purchase Order Coll]
...

Compute: Length value: $$CollectionFieldByKey:$UDF:$VoucherNumber:InventorySearchKeyColl

 

Concept: Inventory Entries Doesn't have a search Key By Default That is why...It wasn't working So, I created a collection where I fetched Data Of Inventory Entries and added a search Key

 

Can you share the collection with me. I dont know how to make that.

 

use this

[Collection: InventorySearchKeyColl]
Source Collection :.
Walk: Inventory Entries
Compute:UDF:$UDF
Search Key: $VoucherNumber

 

Nahi hora hai Sir, Now its showing Like this
[Collection:CollForLength]
Type : Ledger Purchase Orders


Fetch : VoucherNumber, Name, StorageforLength, StorageforLengthh
[Collection:mycollforlength]

Source Collection : CollForLength
Walk : Inventory Entries
;Compute:StorageforLength:$StorageforLength
;Compute:StorageforLengthh: $$CollectionFieldByKey:$StorageforLength:$Name:mycollforlength
;Search Key: $Name
Fetch : VoucherNumber, Name, StorageforLength, StorageforLengthh

 

1. Source Collection Should be Current Collection
Example: Source Collection:.

2. If you are saving a value at Sub Object Level then You can't find it directly from main object collection. You have to walk to the sub object after that Compute the Values

Tip: Computed name and Method name should be unequal. Believe me... I have wasted hours by checking Every line of codes and After Doing Everything I solved it by doing this many times.

Example:- Compute:UDFVal:$UDF

 

S

Sir i used like this but it shows nothing.
[Collection: InventorySearchKeyColl]
Source Collection :.
Walk: Inventory Entries
Compute:storageforlengthh:$storageforlength
Search Key: $Name

 

Sir It will not show anything in SQL Query

 

And What is $Name

Until You didn't Computed Name... You can't use it

 

K. I will try tomorrow. $name is order no for each item .

 

Yes Sir, Logically It should work like that But Sometimes That Method worked for me

 

Sir, I tried it But still not working, Now its Showing Last Line Value when using Collectionfieldbykey.

Code:

[Collection: InventorySearchKeyColl]
Source Collection :.
Walk: Inventory Entries
Compute:StorageforLengthh:$StorageforLength
Search Key: $Name
  
[*Collection: Pending Purc Orders]
   
    Fetch               : Name, OrderDueDate, FinalBalance, GodownName, TrackLedger, BatchName, BilledQty, +
                          OrderPreclosureQty, Rate, Discount, Amount, OpeningBalance,Parent, StorageforLength, StorageforLengthh, VoucherNumber
Compute: StorageforLengthhh:$$CollectionFieldByKey:$StorageforLengthh:$Name:InventorySearchKeyColl

    ParmVar     : pvAccountName          : String : $$AccountName
    Parmvar     : pvPartyLedgerName      : String : If $$IsEmpty:($$BaseOwner:$PartyLedgerName) then $LedgerEntries[1].LedgerName Else ($$BaseOwner:$PartyLedgerName)
    ParmVar        : pvFirstPartyLedgerName : String : IF @@IsRejIn OR @@IsRejOut Then $$BaseOwner:$PartyLedgerName Else  $.LedgerEntries[1].LedgerName
    Parmvar     : PartyLedVchmode          : String : $..LedgerName

    ;; For Specific Voucher Types,source object is from primary owner (Report Voucher)
    Option                : InPendingOrderwithFltItem       : @@TrackEnabledVchType

    ;; For Other than specific Voucher Types, source object is from stock item allocation report.
    Option                : InPendingOrderwithoutFltItem : Not @@TrackEnabledVchType
  
    Option                : GatherTrackInStr              : NOT @@IsOutwardType AND NOT @@IsInwardType
;    Select $amount, $name,$StorageforLengthhh from PendingPurcOrders

[*Collection: VCHPo]
  
    Parm Var            : pvStockItemName : String : $StockItemName

    Title               : $$LocaleString:"List of Orders"
    Sub Title           : $$LocaleString:"Name", $$LocaleString:"Due On", $$LocaleString:"Balance"
    Source Collection   : Pending Purc Orders
    Fetch               : Name, OrderDueDate, FinalBalance, GodownName, TrackLedger, BatchName, BilledQty, +
                          OrderPreclosureQty, Rate, Discount, Amount, OpeningBalance,Parent, StorageforLengthhh

    Filter              : ForNotAppl,TrackOfItem

    Format              : $Name, 8
    Format              : $StorageforLengthhh, 8
    Format              : $OrderDueDate, 6      : Universal Date
    Format              : $FinalBalance, 8      : Base

    Client Only         : Yes
    Keep Source            : ().    

 

Sir Did You Computed The Search Key?
Please Try to Understand what you are writing

 

Search key Kaise karu Compute?
[Collection: InventorySearchKeyColl]
Source Collection :.
Walk: Inventory Entries
Walk: Batch Allocations
Walk: Accounting Allocations
Compute:SearchKey:$Name
Compute:BasicUserDescriptionn:$BasicUserDescription
Compute:StorageforLengthh:$StorageforLength
Search Key: $SearchKey

 

Sir Aap 3 times walk kyu kar rahe ho?

 

Congrats Sir

 

Drive sir, helped me in the collection.

 

Oo... What method he used?
Can you share the code So, That I can learn new concepts?

 

[Collection : PurOrd_VchSrc]
Type : Vouchers : Voucher type
Child of : $$VchTypePurcOrder
Belongs To : Yes
Fetch : IsOptional
Filter : NOTIsOptionalVoucher
[Collection : PurOrd_VchSummaryColl]
Source Collection : PurOrd_VchSrc
Walk : ALLInventoryEntries, BatchAllocations
By : Order ID : $OrderID
By : StockItemName : $StockItemName
Compute : MYLength : $StorageforLength
Compute : MYPackageforMarks : $BasicPackageMarks
Search Key : $OrderID

 

Thank you