FOCUS

Tags

    HistoryEdited Jun 9, 2009 8:34 PM by Unauthenticated User…

    Filter Portal not working

    Added by Dillon FIshel (dillonf at lmcases dot com)

    FIXED

    My QUOTE::CT_Filter had a "Buildindex" of an Unstored Calculation keeping it from being INDEXED and it was based off of

    FOC_QUOTE not ERD_QUOTE. (not sure if we are going to make sub pages for problems and solutions.)



    While trying to do a Date Filter I always get a blank portal for the left hand side.
    I copied the layout form UI DEV Session Log
    Created the Database fields in the FOCUS table as follows

    CT_FILTER_TIMESTAMP_S

    TART_QUOTECalculation

    (Timestamp)Unstored, from UIN_FOCUS, = Let ( [

    #_table = "QUOTE" ;

    #_index = TableIndex ( #_table ) ;

    #_timestamp = GM_FILTER_TIMESTAMP_START [ #_index ] ;

    #_reveal = GN_FILTER_FLAG_REVEAL [ #_index ]

    ] ;

    Case (

    #_reveal = 1; // All records are showing

    If ( IsEmpty ( #_timestamp ); GetAsTimestamp ( "1/1/0001" );

    #_timestamp );

    IsEmpty ( #_reveal ) or #_reveal = 0; // No records are showing

    If ( IsEmpty ( #_timestamp ); ""; #_timestamp )

    )

    ), Evaluate even if all referenced fields are empty



    CT_FILTER_TIMESTAMP_E

    ND_QUOTECalculation

    (Timestamp)Unstored, from UIN_FOCUS, = Let ( [

    #_table = "QUOTE" ;

    #_index = TableIndex ( #_table ) ;

    #_timestamp = GM_FILTER_TIMESTAMP_END [ #_index ] ;

    #_reveal = GN_FILTER_FLAG_REVEAL [ #_index ]

    ] ;

    Case (

    #_reveal = 1; // All records are showing

    If ( IsEmpty ( #_timestamp ); GetAsTimestamp ( "1/1/4000" );

    #_timestamp );

    IsEmpty ( #_reveal ) or #_reveal = 0; // No records are showing

    If ( IsEmpty ( #_timestamp ); ""; #_timestamp )

    )

    ), Evaluate even if all referenced fields are empty



    CT_FILTER_LOW_QUOTECalculation (Text)Unstored, from UIN_FOCUS, = FilterLow ( ExtractFilterTableName

    ( GetFieldName ( Self ) ) ), Evaluate even if all referenced fields are empty



    CT_FILTER_HIGH_QUOTECalculation (Text)Unstored, from UIN_FOCUS, = Let ( [

    #_table = "QUOTE" ;

    #_index = TableIndex ( #_table ) ;

    #_filter = UIN_FOCUS::GT_FILTER [ #_index ] ;

    #_reveal = GN_FILTER_FLAG_REVEAL [ #_index ] ;

    #_field = GT_FILTER_FIELD [ #_index ]

    ] ;

    Case (

    #_reveal = 1; // All records are showing

    If (

    IsEmpty ( #_field ) or #_field = FilterFieldDefault;

    #_filter & FilterLimitHigh;

    If ( IsEmpty ( #_filter ); #_filter & FilterLimitHigh ; #_field &""& #_filter &

    FilterLimitHigh )

    );

    #_reveal = 0; // No records are showing

    If (

    IsEmpty ( #_field ) or #_field = FilterFieldDefault;

    If ( IsEmpty ( #_filter ); ""; #_filter & FilterLimitHigh );

    If ( IsEmpty ( #_filter ); ""; #_field &""& #_filter & FilterLimitHigh)

    )

    )

    ), Evaluate even if all referenced fields are empty


    Created the Relationship from UNI FOCUS to FIL_QUOTE as follows

    CT_FILTER_LOW_QUOTE <= CT_FILTER
    CT_FILTER_HIGH_QUOTE => CT_FILTER
    CT_FILTER_TIMESTAMP_START_QUOTE <= TIMESTAMP_CREATED
    CT_FILTER_TIMESTAMP_END_QUOTE => TIMESTAMP_CREATED

    On the UI Quotes Layout I changed the filter fields to be based on the repetition number of the index in UI DEV Tables. I also updated all of the Filter Fields script triggers to use the parameter # ( "TABLE" ; "QUOTE" ).

    My Portal is based off of the FIL_QUOTE table and if I change it to ALX_QUOTE than I do receive a Full List of QUOTES. I can create quotes using the "b create record (table ; -tab)" script with a # ( "TABLE" ; "QUOTE" ) as its parameter. When doing that I am able to enter information into the fields on the right hand side of the layout. But I never get the portal to display.

    Any Ideas

    Comments

    /groups/focus/search/index.rss?tag=hotlist/groups/focus/search/?tag=hotWhat’s HotHotListHot!?tag=hot0/groups/focus/sidebar/HotListNo items tagged with hot.hot/groups/focus/search/index.rss?sort=modifiedDate&kind=all&sortDirection=reverse&excludePages=wiki/welcomelist/groups/focus/search/?sort=modifiedDate&kind=all&sortDirection=reverse&excludePages=wiki/welcomeRecent ChangesRecentChangesListUpdates?sort=modifiedDate&kind=all&sortDirection=reverse&excludePages=wiki/welcome0/groups/focus/sidebar/RecentChangesListmodifiedDateallRecent ChangesRecentChangesListUpdateswiki/welcomeNo recent changes.reverse5search