1. CLICK HERE TO JOIN WHATSAPP CHANNEL FOR TDL PROGRAMS

Help me in filtering in a collection

Discussion in 'Requests' started by Ashique, Oct 25, 2018.

    
  1. Ashique

    Ashique New Member


    Dear Admin,
    Dear all,
    What should I had in a collection as filter to only collect the voucher type journal and where the stline1 is set to yes ?
    [#part: VTYP BehaviourMain]
    ........
    [Line:stline1]
    field:long prompt,stline1
    Local:field:long prompt:info:"use for auto journal?"
    [Field:stline1]
    Use:logical field
    Storage:atjrnal
    Set always:No
    Inactive:NOT ($$ISJOURNAL:$PARENT)
    [COLLECTION:EXLEG]
    Type:vouchertype
    Filter:namefilter
    [System:Formula]
    namefilter: ???????????????
     
    Ashique, Oct 25, 2018
    #1


  2. sivam

    sivam Active Member


    In Line Level

    [Line:stline1]
    field:long prompt,stline1
    Local:field:long prompt:info:"use for auto journal?"
    Local:Field:Default:Inactive:NOT ($$ISJOURNAL:$PARENT)

    For Collection

    [Collection: Abcd]

    Type : VoucherType
    Child Of : $$VchTypeJournal
    Belongs To : Yes
     
    sivam, Oct 25, 2018
    #2
    vinoth likes this.


  3. Ashique

    Ashique New Member


    But i want to show only that journal voucher type that has value of "use for auto journal" is set to "yes"
     
    Ashique, Oct 25, 2018
    #3


  4. sivam

    sivam Active Member


    In Filter

    namefilter : $atjrnal
     
    sivam, Oct 25, 2018
    #4
    vinoth likes this.


  5. Ashique

    Ashique New Member


    Thank you Sir....You are best..!!:)
     
    Ashique, Oct 25, 2018
    #5


  6. fannu

    fannu Member


    How to Filter Group Parent Filter
     
    fannu, Apr 21, 2020
    #6


Share This Page