nchagan さんのグループアクティビティ

Getproperty() function returns only Null Value

nchagan — Wed, 17 Mar 2021 14:56:29 GMT

Hello,

I am facing an issue while developing a server side C# method. My method supposed to pull up all the Manufacturer Parts from the table and iterate through them checking them for a condition. If the condition is met, it should return an error.

I was able to retrieve the Manufacturer Part list and iterate over them. However when I am trying to get the value of a property of the Manufacturer Part, it always returns Null.

***********************************************************************************************

Item Man_Part_List = inn.newItem("Manufacturer Part");
Man_Part_List.setAttribute("where", "[Manufacturer_Part].IS_CURRENT= '1'");
Man_Part_List = Man_Part_List.apply();

for (int i = 0; i < Man_Part_List.getItemCount(); i++)
{

   Item cur_man_part = Man_Part_List.getItemByIndex(i);
   string cur_man_part_name = cur_man_part.getProperty("item_number");       //cur_man_part_name always returns NULL

   if (cur_man_part_name == part_number)
   {
    return this.getInnovator().newError("Manufacturer Part with same name already exist" );
    count = count + 1;
   }

}

***********************************************************************************************

Thanks,

NC.

ApplySQL Previleges Issue

nchagan — Fri, 15 Jan 2021 14:33:45 GMT

Hello All,

I have a method that uses ApplySQL which works just fine for the user that have administrative privileges. However, for non-admin users the method does not work and error out. Learned that this is because of the function ApplySQL, so trying to find alternatives for this function call which could be ApplyAML().

Need some help changing the below sql query that is being passed to ApplySQL to convert into AML so it can be passed to ApplyAML.

ApplySQL():

1) var sql = "select a from [b] where c = '{d}'";
2) var res = document.thisItem.getInnovator().applySQL(sql.replace("{d}", variable));

I came up with this code for ApplyAML() which does not work.

ApplyAML():

1) var doc = innovator.newItem();
2) doc.loadAML("<Item type='b' action='get' select='a'>" +
"<c condition='like'>'%{d}%'</c>" + "</Item>");
3) var res = doc.apply();

The method is a client-side java script.

Thanks

Ask A Question I

Fri, 15 Jan 2021 10:11:35 GMT

Ask a question in a forum.

nchagan さんの グループ アクティビティ

Getproperty() function returns only Null Value

ApplySQL Previleges Issue

Ask A Question I

nchagan さんのグループアクティビティ