Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Add last updated date to frameworks and competencies #37

Closed
tejaswidaruvuri opened this Issue Jul 24, 2017 · 25 comments

Comments

Projects
None yet
5 participants
@tejaswidaruvuri
Copy link

tejaswidaruvuri commented Jul 24, 2017

External systems like WorkIt are syncing competency and framework information. We would like to have the ability to check if competency or framework information has been changed in order to sync back to our system. The presence of a last updated date would allow a process to retrieve records that have changed since the last check.

@stuartasutton

This comment has been minimized.

Copy link

stuartasutton commented Jul 24, 2017

That is no problem. The frameworks can have both Dublin Core date created and date modified.

@Lomilar

This comment has been minimized.

Copy link
Collaborator

Lomilar commented Jul 28, 2017

Last Modified can be inferred by taking the last segment of the @id and converting it to a date (UTC millis from the epoch, I believe).

Date Created isn't so easy, but Stuart's suggestion would work. We're adding several schemata to our namespace scope in 0.3.

@cwd-mparsons

This comment has been minimized.

Copy link
Member

cwd-mparsons commented Aug 9, 2017

@Lomilar The original request for a last modified date was to enable a request the equivalent of:
Select * from frameworks where lastModifiedDate > lastSyncDate
Same for competencies.

The purpose was to allow us to sync any records that had been updated since the last time a sync was run.
I don't see how the latter could be accomplished where the modified date is part of the @id property.

@Lomilar

This comment has been minimized.

Copy link
Collaborator

Lomilar commented Aug 9, 2017

Got it. The 0.3 schema (latest) has all objects extending from CreativeWork, which provides https://schema.org/dateModified and https://schema.org/dateCreated and https://schema.org/datePublished.

None of these are enforced.

@siuc-nate

This comment has been minimized.

Copy link

siuc-nate commented Feb 7, 2018

@Lomilar can you post an example or two of data with values in the dateModified field so we can verify it?

Thanks.

@Lomilar

This comment has been minimized.

Copy link
Collaborator

Lomilar commented Feb 8, 2018

This hasn't yet been implemented. Issues listed below.

cassproject/CASS#42 - Sort and search of lastModified.
cassproject/cass-editor#116 - Autopopulate some schema fields.

@siuc-nate

This comment has been minimized.

Copy link

siuc-nate commented Feb 8, 2018

Sorry, I meant actual JSON documents in one of the CASS databases somewhere.

@cwd-mparsons

This comment has been minimized.

Copy link
Member

cwd-mparsons commented Jul 18, 2018

@Lomilar Can this item be added to the priority list? The minimum would be to be able to search by most recently updated.
Should we have this issue in the cass-editor repo?

@Lomilar

This comment has been minimized.

Copy link
Collaborator

Lomilar commented Jul 23, 2018

Yeah. Should be possible.

@Lomilar

This comment has been minimized.

Copy link
Collaborator

Lomilar commented Jul 25, 2018

@stuartasutton

This comment has been minimized.

Copy link

stuartasutton commented Jul 26, 2018

@Lomilar, @cwd-mparsons & @siuc-nate, we need to add a ceasn:dateModified (same as dct:modified) to the schema for both framework and competency.

Note, however, that this is not quite as simple as it seems. A dateModified on the framework means that the data in the framework object has been changed--which would not mean that every (or any) competency node data has changed. And likewise, a dateModified on a competency does not mean that the framework object has changed in any way. So, this is not some substitute for version.

@Lomilar

This comment has been minimized.

Copy link
Collaborator

Lomilar commented Jul 26, 2018

We already implement schema:dateModified, which does what you mention here.

I think the only difference in our perspectives could be that dateModified on the framework changes when a competency is added, removed, or rearranged. On a competency, it only changes when the data of the competency changes.

image

@stuartasutton

This comment has been minimized.

Copy link

stuartasutton commented Jul 26, 2018

