StellarDataStoreDataSetVCL filtering problem

FNC TMS FNC Cloud Pack
1

In table is fields "JobReceived" and "JobDone". Both are TDataTime types.

Need to get records where JobReceived contains date and JobDone is empty.

When i add one filter "JobReceived >= 2024-1-1T00:00:00" i get records what are received and also done. But need to get only jobs that are delivered. How i need to setup second filter? Have tryed all kind of variations but with no result.

Second question: How to setup in filter where "JobReceived" is not null?

And third question: DateTime values in table are null. In DB controls shows date 30.12.1899. How to make controls show no date when DateTime in table is null?

2

Hi,

To use multiple filters you can add all required filters to the Filters collection and use the required logical operator with the ALogicalOperator parameter.

For example:

  TMSFNCCloudStellarDataStoreDataSetVCL1.Filter.Add('JobReceived', '2024-01-01T00:00:00', coLargerThanOrEqual, loNone);
  TMSFNCCloudStellarDataStoreDataSetVCL1.Filter.Add('JobDone', 0, coEqual, loAnd);

In Delphi a null date is automatically converted to 1899-30-12. You can add a filter where JobReceived > '1899-30-12T00:00:00'.
You'll need to manually add logic to the DB controls to not show a date when the value in the DB is null.