xBrowse Tree (SKIPPER) urgent help

xBrowse Tree (SKIPPER) urgent help

Postby fraxzi » Tue Mar 22, 2011 2:08 am

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
Last edited by fraxzi on Tue Mar 22, 2011 3:44 am, edited 1 time in total.
Kind Regards,
Frances

Fivewin for xHarbour v18.07
xHarbour v1.2.3.x
BCC 7.3 + PellesC8 ( Resource Compiler only)
ADS 10.1 / MariaDB
Crystal Reports 8.5/9.23 DE
xMate v1.15
User avatar
fraxzi
 
Posts: 811
Joined: Tue May 06, 2008 4:28 am
Location: Philippines

Re: xBrowse Tree

Postby fraxzi » Tue Mar 22, 2011 3:26 am

Dear All, MR. RAO,


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


Anyone with sample?


Kind Regards,
Frances
Kind Regards,
Frances

Fivewin for xHarbour v18.07
xHarbour v1.2.3.x
BCC 7.3 + PellesC8 ( Resource Compiler only)
ADS 10.1 / MariaDB
Crystal Reports 8.5/9.23 DE
xMate v1.15
User avatar
fraxzi
 
Posts: 811
Joined: Tue May 06, 2008 4:28 am
Location: Philippines

Re: xBrowse Tree (SKIPPER) urgent help

Postby fraxzi » Tue Mar 22, 2011 12:30 pm

Dear Mr. Antonio,


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


Kind regards,
Frances
Kind Regards,
Frances

Fivewin for xHarbour v18.07
xHarbour v1.2.3.x
BCC 7.3 + PellesC8 ( Resource Compiler only)
ADS 10.1 / MariaDB
Crystal Reports 8.5/9.23 DE
xMate v1.15
User avatar
fraxzi
 
Posts: 811
Joined: Tue May 06, 2008 4:28 am
Location: Philippines

Re: xBrowse Tree (SKIPPER) urgent help

Postby James Bott » Tue Mar 22, 2011 3:20 pm

How about just filtering the database and redisplaying the tree?

Regards,
James
User avatar
James Bott
 
Posts: 4840
Joined: Fri Nov 18, 2005 4:52 pm
Location: San Diego, California, USA

Re: xBrowse Tree (SKIPPER) urgent help

Postby fraxzi » Tue Mar 22, 2011 3:33 pm

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
Kind Regards,
Frances

Fivewin for xHarbour v18.07
xHarbour v1.2.3.x
BCC 7.3 + PellesC8 ( Resource Compiler only)
ADS 10.1 / MariaDB
Crystal Reports 8.5/9.23 DE
xMate v1.15
User avatar
fraxzi
 
Posts: 811
Joined: Tue May 06, 2008 4:28 am
Location: Philippines

Re: xBrowse Tree (SKIPPER) urgent help

Postby James Bott » Tue Mar 22, 2011 3:46 pm

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
User avatar
James Bott
 
Posts: 4840
Joined: Fri Nov 18, 2005 4:52 pm
Location: San Diego, California, USA

Re: xBrowse Tree (SKIPPER) urgent help

Postby fraxzi » Tue Mar 22, 2011 3:56 pm

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...
Kind Regards,
Frances

Fivewin for xHarbour v18.07
xHarbour v1.2.3.x
BCC 7.3 + PellesC8 ( Resource Compiler only)
ADS 10.1 / MariaDB
Crystal Reports 8.5/9.23 DE
xMate v1.15
User avatar
fraxzi
 
Posts: 811
Joined: Tue May 06, 2008 4:28 am
Location: Philippines

Re: xBrowse Tree (SKIPPER) urgent help

Postby fraxzi » Tue Mar 22, 2011 4:10 pm

Dear Mr. James,

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

Image


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



Kind Regards,
Frances
Kind Regards,
Frances

Fivewin for xHarbour v18.07
xHarbour v1.2.3.x
BCC 7.3 + PellesC8 ( Resource Compiler only)
ADS 10.1 / MariaDB
Crystal Reports 8.5/9.23 DE
xMate v1.15
User avatar
fraxzi
 
Posts: 811
Joined: Tue May 06, 2008 4:28 am
Location: Philippines

Re: xBrowse Tree (SKIPPER) urgent help

Postby James Bott » Tue Mar 22, 2011 5:06 pm

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
User avatar
James Bott
 
Posts: 4840
Joined: Fri Nov 18, 2005 4:52 pm
Location: San Diego, California, USA

Re: xBrowse Tree (SKIPPER) urgent help

Postby fraxzi » Wed Mar 23, 2011 12:11 am

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
Kind Regards,
Frances

Fivewin for xHarbour v18.07
xHarbour v1.2.3.x
BCC 7.3 + PellesC8 ( Resource Compiler only)
ADS 10.1 / MariaDB
Crystal Reports 8.5/9.23 DE
xMate v1.15
User avatar
fraxzi
 
Posts: 811
Joined: Tue May 06, 2008 4:28 am
Location: Philippines

Re: xBrowse Tree (SKIPPER) urgent help

Postby James Bott » Wed Mar 23, 2011 1:52 am

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
User avatar
James Bott
 
Posts: 4840
Joined: Fri Nov 18, 2005 4:52 pm
Location: San Diego, California, USA

Re: xBrowse Tree (SKIPPER) SOLVED

Postby fraxzi » Wed Mar 23, 2011 6:31 am

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. :D

Image

Kind Regards,
Frances
Last edited by fraxzi on Wed Mar 23, 2011 7:47 am, edited 1 time in total.
Kind Regards,
Frances

Fivewin for xHarbour v18.07
xHarbour v1.2.3.x
BCC 7.3 + PellesC8 ( Resource Compiler only)
ADS 10.1 / MariaDB
Crystal Reports 8.5/9.23 DE
xMate v1.15
User avatar
fraxzi
 
Posts: 811
Joined: Tue May 06, 2008 4:28 am
Location: Philippines

Re: xBrowse Tree (SKIPPER) urgent help

Postby nageswaragunupudi » Wed Mar 23, 2011 6:37 am

fraxzi wrote:Dear Mr. Antonio,


Can you help for xbrowse:otree skipper or xbrowse skipper to check if :otreeitem: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:oTree:oFirst

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

G. N. Rao.
Hyderabad, India
User avatar
nageswaragunupudi
 
Posts: 10631
Joined: Sun Nov 19, 2006 5:22 am
Location: India

Re: xBrowse Tree (SKIPPER) urgent help

Postby fraxzi » Wed Mar 23, 2011 7:49 am

Dear Mr. RAO,

Thank you for your explanation.

It seems the only solution is workable.


Kind Regards,
Frances
Kind Regards,
Frances

Fivewin for xHarbour v18.07
xHarbour v1.2.3.x
BCC 7.3 + PellesC8 ( Resource Compiler only)
ADS 10.1 / MariaDB
Crystal Reports 8.5/9.23 DE
xMate v1.15
User avatar
fraxzi
 
Posts: 811
Joined: Tue May 06, 2008 4:28 am
Location: Philippines


Return to FiveWin for Harbour/xHarbour

Who is online

Users browsing this forum: No registered users and 89 guests