Get the last state of an Object with query definition or REST

Question

Hello ARAS community,

once again o would have your advice.

to be clear, this is what we have in the table of an object :&nbsp;

id&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; REF_NUMBER_&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;MODIFIED_&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;ON STATE&nbsp; &nbsp; &nbsp; &nbsp;IS_CURRENT&nbsp; &nbsp; &nbsp; &nbsp; MAJOR_REV2154BB99E5F046&nbsp; &nbsp; &nbsp; &nbsp; B&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2019-11-06 09:43:54.560&nbsp; &nbsp; &nbsp; &nbsp;Working&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; A2A7B8BD203A54C&nbsp; &nbsp; &nbsp; &nbsp;C&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2019-11-06 09:44:03.450&nbsp; &nbsp; &nbsp; &nbsp;Working&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;A5E2A1CD82CD14A&nbsp; &nbsp; &nbsp; &nbsp;A&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2019-11-06 09:45:41.210&nbsp; &nbsp; &nbsp; &nbsp;Saved&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;AB3CE5360E24449B&nbsp; &nbsp; &nbsp; A&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2019-11-06 09:43:48.837&nbsp; &nbsp; &nbsp; Working&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;0&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;A

I need as a result to get the line 1, 2 and 4. this correspond to get all the object at the state Working and only the most recent one.
My problem is if i use as filter&nbsp;(state = 'working') AND (is_current = 1) i only get line 1 and 2. the 3 cannot be segregated.
Is it possible ?

Thank you :)

skyler_crossman · Answer

Hi Alexandrecimp,
Just to make sure I understand, in this table the IS_CURRENT column is a 1 when it's the most recent version and a 0 if it's old? If that's the circumstance, and you want the objects which have the state Working and are current, then it seems like rows 1 and 2 are the correct output, since row 4 isn't current.
You can effectively do OR searches, but since line 3 has IS_CURRENT of 1, it would turn up in that search. In this data set, just searching for (state='working') would return only rows 1, 2, and 4, but I imagine that in a larger data set there might be rows which are being worked on but aren't current.&nbsp;
Let me know if that helps! If it doesn't, please give a little more detail on what defines the most recent rows. If there isn't a clear answer in the data you have, you might be able to add a property that would have the information you need.
Skyler C.

alexandrecimp · Answer

Hello,
I tried something like that but i am afraid this is still not enough as i have to get all the last version of my object for one state :
Innovator _innovator = this.getInnovator();
//extract logvar _log_item = _innovator.applyMethod("_Get_Session_Variable", "&lt;_variable&gt;Log_Enabled&lt;/_variable&gt;");var _log_enabled = false;if (_log_item.getProperty("_variable_value", "") == "True") _log_enabled = true;
//print log if (_log_enabled) CCO.Utilities.WriteDebug("_" + DateTime.Now.ToString("yyyy-MM-dd"), "run_qry method begin");
System.Diagnostics.Debugger.Launch();
string State = this.getProperty("state","");
Item gti = this.newItem("object", "get");***.setProperty("generation", "*");***.setPropertyCondition("generation", "like");***.setProperty("state", State);// ***.setAttribute("orderBy","generation DESC");***.setAttribute("queryType","Latest");
***= ***.apply();
System.Diagnostics.Debugger.Break();
return ***;

Now i will try to put some SQL in my method^^.

alexandrecimp · Answer

For the community this one works fine :&nbsp;&nbsp;
Innovator _innovator = this.getInnovator();
//extract log
var g_log_item = _innovator.applyMethod("_Get_Session_Variable", "&lt;gtsi_variable&gt;_Log_Enabled&lt;/_variable&gt;");
var _log_enabled = false;
if (_log_item.getProperty("_variable_value", "") == "True") _log_enabled = true;
//print log
if (_log_enabled) CCO.Utilities.WriteDebug("_" + DateTime.Now.ToString("yyyy-MM-dd"), "_run_qry method begin");
&nbsp;
System.Diagnostics.Debugger.Launch();
&nbsp;
string State = this.getProperty("_state","");
&nbsp;
StringBuilder sql = new StringBuilder();
&nbsp;
sql.AppendLine("SELECT ID, g_code, config_id, state, Major_Rev, Generation, is_current FROM innovator.[***] 1 WHERE 1.generation =(SELECT MAX(generation) from innovator.[***] 2 where 2.state = 'Working' AND 2.config_id = 1.config_id)order by modified_on");
&nbsp;
Item _result = _innovator.applySQL(sql.ToString());
&nbsp;
System.Diagnostics.Debugger.Break();
&nbsp;
return _result;

Answer

Thank you very much for your reply !! It is very valuable.&nbsp;
happy wheels

Answer

I agree with you, it was a really useful answer, thank you.&nbsp; jack

Forum Discussion

Get the last state of an Object with query definition or REST

5 Replies

Recent Discussions

DBList request failed: Request uri: 'http://localhost/InnovatorServer/Server/DBList.aspx', Status code: '404', Reason: 'Not Found'.

Batch Loader Download Location / Source Code

MPP 2025 Release (14.0.3) Corrupt Archive

HTTP Error 500.19 after installing Innovator 2025 - Solved

Installing Aras kills IIS?