FiveTech Support Forums

Dear All,
Dear Mr. RAO,

How can I filter oTree of xbrowse... say the tree has text = 'FIVEWIN' and I want all tree item with 'FIVEWIN' text only..

How can I show that on already processed tree?

Kind Regards,
Frances

Dear All, MR. RAO,

Maybe a skipper to :bSkip ?? skip when TreeItem:Cargo <> cCondition?

Anyone with sample?

Kind Regards,
Frances

Dear Mr. Antonio,

Can you help for xbrowse:otree skipper or xbrowse skipper to check if treeitem:cargo == condition?

Kind regards,
Frances

How about just filtering the database and redisplaying the tree?

Regards,
James

James Bott wrote:How about just filtering the database and redisplaying the tree?

Regards,
James

Hello Mr. James,

I tried that but if user chooses to search for certain 'string' on ::otreeitem:cargo or on the otree .. the tree created was rubbish... it doesnt meet criteria.
Better if generated xbrowse tree has some custom skipper where I can skip ::otreeitem or tree item not to display so user can select from supposed to be long list (500 items) out of say.. 5 items matching
the criteria.


Kind Regards,
Frances

Frances,

>I tried that but if user chooses to search for certain 'string' on ::otreeitem:cargo or on the otree .. the tree created was rubbish... it doesnt meet criteria.

Well, I have to wonder, if filtering the database didn't work, then how is using bSkip going to solve the problem? I think perhaps that your filter was incorrect. You still need a working filter to use bSkip.

Regards,
James

James Bott wrote:Frances,

>I tried that but if user chooses to search for certain 'string' on ::otreeitem:cargo or on the otree .. the tree created was rubbish... it doesnt meet criteria.

Well, I have to wonder, if filtering the database didn't work, then how is using bSkip going to solve the problem? I think perhaps that your filter was incorrect. You still need a working filter to use bSkip.

Regards,
James

Dear Mr. James,

Perhaps you are right... I also wonder how to solve this..

The xBrowse Tree hasmultiple level.. and filtering those 'strings' somehow not easy at least to me.


I will post screenshots of current xbrowse tree I have.


Kind Regards...

Dear Mr. James,

Here's the xBrowse tree I wish to re-filter or by :bskip with condition




Say... I want to see items with only string 'Telephone'... user should only see items with that string.. 'Telephone'.



Kind Regards,
Frances

Frances,

OK, I have not used xbrowse as a tree before so I don't have any knowledge of how it works.

I am guessing that (for your example) you just want to see the three lines in the first column that contain "telephone?" If so, it seem like you just need a simple two column display for that. Or, did you want to display also some of the tree headings above these records also? In that case the headings don't contain the keyword.

Also are the different headings (Expense, Capital Expenditure, etc.) different fields of the database? As I said, I don't quite understand how this works.

Regards,
James

Dear Mr. James,

If user search for string like 'Telephone' it doesn't matter if headings are shown as long as the searched string displays (ONLY) and go back to normal tree when skip up or skip down
much like of incremental search..

Kind regards,
Frances

Francis,

Well, I think you just need to do a filter something like this:

set filter to upper( cKeyword) $ upper( [fieldname] )

Where [fieldname] is replaced by the fieldname you wish to search.

Regards,
James

Dear Mr. James,

Thanks for all your inputs...


I trashed the Idea on filtering already processed xBrowse oTree.. seems skipper is not easy.. I need to deploy this app today.

What I did is to dump or export the xBrowse oTree to temporary dbf file.. and use that file as the xbrowse... looks like tree. From there i can filter what user's string wishes to find.


Only drawback is that I loose the real Tree Object.. no expandable/collapsible line item... Not Ideal to me... BUT users accept it better than the real xBrowse oTree.

I think FiveWin/Xbrowse developers should have a way to filter-out tree items or similar data source displayed by xBrowse (if not RDD).. just my 2 cents.

I will post similar results under XP my previous screenshot was from my win7 PC back home. I'm in the office right now.



Kind Regards,
Frances

fraxzi wrote:Dear Mr. Antonio,


Can you help for xbrowse:otree skipper or xbrowse skipper to check if treeitem:cargo == condition?


Kind regards,
Frances

It is not impossible to change LinkList ( oTree ) skipper. But providing filtering mechanism in the Trees involves more changes to the class including number of rows, serial number of any row and repositioning to a given row number. Then only the filter works in xbrowse. While there is nothing that is impossible, it involves a lot of changes to the class.

I personally prefer ( and in fact that is what I do in my own programs ), is to set filter to the original dbf ( or the datasource ) and read the filtered data into the tree and set oBrw:oTree := oNewTree and oBrw:oTreeItem := oBrw:oFirst

Please also note that at present xbrowse does not support empty trees.

Dear Mr. RAO,

Thank you for your explanation.

It seems the only solution is workable.

Kind Regards,
Frances