InfoQube IM - Community

Submitted by Tom on 2009/05/19 04:33

Pierre

would you consider (if it's possible) allowing editing of ItemCreated date?

I'm increasing using it to sort items and sometimes would like to be able to bump an item up or down the list

or maybe I should try and think of another way of sorting - maybe I could create a 'fake' ItemCreated field based on the original that could be modified . .

Comments

Hi Tom

I think that you've answered your own question...

On the principle that a name should mean what it says, I do NOT think that ItemCreated should EVER change.

In any event:

You've already got ItemModified - so why not make a change to the Item (trivial if necessary, e.g. adding a trailing space to the Item), which will bump the ItemModified field
Or if what you really mean is, ItemCreatedOrModified, create that field and keep it up to date with a field level equation which initially sets it to ItemCreated, automatically updates it to ItemModified if that changes, and is NOT set read-only, so that you can update it manually

Mark Gregory, Rennes, France - GMT +1/+2; EST +6

Hi Mark,

thanks for your reply

point taken that ItemCreated should not change - Item modified doesnt suit quite so well but i could try it out and see how I get on

I need to be able to send items both up and down the list so your second suggestion could suit well

> Or if what you really mean is, ItemCreatedOrModified, create that field and keep it up to date with a field level equation which initially sets it to ItemCreated, automatically updates it to ItemModified if that changes, and is NOT set read-only, so that you can update it manually

I'd probably start by simply copying the IemCreated field

I know there was an example somewhere of an equation to 'copy' the contents of a second field but I can find it - anyone got any tips? :-)

Tom, I think I have to agree that ItemCreated should remain as such.

However, can't you create another date field (entrydate) define it as (now) which would sort of be like createdate but w the ability to change & sort on that field instead of the actual createdate?

Jan Rifkinson

Ridgefield CT USA

HP Blackbird Vista Ultimate SP-1

> However, can't you create another date field (entrydate) define it as (now) which would sort of be like createdate but w the ability to change & sort on that field instead of the actual createdate?

True but in order to automate it and back-date it I think making it based on ItemCtreated or modified date would be the easiest (I'd only have to manually change the odd item then)

Pierre I couldn't find this in manual or site (it may be there but I couldn't find it) can you remind us how to make one field equal to another ?

and I will add it to the manual then.

Checkout Row level equations in Field Management Dialog - Equations

Why not create a calculated field that would take either the created date or another date if present. Enter the following in the Options section of a date field (name=MyDate)

<source>SELECT ¯qItemCreated.ItemID, IIf(IsNull([date]),[ItemCreated],[Date]) AS [MyDate]
FROM ¯qItemCreated LEFT JOIN ¯qDate ON ¯qItemCreated.ItemID = ¯qDate.ItemID;
</source>

This way, the MyDate field will equal ItemCreated unless something is in the field "Date" (in my IQBase, "Date" is a generic date field)

I can help if you need for a variant with different field names

[edit] I updated Smart Fields (aka smart folders) with this example

[quote=Pierre_Admin]This way, the MyDate field will equal ItemCreated unless something is in the field "Date" (in my IQBase, "Date" is a generic date field)[/quote]

that works thanks Pierre

just curious:

I tried =Itemcreated in the Equations box of the new field - which I had called datemade - that didnt work for new items (datemade field remained empty) so I tried

A: datemade=Itemcreated

in the Auto-assignment rules of the Itemcreated field but that didnt work either for new items (datemade field remained empty)

Just wondering why that didnt work ?

Also wondering - is there a name for this <source> etc. code?

Perhaps related to the problem reported by Tom: Neither CreatedDate nor ModifiedDate are being updated in my principal IQbase.

Mark Gregory, Rennes, France - GMT +1/+2; EST +6

Should not be related to what Tom wanted. Perhaps we should start a new thread. Did you try to repair?

Have repaired, and also upgraded to 0.9.24 C. No change.

Some more information. CreatedDate has ID 534 (which is not a system field, presumably?). ModifiedDate has ID 533. Both appear empty for a new item. If I do a quick search, for that new item, it is reported with the correct Created and Modified fields. But note the difference in field names - and Created and Modified do not appear in the Manage Fields dialogue.

Can you move this conversation to a new thread? I'm not sure how to do that in Drupal.

Mark Gregory, Rennes, France - GMT +1/+2; EST +6

Still hoping for a reply, Pierre...

Mark Gregory, Rennes, France - GMT +1/+2; EST +6

Sorry for the delay, I'm trying to get 0.9.24D out. This is really strange. Can you provide a screenshot? Can you make a copy, deleting all items and send it over?

The attached file has had "Delete all items" done to it.

Good luck with 0.9.24D. I don't know what you did when you took that (to us) long time out to restructure the code, but you suddenly seem to be getting a lot of features and fixes out very quickly. And to judge from the increased activity on the community website, your future purchasers are getting excited all over again. Thanks for all your efforts.

Mark Gregory, Rennes, France - GMT +1/+2; EST +6

And once again I can now see that it's me that's made a mistake!

I have the following date fields in the IQBase:

ItemCreated

ItemModified

CreatedDate

ModifiedDate

The first two are the system fields, and they ARE being updated.

Sorry to raise a false alarm!

Mark Gregory, Rennes, France - GMT +1/+2; EST +6

Great! I'm reassured.

BTW No problem for the false alarm