FiveTech Software tech support forums

https://i.postimg.cc/ht1z08gJ/LAST.gif

I would like to create something like this, that is, create the possibility of filtering information in an archive. To do a test I took customer.dbf and I put the possibility of searching for the city, the state, Married or not married, the age, and the salary ...

Otto,

178 fields and 2300 records .

Filtering is mostly between 1-3 secs, so no problem here. (FAST = ok)

I'm not looking for a other solution, since it works great for my purpose.

I just want to know if the set filter to .... works indeed like I descripte in the post and is pulling the index ...

... how various methods from different categories work together to handle a single user action. Many other workflows, like navigation, editing, and filtering, involve similar interactions between different sets of methods.

This detailed breakdown should provide a better understanding of how the ...

... Usage Example: (Advanced usage for custom incremental seek logic)

150. RddIncrFilter( cExpr, uSeek )

Description: Performs incremental filtering on an RDD data source using a custom expression.

Parameters:

cExpr: CHARACTER - Expression to evaluate for filtering.

uSeek: - Search string ...

... the list items (e.g., an array or hash).

7. **`uOrgData`**
- **Type**: Variant
- **Description**: Stores the original data source before any filtering or modification.

8. **`nDataType`**
- **Type**: Numeric
- **Description**: Indicates the type of data source (e.g., array, hash).

9 ...

... the plan:

HTML Table Layout : A simple, Bootstrap-based layout for styling and responsive design.
JavaScript for Interactivity :
Sorting and filtering directly in the browser using native JavaScript and DOM manipulation.
Pagination for improved user experience and more efficient display ...

I wonder if using multiple fields to perform a filter (used in a Xbrowse with the headers search gets) the order is important.

Let say that I want foling fields filtered :

Index is on Name : filter like Name...+Color++++Size (filter setting)

Name : Test
Color : Blue
size : Large

Second option is ...

... notice how much unnecessary overhead you accumulate with RDD.

Indexes are still a problem, but I think that with fast SSDs, indexes don't affect filtering and access that much. So, I plan to dismiss them.

SQL is not an alternative for such lightweight, small applications like mine. Additionally ...

... and Autofit.

Did you test with : oBrw:lFastDraw set to .t. ? I don't see it in the test.

Also very important is the fact of using the best filtering/scoping. There have been some postings about this.
In these postings I noticed that Mr. Rao explaned the speed issues if not using the correct ...

This is a interesting sample for filtering....

Mr. Rao,

Would you please be so kind to enhance this sample so that there is a second combobox selecting ages like (20 - 40 - 50 etc)
and state like (NY, WY etc) Any small sample with more combo's will de ok. Please use the array's as data because I ...

In this case, no. Using data architect, I tried filtering for not empty but it still includes them


Sent from my iPhone using Tapatalk

... version. I wonder for my purposes.

I have to reread xbrowse systems for better use with array. Not sure that I will go that way....

Who has information about the RDD (CDX) filtering techniques ? Mr. Rao wrote that this is one of the most important speed issues in xbrowse when not done the best way.

BarGet's purpose is not just for filtering. This helps us to GET some value and it is for us to do whatever with that Value, whether we use for filter or for seek or for setting scopes or for whatever purpose.

Do not underestimate filters.
Scope has limited scope. What I mean is scopes are not ...

BarGet's purpose is not just for filtering. This helps us to GET some value and it is for us to do whatever with that Value, whether we use for filter or for seek or for setting scopes or for whatever purpose.

Do not underestimate filters.
Scope has limited scope. What I mean is scopes are not ...

... scope the data for quick access
case cData = "CustStreet"
set index street
scope the data
otherwise // more fields have been filled in, so filtering will be a better option
do the filter stuff
endcase



here is my current filtercode :



// From insite the Xbrowse setup

oBrwSel:lGetBar ...