The difference is not a big concern.

@stuartasutton

This comment has been minimized.

Copy link

stuartasutton commented Jul 26, 2018

We do, nevertheless, need to add ceasn:dateModified to the the ceasn schema.

@Lomilar Lomilar assigned Lomilar and unassigned Lomilar Jul 30, 2018

@siuc-nate

This comment has been minimized.

Copy link

siuc-nate commented Sep 12, 2018

@stuartasutton is this issue waiting on us to do something with CTDL-ASN or is there still something for the CASS team to do here?

@stuartasutton

This comment has been minimized.

Copy link

stuartasutton commented Sep 12, 2018

No, this is us. It's a missing property from the ceasn schema.

@Lomilar Lomilar assigned stuartasutton and unassigned Lomilar and cwd-mparsons Sep 14, 2018

@Lomilar

This comment has been minimized.

Copy link
Collaborator

Lomilar commented Sep 14, 2018

Any issues to reference, or any followup here, @stuartasutton ?

@stuartasutton

This comment has been minimized.

Copy link

stuartasutton commented Sep 14, 2018

@Lomilar, @siuc-nate & @jkitchensSIUC, nothing beyond getting a ceasn:dateModified property declared. DCMI has a modified and schema has dateModified. Ours should be declared with a "same property as" assertion to both DCMI and Schema.org namespaces. The DCMI definition is quite adequate ("Date on which the resource was changed."). The schema.org definition is less so.

@cwd-mparsons

This comment has been minimized.

Copy link
Member

cwd-mparsons commented Oct 10, 2018

@Lomilar I see that dateModified is in the CASS (JSON-LD) export, but not in the Credential Engine ASN (JSON-LD) export.

@Lomilar

This comment has been minimized.

Copy link
Collaborator

Lomilar commented Oct 15, 2018

The JSON-LD Schema at http://credreg.net/ctdlasn/schema/context/json lacks an entry for dateModified. See comment from Sep 14.

I can make the change on our side first, but that will introduce an awkward looking variable into the export.

@siuc-nate

This comment has been minimized.

Copy link

siuc-nate commented Oct 15, 2018

We don't currently have a ceasn:dateModified property, pending or otherwise.

Would something like this work?:

URI: ceasn:dateModified (or lastUpdated ?)
Label: Date Modified (or Last Updated)
Definition: The date on which this framework or competency was most recently modified (updated?) in some way. (or "The most recent date on which this..." might flow better)
Domain: ceasn:CompetencyFramework, ceasn:Competency
Range: xsd:date
Equivalent To: schema:dateModified, dct:modified
Subproperty Of: dct:date (not sure about this one)

While we're at it, it might be good to also declare ceasn:dateCreated to be Equivalent to schema:dateCreated (it's already equivalent to dct:created)

@Lomilar

This comment has been minimized.

Copy link
Collaborator

Lomilar commented Oct 15, 2018

Looks good.

@siuc-nate

This comment has been minimized.

Copy link

siuc-nate commented Oct 24, 2018

Per our 10/24/2018 conversation:
Action to be taken:

URI: ceasn:dateModified
Label: Date Modified
Definition: The date on which this framework or competency was most recently modified in some way.
Domain: ceasn:CompetencyFramework, ceasn:Competency
Range: xsd:dateTime
Equivalent To: schema:dateModified, dct:modified
Subproperty Of: dct:date

@Lomilar

This comment has been minimized.

Copy link
Collaborator

Lomilar commented Oct 24, 2018

Please notify @Lomilar when this action is taken.

@siuc-nate

This comment has been minimized.

Copy link

siuc-nate commented Oct 25, 2018

The changes above have been made in pending CTDL-ASN and noted in the history tracking.

@Lomilar This goes live tomorrow.
http://credreg.net/ctdlasn/release?releaseID=20181026

@siuc-nate siuc-nate closed this Oct 25, 2018

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
You can’t perform that action at this time.