Explains the way you can use linq queries on the product page to search for keys that satisfy certain properties.
id=2
- One key where id is equal to 2.</li>id=2
or id=3
- Two keys, one with id set to 2 and another with id set to 3.id < 10
- Keys where id is less than 10. Here, we will get 9 keys. You can also change to id <= 10
to get 10 keys (using less than or equal to operator).key="ITVBC-GXXNU-GSMTK-NIJBT"
- One license key (if exists).key.contains("ITVBC")
- All keys that contain “ITVBC”.ITVBC-GXXNU-GSMTK-NIJBT
and key="ITVBC-GXXNU-GSMTK-NIJBT
” are equivalent.
created = today
- Keys created today only.created >= yesterday
- Keys created today and yesterday. We could also type created = today or created = yesterday
.created >= DateTime(2015,01,01)
- Keys that were created in the beginning of 2015.expires <= DateTime(2016,01,01)
- Keys that will expire no later than the beginning of 2016.tomorrow
, monthback
, monthforward
>.
period = 30
- Keys that have a period equal to 30.F1 = true
- Keys that have feature1 set to true (or 1 on the product page).notes="Bob"
- Keys where Notes is equal to “Bob”notes.contains("to Bob")
- Keys where Notes contains “to Bob”block=true
- Keys that are blocked (block=yes/true).customer.name="Bob"
- Keys where the Customer’s name is “Bob”customer.id=3
- Keys where where Customer’s id is 3.customer.created= today
- Keys where the Customer’s creation date is set to today.resellerid=1234
- show only licenses created by reseller with id 1234.resellerid=-1
- show licenses that were not created by any reseller.ActivatedMachines.Count() > 0
- Keys that have at least one activated device.ActivatedMachines.Count() > 0 and ActivatedMachines.Count() < 10
- Keys that have at least one and at most 9 activated devices.ActivatedMachines.Count(it.Mid="machine code") > 0
- Keys with at least one device that has the machine code “machine code”.ActivatedMachines.Count(it.Time >= DateTime(2015,01,01)) > 0
- Keys that were activated after the 1st of January, 2015.dataobjects.count() > 0
- Keys with at least one data objectdataobjects.count(it.StringValue="test") > 0
- Keys where at least one data object has the string value of “test”.dataobjects.count(it.name="usagecount") > 0
- Keys that have a usage counter (see Set Usage ‘Quota’ for a Feature)trialactivation = true
- Keys with Trial Activation enabled.allowedmachines.contains("machine code")
- Keys that have an allowed machine code “machine code”.