DISPLAYLIST / VALUELIST

[Roberto]

Hello everyone,

Is there a way to retrieve the values and displays of a property?

Like below:

/// The current approval status
/// 0=Not Approved, 1=Approved, 2=Waiting for Approval, Null is valid and Approval not applicable
Property ApprovalStatus As %Integer(DISPLAYLIST = ",Not Approved,Approved,Waiting for Approval", VALUELIST = ",0,1,2");

Thanks.

-Roberto

[Roberto]

I figured it out looking at the documentation.

Here it is if anyone is looking to do this also:

Set cdef=##class(%Library.ClassDefinition).%OpenId("db.Provider")
Set count=cdef.Properties.Count()
For i=1:1:count {
Set fieldname=cdef.Properties.GetAt(i).Name
If (fieldname="ApprovalStatus") {
Set tempvar=cdef.Properties.GetAt(i)
Set parameters=tempvar.Parameters
W parameters.GetAt("DISPLAYLIST"),!
W parameters.GetAt("VALUELIST"),!
}
}

-Roberto

[Brendan Bannon]

If you want to find all the Properties in a namespace that have a DISPLAYLIST you can run this query

 

SELECT  Parent,Name, Parameters FROM %Dictionary.CompiledProperty

WHERE FOR SOME %ELEMENT(Parameters) (%VALUE IS NOT NULL and %KEY = 'DISPLAYLIST')

 

I was not able to isolate the display list so the output is not very pretty.

 

Brendan

--
--
Caché, Ensemble, DeepSee

---
You received this message because you are subscribed to the Google Groups "Caché, Ensemble, DeepSee" group.
To unsubscribe from this group and stop receiving emails from it, send an email to intersystems-publi...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.